Problem with inserting info into database via _SESSION['username']

SeanKann

What I'm trying to do is the following

I have users logging in where they can edit personal info

I'm having problems with the INSERT part of getting it to the database

Here is my code

mysql_connect($DBhost,$DBuser,$DBpass);
@mysql_select_db($DBName) or die( "Unable to select database");

$query = "INSERT INTO $table VALUES '$realname', '$location', '$current' WHERE username=$username";
mysql_query($query);

$username = $_POST['username'];
$realname=$_POST['realname'];
$location=$_POST['location'];
$current=$_POST['current'];

mysql_close();

print "<HTML>
<BODY><center><table border=\"0\"width=\"500\"><tr><td>";
print "<p>You Just Entered This Information Into the Database<p><blockquote>";
print "Name : $realname <br>Location : $location<br>Current Game: $current<br></blockquote></td></tr></table>

Thank you $username
</center></BODY></HTML>";

It shows the info that they added into the database on the page but it doesn't goto the database when I check

Any help would be great

guest

$dbuser = "0000000";
$dbname = "0000000";
$dbpass = "0000000";
$dbhost = "0000000";
$table = "table_name";

//connect
mysql_connect($dbhost,$dbuser,$dbpass);
@mysql_select_db($dbname) or die( "Unable to select database");


mysql_query("INSERT INTO $table ( `realname` , `location` , `current` , `username` )
    VALUES ( '"$realname', '$location', '$current', '$username')");

what you had to do is put the option under which tab it should be in and the VALUES that it should put in

and dont forget it make a table in the DB

CREATE TABLE `table_name` (
  `realname` varchar(30) NOT NULL default '',
  `location` varchar(30) NOT NULL default '',
  `current` varchar(30) NOT NULL default '',
  `username` varchar(30) NOT NULL default ''
);

now you have to finish the rest which is make the forms to submit the values🙂

rockerscc

try assigning the local varialbles before the sql statement.