insert validation help

[Anon]

Could anyone tell me what is wrong here. The script check the database to see if a record exists, if it does it says so, otherwise it inserts the record.
Currently it always says the record exists

IF ($type=="add") {

$sql = "SELECT count(*) FROM product_table WHERE product = $product";
$result = mysql_query ($sql);

if ($result)
{
$row = mysql_fetch_row ($result);

if ($row[0] == 0) // thats the value of count(*)
{
$insert_sql = "INSERT INTO product_table (product)
VALUES ('$product')";
$insert_result = mysql_query($insert_sql) or die ("Couldn't execute query----Insert Product");
if (!$insert_result) {
echo "Couldn't add product!";}
}
}
else
{
$message =" This record already exists";
}

Cheers for any help
Matt

[Anon]

try this...

<?php

$result = mysql_query("SELECT count(*) FROM product_table WHERE product = $product;");
if(mysql_num_rows($result)) {
echo "The user exists!";
} else {
$insert = mysql_query("INSERT INTO blah (blah, blah, blah) VALUES ('$blah','$blah','$blah';");
}

?>

For what you said your trying to do, that looks like a suitable solution.

Hope it helps!

Regards, Stezz.

[ziggs]

IF ($type=="add") {
$sql = "SELECT * FROM product_table WHERE product='$product'";
$result = mysql_query($sql);
$row = mysql_fetch_row($result);
if ($row == 0){
$insert_sql = "INSERT INTO product_table
VALUES (Null,'value1','value2')";
$insert_result = mysql_query($insert_sql);
exit;
}else{
$message =" This record already exists";
}
}

I think this may do it. Though I am kinda new and havent tested it at all. I don't know exactly what your values are or how everything is set up. This hopefully will give some ideas. If I am wrong then I am sorry and have a great day!
Ziggs

[Anon]

Thanks for the help