Re: mysql_result() problem

From:	SayOrange.com	Date:	Wed, 09 Apr 2003 16:42:39 +0000
Subject:	Re: mysql_result() problem
References:	1	Groups:	php.db
Request:	Send a blank email to php-db+get-26960@lists.php.net to get a copy of this message

A tutorial on PHP/MYSQL http://www.freewebmasterhelp.com/tutorials/phpmysql/1 May be off topic...Sorry! 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?

-- -- SayOrange.com http://www.sayorange.com