Dani wrote:
> 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' "
>
#2 - yes. that's what SQL is all about...
#1 - Why do the $row=xxxx, then also do it in a while loop? Why not
just do it in a while loop? I'm not sure that'd necessarily help in this
case (most likely won't) but it would certainly be less typing in the
future.
Are you postive 2 rows match the 'hotel' and 'melati'?
> 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]";
> }
>
--------------------------------
Michael Kimsal
PHP Training Courses
http://www.tapinternet.com/php/
734-480-9961
--
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]
