DATE_FORMAT(). Can't get it to work.

[fmaestas]

Hello,
Trying to use DATE_FORMAT in my query but just cannot figure it out.

I have a 3 tables that I'm querying, the date fields are in the table "products_tbl". Have tried listing individual fields instead of the * but the same error happens. I'm stuck.

Here is my query...

$query = "SELECT * FROM customer_tbl, projects_tbl, products_tbl

DATE_FORMAT(due1, '%m/%d/%y') AS newdue1

WHERE projects_tbl.pid='$project_select'
AND products_tbl.projid='$project_select'
AND projects_tbl.custid=customer_tbl.cid";

$result=mysql_query($query);
while($row = mysql_fetch_row($result))

When I uncomment the DATE_FORMAT line, I recieve the error: Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource.

I have it working in another page but that query only uses one table and and does not have any WHERE or AND statements Could the problem lie in using multiple tables or these statements?

Any advice appreciated.

Frank Maestas
[e-mail]

[DigitalExpl0it]

Originally posted by fmaestas
Hello,
Trying to use DATE_FORMAT in my query but just cannot figure it out.

I have a 3 tables that I'm querying, the date fields are in the table "products_tbl". Have tried listing individual fields instead of the * but the same error happens. I'm stuck.

Here is my query...

$query = "SELECT * FROM customer_tbl, projects_tbl, products_tbl

DATE_FORMAT(due1, '%m/%d/%y') AS newdue1

WHERE projects_tbl.pid='$project_select'
AND products_tbl.projid='$project_select'
AND projects_tbl.custid=customer_tbl.cid";

$result=mysql_query($query);
while($row = mysql_fetch_row($result))

Frank Maestas
[e-mail]

humm have your tryed placing date_format before the FOR startement?

$query = "SELECT DATE_FORMAT(date,'%d-%m-%Y') AS datefr FROM matable WHERE id=1";