Posted by John K on 10/07/84 11:36

I tried it didn't produce a result (the date that is). Time produced
result however.

This is what I put in. Did I do something wrong?

<?php
mysql_select_db($database_hthConnect, $hthConnect);
$query_gigRecall = "SELECT DATE_FORMAT('%M %e,
%Y',tbl_gigs.fld_gig_Date) as fld_gig_Date, tbl_gigs.fld_gig_Time,
tbl_gigs.fld_gig_Place FROM tbl_gigs";
$gigRecall = mysql_query($query_gigRecall, $hthConnect) or
die(mysql_error());
$row_gigRecall = mysql_fetch_assoc($gigRecall);
$totalRows_gigRecall = mysql_num_rows($gigRecall);
?>

[Back to original message]