// Connect to hcometz database and retrieve data $username="root"; $password="alcatraz5757"; $database="hcometz"; mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $query="SELECT category FROM tb_categories where position > 0 order by position"; $result=mysql_query($query); $num=mysql_numrows($result); $query2="SELECT category FROM tb_categories where subcategory = 1 order by subcategory"; $result2=mysql_query($query2); $num2=mysql_numrows($result2); $query3="SELECT category FROM tb_categories where subcategory = 3 order by subcategory"; $result3=mysql_query($query3); $num3=mysql_numrows($result3); #$query4="SELECT [date] FROM tb_inventory order by [date]"; $query4="SELECT date FROM tb_inventory order by date desc limit 1"; $result4=mysql_query($query4); $num4=mysql_numrows($result4); $query5="SELECT * FROM tb_links order by position"; $result5=mysql_query($query5); $num5=mysql_numrows($result5); mysql_close(); //Get today's date for Copyrite $today = getdate(); $year = $today['year']; ?>
|
||||||||
|