--- Wade Smart <[EMAIL PROTECTED]> wrote:

> 20080728 1321 GMT-6
> 
> I want to post a message that when there are NO product available. Its turned
> 
> out to be more difficult than I thought.
> 
> I tried is_array, empty, !empty, thinking  - well, if its empty then I know 
> nothing is there. But its not working.
> 
> if(mysql_select_db('wt')){
>    $query = "SELECT name FROM deer_product WHERE
>    deer_type='".$_GET['deer_type']."'";
> 
>      if($result = mysql_query($query, $dbc)){                         
>        while ($row = mysql_fetch_array($result)){
>          print '<center>';
>       if(!empty($row[0])){
>        print '<p>
>          <ahref="deer_product.php?deer_type='.$_GET['deer_type'].
>            '&amp;name='.$row[0].'"><b>'.$row[0].'</b></a></p>';
>       } else {
>        print 'There is no '.$_GET['deer_type'].' for sale at this time.';
>       }
>       print '</center>';      
>       }
>      }
> }


If no rows are returned from your query, your while() loop may never get run.

You can select a count() in your query for each item and this way you'll get a
number (even 0) for them.

James

Reply via email to