I have a rather longer query which I would like to get all records past todays date. Here is my query
$ttwo = date("YmdGi"); $dbq = select("select detail.*, type.type_name, status.status_name, staff.staff_name, source.source_long, source.source_short from detail, type, status, staff, source where type.type_id = detail.detail_type && status.status_id = detail.detail_status && staff.staff_id = detail.detail_staff && source.source_short = detail.detail_source && 'detail_start_date_y,detail_start_date_m,detail_start_date_d,detail_start_time_h,detail_start_time_m' <= '$ttwo' order by detail.detail_start_date_m DESC, detail.detail_start_date_d DESC"); The query works fine before I try to get all records in the furure as shown below 'detail_start_date_y,detail_start_date_m,detail_start_date_d,detail_start_time_h,detail_start_time_m' <= '$ttwo' The query does not error out it just does not give any records, and I know there are 4 records Detail_start_date_y = 4 digit year Detail_start_date_m = 2 digit month Deatil_start_date_d = 2 digit day Detail_start_time_h = 24 hour time Can anyone see what I am doing wrong? Thanks in advance. --------------------------------------------------------------------------- Chris Kay Technical Support - Techex Communications Website: www.techex.com.au Email: [EMAIL PROTECTED] Telephone: 1300 88 111 2 - Fax: (02) 9970 5788 Address: Suite 13, 5 Vuko Place, Warriewood, NSW 2102 Platinum Channel Partner of the Year - Request DSL - Broadband for Business --------------------------------------------------------------------------- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php