Tables should be opened and closed - and (please) code should be readable! =dn
----- Original Message ----- From: Barry Rumsey To: [EMAIL PROTECTED] Sent: 21 January 2002 17:54 Subject: [PHP-DB] theme header query I'm trying toadd thefollowing codeto atheme: ."<td class=topmenu width='73' height='19' bgcolor='#ffffff'>\n" ."$sqlhostname = "localhost"; $login = "xxxx"; $password = "xxxx"; $base = "xplyrics"; $db_connect = mysql_connect($sqlhostname,$login,$password); $base_selection = mysql_select_db($base,$db_connect);$query = "SELECT COUNT(*) FROM xp_topics WHERE artist='artist' ORDER BY topicid DESC LIMIT 1"; $numartist = mysql_query($query) or die("Select Failed!"); $numartist = mysql_fetch_array($numartist); <b>Total Artists:</b> $numartist[0]<br>; </td>\n" But when I try and load that page it comes back blank. Am I missing something or it just wont work. ____________________________________________________ IncrediMail - Email has finally evolved - Click Here