MySQL

conditional execution of Sql query thru PHP

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jun 2008

Posts: 46

Reputation: akshit is an unknown quantity at this point

Solved Threads: 0

akshit

Offline

Light Poster

conditional execution of Sql query thru PHP

Apr 22nd, 2009

Hi.

I am working on a php-mysql project.

My table contains a field called "ID", which i have declared as teh PRIMARY key.

but what i want is, that when the user tries ot insert record B into the table, an [B]ERROR message[/B] should be displayed, showing that a record already exists with primary key =100....

I tried doing this as follows:

if('$id' in (mysql_query("Select ID from client") ))
{
echo "ERROR!";
}

else
{
run the query...
}

someone please help...
thx...

•

Join Date: Nov 2007

Posts: 3,747

Reputation: nav33n is a jewel in the rough

Solved Threads: 331

nav33n

Offline

Senior Poster

Re: conditional execution of Sql query thru PHP

Apr 22nd, 2009

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$query = "select * from table where id = 100";
$result = mysql_query($query);
if(mysql_num_rows($result) > 0 ) {
// record already exists
} else {
 // record doesn't exist, so insert.. 
}
$query = "select * from table where id = 100";
$result = mysql_query($query);
if(mysql_num_rows($result) > 0 ) {
// record already exists
} else {
 // record doesn't exist, so insert.. 
}

Use [code] tags to wrap your code next time.