Insert into table

[duny]

I would like to modify this part of the script

This is the insert form

<?
session_start();
?> 
$affname = $HTTP_SESSION_VARS['_amember_user']['login'];
<form action="script.php">
User ID: $affname<input type="hidden" name="Name" value="<? $affname; ?>><br>
Referred: <input type="text" name="Referred"> 
<input type="submit" name="submit" value="submit">
</form> 


When the user want to add his username to a member he referred i want it to be able to update the database

so i have this
[code=php]

$sql = " INSERT INTO members SET
Email = "$email",
First_Name = "$name"
");

i want it to select the table members and find the username and insert $affname in the street colum.

basically adding there name to the street name

[mogster]

I don't think this will work:

$sql = " INSERT INTO members SET 
Email = "$email", 
First_Name = "$name" 
");

Two ways:

$sql = "insert into members values ('', '$email', '$name')";

The first empty '' is for the autoincremented insert id, if you use that - if not, skip it.
This will do a full row in the db, and the values must match the number of fields in the table, else it fails.

The other method specifies the fields to be created, and leaves to mysql to tackle non-specified fields (creating default values):

$sql = "insert into members (email, name) values ('$email', '$name')";

knutm :-)

[yelvington]

Nothing wrong with

INSERT INTO table SET column1="string", column2=4;

Your original code, however, is bad PHP due to failure to escape embedded quotation marks:

$sql = " INSERT INTO members SET
Email = "$email",
First_Name = "$name"
");

should be

$sql = " INSERT INTO members SET
Email = \"$email\",
First_Name = \"$name\"
");

[duny]

since i have multiple fileds in there how can i choose the member i want to insert the data in

let say i have my members andrew and bob and i want to update andrews phone field. so what would i add to the above line.

[yelvington]

Look up WHERE in the MySQL manual.