I have a rather longer query which I would like to get all records past todays date.
Here is my query
$ttwo = date("YmdGi");
$abc = "
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";
$dbq = select($abc);
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
---------------------------------------------------------------------------
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
