mysql select between help

Codewalkers Forums Sponsor:

February 14th, 2004, 05:48 PM

Anonymous

Registered User

Codewalkers God 35th Plane (22000 - 22499 posts)

Join Date: Apr 2007

Posts: 22,309

Time spent in forums: < 1 sec
Reputation Power: 24

mysql select between help

Need to select * bewteen $x,$y statement but can't quite get the syntax

php Code:

Original - php Code

 
$startye = date($_POST['startYear']); //set a format a start year
$startm = date($_POST['startMonth']); // set a format start month
$startd = date($_POST['startDay']);  // set a format start day
$startDate="$startye-$startm-$startd"; //slap start date all together
// -------
$endye = date($_POST['endYear']); //set a format a end year
$endm = date($_POST['endMonth']); // set a format end month
$endd = date($_POST['endDay']);  // set a format end day
$endDate="$endye-$endm-$endd"; //slap end date all together
 
SELECT distinct cust_serv_agent_id FROM `cust_serv` 
    where DATE_FORMAT(cust_serv_agent_time_compl, '%Y-%c-%e') in '$startDate', '$endDate'

February 14th, 2004, 08:07 PM

Blindeddie

Join Date: Apr 2007

Location: NJ - USA

Posts: 2,152

Time spent in forums: < 1 sec
Reputation Power: 4

RE: mysql select between help

I am not sure if this is what you are looking for, but you can use the between keyword...

SELECT distinct cust_serv_agent_id FROM `cust_serv`
where DATE_FORMAT(cust_serv_agent_time_compl, '%Y-%c-%e') between '$startDate' and '$endDate'

This would also include the start and end dates in the selection process. Another way to do it would be...

SELECT distinct cust_serv_agent_id FROM `cust_serv`
where DATE_FORMAT(cust_serv_agent_time_compl, '%Y-%c-%e') > '$startDate' and DATE_FORMAT(cust_serv_agent_time_compl, '%Y-%c-%e')<'$endDate'

this would only return dates that are between those two dates.

Viewing: Codewalkers Forums > Other Technologies > Database Help > mysql select between help

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump