--- 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'].
> '&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
