topshelfbleu Posted October 15, 2010 Share Posted October 15, 2010 Hi - I know this is a #101 question but here goes! I simply want to select a single row from a table and use the columns fields as variables that can then be posted in a form. $result = mysql_query("SELECT * from tblquestions WHERE qid='1'"); if (!$result) { echo 'Could not run query: ' . mysql_error(); exit; } $row = mysql_fetch_row($result); $oid=$result['oid']; $qid=$result['qid']; $question=$result['question']; The code above isn't working - as when I try to echo each variable <?php echo $question;?> nothing is being shown on screen. I'm obviously barking up the wrong tree in the way I'm trying to create the variable - but don't really have any idea where to look next. Link to comment https://forums.phpfreaks.com/topic/215918-variable-creation-from-table-beginners-question/ Share on other sites More sharing options...
Pikachu2000 Posted October 15, 2010 Share Posted October 15, 2010 Have you made sure the query isn't returning an empty result set? Link to comment https://forums.phpfreaks.com/topic/215918-variable-creation-from-table-beginners-question/#findComment-1122577 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.