[simone]

Okay, so im using foreach() to pull the info from my database and turning them into variables ..however, when there's nothing in the database, i get an error. Its probably as plain as day, but whats the code to tell it, to pull from the database only if theres 1 or more rows..

Thanks!

[blaw]

Hi there,

mysql_num_rows() to test if it's an empty set or is_array() to test if it's an array before running your foreach loop might help?

HTH.

[simone]

Thanks Blaw, is_array worked perfectly, i tried mysql_num_rows before i posted this topic, it gave me more errors for some reason. But anyway, thanks again!

*edit*

Ohhh, mkay, it worked perfectly at getting rid of the error, but now when theres data in their, it wont pull it, heres my code ...

PHP Code:

    $appquery = $db->query("SELECT * FROM $table_applied");

      if (is_array($appquery)) {

        foreach($db->fetch_array($appquery) as $key => $val) {

        $$key = $val;

        $APPLIED[$key] = $val;

        }

    } 

[blaw]

Hi again,

Your code was somewhat different from what I assumed it to be... Anyway, how about using if(!empty($appquery)) or even if($appquery) then, instead of is_array()? is_array() doesn't work because before fetching it, it is not an array yet, but resource.

I don't use PEAR's DB class, so I'm not too sure of this, but there must be a method that works in the same way as mysql_num_rows() does, too, which you might want to check out.

[simone]

PHP Code:

     $appquery = $db->query("SELECT * FROM $table_applied"); 

  if(!empty($appquery));

      else {

        foreach($db->fetch_array($appquery) as $key => $val) { 

        $$key = $val; 

        $APPLIED[$key] = $val; 

        } 

    } 

That does the exact same thing as the is_array() ..this is really bugging me, i also tried the if(@appquery) and it showed the info, but again when there was nothing in the database it gave me the error.

[simone]

ahhh, i figured it out, i was putting my mysql_num_rows in wrong ...heres how it worked out.

PHP Code:

$appquery = $db->query("SELECT * FROM $table_applied"); 

  $approws = $db->num_rows($appquery);

      if(!$approws);

         else { 

           foreach($db->fetch_array($appquery) as $key => $val) { 

              $$key = $val; 

                $APPLIED[$key] = $val; 

        }

           }; 

Thanks for your help Blaw!