Long query not working

BIOSTALL

I have this query:

$result = mysql_query("SELECT postcount,lastpostsubject,DATE_FORMAT(lastpostdate, '%d/%m/%Y'),location,DATE_FORMAT(membersince, '%d/%m/%Y'),DATE_FORMAT(lastactivedate, '%d/%m/%Y') FROM Forum_Users WHERE username='$username'", $connection);

It worked fine before i added the DATE_FORMAT bits. Can anyone please tell me if they can see something wrong with this?? cheers,

BIOSTALL

leatherback

Hi,

I am not sure but I think you need to place a name for the generated formatted strings:

e.g.,
select .., dateformat(...) AS date1

edcellgavin

try printing mysql's error note with mysql_error() so you'll have a clue what really went wrong.

BIOSTALL

Well, wen the query runs, its returns the postcount bit but everything afer that is empty.

If someone wouldn't mind expanding on leatherbacks idea i would appreciate it 🙂

BIOSTALL

leatherback

use the manual

and try:


result = mysql_query("SELECT  postcount,lastpostsubject,DATE_FORMAT(lastpostdate
  , '%d/%m/%Y') as date1  ,location,DATE_FORMAT(membersince, '%d/%m/%Y') as date2, DATE_FORMAT(lastactivedate, '%d/%m/%Y') as date3 FROM Forum_Users WHERE username='$username'", $connection);

BIOSTALL

How can i then assign date1, date2 etc to variables??

leatherback

That is actually what is happening:

You say:

Format the colum lastpostdate, according to a certain date format, and call it date1.

In the output you can then use the name date1 to refer to the formatted date.

Not sure, but I think that is what was causing your error.