Problems adding data in mysql

[rulinus]

I´m trying to add some data to my db in mysql, i do not get any error messages but nothing happens. I added the mysql_affected_rows() and instead of a 1 or 2 I get a -1.
I can´t figure out why.
anny help would be mus appreciated.😕

[tomhath]

Try running the insert like this. Otherwise you won't see the mysql errors:

$result = mysql_query ("INSERT ...")
or die ("Invalid query" . mysql_error());

[rulinus]

Thanks for the quick reply.
Actualy my script goes like this, well the part that matters:

$nombre = addslashes($nombre);
$apellidoP = addslashes($apellidoP);
$apellidoM = addslashes($apellidoM);
$direccion = addslashes($direccion);
$ciudad = addslashes($ciudad);
	$dbh=mysql_connect ("localhost", "coyoacan_rulo", "***") or die ('I cannot connect to the database.');
mysql_select_db ("coyoacan_prueba"); 
	$query = "INSERT INTO usuarios (userID, nombre, apellidoP, apellidoM, direccion, ciudad) values
		('\".$nombre.\"','\".$apellidoP.\"','\".$apellidoM.\"','\".$direccion.\"','\".$ciudad.\"')";
		$result = mysql_query($query);
		echo mysql_affected_rows();

the affected rows still show a -1

thanks

[tomhath]

Get rid of the backslashes and check for an error:

   $query = "INSERT INTO usuarios (userID, nombre, apellidoP, apellidoM, direccion, ciudad) values  ('" . $nombre . "','" . $apellidoP . "','" . $apellidoM . "','" . $direccion . "','" . $ciudad . "')";

echo $query;

$result = mysql_query($query) or die ("Query failed: " . mysql_error() );

[tomhath]

Just spotted a problem, take "userid" out of the list of column names (I assume it's an autoincrement column, mysql will populate it for you). Otherwise the number of column names does not match the number of values.

[rulinus]

thankyou, apparently the details are my deamon in php

thakyou really, it works now 😃