Submit, Update, Delete

[corruption]

I was wondering if on a form i could have three buttons.

i.e. <input type="submit" name"Submit" value= <?php $sql = INSERT INTO test (fname,lname,number,phone,address,,,) VALUES ('$fname','$lname',,,,);

$query = mysql_query($sql); ?>

<input tpye="submit" name="Delete" value = <?php $sql Delete from test ..... ?>

and <input type = "submit" name="Update" value= <?php UPDATE employees SET first='$first',last='$last',address='$address',position='$position' WHERE number='number'; ?>

or somehing like that??

[LifeComITGuy]

Hrm, I'd say no, not like that anyway.

See, the problem is, you're looking to have your form submit server side code. what will happen is that the webserver will execute that code and you'll only see its output. No only that, but if you put in a mysql_query() function for every one, the webserver will execute that command automatically, which can lead to some very nasty and confusing bugs. I did something like this awhile back using PHP to load crystal report pages. the way I did it is something like this -

<form action="load.php?type=insert" method="post">
<input type="submit" value="Run Insert Query">
</form><br>
<form action="load.php?type=delete" method="post">
<input type="submit" value="Run Delete Query">
</form><br>
<form action="load.php?type=update" method="post">
<input type="submit" value="Run Update Query">
</form>

Then, on the load.php page

<?

$type = @$_POST['type'];

if($type == "insert"){
    $sql = "INSERT INTO ...";
}elseif($type == "delete"){
   $sql = "DELETE FROM ...";
}elseif($type == "update"){
   $sql = "UPDATE TABLE SET ...";
}

Hope that helps