Thank you Bas, i cant believe that once again it has been down to simple syntx cheers
"Bas" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] b1.pair.com... > Just change your code to: > > $result = mysql_query("SELECT * FROM $tablename WHERE id= $id")or > die("<br>ther was an error<br> > tablename:= $tablename<br> > row id:= $id"); > > > if ($myrow = mysql_fetch_array($result)) { > echo "<form method='post' action='edit3.php?tablename=$tablename'>\n"; > do { > printf("<input type='hidden' name='id' value=%s> > Artist <br><input type='text' name='artist' size=25 maxlength=25 > value='%s'><br> > Title <br><input type='text' name='title' size=25 maxlength=25 > value='%s'><br> > Picture <br><input type='text' name='picture' size=25 maxlength=25 > value='%s'><br> > Review <br><textarea name='review' cols=30 rows=5>%s</textarea><br> > Label<br><input type='text' name='label' size=25 maxlength=25 > value='%s'><br> > Format <br><input type='text' name='format' size=25 maxlength=25 > value='%s'><br> > Price <br><input type='text' name='price' size=10 maxlength=8 > value='%s'><br> > Rating <br><input type='text' name='rating' size=10 maxlength=8 > value='%s'><br>\n", > $myrow["id"], > $artist=$myrow["artist"], > $title=$myrow["title"], > $picture=$myrow["picture"], > $review=$myrow["review"], > $lable=$myrow["label"], > $format=$myrow["format"], > $price=$myrow["price"], > $rating=$myrow["rating"]); > } while ($myrow = mysql_fetch_array($result)); > echo "<br><input type='submit' value='Submit' name='submit'>"; > echo "<input type='reset' value='Reset' name='reset'></form>\n"; > } > > I have not tested this, but it should work(it was a html-problem) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php