Drew, your idea for the sleep function worked like a charm. Now I have another problem I hope you can help me with.
I am trying to run a query from a variable passed from the URL and get this error:
Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING
This is the page I am sending from.
http://www.barstool-directory.com/test/cat.php
<?php
$login = "netshops";
$password = "feedme";
$table = "hammocks";
$aid = "cd1";
$database = "netshopsaffiliates_com_-_datafeeds";
$connection = mysql_connect("207.234.208.224","$login","$password")
or die ("Unable to connect.");
mysql_select_db($database)
or die ("Unable to open database.");
$sql = "SELECT DISTINCT category FROM $table ORDER BY category";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
while ($row = mysql_fetch_array($result))
{
extract($row);
echo "<table width='600' border='0' cellspacing='0' cellpadding='3'> \n";
echo "<tr>\n";
echo "<td valign='top'>\n<a href='list.php?cat=$category'> \n<b> $category </b> </a> \n<br>\n";
echo "</tr>\n";
echo "</table>\n";
}
mysql_close($connection);
?>
This is where I am trying to send it to:
http://www.barstool-directory.com/test/list.php
<?php
$login = "netshops";
$password = "feedme";
$table = "hammocks";
$aid = "cd1";
$database = "netshopsaffiliates_com_-_datafeeds";
$connection = mysql_connect("207.234.208.224","$login","$password")
or die ("Unable to connect.");
mysql_select_db($database)
or die ("Unable to open database.");
$sql = "SELECT * FROM $table WHERE category = <?php echo $_REQUEST['cat']?>";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
while ($row = mysql_fetch_array($result))
{
extract($row);
echo "<table width='600' border='0' cellspacing='0' cellpadding='3'> \n";
echo "<tr>\n";
echo "<td valign='top'>\n<a href='$link$aid'> <img src='$image' border=0> </a> \n <br> <b> Price: </b> $$price\n </td> \n";
echo "<td valign='top'>\n<a href='$link$aid'> \n<b> $product </b> </a> \n<br> $description\n <br></td>\n";
echo "</tr>\n";
echo "</table>\n";
echo "<hr size='1'>\n";
}
mysql_close($connection);
?>
Could you help me one last time?
Thanks,
Thomas