Print ONCE ONLY?????
| From: | Dani | Date: | Sun, 13 Jan 2002 01:54:23 +0000 |
| Subject: | Print ONCE ONLY????? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-80320@lists.php.net to get a copy of this message | ||
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
data.
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 =
'melati'";
$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!
regards,
Dani