[RESOLVED] Help with coding please...

Biter

I am trying to create a new script that will allow awards to be removed from a pilot that already has awards. Reason? double posting of awards requires removal.

I have created this script and I am close but far.

} elseif($Delete_Award) {
$frm_pilot = $POST['frm_pilot'];
$frm_award = $POST['frm_award'];

if(!$frm_pilot || !$frm_award) {
	include("header.inc.php");
	ShowErrorPage('One field is missing');
}

$Delete = new MySQLquery;
$Delete->query('DELETE FROM PilotAwards WHERE pw_user_id = ' . $frm_award',' . $frm_pilot');

The last line is not right.....I can't seem to find where I'm not getting it correct. This line that I tried: $Delete->query('DELETE FROM PilotAwards WHERE pw_user_id = ' . $frm_pilot);.........works, but it deleted ALL of the awards.....not quite what I want. I only want to delete the award that is selected (frm_award)

Any help would be appreciated.

Biter

sneakyimp

Use [/code] after your code and

 before it so that we can see the text formatted.  It looks like you have a syntax error in that last line -- you don't match up all your quotes and stuff.

Biter

} elseif($Delete_Award) {
$frm_pilot = $_POST['frm_pilot'];
$frm_award = $_POST['frm_award'];

if(!$frm_pilot || !$frm_award) {
include("header.inc.php");
ShowErrorPage('One field is missing');
}

$Delete = new MySQLquery;
$Delete->query('DELETE FROM PilotAwards WHERE pw_user_id = ' . $frm_award',' . $frm_pilot');

Biter

The last line is not right.....I can't seem to find where I'm not getting it correct. This line that I tried:

$Delete->query('DELETE FROM PilotAwards WHERE pw_user_id = ' . $frm_pilot);

.........works, but it deleted ALL of the awards.....not quite what I want. I only want to delete the award that is selected (frm_award)

Any help would be appreciated.

Biter

sneakyimp

Not having designed your database, I don't know what values you are after. It looks like you were trying to put a comma in there before somewhere.

Biter

This is the add award....which works fine.

} elseif($Add_Award) {
	$frm_pilot = $_POST['frm_pilot'];
	$frm_award = $_POST['frm_award'];

if(!$frm_pilot || !$frm_award) {
	include("header.inc.php");
	ShowErrorPage('One field is missing');
}

$Add = new MySQLquery;
$Add->query("INSERT INTO PilotAwards (pi_aw_id, pw_user_id, pw_aw_id) VALUES ('', '$frm_pilot', '$frm_award')");

sneakyimp

I essentially have no idea if this is correct but I'm trying anyway. You really should be trying harder to understand what your code is doing or you should give up programming.

$Delete->query("DELETE FROM PilotAwards WHERE pw_user_id = " . $frm_pilot . " AND pw_aw_id =  " . $frm_award);

Biter

27 years ago I was into programing, but of course php wasn't designed back then.

I tried my best with what little knowledge I have. You did find the solution to what I wanted and I appreciate it very much. Darn that AND statement...LOL...I'll have to remember that one next time.

Thank you again for your patience and time.

Cheers!

Biter

bradgrafelman

Don't forget to mark this thread resolved (if it is).