Jump to content


Photo

[resolved] mysql_fetch_array problem


  • Please log in to reply
1 reply to this topic

#1 mojoman

mojoman
  • Members
  • Pip
  • Newbie
  • 3 posts
  • LocationUK

Posted 07 October 2003 - 03:52 PM

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

#2 mojoman

mojoman
  • Members
  • Pip
  • Newbie
  • 3 posts
  • LocationUK

Posted 07 October 2003 - 04:06 PM

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




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users