I have two servers, a test and real one (obviously
The problem I'm having is located at: http://10secondclub.net/jobs.php?sort=dateasc so you can see it for yourself. The site is still under development but you get the idea
Basically, the password in the config.php is DEFINATELY correct. I have an admin panel for my jobs area and it uses the same file and can connect and run not a problem, so it's not the password or username etc.
Here's the code that it errors with:
Code: Select all
require("config.php");
$dbLink = @mysql_connect($dbasehost,$dbaseuser, $dbasepassword);
mysql_select_db($dbase);
$sql="Select * FROM jobnum ORDER BY recordid ASC";
$result = mysql_query ($sql,$dbLink) or die( "oh no, there's a problems getting job list from the database.");
While ($row = mysql_Fetch_array($result)){
$user=$row['username'];
$pass=$row['password'];
}
mysql_close();Can anyone see any glaring problems? I'm tearing my hair out... Surely it's so simple.
Thanks !
Rob