[Resolved] Can you see my syntax error? I can't

DjRubbish

Hello,

when running this script:

<?php

view_users

$page_title = 'view users';

include ('templates/header.inc');

require_once ('mysql_connect.php');

$query = "SELECT CONCAT(last_name, ',' ,first_name) AS name, DATE_FORMAT (registration_date, '%M %d, %Y') AS dr FROM users ORDER BY registration_date ASC";
$result = @ ($query);

if ($result){
echo '<table align="center" cellspacing = "2" cellpadding = "2"><tr><td align = "left"><b>Name</b></td><td align = "left"><b>Date Registered</b></td></tr>';

while ($row = mysql_fetch_array($result, MYSQL_NUM)){
echo "<tr><td align = \"left\"> $row[0]</td><td align = \"left\">$row[1]</td></tr>\n";
}
echo '</table>';

// free up query resources

mysql_free_result ($result);

}else{

echo '<p> The users could not be displayed due to a system error. We apologise for any incovenience.</p><p>' . mysql_error() . '</p>';
}
mysql_close();
include ('templates/footer.inc');

I always get the "syntax error" message around this '(registration_date, '%M %d, %Y') AS dr FROM users ORDER BY regi'

The thing is, I'm typing in php from a book! (Larry Ullman's "PHP and MYSQL for dynamic websites if you're interested) and I've typed it and re-typed it but I'm getting nowhere.

Can anyone help please?

Natty_Dreadlock

do u get a php syntax error or some error from mysql, i.e. does the message begin with "The users could not be displayed..." (the error message u define in the script). if so, check the sql query

SELECT CONCAT(last_name, ',' ,first_name) AS name, DATE_FORMAT (registration_date, '%M %d, %Y') AS dr FROM users ORDER BY registration_date ASC

i think the single ' could cause a problem, and i do not really understand why they r there - if u just wanna select last_name and first_name from your table, use

SELECT CONCAT(last_name, first_name) AS name, DATE_FORMAT (registration_date, '%M %d, %Y') AS dr FROM users ORDER BY registration_date ASC

hth

DjRubbish

thanks for your reply.

I tried what you suggested and it still comes up with the error mesage.

I checked the mysql query: it calls for registration_date and the column in mysql is named 'registration_date' so I can't see how it's missing it.

Debugging is a pain when you're just a beginner 🙁

Now I've run the select query in phpmyadmin and it works fine! But my php and mysql just won't talk to each other. 🙁 🙁

Natty_Dreadlock

can u plz post the complete error message?

DjRubbish

It was the space between DATE_FORMAT and the parentheses that was messing it up.

MySQL doesn't like that.

Soon as I took it out it worked like a charm.

Thanks for your interest!