Problem entering NEW data

[Rifts]

Hello everyone.. I have been struggling all day with this problem.

Here is some background info maybe it will help:

users can register on my website their firstname, lastname, username, password, and email are all saved to my database at this time.

when i user logs in they can go to their profile on this page i have a form, say it asks favcolor and cityborn
(here is where the problem is)...

after submitting the form I can not figure out how to enter the results into the database based on the user that is logged in.

so say my table looks like this:

fname lname user password email favcolor cityborn

john smith jsmith blabla blabla

jimmy jones jjones blabla blabla

mike banks mabnks blabla blabla

so if user mike is logged in and fills out the form I need his answers of favcolor to go in the correct row for him.

thanks, i hope that makes sense

[Rifts]

well my fake little table didnt space the way it was suppose to and i cant seem to edit mmy post sorry

[dagon]

the mysql:

UPDATE users set (whatever they set) WHERE id=USER_ID

you do seem to be missing an id field, in most set ups the id would be passed around the various pages (once logged in) in a session, and used for things like this.

[Rifts]

thank you update worked perfectly

now could you tell me why this wont work to display my data?

<?php
	//Start session
	session_start();

//Include database connection details
require_once('config.php');

//Array to store validation errors
$errmsg_arr = array();

//Validation error flag
$errflag = false;

//Connect to mysql server
$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
if(!$link) {
	die('Failed to connect to server: ' . mysql_error());
}

//Select database
$db = mysql_select_db(DB_DATABASE);
if(!$db) {
	die("Unable to select database");

	$query="SELECT * FROM members";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();
?>
<table border="0" cellspacing="2" cellpadding="2">
<tr>
<th><font face="Arial, Helvetica, sans-serif">Value1</font></th>
<th><font face="Arial, Helvetica, sans-serif">Value2</font></th>
<th><font face="Arial, Helvetica, sans-serif">Value3</font></th>
<th><font face="Arial, Helvetica, sans-serif">Value4</font></th>
<th><font face="Arial, Helvetica, sans-serif">Value5</font></th>
</tr>

<?php
$i=0;
while ($i < $num) {

$f1=mysql_result($result,$i,"field1");
$f2=mysql_result($result,$i,"field2");
$f3=mysql_result($result,$i,"field3");
$f4=mysql_result($result,$i,"field4");
$f5=mysql_result($result,$i,"field5");
?>

<tr>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f1; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f2; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f3; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f4; ?></font></td>
<td><font face="Arial, Helvetica, sans-serif"><?php echo $f5; ?></font></td>
</tr>

<?php
$i++;
}
?>

i get Parse error: parse error in C:\wamp\www\homepage\work.php on line 64

line 64 is ?>

[bradgrafelman]

The opening '{' brace on this line:

	if(!$db) {

is never closed.

[dagon]

beat me to it

[Rifts]

nvm figured it out