Re: theme header query
| From: | DL Neil | Date: | Mon, 21 Jan 2002 19:13:25 +0000 |
| Subject: | Re: theme header query | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-16031@lists.php.net to get a copy of this message | ||
Tables should be opened and closed
- and (please) code should be readable!
=dn
----- Original Message -----
From: Barry Rumsey
To: php-db@lists.php.net
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