modifiying sign up script need help

aznjay

<? 
$conn = mysql_connect("localhost","chaotici_commu","dragon");
$db = mysql_select_db("chaotici_chaotic"); 

$mail = $_POST['email'];
$gender = $_POST['txtgender'];
$month = $_POST['txtmonth'];
$bday = $_POST['txtbday'];
$byear = $_POST['txtbyear'];
$place = $_POST['country'];
$stat = $_POST['status'];
$hood = $_POST['hood'];
$prov = $_POST['txtprov'];
$postal = $_POST['txtpostal'];
$a = $_POST['aol'];
$m = $_POST['msn'];
$i = $_POST['icq'];
$commen = $_POST['txtcomments'];


$result= MYSQL_QUERY("INSERT INTO users (id, username, password, txtcomments, email, txtgender, txtmonth, txtbday, txtbyear, country, status, hood, txtprov, txtpostal, aol, msn, icq)". "VALUES ('NULL', '$username', '$password', '$commen', '$mail', '$gender', '$month', '$bday', '$byear', '$place', '$stat', '$hood', '$prov', '$postal', '$a', '$m', '$i', 'commen')"); 
echo "Your name and password have been submitted into our database :)"; 
?>

How come it won't send it to the database.Is there something wrong???

pyro

You have an extra value thrown in there. Remove 'commen' from the VALUES section. Also, why did you capitalize the MYSQL_QUERY()? I would use mysql_query().

kidsleep

In the future try this: mysql_query("query statement here") or die(mysql_error());

Makes debugging code a heck of a lot easier 😉

aznjay

Heyz pyro thank you, can you help me on something too. I got this guestbook script but i have no clue how to make the script work on different users. For example i login in adn then I check my guestbook and i only see my own messages and when i look at other peoples page i could see thier guestbook and signit. If you have join xkube.com or apt107.com you will see their guestbook. Can you help me pleas? AIM me at aznjay2x thank you.

pyro

I don't have AIM, but I conveniently have just written this. 🙂

aznjay

heyz i don't know where to start configuring this out. Like in apt107.com i dont' know how to set it up with the mysql and the users table. can you help me through msn or some instant messenger you have??