[RESOLVED] trouble with mySql query

[freedmania]

In the table 'themes' in a mySql database, there are six records, id 22 - 27. The fields ('columns') are id; name; image; bgcolor.
When I run, "SELECT * FROM themes WHERE id='24';" from phpmyadmin, I get:
id = 24;
name = "Spring";
image = "Gabrielle.jpg";
bgColor = 11;
just as I should. But when I run this php script, ...

<?php
require_once('../Connections/seaecardsDB.php');

function setGlobals(){
global $selectImg, $imgW, $imgTh;
global $thName, $thFont, $thFcol, $thBGcol;

$imgg = $_POST["selectedImage"];
$imgDataRA = explode(",",$imgg);
$imgW = $imgDataRA[1];
$imgTh = $imgDataRA[2];

}

setGlobals();

// GET THEME STUFF = name, font, fontcolor, bgcolor
// $imgTh from setGlobals() is the index
print "Do I have imgTh $imgTh ** "; // I always do
$qr = 'SELECT FROM themes WHERE thid= \''.$imgTh.'\';';
$re = mysql_query($qr) or die(mysql_error());
$th = array();
$th[] = array('name'=>mysql_result($re,'thname'), 'font'=>mysql_result($re,'thfont'), 'fcol'=>mysql_result($re,'thfontcolor'), 'bgcol'=>mysql_result($re,'thbgcolor'));
echo 'AND THE WINNER IS - - - name '.$th['name']." font ".$th['font']." fcol ".$th['fcol']." bgcol ".$th['bgcol'];
?>
... $th is not an array. It is a single value that equals $imgTh. $th['name'], etc, are empty.

I've tried "name=>mysql_result($re,0,'theme_name')" and as many other variations I could think of. I must have screwed up the syntax somehow, but I don't see how. I've run out of brainpower, strength and time. Please.

Any help will be treasured, and used immediately.

Thanks,
Paul

[Drakla]

After your query us mysql_fetch_assoc() to pull results out as whole rows - each row is an array. It's much more efficient that mysql_result().

Also use print_r to look at your results if you're unsure of what's going on. Before your winner echo put

echo '<pre>'.print_r($th, 1).'</pre>';

You'll soon see you've got an array index zero with your results buried a level down.

So use $th = mysql_fetch_assoc($re); then do a print_r to get the full picture.

[freedmania]

gasp.

Magnificent. More thanks than I can offer are yours.

And, sorry about the missing '

' markup. I wouldn't want to cause the little bugger any undue distress.