Hi I am stuck trying to combine 3 things 
I have

$query_Recordset1 =("select *, DATE_FORMAT(thedate,'%d/%M/%Y') as 
editeddate from CC_Courses");

on one page


$query_Recordset1 = sprintf("SELECT * FROM CC_Courses WHERE 
Course_Category = '%s'", $colname_Recordset1);

on another page

I need to combine these two statements so that it will filter from the 
drop down list and show only those records, whilst at the same time 
formating the date as in the first statement ALSO I need to be able to 
display only those records which are from todays date onwards.

I am completely stuck can anyone please help me?
TIA
M









Community email addresses:
  Post message: [email protected]
  Subscribe:    [EMAIL PROTECTED]
  Unsubscribe:  [EMAIL PROTECTED]
  List owner:   [EMAIL PROTECTED]

Shortcut URL to this page:
  http://groups.yahoo.com/group/php-list 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/php-list/

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 


Reply via email to