[PHP] Re: SQL statement - date

2005-04-06 Thread kyriacos sakkas
Jacques wrote: > How should I formulate my sql statement to create a result set of members > who registered between now and 7 days ago? > > I have tried the following and it is obviously incorrect: > > $sqlnewmembers = "Select uid, uprofilename from tblusers where udatereg > between (date() and

[PHP] Re: SQL statement - please help

2005-03-24 Thread Jason Barnett
Try a MySQL list. Or possibly even php-db. -- Teach a man to fish... NEW? | http://www.catb.org/~esr/faqs/smart-questions.html STFA | http://marc.theaimsgroup.com/?l=php-general&w=2 STFM | http://php.net/manual/en/index.php STFW | http://www.google.com/search?q=php LAZY | http://mycroft.mozdev.o

[PHP] Re: SQL statement

2003-09-23 Thread David Robley
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] says... > Hello, > > Im having a bit of trouble with the DATE_FORMAT function in mysql. > > $query = ('SELECT username, password, DATE_FORMAT(timestamp, '%d%m%y') FROM > custlogon'); > > I know its failing because php doesnt like the quotatio

Re: [PHP] Re: SQL statement

2003-09-23 Thread Dan J. Rychlik
Tried that, it failed. I recieve undefined index timestamp. when executing. - Original Message - From: "Ney André de Mello Zunino" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, September 23, 2003 7:04 PM Subject: [PHP] Re: SQL statement

[PHP] Re: SQL statement

2003-09-23 Thread Ney André de Mello Zunino
Dan J. Rychlik wrote: $query = ('SELECT username, password, DATE_FORMAT(timestamp, '%d%m%y') FROM custlogon'); Trying enclosing the whole SQL query string in double quotes. Regards, -- Ney André de Mello Zunino -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.p