[SOLVED] Prob with INSERT

[forumnz]

Heres the code:

 

<?php
include('dbcon.php');

$catid=$_POST['value'];
$name=$_POST['name'];
$z = "0";

mysql_query("INSERT INTO cmcats (catid, catup, name) 
VALUES ('$catid', '$z', '$name')");

?>

 

Any idea what could be wrong?

 

Thanks,

Sam.

[papaface]

try:

<?php
include('dbcon.php');

$catid=$_POST['value'];
$name=$_POST['name'];
$z = "0";

mysql_query("INSERT INTO cmcats (catid, catup, name) 
VALUES ('{$catid}', '{$z}', '{$name}')");

?>

[revraz]

Nope, but it would help if you used error reporting and told us what the error was.

[btherl]

Doing this will give you a helpful error message:

 

mysql_query("INSERT INTO cmcats (catid, catup, name) 
VALUES ('$catid', '$z', '$name')")
  or die("Mysql error: " . mysql_error());

 

Note that I have removed the ";" from the end of the first line when I added the "or die"

[forumnz]

Thanks! All fixed!

 

Sam.