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