Argh!

[pablodelapena]

Im making an installer for my site to make things easier for me in the future and ive run into some bother.

It creates all the tables fine, but as soon as i try and insert the administrator's details into the Auth table it screws up!

I get a syntax error, and as hard as i look i cannot see it! this is the code im using

<?php
$group = "admin";

$insert_sql = "INSERT INTO auth (username, password, email, group) VALUES ('$admin_user', password('" . addslashes($admin_pass) . "'), '$admin_email', '$group')";
$create_query = mysql_query($insert_sql);
?>

It says i have an error in my syntax somewhere along the $insert_sql line from 'group) VALUES ('admin_user........ till then end of the query. I see no syntax error! in fact i pretty much copied this from a script which already works! help?!

thnks!:)

[stolzyboy]

group is a mysql reserved word, you cannot use it for a field name, for a full list of reserved words, look here

[pablodelapena]

but it allows me to create the field 'group'?! f i change it will it be all ok?

[stolzyboy]

yes, it should be, and yes it allows you to create it, but when you try to use it, it will error as you have already found out

[pablodelapena]

thanks! step by step i am un-newbie-fying myself in the PHP world!

[jimson]

To : pablodelapena
Try change it to "grp" which is still represents the group name

[stolzyboy]

wow, novel idea, i'm pretty sure he could figure that out