On Thu, May 10, 2007 2:55 pm, [EMAIL PROTECTED] wrote:
Hello,
I have a loop on an sqlite query which checks $domain until the status
of
$domain changes and then it deletes $domain.
However when all the $domain items have been deleted I need the script
to
stop.. regardless of how many querys the loop
still has to run. So I want to detect when its empty and then stop.
I have this... which does not work.
?
$db = sqlite_open(whois.sqlite);
$x = 0;
while ($x 9000) {
$result = sqlite_query($db, SELECT * FROM whois ORDER BY id);
// if (!$result) {
if (empty($result)) {
echo No data;
I dunno for sure what empty() is gonna do with $result, but I suspect
that this message should say query failed rather than no data
No data returned is not an error, it's just an empty set, which is
very common.
} else {
while ($row = sqlite_fetch_array($result)) {
$domain = $row['name'];
echo $domain;
The quotes is kinda silly here...
$x++;
usleep(40);
}
}
}
sqlite_close($db);
?
You said you were deleting things...?
Where?
What are you actually trying to do?
delete from whois springs to mind as a MUCH better way from what you
described, but not what you coded...
--
Some people have a gift link here.
Know what I want?
I want you to buy a CD from some indie artist.
http://cdbaby.com/browse/from/lynch
Yeah, I get a buck. So?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php