Ad:

PHP Discussion Thread
Unsolved
Views: 34623

Page 1
2
Next

You are currently viewing page 1 of this multi-page discussion thread

Jan 28th, 2007

test mysql query for no results

Expand Post »

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?

Similar Threads

Double MySQL Query in PHP
MySQL query's in MySQL
Change MySQL Query Timeout Period in MySQL
pagination of mysql query results in PHP
MySQL query to loop through results distinctly in MySQL

nathanpacker

Reputation Points: 10

Solved Threads: 0

Posting Whiz in Training

Offline

234 posts
since May 2005

Permalink

Jan 28th, 2007

Re: test mysql query for no results

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.

php_daemon

Reputation Points: 13

Solved Threads: 2

Junior Poster

Offline

138 posts
since Aug 2006

Permalink

Jan 30th, 2007

Re: test mysql query for no results

Click to Expand / Collapse Quote originally posted by php_daemon ...

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.

nathanpacker

Reputation Points: 10

Solved Threads: 0

Posting Whiz in Training

Offline

234 posts
since May 2005

Permalink

Mar 16th, 2008

Re: test mysql query for no results

Click to Expand / Collapse Quote originally posted by php_daemon ...

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!!!!!

1supergirl

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

3 posts
since Mar 2008

Permalink

Mar 6th, 2009

Re: test mysql query for no results

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

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.

jamesmjr

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

4 posts
since Mar 2009

Permalink

Mar 6th, 2009

Re: test mysql query for no results

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.

nathanpacker

Reputation Points: 10

Solved Threads: 0

Posting Whiz in Training

Offline

234 posts
since May 2005

Permalink

Mar 6th, 2009

Re: test mysql query for no results

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

jamesmjr

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

4 posts
since Mar 2009

Permalink

Mar 6th, 2009

Re: test mysql query for no results

Click to Expand / Collapse Quote 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.

nathanpacker

Reputation Points: 10

Solved Threads: 0

Posting Whiz in Training

Offline

234 posts
since May 2005

Permalink

Mar 9th, 2009

Re: MSSQL and num_rows

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:

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);

jamesmjr

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

4 posts
since Mar 2009

Permalink

Jan 5th, 2012

Finally

I was struggling with checking my empty results set before I loop with a while block until I found the above num_rows code and it worked right off. I think I spent 3 hours on this...amazing! Now I need to redirect back to the login page but this too is a struggle because I am using php header location and it's hard because I read that you are supposed to call before anything else. I'll get it though.

Thanks everyone!!!

c++learner

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

27 posts
since Jul 2010

Page 1
2
Next

Previous Thread in PHP Forum Timeline: Help With Getting Next Results $SQL

Next Thread in PHP Forum Timeline: install curl

DaniWeb Message

Cancel Changes

User Name
Password