SELECT query....

[imatus]

Ewwwww sorry seems like i misplaced this threat :S
Anyway it is SOLVED There mustn't be space between DATE_FORMAT and ()

Hello again everybody :)

Does anyone have an idea why this works:

$query = "SELECT * FROM players";

but this doesn't:

$query = "SELECT player_id, name, DATE_FORMAT (birthday, '%e %b %Y') AS bd, country, email FROM players";

??

it is followed by:
...
(line 141) while ($row = mysql_fetch_array ($result, MYSQL_ASSOC)) {

echo "<tr>";
echo "<td>{$row['name']}</td>";
echo "<td align='center'>" . $row['bd'] . "</td>";

And it says: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in ... on line 141

Any ideas??
Thank you in advance for your help!!
Have a great day :)

[alexpayne]

well my answer would have been wrong anyway.