DaniWeb Forum Index > Web Development > PHP

test mysql query for no results

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

•

Join Date: May 2005

Posts: 232

Reputation: nathanpacker is an unknown quantity at this point

Solved Threads: 0

nathanpacker nathanpacker is offline

Offline

Posting Whiz in Training

test mysql query for no results

Jan 28th, 2007

Hey, I'm running a mysql query, and would like to run a script if the query returns no results. But what do I use to test for no results?

Something like:

[PHP]

if (!$query) {

do this

}

[/PHP]

But just not sure how to implement it. Little help?

•

Join Date: Aug 2006

Posts: 138

Reputation: php_daemon is an unknown quantity at this point

Solved Threads: 2

php_daemon php_daemon is offline

Offline

Junior Poster

Re: test mysql query for no results

Jan 28th, 2007

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
if(mysql_num_rows($result)==0){
  //do this
}
if(mysql_num_rows($result)==0){
  //do this
}

Last edited by php_daemon; Jan 28th, 2007 at 6:21 pm.

•

Join Date: May 2005

Posts: 232

Reputation: nathanpacker is an unknown quantity at this point

Solved Threads: 0

nathanpacker nathanpacker is offline

Offline

Posting Whiz in Training

Re: test mysql query for no results

Jan 30th, 2007

•

Originally Posted by php_daemon

Help with Code Tags

php Syntax (Toggle Plain Text)
if(mysql_num_rows($result)==0){
  //do this
}
if(mysql_num_rows($result)==0){ //do this }

Thanks, that was perfect.

•

Join Date: Mar 2008

Posts: 3

Reputation: 1supergirl is an unknown quantity at this point

Solved Threads: 0

1supergirl 1supergirl is offline

Offline

Newbie Poster

Re: test mysql query for no results

Mar 16th, 2008

•

Originally Posted by php_daemon

Help with Code Tags

php Syntax (Toggle Plain Text)
if(mysql_num_rows($result)==0){
  //do this
}
if(mysql_num_rows($result)==0){ //do this }

OMG, you helped me so much!! I am new to php, and I was tearing my hair out. Thank you, Thankyou,! You are my hero!!!!!

•

Join Date: Mar 2009

Posts: 4

Reputation: jamesmjr is an unknown quantity at this point

Solved Threads: 0

jamesmjr

Offline

Newbie Poster

Re: test mysql query for no results

Mar 6th, 2009

Will this work for odbc_num_rows also. I tried but I get the same message no matter what

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
$sql="SELECT * FROM rac_master WHERE mrnumb='$mrnumb' AND racnumb='$racnumb' AND findetdate IS NULL";
   $resultx=odbc_exec($conna,$sql);
       if (odbc_num_rows($resultx)==0) {
           echo"Record Has Been Finalized";
           }
           odbc_close($conna);
$sql="SELECT * FROM rac_master WHERE mrnumb='$mrnumb' AND racnumb='$racnumb' AND findetdate IS NULL";
   $resultx=odbc_exec($conna,$sql);
       if (odbc_num_rows($resultx)==0) {
           echo"Record Has Been Finalized";
           }
           odbc_close($conna);

Last edited by peter_budo; Mar 8th, 2009 at 7:03 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

•

Join Date: May 2005

Posts: 232

Reputation: nathanpacker is an unknown quantity at this point

Solved Threads: 0

nathanpacker nathanpacker is offline

Offline

Posting Whiz in Training

Re: test mysql query for no results

Mar 6th, 2009

Can't say for sure, but one way to find out would just be to test it. Echo that variable out and see what you get.

•

Join Date: Mar 2009

Posts: 4

Reputation: jamesmjr is an unknown quantity at this point

Solved Threads: 0

jamesmjr

Offline

Newbie Poster

Re: test mysql query for no results

Mar 6th, 2009

It returns "Record Has Been Finalized", even if the query statement is met. Does it matter what data type is being used in the table

•

Join Date: May 2005

Posts: 232

Reputation: nathanpacker is an unknown quantity at this point

Solved Threads: 0

nathanpacker nathanpacker is offline

Offline

Posting Whiz in Training

Re: test mysql query for no results

Mar 6th, 2009

•

Originally Posted by jamesmjr

It returns "Record Has Been Finalized", even if the query statement is met. Does it matter what data type is being used in the table

Wish I could help you here. I'm a novice at this stuff. Maybe someone more experienced will chime in.

•

Join Date: Mar 2009

Posts: 4

Reputation: jamesmjr is an unknown quantity at this point

Solved Threads: 0

jamesmjr

Offline

Newbie Poster

Re: MSSQL and num_rows

Mar 9th, 2009

Turns out the odbc_num_rows will always return -1 when using MSSQL. I changed my connecton to mssql_connect and mssql_num_rows . Every thing is working fine now.

Example:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$conn=mssql_connect('localhost','******','******');
 $msdb=mssql_select_db("DatabaseName",$conn);
 $sql="SELECT * FROM Table WHERE value='$variable' ";
 $result=mssql_query($sql,$conn);
         IF (mssql_num_rows($result)==0)  {
           echo"What ever";
           }
           mssql_close($conn);
$conn=mssql_connect('localhost','******','******');
 $msdb=mssql_select_db("DatabaseName",$conn);
 $sql="SELECT * FROM Table WHERE value='$variable' ";
 $result=mssql_query($sql,$conn);
         IF (mssql_num_rows($result)==0)  {
           echo"What ever";
           }
           mssql_close($conn);