Re: mysql_result() problem
| From: | Adam Voigt | Date: | Wed, 09 Apr 2003 13:21:05 +0000 |
| Subject: | Re: mysql_result() problem | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-26954@lists.php.net to get a copy of this message | ||
Change to:
MONTH(B.Booking_Date) AS Booking_Date
And see if that makes it work.
On Wed, 2003-04-09 at 09:16, shaun wrote:
> Hi,
>
> I have the following query which works fine when I enter it directly to the
> MySQL Database:
>
> SELECT DISTINCT MONTH(B.Booking_Date) FROM WMS_Fields F, WMS_Data D,
> WMS_Bookings B WHERE F.Project_ID = ' 1' AND F.Field_ID = D.Field_ID AND
> B.Booking_ID = D.Booking_ID ORDER BY B.Booking_Date;
>
> However when i try to perform this command:
>
> $month = mysql_result($result, $i, Booking_Date);
>
> I get the following error:
>
> Warning: Booking_Date not found in MySQL result index 3 in
> /home/w/o/workmanagement/public_html/view_data.php on line 88
>
>
> I think this must be something to do with the fact I using the MONTH command
> in my query but I am not sure how to work around this, any ideas?
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
Adam Voigt (adam@cryptocomm.com)
Linux/Unix Network Administrator
The Cryptocomm Group
My GPG Key: http://64.238.252.49:8080/adam_at_cryptocomm.asc