From: "mike karthauser" <[EMAIL PROTECTED]>

> Thanks for this - I ended up rehashing my query to this:
>
> <?
> $result = mysql_query("SELECT * FROM dates WHERE bookcode = '$bookcode'
> ORDER BY date1",$db);
>
>
> // loop to populate array
>
> $myrow = mysql_fetch_array($result);
>
> $i = 1;
> while ($i <= '30') {
>
> if ($myrow['date'.$i] > '0000-00-00')

You're making PHP do some extra work here. You're testing to see if one
string is greater than another... how can strings be greater than or less
than? Why don't you just check for $myrow['date'.$i] != '0000-00-00' ??

---John Holmes...

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

Reply via email to