problem with database connection. . Really stumped me
Posted: Tue Oct 14, 2003 9:44 am
Hi all,
Here is the code:
It returns the error "problems getting job listing" but as far as i'm concerned the dbasehost, user and password are all correct. I'm at an absalute loss here...
Can anyone see a problem with the code that might cause the error?
Thanks SO much for your help
Rob
Here is the code:
Code: Select all
$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( "problems getting job listing");
While ($row = mysql_Fetch_array($result)){
$user=$rowї'username'];
$pass=$rowї'password'];
}
mysql_close();Can anyone see a problem with the code that might cause the error?
Thanks SO much for your help
Rob