Jump to content

variable creation from table - Beginners question


topshelfbleu

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.

Archived

This topic is now archived and is closed to further replies.

×
×
  • 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.