bad query runs with no error!

[sneakyimp]

there must be some weird setting on the mysql database i am using for this latest project. the following query runs without throwing an error:

SELECT start_time, last_access_time, user_ip session_data FROM demo_sessions WHERE id='b31fd40c7e9135f2b52e4f17c23fc3c54da137b8'

notice there is no comma between user_ip and session_data

what's the story here? seems like a real security risk to me because my server won't log bad requests.

[Lars_Berg]

Nothing wrong with the query.

user_ip session_data

means that you define a correlation name for the user_ip column.

[sneakyimp]

i thought you need

user_ip as session_data

[harmor]

"AS" is mainly for "JOIN" clauses ( LEFT JOIN, INNER JOIN, etc.)
If you join two tables that have the same field name you can "AS".

Both the "user" and "usergroup" tables have the field "usergroupid".

$getusers = mysql_query("
SELECT u.usergroupid AS u_groupid, ug.usergroupid AS ug_groupid 
FROM user AS u
LEFT JOIN usergroup AS ug
ON u.usergroupid = ug.usergroupid ");
$user = mysql_fetch_array($getusers);

echo "Usergroup ID: ".$user['ug_groupid']." <br />
User ID: ".$user[u_groupid']."";

Sorry for the bad explanation but hopefully you'll get it.

[sneakyimp]

i get it but...the other mysql installs i've worked with flag that type of query as an error. i'm guessing this is either a more recent or older implementation of mysql. i wish it would be flagged as bad sql because one of my most common mistakes is leaving out commas in my queries. i guess i'll have to be extra careful now.

[Lars_Berg]

AS is optional when defining a column correlation name.