not valid mysql-link resource, ARGH

holstead

Ok this is the first 6 lines of code in the file. I'm getting the "not a valid Mysql-Link resource" on line 5..which is the line where the while loop is declared. What in the hell is going on? I've checked this 1000 times and still have no idea why its bombing. it connects to the database fine, there is a customer database, there is a id field and a SubmitDate field, the mysql server is running, the query appears to be fine, atleast when I cut and paste it into mysql prompt it works. I'm at a loss, HELP!

<?
 $dbx = mysql_connect('localhost','root','password');
	$db = mysql_select_db('beachfractional',$dbx);
	$result = mysql_query('SELECT id, SubmitDate FROM customer', $dbx) or die(mysql_error());
	while($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
     echo("test");
 }
?>

holstead

Whenever I SELECT * or SELECT id it bombs out, for some reason it wont let me get the id field. Is this a reserved word?

id is primary key, is that the problem? I wouldn't imagine so.

dnast

I use id so that isn't the problem. Take $dbx out of your mysql_query() and see what happens (it's not necessary).

$result = mysql_query('SELECT id, SubmitDate FROM customer') or die(mysql_error());

Either way, I still don't see why your code wouldn't work unless it was just not connecting to the database.

hot_ice83

while($row = mysql_fetch_array($result, MYSQL_ASSOC)) {

why not try this:
$row = mysql_fetch_assoc($result, $dbx) {