RE: [PHP-DB] checking for 0 results?

2002-11-15 Thread Aaron Wolski 
Or you can skip a step like:

$sql = select * from ietsfuckingfriday;

if (mysql_num_rows($result) == 0) {

do_something();

} else {

do_anotherthing();

}

Aaron

-Original Message-
From: Snijders, Mark [mailto:Mark.Snijders;atosorigin.com] 
Sent: November 15, 2002 8:26 AM
To: 'Jonathan Narong'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] checking for 0 results?

$sql = select * from ietsfuckingfriday;

$result = mysql_query($sql);

$num_rows=mysql_num_rows($result);

if ($num_rows==0)echo yesss we did it;


(sorry it's friday :-)

almost can go home :--)



-Original Message-
From: Jonathan Narong [mailto:jon;binaryillusions.com]
Sent: vrijdag 15 november 2002 14:23
To: [EMAIL PROTECTED]
Subject: [PHP-DB] checking for 0 results?


maybe i'm totally not thinking straight right now, but is there a way in
php
to check if 0 results are returned in a mysql query?

for example, i have a definition database, that has a list of letters
the
user clicks on (click on the letter, and all the terms for that letter
pop
up).. but for some letters there are no terms. so i just wanted to echo
out
a simple no terms message or something. in any case, i need to check
if
there are no results from a mysql query (an error won't be returned).

thanks ..

-jon



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] checking for 0 results? edit

2002-11-15 Thread Aaron Wolski 
Doh!

Edit:

if (mysql_num_rows($sql) == 0) {

Aaron

-Original Message-
From: Aaron Wolski [mailto:aaronjw;martekbiz.com] 
Sent: November 15, 2002 8:42 AM
To: 'Snijders, Mark'; 'Jonathan Narong'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] checking for 0 results?

Or you can skip a step like:

$sql = select * from ietsfuckingfriday;

if (mysql_num_rows($result) == 0) {

do_something();

} else {

do_anotherthing();

}

Aaron

-Original Message-
From: Snijders, Mark [mailto:Mark.Snijders;atosorigin.com] 
Sent: November 15, 2002 8:26 AM
To: 'Jonathan Narong'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] checking for 0 results?

$sql = select * from ietsfuckingfriday;

$result = mysql_query($sql);

$num_rows=mysql_num_rows($result);

if ($num_rows==0)echo yesss we did it;


(sorry it's friday :-)

almost can go home :--)



-Original Message-
From: Jonathan Narong [mailto:jon;binaryillusions.com]
Sent: vrijdag 15 november 2002 14:23
To: [EMAIL PROTECTED]
Subject: [PHP-DB] checking for 0 results?


maybe i'm totally not thinking straight right now, but is there a way in
php
to check if 0 results are returned in a mysql query?

for example, i have a definition database, that has a list of letters
the
user clicks on (click on the letter, and all the terms for that letter
pop
up).. but for some letters there are no terms. so i just wanted to echo
out
a simple no terms message or something. in any case, i need to check
if
there are no results from a mysql query (an error won't be returned).

thanks ..

-jon



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] checking for 0 results?

2002-11-15 Thread Snijders, Mark 
and how does $sql now gets in touch with $result




Or you can skip a step like:

$sql = select * from ietsfuckingfriday;

if (mysql_num_rows($result) == 0) {

do_something();

} else {

do_anotherthing();

}

Aaron

-Original Message-
From: Snijders, Mark [mailto:Mark.Snijders;atosorigin.com] 
Sent: November 15, 2002 8:26 AM
To: 'Jonathan Narong'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] checking for 0 results?

$sql = select * from ietsfuckingfriday;

$result = mysql_query($sql);

$num_rows=mysql_num_rows($result);

if ($num_rows==0)echo yesss we did it;


(sorry it's friday :-)

almost can go home :--)



-Original Message-
From: Jonathan Narong [mailto:jon;binaryillusions.com]
Sent: vrijdag 15 november 2002 14:23
To: [EMAIL PROTECTED]
Subject: [PHP-DB] checking for 0 results?


maybe i'm totally not thinking straight right now, but is there a way in
php
to check if 0 results are returned in a mysql query?

for example, i have a definition database, that has a list of letters
the
user clicks on (click on the letter, and all the terms for that letter
pop
up).. but for some letters there are no terms. so i just wanted to echo
out
a simple no terms message or something. in any case, i need to check
if
there are no results from a mysql query (an error won't be returned).

thanks ..

-jon



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] checking for 0 results?

2002-11-15 Thread Hutchins, Richard 
Aaron was right initially:

$sql = select * from ietsfuckingfriday;

$result = mysql_query($sql);

$num_rows=mysql_num_rows($result);

