Update Page If Query Return False

Question

Guys, next I have this appointment here

$consultapedidos = mysql_query("SELECT * FROM pedidos WHERE produzido = '0'");
if(mysql_num_rows($consultapedidos)==true){
while($lnped = mysql_fetch_array($consultapedidos))
}

when it returns true I want it to list the results it found, but if it returns false, I want it to update the page every 5 seconds until it finds a record. Does anyone have any idea how I can do that?

Answer 1

$consultapedidos = mysql_query("SELECT * FROM pedidos WHERE produzido = '0'");
if(mysql_num_rows($consultapedidos)==true){
    while($lnped = mysql_fetch_array($consultapedidos)) {
    }
} else {
    echo '<meta http-equiv="refresh" content="5"/> ';
}

Basically this, print the tag to update every 5 seconds, just implement in your code in the best way.

I hope it helps

Hug