Syntax error! Probably easy answer!!

[BigX]

Hi,

 

I'm still learning PHP so this question is probably easy for you PHP veterans 

I have this piece of code:

 

<?php

 

  $id = $_GET['id'];

  $organisatie = mysql_query("SELECT * FROM organisaties WHERE id=" . $id);

 

  echo "<table width='400' border='0'>

  <tr>

  <td width='400' bgcolor='#FFFFFF'>'$organisatie[Organisatie]'</td>

  </tr>";

 

?>

 

I only see '' on the page while I would like to see $organisatie[Organisatie]!! There is probably something really wrong with the syntax there but I don't know what!!

 

Thanx in advance for any help!!

[ratcateme]

you need to fetch a mysql result array like this

<?php
    
     $id = $_GET['id'];
     $result = mysql_query("SELECT * FROM organisaties WHERE id=" . $id);
     echo "<table width='400' border='0'>";
     while($row = mysql_fetch_array($result)){
          echo "<tr>
          <td width='400' bgcolor='#FFFFFF'>'$row[Organisatie]'</td>
          </tr>";
     }
    
?>

 

Scott.

[darkfreaks]

also your query is wrong

 

 

:

 

<?php

$result = mysql_query("SELECT * FROM organisaties WHERE id= '$id'");?>

[BigX]

Thanks that worked!!

 

One other short questions! The result that shows should be 'Blijf van m'n lijf' (Dutch) but it won't show the '

Instead it shows 'Blijf van m(square)n lijf' Why is this and is there any way around this??

 

thanks

[darkfreaks]

 

 

try:

<?php

$id=mysql_real_escape_string(trim($_GET['id']));

?>

[darkfreaks]

you could also try

 

<?php

str_replace('square',"'",$id);?>

[conker87]

also your query is wrong

 

 

:

 

<?php

$result = mysql_query("SELECT * FROM organisaties WHERE id= '$id'");?>

Actually, that's a perfectly legal query if the field id is an integer (which considering it's an ID, it probably is)