Newbie Problematic Insert

[Anon]

Hi
I'm new to php and not too hot on the language. Could someone please help me here... I would like to insert into the table "leader" column "team"....the value of "$teamname" where "$teamleader" = "staff_id"
$teamname and $teamleader are passed to the page in a form.

$sql2 = "INSERT INTO leader (team) WHERE staff_id=$teamleader
VALUES (\"$teamname\")";

$sql_result2 = mysql_query($sql2) or die ("Couldn't execute query 2");

if (!$sql_result) {
echo "<p>Couldn't add record 2!";
}

Thanks in advance
Matt Thornhill

[Anon]

You can't insert with a where clause. Inserting is adding, and you can't add a row to an existing row. You need to update the row.

I'm assuming that your table is something like this:

team_id, staff_id, leader

And you currently have some rows in there:

1, 1, bob
2, 3, joe
3, 2, frank

And now you want to change the leader of staff_id 3's row. You'd do this:

update team set (leader='john') where staff_id = 3;

If you have a brand new team that you are inserting information for you need to insert it all:

insert into team values (4,4,'john');

[Anon]

Hi

My table (leader) contains:

leader_id staff_id team

I want to update a team name where $teamleader = staff_id

//second sql insert
$sql2 = "UPDATE leader SET (team) WHERE staff_id = $teamleader
VALUES (\"$teamname\")";

$sql_result2 = mysql_query($sql2) or die ("Couldn't execute query 2");

if (!$sql_result) {
echo "<p>Couldn't add record 2!";
}

I'm still doing something wrong, so I guess I still havn't got the syntax correct.

[Anon]

Cheers Rob I figured it now 😃

Thanks loads for the help....
Cheers

Rob wrote:

You can't insert with a where clause. Inserting is adding, and you can't add a row to an existing row. You need to update the row.

I'm assuming that your table is something like this:

team_id, staff_id, leader

And you currently have some rows in there:

1, 1, bob
2, 3, joe
3, 2, frank

And now you want to change the leader of staff_id 3's row. You'd do this:

update team set (leader='john') where staff_id = 3;

If you have a brand new team that you are inserting information for you need to insert it all:

insert into team values (4,4,'john');