[SOLVED] Can I add more forms?

[Gayner]

if(isset($_POST['avatar'])){
	 mysql_query("UPDATE ibf_members SET avatar='25' WHERE id={$ibforums->member['id']}");
	 header("Location: index.php?act=UserCP&CODE=Avatar");
}

 

I have this as my HTML:

 

Avatat url * <input type="text" name="avatar" value="">
<input type="Submit" value="Update Avatar">

 

How can I update another field name using only 1 mysql_query function too?

thx

 

 

 

[halfman]

I am not sure what you want to do but I think you should be able to use AND or pass the field name and tablename from another table in your db as variables.

[Gayner]

I am totally lost, on what u said xD:d

[halfman]

my bad,

Cant you do this:

mysql_query("UPDATE ibf_members SET avatar='25', fieldName2 = 'value' WHERE id={$ibforums->member['id']}");

 

If not then I am not following your problem and I need a bit more info on that.

[Gayner]

Sweet, omg awesome, I love mysql now , thanks a bunch sir.

[halfman]

Sweet, omg awesome, I love mysql now , thanks a bunch sir.

No worries mate