Re: Populating an array from mysql db

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



From: "mike karthauser" <mikek@brightstorm.co.uk>

> 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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux