theme header query
| From: | Barry Rumsey | Date: | Thu, 01 Jan 1970 00:00:00 +0000 |
| Subject: | theme header query | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-16027@lists.php.net to get a copy of this message | ||
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.