Probably very simple answer. I hope!

[stig1]

I have a table filled with data that I get returned from MySQL using the mysql_fetch_array() function.

 

Within the table rows, I have an input box that I would like to set each value different.

 

Eg. $qty[0], $qty[1], $qty[2].

 

And so on, until it reaches the end of the data range set.

 

Is this possible? Simple? Any help most apprecaited.

[CroNiX]

<?php
while($qty = mysql_fetch_array($result)){
    echo "<tr><td><input type=\"text\" value=\"" . $qty[0] . "\" /></td></tr>\n";
}

or something close to that

[stig1]

that would work for a dataset that only returns 1 row.. but say i have 5 or 10 rows of data.

 

 

[redarrow]

<?php $res=array("cat","dog","pig"); ?>

<form method="POST" action="<?php echo $_SERVER['PHP_SELF'] ?>" ">

<br>

<?php foreach( $res as $r){

$replace=array("cat","pig",$r);

$replace_with=array("mice","tigger",$r);

$r=str_replace($replace,$replace_with,$r);
?>

<input type="test" name="<?php echo $r; ?>" value="<?php echo $r;?>" >

<?php } ?>

<br>

<input type="submit" name="submit" value="SEND!">

</form>

[Barand]

that would work for a dataset that only returns 1 row.. but say i have 5 or 10 rows of data.

 

 

 

why do you think that?

 

You will have to alter the [ 0 ] to the correct column offset for the qty value.

[stig1]

How would I do that dynamic? Cause I couldn't put the values in manual, due to each table could have a different number of rows.

 

Does the mysql_fetch_array function, have like an echo the array ID out?

[CroNiX]

What id are you talking about?  The array index?  I was only going by the example that you gave, $qty[0], $qty[1], $qty[2]...

The code I posted will create that table row for each qty in the result array...