Matching record error

[joan23]

Listed below is my PHP code in adding new clients to my MySQl database. My problem is when a record already exist it should not insert,but mine insert i already did put some macthing condition on my code.Please help.What seems to be wrong?
<?php
// Include config file
include('common.php');

// Connect to database
$link = dbConnect();

//Build query to select client_grpid
$query = "SELECT client_grpid FROM clients_grp WHERE client_type='$client_type'";

//Execute query
$result = @mysql_query($query);

//Fetch the result in array and assign to $row
$row = @mysql_fetch_array($result);
	//Get the content and assign to $client_type
     $client_grpid = stripslashes($row['client_grpid']);

	//Check method if client name to be inserted exist	 
	//Build query to select client name
	$query = "SELECT * FROM client WHERE client_name = '$client_name'";

	//Execute query
    mysql_query($query);

	//If match is found
	if (mysql_num_rows($query)!=0){
		//Inform user
		$msg = "$client_name already exist";	
	 }
	// Build query to insert new client name
	$query = "INSERT INTO client(client_grpid, client_name)
    	      VALUES('$client_grpid', '$client_name')";

	// Execute query
	$result = @mysql_query($query);

mysql_close($link);

?>

[[deleted]]

Well, try this, seems that you check for the existence of the record but then still insert it....

//If match is found
if (mysql_num_rows($query)!=0){
//Inform user
$msg = "$client_name already exist";
} else {
// Build query to insert new client name
$query = "INSERT INTO client(client_grpid, client_name)
VALUES('$client_grpid', '$client_name')";
}
// Execute query
$result = @($query);

Note..all I did was inclose the insert portion in an else clause...

Matt Wade
codewalkers.com

[joan23]

I did a you said, but i got error like this

Warning: Supplied argument is not a valid MySQL result resource in c:\inetpub\wwwroot\flash\swf\add_client.php on line 27

this point to
//if match found

if (mysql_num_rows($query)!=0){

and still it insert the record. What do you think????

FYI: I call my PHP code in HTML form
Thanks

[mattw]

sorry...I'm very tired 🙂...try this:

<?php
// Include config file
include('common.php');

// Connect to database
$link = dbConnect();

//Build query to select client_grpid
$query = "SELECT client_grpid FROM clients_grp WHERE client_type='$client_type'";

//Execute query
$result = @($query);

//Fetch the result in array and assign to $row
$row = @mysql_fetch_array($result);
//Get the content and assign to $client_type
$client_grpid = stripslashes($row['client_grpid']);

//Check method if client name to be inserted exist
//Build query to select client name
$query = "SELECT * FROM client WHERE client_name = '$client_name'";

//Execute query
mysql_query($query);

//If match is found
if (mysql_num_rows($result)!=0){
//Inform user
$msg = "$client_name already exist";
} else {
// Build query to insert new client name
$query = "INSERT INTO client(client_grpid, client_name)
VALUES('$client_grpid', '$client_name')";

// Execute query
$result = @($query);
}

mysql_close($link);

?>