[SOLVED] php text form update help

[Jiraiya]

I need help creating this php updating form its supposed to update a pic url with a new one that is submitted by a html form i what i have is shown below

 

 

<form>
Picture URL:
<input type="text" pic="pic" />
<input type="submit" value="Submit" />
</form> 
<br />

</form> 
<?php

$username = $_COOKIE['ID_my_site']; 
mysql_connect("mysql", "username", "password") or die(mysql_error());
mysql_select_db("members") or die(mysql_error());


$sql = mysql_query("UPDATE users SET `pic` = name") or die(mysql_error());



?>

[Ken2k7]

1. In your INPUT tag, what's pic="pic"? Did you mean name="pic"?

2. What's name in your SQL - UPDATE users SET `pic` = name?

 

<form method="post">
Picture URL:
<input type="text" name="pic" />
<input type="submit" name="submit" value="Submit" />
</form>
<br />

</form>
<?php
if (isset($_POST['submit'])) {
$username = $_COOKIE['ID_my_site']; 
mysql_connect("mysql", "username", "password") or die(mysql_error());
mysql_select_db("members") or die(mysql_error());

$pic = mysql_real_escape_string($_POST['pic']);
$sql = mysql_query("UPDATE users SET `pic` = $pic WHERE username='$username'") or die(mysql_error());
}

?

[Jiraiya]

1. yes i did mean name=pic

2. im trying to update the pic variable in my database with the text submitted in the form above

[Jiraiya]

that code that you posted didnt do anything

[Ken2k7]

Well, I wasn't sure how to put it. If your SQL is just -

$sql = mysql_query("UPDATE users SET `pic` = $pic") or die(mysql_error());

 

then that would modify the pic for all users! I'm sure you only want to update one right?

[Jiraiya]

yes just for one user

[Ken2k7]

So how do you determine what user to set it for? What's the column name?

[Jiraiya]

i was hoping this would do it $username = $_COOKIE['ID_my_site'];

username = persons user name

[Ken2k7]

Hmm...

<form method="post">
Picture URL:
<input type="text" name="pic" />
<input type="submit" name="submit" value="Submit" />
</form>
<br />

</form>
<?php
if (isset($_POST['submit'])) {
$username = $_COOKIE['ID_my_site'];
mysql_connect("mysql", "username", "password") or die(mysql_error());
mysql_select_db("members") or die(mysql_error());

$pic = mysql_real_escape_string($_POST['pic']);
$username = mysql_real_escape_string($username);
$sql = "UPDATE users SET `pic` = '$pic' WHERE username='$username'";
$result = mysql_query($sql) or die(mysql_error());
}