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
I HAVE granted uname etc and flush priviliges...
$conn = mysql_connect("localhost", "news", "news");
//Pick the database to use
Here's my script for that page, calling entries from db and (suppose to) display them :
$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);
this is EXACTLY what I've always done (I've actually copied and pasted everything..
<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>
} while ($rows = mysql_fetch_assoc($rssub)) ;
PLEAAAASE help me! I just don't know what to do??!