$NOW=date("Y-n-j"); ?>
C
ontractors
E
stimate
.com
Saving contractors
time
and
money
by delivering
complete
bid estimates.
Trade Adds
How do I create my ads?
State
City
Agency
Project #
Description
Bid Date
$hostname = "localhost"; $username = "contract_contrac"; $password = "BigBucks"; $usertable = "advertising"; $dbName = "contract_contract"; MYSQL_CONNECT($hostname, $username, $password) OR DIE("Unable to connect to database"); @mysql_select_db( "$dbName") or die( "Unable to select database"); ?> $query = mysql_query("SELECT * FROM advertising WHERE EXPIRES >= '$NOW' order by $Sorted"); //$i=1; while ($row = mysql_fetch_array($query)) { $variable1=$row["NUMBER"]; $bgcolor="#e0e0e0"; if (is_int($i/2)) { $bgcolor="#FFFFFF"; } echo"
"; print $row["COUNTY"] ; echo "
"; print $row["LOCATION"] ; echo "
"; print $row["AGENCY"] ; echo "
"; print $row["PROJECT"] ; echo "
"; print $row["PROJECTTEASE"] ; echo "
"; print $row["BIDDATE"] ; echo "
"; $i++; } //end ?>