This is my code:

 
<?php
$conn = mysql_connect("xxx","xxx","xxx"); 
mysql_select_db("xxx",$conn);
$ClientID = $_COOKIE["Brag_Flag_user"];
//Get Project Info
$SQL="Select * From Projects where ClientID = $ClientID and Status = 'Current'";
$result = mysql_query($SQL);
$row = mysql_fetch_array($result);
$ProjectID = $row[0];
$TemplateID = $row[2];
//Store Input Text
$TextID = $_GET["TextID"];
$Text = $_GET["Text"];
$SQL="Update ProjectText Set Text = '$Text' Where ProjectID = $ProjectID and TextID = $TextID";
mysql_query($SQL);
 
//Scaling to match Preview
$Inch = 24;
$overlay = imagecreatefrompng("Images/Overlay_Blanks/24x36.png");
$red = imagecolorallocate($overlay, 255, 0, 0);
$black = imagecolorallocate($overlay, 0, 0, 0);
 
//Set Overlay Destination
$TextOverlays = "Images/Text_Overlays/$ProjectID.png";
$SQL="Select TxtFldCnt from Templates Where TemplateID = $TemplateID";
$result=mysql_query($SQL);
$row=mysql_fetch_row($result);
$TxtFldCnt= $row[0];
for ($i=1;$i<=$TxtFldCnt;$i++);
 {
  //Get Stored Text
  $SQL = "Select PreviewText . Text , Texts . * From PreviewText Inner Join Texts on PreviewText . TextID = Texts . TextID Where PreviewText . TextID = $i And PreviewText . ProjectID = $ProjectID And Texts . TemplateID = $TemplateID";
$result=mysql_query($SQL);
$row = mysql_fetch_array($result);
$PosLeft = $row[3]*$Inch; 
$PosBottom = $row[4]*$Inch;
$PosWidth  = $row[5]*$Inch;
$PosHeight  = $row[6]*$Inch;
$Font  = "Fonts/".$row[7];
$Color  = $row[8];
$Shadow = $row[9];
  echo "$overlay,36,0,$PosLeft,$PosBottom,$red ,$Font,$row[0]";
  //Create Text Overlay Image
  imagettftext($overlay,36,0,$PosLeft,$PosBottom,$red ,$Font,'$row[0]');
 }
 
//Save TextOverlay
imagesavealpha($overlay, true);
imagepng($overlay,$TextOverlays);
//Set Destination for Preview Image
$preview = "Images/Previews/$ProjectID.png";
//Create Copy of Project Template for Project Preview
$ProjectPreview = imagecreatefrompng("Images/Project_Templates/$ProjectID.png");
//Create Copy of Photo Overlay
$Photo = imagecreatefrompng("Images/Photo_Overlays/$ProjectID.png");
//Create Copy of Text Overlay
$Text = imagecreatefrompng("Images/Text_Overlays/$ProjectID.png");
//Paste Text Overlay 
imagecopy($ProjectPreview,$Text,0,0,0,0,570,864);
//Paste Photo Overlay
imagecopy($ProjectPreview,$Photo,0,0,0,0,570,864);
//Save Preview
imagesavealpha($ProjectPreview, true);
imagepng($ProjectPreview,$preview);
?>

You will se in the red portion the query string refers to the variables $ProjectID, TemplateID and $i. I can echo these values and they are there. When I echo the SQL string it comes out like this:

Select PreviewText . Text , Texts . * From PreviewText Inner Join Texts on PreviewText . TextID = Texts . TextID Where PreviewText . TextID = And PreviewText . ProjectID = And Texts . TemplateID =

What am I doing wrong?

remove the spaces between the tablenames, the fullstops (periods) and the fieldnames