I think this MySQL is proper Syntax, but not getting any results or errors

[suttercain]

Hello,

 

I have

$query = mysql_query("SELECT *, STR_TO_DATE(comics.cover_date,'%m/%d/%Y') as Mydate FROM comics, titleSheet WHERE comics.comic_id ='titleSheet.comic_id' ORDER BY Mydate, comics.issue_number") or die(mysql_error());
$tscount = mysql_num_rows($query);
echo $tscount;

 

It echos 0 when it should be 300 and something... any help.

 

Thanks.

[rajivgonsalves]

your query

 

SELECT *, STR_TO_DATE(comics.cover_date,'%m/%d/%Y') as Mydate FROM comics, titleSheet WHERE comics.comic_id ='titleSheet.comic_id' ORDER BY Mydate, comics.issue_number

 

should be

 

SELECT *, STR_TO_DATE(comics.cover_date,'%m/%d/%Y') as Mydate FROM comics, titleSheet WHERE comics.comic_id =titleSheet.comic_id ORDER BY Mydate, comics.issue_number

 

if you quote titleSheet.comic_id mysql will take it as a string

[drranch]

did you run it in MYSQL or are you running it from an html page?

 

when you run it in MYSQL it will tell you where your syntax needs fixing