[RESOLVED] Edit a complete record

[Tank_Girl]

Once again I'm completely lost, and I tried a tutorial but their code is failing miserably.
I'm trying to pull a full record data from a "edit.php?id=NUMBER" link.
Then have that in the form values to edit, and submit to update.php.
This is what I have so you can get an idea of what I'm attempting.
edit.php

<?php
$id=$_GET['id'];

include 'config.php';

mysql_connect(localhost,$user,$password);

$query=" SELECT * FROM gol_points WHERE id='$id'";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

$i=0;
while ($i < $num) {
$name=mysql_result($result,$i,"name");
$points=mysql_result($result,$i,"points");
$gold=mysql_result($result,$i,"gold");
$referral=mysql_result($result,$i,"referral");
$forums=mysql_result($result,$i,"forums");
$profile=mysql_result($result,$i,"profile");
$recruiter=mysql_result($result,$i,"recruiter");

echo "<form action=update.php method=post>
<input type=hidden name=ud_id value=$id>
Character Name: <input type=text name=ud_name value=$name><br>
Points: <input type=text name=ud_points value=$points><br>
Gold: <input type=text name=ud_gold value=$gold><br>
Referral: <input type=text name=ud_referral value=$referral><br>
Forums: <input type=text name=ud_forums value=$forums><br>
Profile: <input type=text name=ud_profile value=$profile><br>
Recruiter: <input type=text name=ud_recruiter value=$recruiter><br>
<input type=Submit value=Update>
</form>";

++$i;
}


?>

update.php

<?php

$ud_id=$_POST['ud_id'];
$ud_name=$_POST['ud_name'];
$ud_points=$_POST['ud_points'];
$ud_gold=$_POST['ud_gold'];
$ud_referral=$_POST['ud_referral'];
$ud_forums=$_POST['ud_forums'];
$ud_profile=$_POST['ud_profile'];
$ud_recruiter=$_POST['ud_recruiter'];

include 'config.php';

mysql_connect(localhost,$user,$password);


$query="UPDATE gol_points SET name='$ud_name', points='$ud_points', gold='$ud_gold', referral='$ud_referral', forums='$ud_forums', profile='$ud_profile', recruiter='$ud_recruiter' WHERE id='$ud_id'";
mysql_query($query);
echo "Record Updated";
mysql_close();

?>

[Tank_Girl]

NEVER MIND! lol
I was way off on the first part, but I got it.
Here is the finished result.
the edit.php I needed the fetch array.
in the update I notice one mistake forgetting to select the database.

edit.php

<?
include 'config.php';

mysql_connect(localhost,$user,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM gol_points WHERE id=$id";
$result=mysql_query($query);

$row = mysql_fetch_array($result);

$name= $row[1];
$points= $row[2];
$gold= $row[3];
$referral= $row[4];
$forums= $row[5];
$profile= $row[6];
$recruiter= $row[7];

mysql_close();

echo "ID - $id <BR><BR>";
echo "<form action=update.php method=post><input type=hidden name=ud_id value=$id>Character Name: <input type=text name=ud_name value=$name><br>Points: <input type=text name=ud_points value=$points><br>Gold: <input type=text name=ud_gold value=$gold><br>Referral: <input type=text name=ud_referral value=$referral><br>Forums: <input type=text name=ud_forums value=$forums><br>Profile: <input type=text name=ud_profile value=$profile><br>Recruiter: <input type=text name=ud_recruiter value=$recruiter><br><input type=Submit value=Update></form>";

?>

update.php

<?php

$ud_id=$_POST['ud_id'];
$ud_name=$_POST['ud_name'];
$ud_points=$_POST['ud_points'];
$ud_gold=$_POST['ud_gold'];
$ud_referral=$_POST['ud_referral'];
$ud_forums=$_POST['ud_forums'];
$ud_profile=$_POST['ud_profile'];
$ud_recruiter=$_POST['ud_recruiter'];

include 'config.php';

mysql_connect(localhost,$user,$password);
mysql_select_db($database) or die( "Unable to select database");

$query="UPDATE gol_points SET name = '$ud_name', points = '$ud_points', gold = '$ud_gold', referral = '$ud_referral', forums = '$ud_forums', profile = '$ud_profile', recruiter = '$ud_recruiter' WHERE id = '$ud_id'";
mysql_query($query);
echo "Record Updated";
mysql_close();
print $query;

?>

[Piranha]

Please mark this thread resolved, can be found under Thread tools. Then people won't read your code to try and spot errors and after that find out that the problem is already solved.