eugene2009 Posted November 17, 2009 Share Posted November 17, 2009 i ran into a problem... Just a quick narrowed down example.. $query = mysql_connect ($db_hostname, $db_username, $db_pass) or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db ($db_name); $id = $_GET['id']; //gets the id from url $query = "SELECT * FROM comments WHERE id='$id'"; //select records with passed id $result = mysql_query($query); //perform the query $row = mysql_fetch_row($result); echo 'The customers name is, '.$row['name'].' and he made a purchase on, '.$row['date'].'.<BR>'; ?> What am I doing wrong? Quote Link to comment Share on other sites More sharing options...
Zyx Posted November 17, 2009 Share Posted November 17, 2009 Just a quick look to the manual should help: http://docs.php.net/mysql_fetch_row mysql_fetch_row() returns an array with numerical indexes. The function you are looking for is mysql_fetch_assoc(). BTW. Do not create so many variables when you do not need them and use some form of error reporting: $result = mysql_query('SELECT * FROM `comments` WHERE `id` = \''.$_GET['id'].'\'') or die(mysql_error()); if($row = mysql_fetch_assoc($result)) { // row fetched } else { // no results } That's much better... 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.