QUOTE(we_undertaker @ 29 May, 2008 - 10:36 PM)
This is my form
<td><input type="text" name="cate[]" class="fieldTXTBOX" value="<? echo $row['Category']?>" /></td>
There is still an information gap here... there is stuff we need to know, in order to help you.
CODE
<?php
$query = "select * from categories";
This will select EVERYTHING. We don't know what column names you have in this database.
CODE
$result = mysql_query($query);
$num = mysql_num_rows($result);
?>
<?php
if($num > 0){
while($row = mysql_fetch_assoc($result)){
?>
This will fill the row array with number, not the column names.
Assuming that 'Category' is a column name, try this.
CODE
<form name="r_form" action="change_cate.php" method="post" enctype="multipart/form-data" onsubmit="return validateForm()">
<table width="90%" border="0" cellpadding="3" cellspacing="3">
<?php
$query = "select Category from categories";
$result = mysql_query($query);
$num = mysql_num_rows($result);
?>
<?php
if($num > 0){
while($row = mysql_fetch_assoc($result)){
?>
<tr class="mainCONTENT"><td class="label" width="100">Category :</td>
<td><input name="cat" class="fieldTXTBOX" value="<? echo $row[0]?>" /></td>
</tr>
<?php } } ?>
<tr><td> </td>
<td><input type="image" border="0" value="submit" onClick="return validateForm();" src="../images/Register_Submit_27.jpg" style="cursor:crosshair;"></td>
</tr>
</table>
</form>
28 May, 2008 - 09:59 PM
| 