Hi
before you can use an 'else' you'd need an 'if'
However you can do it without either. Your while will be bypassed if no
rows are returned. so after the while add:
if ($num == 0){
echo "
<tr>
<td>No Results found</td>
</tr>";
}
As for redirection. Doesn't seem to be possible if you've already
started outputting the table as your code implies
Niel
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
