The code is shown below
there is now a delay before the page is displayed of 50 secs
it must be hitting the sleep command as it searches, and so stops searching
the database table
is there any workaround ?
echo "Your Search Results are as follows<p>";
?>
<table width="100%" border="2" cellspacing="0" cellpadding="1">
<tr bgcolor="#00A5C6">
<td>Title</td>
<td>URL</td>
<td>Description</td>
<td>for Keyword</td>
</tr>
<?php
$result=mysql_query("SELECT * FROM `searchdata` WHERE 1 AND `keyword` = " .
"'$thissearchterm'" );
$key=1 ;
while ($row=mysql_fetch_row($result)){
?>
<?php mysql_query("INSERT INTO searchsorting (username,bid) VALUES ( '
$row[5] ' , ' $row[6] ' )");
$a = array( $key => $row[6] );
$key=$key + 1 ; ?>
<?php
} ; //end of while loop
?>
<?php
sleep (50) ;
function cmp ($a, $b) {
if ($a == $b) return 0;
return ($a > $b) ? -1 : 1;
}
// $a = array (0.10, 0.30, 5, 6, 1);
usort ($a, cmp);
echo "Bid Prices and Positions<br>" ;
while (list ($key, $value) = each ($a)) {
echo " Position $key: £$value > ";
}
echo " <a href=http://www.phpexpert.org/ppcsearch/>Become a Bidder</a> ";
?>
</table>
--
www.phpexpert.org/truefaith.htm
"True Faith is not just when you believe in God and yourself, it is when
others begin to believe in you as well" - Damian John Paul Brown 2004
"Ryan A" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hey,
> Use the sleep() function.
>
> Cheers,
> -Ryan
>
> On 4/13/2004 4:42:56 AM, Damian Brown ([EMAIL PROTECTED]) wrote:
> > I am writing a script that searches through a database table, and then
> > there
> > is an array function below the searching, but the array function gets
> > executed before
> > the database table searching finishes and I want it to wait until
> > the database has been searched before executing the array code
> >
> > Thanks in Advance
> >
> > --
> > www.phpexpert.org/truefaith.htm
> > "True Faith is not just when you believe in God and yourself, it is when
> > others begin to believe in you as well"
> > - Damian John Paul Brown 2004
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
