[RESOLVED] no output from query

[harlequeen]

Can someone help me with this please?

I am getting a date passed from another page, which I can echo to screen, so the correct variable is getting through. I then try to query the db using the variable, but I am not getting any output.

The code I am using is below. What am I missing?

$guestdatebooking = mysql_query("SELECT * FROM Bookings WHERE DATE_FROM = '$DATE_FROM'" );

while ($myrow = mysql_fetch_array($guestdatebooking)) ;
{

echo "<br>Name: ".$myrow["BOOKING_ID"]."<br>";
echo "<b>Initials: ".$myrow["Guests_Guest_ID"]."</b><br>";
echo "address1: ".$myrow["NO_OF_NIGHTS"]."<br>";
echo "address2: ".$myrow["DATE_FROM"]."<br>";
echo "Post code: ".$myrow["DATE_TO"]."<br>";
echo "tel_no: ".$myrow["NO_OF-PEOPLE"]."<br>";
echo ":::::::::::::::::::::::::::::::::::::::::::::::::";

}//end while.

[devinemke]

$result = mysql_query("SELECT * FROM Bookings WHERE DATE_FROM = '$DATE_FROM'") or exit(mysql_error());
if (mysql_num_rows($result)) {echo 'record(s) found';}
else {echo 'no records found';}

what do you see now?

[harlequeen]

Providing I put a valid date in I get the following messag

record(s) found

but I don't get any other output . Is this an error with my code that tries to return the rows?

Am I right in thinking that the following code

echo "<br>Name: ".$myrow["BOOKING_ID"]."<br>"; 

should bring back the result of the query of Bookings and bring the content of the BOOKING_ID field/column?

Thanks

[harlequeen]

I had a semicolon in the wrong place and it was stopping the output. Found it, removed it, and got what I wanted.

Cheers for the help.

Harlequeen