Need help with a function...

[Monkey644]

Hey all,

Can one you with your expert skills, help me out by making the following function work.

It currently loads the input area but doesn't submit...

 

function gang_staff_status(){global $db,$ir,$gangdata;if(isset($_POST['subm'])){$db->query("UPDATE gangs SET gangSTATUS={$_POST['vp']} WHERE gangID={$gangdata['gangID']}");print "Gang Status changed to {$gangdata['gangSTATUS']}";}else{print "<form action='yourgang.php?action=staff&act2=vicepres' method='post'>Enter the ID of the new vice-president.
<input type='hidden' name='subm' value='submit' />ID: <input type='text' name='vp' value='{$gangdata['gangSTATUS']}' maxlength='10' width='7' />
<input type='submit' value='Change' /></form>";}}

 

If someone could sort this out and post it for me, i would be grateful.

[Guest Null]

Why is the button invisible? and the input type has to be a submit, it cannot be hidden or itll act as hidden as far as i know

[Dayo]

try this

function gang_staff_status(){
global $db,$ir,$gangdata;
if(isset($_POST['vp'])){
$db->query("UPDATE gangs SET gangSTATUS=".mysql_real_escape_string($_POST['vp'])." WHERE gangID={$gangdata['gangID']}");

print "Gang Status changed to ".$gangdata['gangSTATUS'];
}else{print "<form action='yourgang.php?action=staff&act2=vicepres' method='post'>Enter the ID of the new vice-president.
ID: <input type='text' name='vp' value='".$gangdata['gangSTATUS']."' maxlength='10' width='7' />
<input type='submit' value='Change' /></form>";}
}

[Monkey644]

Nothing, just get Error processing request, error has been logged.

[Dayo]

this?

function gang_staff_status(){
global $db,$ir,$gangdata;
if(isset($_POST['vp'])){
$db->query("UPDATE gangs SET gangSTATUS='".mysql_real_escape_string($_POST['vp'])."' WHERE gangID='".$gangdata['gangID']."'");
echo mysql_error();
print "Gang Status changed to ".$gangdata['gangSTATUS'];
}else{print "<form action='yourgang.php?action=staff&act2=vicepres' method='post'>Enter the ID of the new vice-president.
ID: <input type='text' name='vp' value='".$gangdata['gangSTATUS']."' maxlength='10' width='7' />
<input type='submit' value='Change' /></form>";}
}

[Monkey644]

Nope, same as last time.

[Dayo]

re is your error log?

[Monkey644]

I dont know where it is

[Dayo]

can you disable that message? ...

also just a question you have made the table gangSTATUS

[Monkey644]

Yes i have and i dont know if i can disable, ill have a look

[Monkey644]

Now i'm getting

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Warring' WHERE gangID='24'', '/yourgang.php', unix_timestamp())' at line 2

[Monkey644]

Fixed it, thanks to everyones help :)

[Dayo]

no problem mate, try to find where your errors are loged, its much easier knowing what the error is rather then taling a stab in the dark