Is
AND B.Booking_End_Date <= '".$booking_end_date."'";
maybe supposed to be
AND B.Booking_End_Date <= '".$_GET[booking_end_date]."'";
Also, because mysql cannot convert the PHP variables, you have to be doing more than cutting and pasting the query into the CLI. My crystal ball just went cloudy.
Doug
On Tue, 22 Apr 2003 17:18:45 +0100, shaun wrote:
>Hi,
>
>I am completely foxed by this:
>
> $query = "SELECT A.*, B.*, U.User_ID
> FROM WMS_Allocations A, WMS_Bookings B, WMS_User U,
>WMS_Projects P
> WHERE A.User_ID = B.User_ID
> AND A.User_ID = '".$ses_user_id."'
> AND B.Booking_Start_Date >= '".$_GET[booking_date]."'
> AND B.Booking_End_Date <= '".$booking_end_date."'";
> echo "query = $query<br>";
> $result = mysql_query($query) or die ('Query failed, MySQL says:
> '.mysql_error().' in '.__FILE__.' line '.__LINE__)
> $num = mysql_num_rows($result);
> echo "num = $num<br>";
> if($num != 0){
> //.....
>
>$num is zero, but it shouldn't be and when i cut and paste the query
>directly into mysql i get loads of rows. I also get no error messages.
>I would be very grateful if someone could point out what i have
>done wrong here.
>
>P.S. This message has been posted in PHP general but i was asked
>to post it here so please don't attack me for cross posting!
>
>
>
>--
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
