I will appreciate it EXtreamly if someone can help me asap, please. Created a database, ashtonnews, with table tblsubscribe. On my page where the database should list the entries, it doesn’t show. Give’s me a msg :
Warning: mysql_connect(): Access denied for user: ‘news@localhost’ (Using password: YES) in c:\inetpub\wwwroot\ashton\db_connect.php on line **3
**Here’s my db_connect.php
//open connection
$conn = mysql_connect("localhost", "news", "news");
//Pick the database to use
mysql_select_db("ashtonnews", $conn);
I HAVE granted uname etc and flush priviliges…
Here’s my script for that page, calling entries from db and (suppose to) display them :
include('../db_connect.php');
$sql = "Select * from tblsubscribe";
//Create recordset called $rssub
$rssub = mysql_query($sql,$conn);
//Find out how many records in the recordset
$rows = mysql_fetch_assoc($rssub);
do {
<tr>
<td align="left"><?php echo $rows['sid']; ?></td>
<td align="left"><?php echo $rows['sname']; ?></td>
<td align="left"><?php echo $rows['semail']; ?></td>
<td align="left"><?php echo $rows['sdate']; ?></td>
</tr>
} while ($rows = mysql_fetch_assoc($rssub)) ;
this is EXACTLY what I’ve always done (I’ve actually copied and pasted everything…
PLEAAAASE help me! I just don’t know what to do??!