[Resolved] mysql syntax easy i think :/

[ragmulock]

I'm having trouble trying to write this correctly. I've done very little with mysql and I can't think of how to do this right.

$result = mysql_query("Select
DATE_FORMAT(evfrom, '%m-%d-%Y') as evfrom_formatted,
DATE_FORMAT(evto, '%m-%d-%Y') as evto_formatted,
evid, evname, evdesc ORDER BY evfrom_formatted ASC",$link);

I know my $link is setup correctly as i've selected "all" and retrieved and printed everything fine with php, etc. i'm just having a really big problem grabbing these dates and putting them all in the results array. Can somebody please tell me what i'm doing wrong 🙁 thank you.

I'm getting:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource

if that helps at all.

[bpat1434]

When you are querying the database, mySQL doesn't return a valid resource ID number. Basically, when you query for everything in the database, it returns a resource ID. That resource ID is used to reference the values returned from the query. In order to use further mysql functions, a valid resource ID needs to be returned.

Here's what you do:

Print out the query: Make sure it is exactly as you want it to be.
Print out the result of the query: The value of the variable that the query returns should be something like:

Resource ID# Number

Do that, then post what you find out. I'll help after you post.

~Brett

[Drakla]

there's not "FROM table" in that query, that's also a major reason it's not working.

[ragmulock]

boy do i feel stupid... thanks drak that fixed it ><