Problems sending two querys to Mysql Database

Question

Hello the first query is executed fine.. the second one is failing.. why?, i think its ok..

I know the first part its ok , because this data its saved in the database, the second query isn´t.

//insert the row into the database

    $res2 = mysql_query("INSERT INTO `users` (`username`, `password`, `email`, `rtime`, `ms`, `ms2`) VALUES('".$username."','".$password."','".$email."','".$registerTime."','".$ms."','".$ms2."')");

    $userid = mysql_insert_id();


    $sql17 = mysql_query("INSERT INTO `jugadores` (`userid`, `name`, `lastname`) VALUES('".$userid."','".$name."','".$lastname."')");

here is how to see your error `$sql17 = mysql_query(...) or die("Error: ".mysql_error());` — Ibu, May 17 '13 at 23:25
Thanks so much, i found the Error... do i have to close this question?? — Jules Martinez, May 17 '13 at 23:29
Don't forget to [Sanatize](http://php.net/manual/en/function.mysql-real-escape-string.php) [your](http://www.php.net/manual/en/book.mysqli.php) [data](http://www.php.net/manual/en/ref.pdo-mysql.php) — Mahdi.Montgomery, May 17 '13 at 23:58
[How to prevent SQL injection in PHP?](http://stackoverflow.com/questions/60174/how-to-prevent-sql-injection-in-php) has some good information about sanitizing/preventing SWL injection attacks. — Sam, May 18 '13 at 00:32
@JulesMartinez if you have solved your error the best thing is to answer your own question and mark it correct — John C, May 18 '13 at 03:49

score 1 · Answer 1 · answered May 21 '13 at 03:31

1

User ID is an integer so this is making a problem

'".$userid."'

The correct syntax for int. numbers is

".$userid."

answered May 21 '13 at 03:31

Jules Martinez

682
1
6
23

score 0 · Answer 2 · answered May 21 '13 at 03:51

0

I think your userid is a primary key . So you got the problem .you can put your error in google and search the answer

answered May 21 '13 at 03:51

Problems sending two querys to Mysql Database

2 Answers2