You have an error in your SQL syntax. Check the manual that corresponds to your MySQL

netrepsa

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

=====================================

<table width="648" height="616" align="center" bgcolor="#FFFFFF">

<?php

  $db = mysql_connect("localhost", "doorinte_master","di0504c");

  mysql_select_db("doorinte_admin", $db);

  if ($Data=='resellers'){
    $result = mysql_query("SELECT * FROM resellers WHERE ID=$id",$db) or die(mysql_error());
  }ELSEIF ($Data=='maders') {
    $result = mysql_query("SELECT * FROM maders WHERE ID=$id",$db) or die(mysql_error());	  
  }ELSE {
    $result = mysql_query("SELECT * FROM andrews WHERE ID=$id",$db) or die(mysql_error());	  
  }
	    $myrow = mysql_fetch_array($result); 

?>

<tr>
<td width="638" height="578" align="center" valign="top" bgcolor="#FFFFFF"><p>
<?php
$pathto='/home/doorinte/public_html/pictures/';
$filename = $myrow["person_photo"] ;
if (file_exists($pathto.$filename)) {
?>
<img name="" src="../pictures/<? echo $myrow["person_photo"]?>" width="167" height="223" alt=""><br>
<?php
} else {
?>
<img src="../pictures/nopict.jpg" width="167" height="223"><br>
<?php
}
?>

   <strong><font color="#CC6633" size="4"><? echo $myrow["contact_name"] ?><br>
    </font></strong></p>
  <p><strong><font color="#CC6633" size="4">
<?php 
 $pathto='/home/doorinte/public_html/pictures/';
 $filename =  $myrow["company_photo"] ; 
	if (file_exists($pathto.$filename)) {
?>	
  <img name="" src="../pictures/<? echo $myrow["company_photo"]?>" width="527" height="250" alt=""><br>
<?php
   } else { 
?>
<img src="../pictures/nomap.jpg"  width="527" height="250"><br>
<?php
   }

?> 

    Map </font></strong></p></td>

</tr>
<tr>
<td height="30"><div align="center"><font size="1" face="Arial, Helvetica, sans-serif"><strong>©
2004 Door International. All Rights Reserved</strong></font> </div></td>
</tr>
</table>
</body>
</html>

tuf-web_co_uk

this should be in the database forum 😛

try single quoting your field names in your queries. oh and also put apostrophes round '$variables'

$result = mysql_query("SELECT * FROM resellers WHERE ID=$id",$db) or die(mysql_error());

becomes

$result = mysql_query("SELECT * FROM resellers WHERE ID='$id'",$db) or die(mysql_error());

do that for the rest of them and then try your script again

Weedpacket

Have a look also at the first question in the Debugging 101 thread in the Echo Lounge.