[RESOLVED] Inserting an array into the DB?

[ausgezeichnete]

Well,this is my code i tried to view the database table by putting the data in an array and looping into them:

for($i=0;$i<count($fields);$i++){

echo "<th>". $fields[$i]->name."</th>";
}
echo"</tr>";
while($records=mysqli_fetch_array($query,MYSQLI_NUM)){
echo"<tr>";
	for($y=0;$y<count($records);$y++){
		echo "<td>". $records[$y]."</td>";

no am trying to make an update page
so,i dont know how to update each of the fields into the database??
do i have to declare each field alone instead of using an array

[bpat1434]

Updates are essentially done on a column by column basis, so you only need to specify in the UPDATE clause what has actually changed. So if the user changes the "pseudo" column, our update statement would be:

UPDATE `tablename` SET `pseudo`='$user_supplied_value'

Hope that helps.

[ausgezeichnete]

thnx for trying to help i did but faced another problem!!
check it on my next thread plz

[kakki]

pls mark this thread closed