Updating multiple fields

Phouber · #1 05-04-2008, 05:54 AM

Hey guys,
I have a code here that works fine, the problem is i want to update more than 1 field.

PHP Code:

  function updateField($username, $table, $field, $value) {

 con=connect(); //My connection function

 $query = "UPDATE " .$table. " SET " .$field. "=" .$value. " WHERE username='$username'";

 $result = mysql_query($query, $con) or die(mysql_error());

}

Am I allowed to use an array or do I have to use

PHP Code:

  while($query = "UPDATE " .$table. " SET " .$field. "=" .$value. " WHERE username='$username'";) {

 mysql_query($query, $con);

}

Thanks
Matt

Phouber · #2 05-04-2008, 06:46 PM

Hello?

Phouber · #3 05-07-2008, 03:24 AM

Hey guys, thanks for the help ;)

navaldesign · #4 05-07-2008, 10:28 AM

You got no help because no help can be offered.

There is no way to batch update a database, at least to my knowledge. You can only create a loop that will repeat the same operation as many times as required.

Phouber · #5 05-07-2008, 08:26 PM

a loop such as

PHP Code:

  while($query = "UPDATE " .$table. " SET " .$field. "=" .$value. " WHERE username='$username'";) { 

 mysql_query($query, $con); 

}

?

navaldesign · #6 05-07-2008, 09:30 PM

The loop depends on the logic, but there i can't see the logic in the loop you posted. The loop depends on what you need to to.

If you can explain the logic, we will be able to help.

Watdaflip · #7 05-07-2008, 10:25 PM

All that while loop is checking for is if $query = something... which since you are using a string that stays constant its always going to be assigned at the very least
"UPDATE SET WHERE username='$username'"

Now what you need to do is count how many elements are in the array using the count() function. Then just use a for loop (or while loop if you wanted) and go through each element of the array one by one until you have gone through it count() times.

PHP Code:

  $count = count($array);
for($i=0; $i < $count; $i++)
{
// do whatever with... $array[$i]
}

Also keep in mind (I don't know if this will work in your exact situation), but you can update more then one column of the same row at a time, just format your query like

PHP Code:

  UDPATE table_name SET column1='value1', column2='value2', column3='value3' WHERE username='$username'

Phouber · #8 05-13-2008, 02:39 AM

Quote:

Originally Posted by Phouber

Hey guys, thanks for the help ;)

Sorry if I offended any1 i was just trying to keep the topic active :D

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)