Problem w/ (!$result) record exist

[Gary_Kambic]

Hello,

I have a table which is currently emply named client_options.

When the e-mail address is not found I want to insert a record into the table. If the e-mail is found in the table, I want to update the field.

Currently, as you can see from my output this is not happening. I thought the !$result condition would be true when the table cann;t find the record and insert the record. It is instead performing the update.

Why is this happening?? Is their a better way to perform this check? Any help would be appreciated.

Gary

test001 Resource id #3 test003 test004

$query = "SELECT * FROM client_options WHERE client_email_address = '$email_address_1'";
$result = mysql_query($query) or die ("Can't connect [ 001 ] because ".mysql_error());
echo "test001";

echo "$result";

if (!$result) {
die('Invalid query: ' . mysql_error());
}

if (!$result) {
/ --------------------- Insert Information | [ CLIENT_OPTIONS ] Table ------------------- /
echo "test002";
$query = "INSERT INTO client_options VALUES ('', '$email_address_1', '$status', '', '', '', '', '', '', '', '', '', '', '')";
mysql_query($query) or die ("Can't connect because [ 002 ]".mysql_error()); }

else {
/ ------------------ Update Information | [ CLIENT_OPTIONS ] Data Base ------------------ /
echo "test003";
$query="UPDATE client_options SET unsubscribe_email_messages='$status' WHERE client_email_address = '$email_address_1'";
mysql_query($query) or die ("Can't connect because [ 003 ]".mysql_error()); }
echo "test004";

?>

[devinemke]

you are tesing for the wrong variable. in your code $result is simply a result set from your query. even if the result set is empty (0 rows) it will store return TRUE. $result will only return FALSE if your query failed. check it out:

<?
$result_select = mysql_query("SELECT * FROM client_options WHERE client_email_address = '$email_address_1'");
if (!$result_select)
{
	echo 'SELECT query failed. here is some debugging info:<br>';
	mysql_error();
	exit();
}

if (mysql_num_rows($result_select))
{
	echo $email_address_1 . ' was found in the database. attempting status update.<br>';
	$result_update = mysql_query("UPDATE client_options SET unsubscribe_email_messages = '$status' WHERE client_email_address = '$email_address_1'");
	if (!$result_update)
	{
		echo 'UPDATE query failed. here is some debugging info:<br>';
		mysql_error();
		exit();
	}
	else
	{
		echo 'status update successful.';
	}
}
else
{
	echo $email_address_1 . ' was NOT found in the database. attempting insert.<br>';
	$result_insert = mysql_query("INSERT INTO client_options VALUES('', '$email_address_1', '$status', '', '', '', '', '', '', '', '', '', '', '')");
	if (!$result_insert)
	{
		echo 'INSERT query failed. here is some debugging info:<br>';
		mysql_error();
		exit();
	}
	else
	{
		echo 'insert successful.';
	}
}
?>

[Gary_Kambic]

Thank you. It works very, very well. I've needed a short script like this for a while now.

Many thanks, :-)

Gary