mySQL questions

[heath]

How do you use the mysql function DATE FORMAT() to reformat the date out of mysql goofy date structure?

Also - is there a mySQL or PHP function that will return the number of records selected from a query or do I need to count this manually?

This doesn't work:

print $mysql_numfields($result);


Nor does this:

 $res = mysql_db_query($db,"select count(answers_id) from answers"
    $row_count = mysql_result($res,0,"count(answers_id)"
print $row_count;

Now what?
thanks
[This message has been edited by heath (edited 09-03-99)]

[Justin]

Don't know about the first question (yet), but the second one is simple:

$total = mysql_numrows ($result);
print "$total results found.";

You should always check the number of rows returned before attempting to extract any results, otherwise if none are returned you'll get an error.

PS - see http://www.php.net/manual/ref.mysql.php3 for all of PHP's mySQL functions

HTH

------------------
Justin Nelson
FutureQuest Support
[This message has been edited by Justin (edited 09-03-99)]