Re: Print ONCE ONLY?????

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