';
$bannerquery = "SELECT * FROM banners ORDER BY RAND()";
$bannerresult = @mysql_query ($bannerquery); // Run the query.
while ($bannerrow = mysql_fetch_array($bannerresult, MYSQL_ASSOC)) {
$datevar = Date("Y-m-d");
if ($bannerrow['paidthrough'] >= $datevar){
$aboutid=$bannerrow['id'];
$views=0;
$views=$bannerrow['views'];
$views=$views+1;
$db_tableBA = 'banners';
// Do update statement.
$update = "UPDATE $db_tableBA SET views='$views' WHERE id='$aboutid'";
mysql_query($update);
echo '
';}
;}
mysql_free_result ($bannerresult); // Free up the resources.
mysql_close(); // Close the database connection.
echo '
Links to Secretary of State Websites
Here is a listing of links to all
Secretary of State websites
throughout the United States, plus
Washington DC, Guam, and Puerto Rico.
For a
listing of court websites,
click
here.
