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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php