Jump to content

variable creation from table - Beginners question


topshelfbleu
 Share

Recommended Posts

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
Share on other sites

This thread is more than a year old.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.