Panel with MYsql data error
Asked Modified Viewed 1,183 times
asked
I am in the process of creating a panel with some mysql data in it. The information is displaying but I also get an error that repeats all over the place after I preview it:
Access denied for user 'username'@'localhost' (using password: NO)
It is odd as I do see the data from mysql, but I also get the error at the top of the page and the top of the preview panel.
Thanks in advance for any help you can provide.
Access denied for user 'username'@'localhost' (using password: NO)
It is odd as I do see the data from mysql, but I also get the error at the top of the page and the top of the preview panel.
Code Download source
openside("Pocket World Achievments");
?>
<html>
<body>
<?php
$username="username_pocket";
$password="xxxxxxxxx";
$database="username_pocket";
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT achievment.name, user.p_name
FROM achievment LEFT OUTER JOIN user ON achievment.p_id = user.p_id";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
?>
<table border="0" cellspacing="2" cellpadding="2">
<tr>
<td><font face="Arial, Helvetica, sans-serif"><b><u>Achievment</u></b></font></td>
<td><font face="Arial, Helvetica, sans-serif"><b><u>GamerID</u></b></font></td>
</tr>
<?php
$i=0;
while ($i < $num) {
$f1=mysql_result($result,$i,"achievment.name");
$f2=mysql_result($result,$i,"user.p_name");
?>
<tr>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f1; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f2; ?></font></td>
</tr>
<?php
$i++;
}
?>
</body>
</html>
<?php
closeside();
Thanks in advance for any help you can provide.
There are no post found.
Category Forum
Panels and InfusionsLabels
None yet
Statistics
- Views 0 views
- Posts 0 posts
- Votes 0 votes
- Topic users 1 member
1 participant
mhermann 10
- Newbie, joined since
- Contributed 1 post on the community forums.
- Started 1 thread in the forums
- Started this discussions
Notifications
Track thread
You are not receiving notifications from this thread.
Related Questions