More Database Woes... (Friday Deadline, :()
Here is most of the code, if it doesn't make sense I removed the php ?'s in certain places 'cause semagic can't do it right.
$sql = "SELECT * FROM fff_news WHERE date LIKE '2004-12-%' ORDER BY DATE_FORMAT(date, '%Y/%m/%d') DESC";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
if (!$result) {
echo("
$sql = "SELECT * FROM fff_news WHERE date LIKE '2004-12-%' ORDER BY DATE_FORMAT(date, '%Y/%m/%d') DESC";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
if (!$result) {
echo("
Error performing query: " . mysql_error() . "\n");
exit();
}
while ($row = mysql_fetch_row ($result)) {
echo $row[3] - echo $row[1]
echo $row[2]
Now if I do 'SELECT * FROM fff_news WHERE date LIKE '2004-12-%' ORDER BY DATE_FORMAT(date, '%Y/%m/%d') DESC' in phpmyadmin the query is correct. but when I run it within my new php page, I don't get my entry for 2004-12-25 but I get it for all other December dates? What is wrong with my php or html around the SQL query?
