[SOLVED] Syntax error while doing a tutorial in a book.

[Benjigga]

I'm going through Larry Ullman's PHP and MySQL book and I've written this script twice identical to how he has it in the book, but I keep getting a syntax error! I am using MySQL 5.0. Here is the error:

 

 

 

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '(last_name, first_name) AS name, DATE_FORMAT (registration_date

 

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

 

 

 

 

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

[Hooker]

What are you actualy trying to do here:

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

 

You need to close the singlequotes or remove the comma's & quotes, ie:

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

 

If you're trying to enter extra details you would do something like:

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

 

[Benjigga]

Those singlequotes were confusing me too when I was going through the book. The " ', ', " I'm assuming it's to add a comma between the last and first name. And that "SELECT CONTACT" is supposed to be "SELECT CONCAT"