$Txt returns empty!

$SQL="SELECT * FROM PreviewText"; 
$Txts = mysql_query($SQL);
while($Txt = mysql_fetch_array($Txts));
{
  $SQL="Select * From Texts Where TemplateID = $TemplateID and TextID = '$Txt[1]'";
  $result = mysql_query($SQL);
  $row = mysql_fetch_row($result);
  $PosLeft = $row[2]*$Inch; 
  $PosBottom = $row[3]*$Inch;
  $PosWidth  = $row[4]*$Inch;
  $PosHeight  = $row[5]*$Inch;
  $Font  = "$row[6]'";
  $Color  = "'$row[7]'";
  $Shadow = "'$row[8]'";
  //Create Text Overlay Image
  imagettftext($overlay,36,0,$PosLeft,$PosBottom,$red ,'Fonts/grilcb',$Txt[2]);
}

How do you know WHAT each element of the $Txt array holds when you use SELECT * ???

reorder the table columns and your query goes totally belly up!

OMFG

while($Txt = mysql_fetch_array($Txts)) ; <---- LOOK HERE!!!11

You never get into that cycle!

Chris, is there any significant use of reordering tables in means of performance?

None that I know of, but it won't be the first time tables have been restructured and the programmer has assumed it will never happen.

That's why I prefer mysql_fetch_object() and then refer as $var->field_name