button submit

[prolong199]

i have a button and when you click on it it executes a query, how do i make it so if i click a different button it executes a different query

[Xnuiem]

In whatever page you are going to after you press the buttons...

Name the buttons different things so when you press on one to submit the form, you can switch on that name. OR you can use the button as your input type and just go to URL using javascript and pass the argument in the URI. I suggest using the latter.

<input type=button value="button 1" onClick=goTo('page.php?button=1')>

<script language=javascript>
function goTo(url){
window.location.href = url;
}
</script>

Then in the destination page.

switch($_GET[button]){
case 1:
$sql = "query 1";
break;
case 2:
$sql = "query 2";
break;
}
mysql_query($sql);

This is all extremely basic logic. I doubt we are seeing anything new here, but you were more than likely having issues putting the logic together.

The best way to do this is figure out where you want to be. Then decide on a way to do that. Then work on how to get there. It doesnt have to be perfect, nor does it have to work the first time, and you can always change it later. But if you do not understand the process to follow and create logic, we will be seeing much more of you around here.

[gesf]

Xnuiem is right!
You can even do:

// Using this you´ll need the javascript function
// that´s in the Xnuiem post

<input id="query1" type="button" value="button 1" onClick="goTo('page.php)">

// Or: (in this case, the destination page 'page.php'
// will be in the form action

<input id="query1" type="submit" value="button 1">

// Then in the destination page.

// For the 2nd case: if(isset[$_POST['submit']]) {
// $_GET/$_POST depending on your form method

if(isset($_POST['query1']){
  $sql = "query 1";
}
elseif {
// Another one
}

mysql_query($sql);

Cheers