Member Avatar for akshit

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 ERROR message 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...

Edited by pritaeas because: Fixed formatting
  • 2 Contributors
  • 2 Replies
  • 130 Views
  • 11 Hours Discussion Span
  • Latest Post Latest Post by akshit
Member Avatar for nav33n 
$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.. 
}
Edited by Reverend Jim because: Fixed formatting
Member Avatar for akshit

hey thx.... i'll try the code, and get bak 2 u!!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.