Jump to content

Archived

This topic is now archived and is closed to further replies.

mojoman

[resolved] mysql_fetch_array problem

Recommended Posts

hi there,

 

I\'m new and just coming down from the elation of getting mysql_connect to actually work.

 

I\'m having trouble with mysql_fetch_array and I can\'t see why. I have used the code below to link to the DB:

 

$db = mysql_select_db($database,$connection) or die (\"Couldn\'t select database.\");

$query = \"SELECT loginname FROM dantest\";

$result = mysql_query($query) or die(\"Couldn\'t execute query!\");

$row = mysql_fetch_array($result,MYSQL_ASSOC);

echo $row[\'password\'];

 

The problem is that $row, when echoed, returns the word \'array\' and not the name that I expected. I want to compare the loginname to another variable butI have clearly done something daft!

 

Any help would be greatly appreciated!

 

Cheers

 

Dan


Share this post


Link to post
Share on other sites

pardon me for being an idiot!

 

I have found the (rather obvious) error through the tried and tested method of staring hard at screen. I was trying to reference another column from within the array. As I only asked for one specific row of info (loginname) asking for $row[\'password\'] was never going to work!

 

Thanks for your time and patience

 

Dan

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.