[SOLVED] way to work around code

[contra10]

is there a way to work around this code

	<?php
mysql_connect("localhost", "root", "") or die(mysql_error()); 
mysql_select_db("registration") or die(mysql_error()); 

if (isset($_POST['submit'])){

if(is_numeric($_POST['grp'])){
$id = $_POST['grp'];

$query= "SELECT * FROM groups WHERE id = $id";
$result = mysql_query($query) or die(mysql_error());;
$group = mysql_fetch_assoc($result);
$groupname = $group['name'];

$insert = "INSERT INTO groups (user) VALUES ('$username') WHERE name = '$groupname'";

$add_group = mysql_query($insert) or die(mysql_error());   
}
else {
echo $_POST['grp'] . ": Is not numeric...";
}
   
?>

I need to upload information in a specific area but i can't user the where function

[contra10]

is there a way?

[revraz]

Not sure about anyone else, but I have no idea on what you are asking.

[contra10]

sry

 

k I want to input into a row of one of my tables a value but in a specific row...a row is created before and I want to know if there is a way to upload into that same row a new variable without using the UPDATE syntax

 

<?php

$insert = "INSERT INTO groups (user) VALUES ('$username') WHERE name = '$groupname'";
?>

 

like i want the username to be uploaded in a specific row

 

[contra10]

please tell me if that is clear enough?

[redarrow]

try this psudo code.

$insert="INSERT INTO groups (user)
SELECT *
FROM groups
WHERE name='$groupname'";

[redarrow]

Go to the bottom of this page, where i got the example from.

 

http://dev.mysql.com/doc/refman/5.1/en/insert.html

 

no nothing about it format, It wired but suppose to work.

[contra10]

that only inputted the username not in the row where i wanted it to be apart of othe values