sql statement

[Dan J. Rychlik]

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 quotation before the format parameters. Ive tried to fix this without any luck. Any Ideas ?

DATE_FORMAT ( timestamp, ' %d%m%y ')

Thanks in advance,
-Dan

[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

[David Robley]

In article <00ca01c3822e$d05406a0$f40d630a@compucom.local>,
[email]drychlik@tcsconsult.com[/email] 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 quotation before the format parameters. Ive tried to fix this without any luck. Any Ideas ?
>
> DATE_FORMAT ( timestamp, ' %d%m%y ')
>
> Thanks in advance,
> -Dan

Try
$query = "SELECT username, password, DATE_FORMAT(timestamp, '%d%m%y') FROM
custlogon";

--
Quod subigo farinam

A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
A: Top-posting.
Q: What is the most annoying thing on usenet?

[ccarterca]

here is the statement

strSQL = "UPDATE SPECIALPAGE SET Title='" & Upload.Form("Title") & "',
Description='" & Replace(Upload.Form("txtDescription"), "'", "''") &"' Where
ID =" & Upload.Form("txtID")

now i have a check box that i also need to update but i want to pass the
checkbox as a numerical value, how would i i add that into my statement
Active="& Replace(Upload.Form("cboActive")) im not sure???

[goerdie_uk]

when ive got stuff like this , make sure the statement works with hard coded values first , then add each variable one at a time to see which one screws it up.