On Wednesday 09 April 2003 21:21, Adam Voigt wrote: > 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); Also the above line should be: $month = mysql_result($result, $i, 'Booking_Date'); -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * ------------------------------------------ Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db ------------------------------------------ /* A jury consists of twelve persons chosen to decide who has the better lawyer. -- Robert Frost */ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
