Re: Re: Broken IF behavior? (Changing the branch changes the evaluation)

Ford, Mike wrote: >> -----Original Message----- >> From: Matt Neimeyer [mailto:matt@neimeyer.org] >> Sent: 29 July 2009 16:47 >> >>>> $Ret = mysql_fetch_array($result); if(!$Ret) { } else { return >> $Ret; } >>> I'm assuming that you are calling my_fetch_array() in a loop of >> some >>> sort and so at some point there are no more records in the result. >> Oh... Um... Yeah... Well... <headdesk> >> >> So... Checking the docs... "Returns an array of strings that >> corresponds to the fetched row, or FALSE if there are no more rows." >> >> Is there a way to differentiate between a FALSE for no more rows and >> an error? > > I don't actually think that mysql_fetch_array can return an error -- read that description > again, it's very clear that you get an array of fetched values or FALSE for no more data, no > other options. If there's any error occurring, it will be in the preceding mysql_query(). > Probably the only error you can get is: supplied argument is not a valid MySQL result resource, if $result is not valid. So you could check that in the code that does the actual query. As for the function, I would just do this: function my_fetch_array($result) { if(version_compare($GLOBALS['Version'], "2.0", ">=")) { return mysql_fetch_array($result); } else { return odbtp_fetch_array($result); } } -- Thanks! -Shawn http://www.spidean.com