mysql_fetch_row with DATE_FORMAT not working

[BIOSTALL]

hey all 🙂 having a bit of trouble displaying a date whilst using mysql_fetch_row and was wondering whether someone would be able to help me please 🙂

Heres my code:

$recent = mysql_fetch_row(mysql_query("SELECT *, DATE_FORMAT(date, '%d/%m/%Y') AS date2 FROM OtherGigs ORDER BY dateadded DESC, timeadded DESC LIMIT $i, 1", $connection));
					$bands = $recent[1];
					$venue = $recent[2];
					$gigdate = $recent['date2'];

When i echo $gigdate however... its equal to null.

Anyone see whats wrong please?? thanks 🙂

BIOSTALL

[kubis]

$recent = mysql_fetch_row(mysql_query("SELECT *, DATE_FORMAT(date, '%d/%m/%Y') AS date2 FROM OtherGigs ORDER BY dateadded DESC, timeadded DESC LIMIT $i, 1", $connection));
// snip
$gigdate = $recent['date2'];

youre trying to access an associative array $recent whilst mysql_fetch_row() returns a non-associative array.

try to use mysql_fetch_array() or mysql_fetch_assoc() instead