Hi all,

I have a statment that goes

PHP Code:

if ($test){
//do this

}elseif(test2){
//insert into database blar blar
insert data into databse 

}else{
Echo" error one of the test filed try again";
} 


What I want to know is before test 2 is run, I need to search the database and see if the data is already entered into the database. And if it is dont insert the data but give error message what the best way of doing this ??

You could do something like this:

PHP Code:

function checkDB()
{
     //check if the data is already in the database
     if(/*data is in database */)
          return true;

     return false;
}

if ($test){
//do this

}elseif($test2 && !checkDB()){
//insert into database blar blar
insert data into databse 

}else{
Echo" error one of the test failed try again";
} 


what the best way to check the database with a select from table where this like that

Originally Posted by millwalll

what the best way to check the database with a select from table where this like that

I like

PHP Code:

if(mysql_result(mysql_query("select count(*) from table_name where something limit 1"),0)>0)
   //data already exist
else
   //data don't exist 


I think this is the fastest and less memory consuming way