Hi Again!

Why does this print only one record?

1. I have checked on the table on MYSQL and I have  2 records with this
2. Can I actually use the word "and" twice or three times for filtering
the data that I need during query?? (example: $query = "select * from
main_table where item_type = 'hotel' and class = 'melati' and price =
'200' and facilities = 'swimming pool' "

Could some body help please???

here is my code

$query = "select * from main_table where item_type = 'hotel' and class =
$result = mysql_query($query);
$row = mysql_fetch_array($result);
echo "$row[item_id]","<BR>";
while ($row = mysql_fetch_array($result))
 echo "WHILE RESULT","$row[item_type]","<BR>","$row[class]";

thank you again!


PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to