Looping through mysql_fetch_array()

slevytam

Hi,

I've been struggling with this for a while so I'd appreciate some help with this.

I use this line to loop through my query results.
while($row=mysql_fetch_array($qr)){
blahblah
}

The question is can I add something to while statement so I filter the results.

ie while($row=mysql_fetch_array($qr) && $row['type']==1){
blahblah
}

If could someone help me accomplish the same.

The help is appreciated!

--SL

mcgruff

Try some tests with:

while ($row = mysql_fetch_assoc($qry) ...and whatever else you want to try) {

print_r($result);
echo '<hr>';

}

ahundiak

Probably best to not try to do the filtering in the while statement itself.

while($row = mysql_fetch_assoc($result))
{
  if ($row['type'] == 1)
  {
    echo 'Got one';
  }
}

slevytam

Thanks,

I tried some tests and it seem the use of != is what is messing me up. Any ideas why or how to get around?

--SL

mcgruff

I've never actually tried filtering in the while statement - hence the piece of code to experiment. I'd usually do it like ahundiak suggested.

Post the bit of the code with the !=.

slevytam

Sure,

This does not work.
while($row=mysql_fetch_array($qr) AND timeleft($row['start'], $row['end']) !="0"){

However this seems to work,
while($row=mysql_fetch_array($qr) AND timeleft($row['start'], $row['end']) =="0"){

Thanks again,

--SL

ahundiak

Just a guess but maybe timeleft returns a number?
Might try dropping the quotes. In fact, you don't even need the !=

while($row=mysql_fetch_array($qr) AND timeleft($row['start'], $row['end']))
{

slevytam

Unfortunately, no luck yet.

Maybe this might help.

here is the function timeleft
function timeleft($time1, $time2){
if(strtotime($time2) < time()){
return 0;
}
else{
$diff_in_sec = abs(strtotime($time2)-strtotime($time1));
$days = floor($diff_in_sec/86400);
$diff_in_sec = $diff_in_sec%86400;
$hours = floor($diff_in_sec/3600);
$diff_in_sec = $diff_in_sec%3600;
$mins = floor($diff_in_sec/60);
$diff_in_sec = $diff_in_sec%60;
$timeleft = $days."d ".$hours."h ".$mins."m ".$diff_in_sec."s";
return $timeleft;
}

And here is where I attempt to use it
$qr = mysql_query("SELECT * FROM items WHERE uid=1 AND sold=0");
$nrows = mysql_num_rows($qr);
if ($nrows > 0){
while($row=mysql_fetch_array($qr) AND timeleft($row['start'], $row['end'])!=0){

Thanks again for the help,

I really appreciate it!

slevytam

I guess I'll give up and use the if / else. Was just hoping to skip the extra code.

Thanks for everyones input!

--SL

BeastRider

Have you tried adding a few extra parens so that

while($row=mysql_fetch_array($qr) AND timeleft($row['start'], $row['end']) !="0"){

becomes

while(($row=mysql_fetch_array($qr)) AND (timeleft($row['start'], $row['end']) !="0")){

I don't know about php but other languages can confuse just what part of the expression gets included/evaluated with the other.

slevytam

Unfortunately, this doesn't work either. Is it possible to use mysql_error() or something similar in this case to find out what is going on?

Thanks,

laserlight

how does it not work?

Why not try finding the simplest example where it does not work, correct that, then work back up from there?

slevytam

Best I can tell is that it doesn't execute the content in the while loop.

Either there are no records returned which is impossible(filtering within the while works) or the statement generates an error!

The page does not crash. I just don't get anything displayed.

Thanks,

--SL

kevinsequeira

well try to echo
timeleft($row['start'], $row['end'])

in the while loop, is it printing out any value ??

reg
kevin