mojoman Posted October 7, 2003 Share Posted October 7, 2003 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 Quote Link to comment Share on other sites More sharing options...
mojoman Posted October 7, 2003 Author Share Posted October 7, 2003 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.