mojoman

Hi all, This may well be a really daft question but if anyone can help out it would be much appreciated. I am looking to create a new MySQL database on my remote server. When I make a database on my local server (Apache on Mac OSX) I open up the terminal and type /usr/local/mysql/bin/mysql and everything MySQL related appears. How do I find out the path to MySQL on the remote Linux machine? The MySQL directory is (obviously) locked away somewhere on the remote server so that the multiple domains can\'t get to each others databases but what do I need to type into the terminal to reach MySQL and create a new database? I am the overall administrator of all the domains so I know the usernames/passwords etc., I just can\'t find MySQL! Thanks for your patience and thankyou, in advance, for your time! Dan

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

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