Getting specific table row based on id mysql DB
<p>I have a database where I view all the records, the last column is the table ID, I click it and I want to be able to edit that rows data only, here's what I got but it doesn't waork after updating phpmyadmin:::</p>

<pre><code>      &lt;?php

include "db.inc.php";

$id=$_GET['id'];

      $order = "SELECT * FROM ircb where id='$id'";
      $result = mysql_query($order);
      $row = mysql_fetch_array($result);
      ?&gt;
      &lt;form method="post" action="update.php"&gt;
      &lt;input type="hidden" name="id" value="&lt;? echo "$row[id]"?&gt;"&gt;

        &lt;tr&gt;        
          &lt;td&gt;Date&lt;/td&gt;
          &lt;td&gt;
            &lt;input type="text" name="cdate" 
         value="&lt;? echo "$row[cdate]"?&gt;" size="30"  style="color: black;background-color:#FFFF11"&gt;
          &lt;/td&gt;
        &lt;/tr&gt;  
        &lt;tr&gt;        
          &lt;td&gt;Item&lt;/td&gt;
          &lt;td&gt;
            &lt;input type="text" name="item" 
         value="&lt;? echo "$row[item]"?&gt;" size="30"  style="color: black;background-color:#FFFF11"&gt;
          &lt;/td&gt;
        &lt;/tr&gt; 
</code></pre>

<p>I end up getting no results returned, when I hover over the link it does display the correct table row id but when I click the link I get empty boxes containing some of the code like <code>&lt;? echo</code> in the fields..no true values though..and the page header after clicking the link does show  ::: ...../edit_form.php?id=8  for row 8 so I assume something in my query is not quite right.
thanks</p>
