Proplems with variable in PHP script for MySQL..

[Pheddy]

Could anyone explain to me why I dont get any info from this code?

<?php
$strID = $_GET["id"];
echo $strID . "<br>";
 
$con = mysql_connect("someserver","someuser","somepass");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
 
mysql_select_db("db_doc", $con);
 
$result = mysql_query("SELECT * FROM docx_main WHERE ID= 'strID'");
 
while($row = mysql_fetch_array($result))
  {
  echo $row['doc_titel'] . "<br />" . $row['doc_body'];
  echo "<br />";
  }
?> 

It showes that the strID is right, when calling page?id=2 but it echoes no text from DB, if I remove the

 WHERE ID= 'strID'

it print every post.. So spelling and (everything) must be right, but why not when using WHERE?

Thanks for any reply!
Frederik

[Markus]

Try adding or die(mysql_error()); to your mysql_* functions.

$result = mysql_query("SELECT * FROM docx_main WHERE ID= 'strID'") or die(mysql_error());
 

[Dormilich]

@Pheddy
maybe you mean

 WHERE ID= '$strID'

[Pheddy]

Hehe sometimes a problem seems so complex, and most of the time you just need to add $ :D Thanks Dor..

[Dormilich]

yea, a dollar makes the world go round *g*