read mysql manual: you must replace ' to ` ''''''''''''''''''''''''''''''''''''''''''''' to `````````````````````````````` in your $sql so
$sql = "SELECT id_from, id_to FROM ids WHERE id_from =`$current_id` OR id_to=`$current_id`"; or more intelligent without ``````````` in your $sql so $sql = "SELECT id_from, id_to FROM ids WHERE id_from =$current_id OR id_to=$current_id"; because for ANY SQL DATABASE IN THIS WORLD something without " ' ` is integer (your ids is integers???? :) ) "Phpu" <[EMAIL PROTECTED]> ???????/???????? ? ???????? ?????????: news:[EMAIL PROTECTED] Hi, I have a table with 2 fields: id_from and id_to. I want to interogate the database and to display the results if the id_to is equal to some current id OR id_from id_from is equla to saame current id. I use this but doesn't work $sql = "SELECT id_from, id_to FROM ids WHERE id_from ='$current_id' OR id_to='$current_id' "; $result = mysql_query($sql); How can i do? Thanks -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
