INSERT confusion

baffled_in_UK

Hi,

I am having a bit of trouble inserting new records into a MySQL Db. My plan is to check if a records exists, if not then insert one.

this was my original code......

$query = "SELECT FROM searchpost WHERE code2 = '$search_post'";
$result3 = mysql_query ("SELECT FROM searchpost WHERE code = '$search_post'");
if (!$row = mysql_fetch_array($result3)) {
$sql3 = "INSERT INTO searchpost (code,gone) VALUES ('$search_post','$gone')";
}

This does not write any records even though the query is empty.

So I thought I'd probably done something wrong so I then searched these forums and found this alternative code :

$query = "SELECT * FROM searchpost WHERE code2 = '$search_post'";
$res=mysql_query($query);
$numrows=mysql_num_rows($res);
if (!numrows) {
$sql3 = "INSERT INTO searchpost (code,gone) VALUES ('$search_post','$gone')";
}

But this returns error :Supplied argument is not a valid MySQL result resource .....(relates to line 2)

Any help would be appreciated.

Thanks

samscripts

Hi,

Supplied argument is not a valid MySQL result resource .....(relates to line 2)

this means that your previous query failed for some reason - ie some kind of error in the syntax of your $query, rather than just not finding any rows.

use mysql_error() to find out what the error was - probably something like 'you have an error in your syntax...'

$query = "SELECT * FROM searchpost WHERE code2 = '$search_post'"; 
$res=mysql_query($query) or die(mysql_error()."<br>$query");  // if the query fails, this will stop the script, and print a mysql error message and the query string
$numrows=mysql_num_rows($res); 
if (!$numrows) { 
$sql3 = "INSERT INTO searchpost (code,gone) VALUES ('$search_post','$gone')"; 
}

also, in the code you posted, you are checking
if(!numrows)

which I think should be

if( !$numrows)

hope this helps,

sam

baffled_in_UK

Thanks guys... great work as usual.

It's real nice to get a reply that doesn't start..

"I'm not gonna give you the code..." OR

"Read the manual"

Some of us need to see it in black & white before it sinks in.

Thanks again.