Somewhere along the line, things got convoluted, but that's how you check
for 0 rows returned from a query.

 -Original Message-
 From: Snijders, Mark [mailto:Mark.Snijders;atosorigin.com]
 Sent: Friday, November 15, 2002 8:45 AM
 To: 'Aaron Wolski'; 'Jonathan Narong'; [EMAIL PROTECTED]
 Subject: RE: [PHP-DB] checking for 0 results?
 
 
 and how does $sql now gets in touch with $result
 
 
 
 
 Or you can skip a step like:
 
 $sql = select * from ietsfuckingfriday;
 
 if (mysql_num_rows($result) == 0) {
 
   do_something();
 
 } else {
 
   do_anotherthing();
 
 }
 
 Aaron
 
 -Original Message-
 From: Snijders, Mark [mailto:Mark.Snijders;atosorigin.com] 
 Sent: November 15, 2002 8:26 AM
 To: 'Jonathan Narong'; [EMAIL PROTECTED]
 Subject: RE: [PHP-DB] checking for 0 results?
 
 $sql = select * from ietsfuckingfriday;
 
 $result = mysql_query($sql);
 
 $num_rows=mysql_num_rows($result);
 
 if ($num_rows==0)echo yesss we did it;
 
 
 (sorry it's friday :-)
 
 almost can go home :--)
 
 
 
 -Original Message-
 From: Jonathan Narong [mailto:jon;binaryillusions.com]
 Sent: vrijdag 15 november 2002 14:23
 To: [EMAIL PROTECTED]
 Subject: [PHP-DB] checking for 0 results?
 
 
 maybe i'm totally not thinking straight right now, but is 
 there a way in
 php
 to check if 0 results are returned in a mysql query?
 
 for example, i have a definition database, that has a list of letters
 the
 user clicks on (click on the letter, and all the terms for that letter
 pop
 up).. but for some letters there are no terms. so i just 
 wanted to echo
 out
 a simple no terms message or something. in any case, i need to check
 if
 there are no results from a mysql query (an error won't be returned).
 
 thanks ..
 
 -jon
 
 
 
 -- 
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 
 
 -- 
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 
 
 
 -- 
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php
 
 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] checking for 0 results?

2002-11-15 Thread 1LT John W. Holmes 
How about:

$sql =  ... ;
$result = mysql_query($sql);
if($row = mysql_fetch_row($result))
{
  do
  {
//process results in $row
  }while($row = mysql_fetch_row($result);
}
else
{ //no results }

This way you don't have to make an extra call to mysql_num_rows() and it
saves you time.

---John Holmes...

- Original Message -
From: Hutchins, Richard [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, November 15, 2002 8:47 AM
Subject: RE: [PHP-DB] checking for 0 results?


 Aaron was right initially:

 $sql = select * from ietsfuckingfriday;

 $result = mysql_query($sql);

 $num_rows=mysql_num_rows($result);

 Somewhere along the line, things got convoluted, but that's how you check
 for 0 rows returned from a query.

  -Original Message-
  From: Snijders, Mark [mailto:Mark.Snijders;atosorigin.com]
  Sent: Friday, November 15, 2002 8:45 AM
  To: 'Aaron Wolski'; 'Jonathan Narong'; [EMAIL PROTECTED]
  Subject: RE: [PHP-DB] checking for 0 results?
 
 
  and how does $sql now gets in touch with $result
 
 
 
 
  Or you can skip a step like:
 
  $sql = select * from ietsfuckingfriday;
 
  if (mysql_num_rows($result) == 0) {
 
  do_something();
 
  } else {
 
  do_anotherthing();
 
  }
 
  Aaron
 
  -Original Message-
  From: Snijders, Mark [mailto:Mark.Snijders;atosorigin.com]
  Sent: November 15, 2002 8:26 AM
  To: 'Jonathan Narong'; [EMAIL PROTECTED]
  Subject: RE: [PHP-DB] checking for 0 results?
 
  $sql = select * from ietsfuckingfriday;
 
  $result = mysql_query($sql);
 
  $num_rows=mysql_num_rows($result);
 
  if ($num_rows==0)echo yesss we did it;
 
 
  (sorry it's friday :-)
 
  almost can go home :--)
 
 
 
  -Original Message-
  From: Jonathan Narong [mailto:jon;binaryillusions.com]
  Sent: vrijdag 15 november 2002 14:23
  To: [EMAIL PROTECTED]
  Subject: [PHP-DB] checking for 0 results?
 
 
  maybe i'm totally not thinking straight right now, but is
  there a way in
  php
  to check if 0 results are returned in a mysql query?
 
  for example, i have a definition database, that has a list of letters
  the
  user clicks on (click on the letter, and all the terms for that letter
  pop
  up).. but for some letters there are no terms. so i just
  wanted to echo
  out
  a simple no terms message or something. in any case, i need to check
  if
  there are no results from a mysql query (an error won't be returned).
 
  thanks ..
 
  -jon
 
 
 
  --
  PHP Database Mailing List (http://www.php.net/)
  To unsubscribe, visit: http://www.php.net/unsub.php
 
 
  --
  PHP Database Mailing List (http://www.php.net/)
  To unsubscribe, visit: http://www.php.net/unsub.php
 
 
 
  --
  PHP Database Mailing List (http://www.php.net/)
  To unsubscribe, visit: http://www.php.net/unsub.php
 
 

 --
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, visit: http://www.php.net/unsub.php



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php