update mysql

[dv6cougar]

ok here's my script and it's not updating anything 🙁

i have removed the form and what not but all that is right, as it's used in anohter script and works perfectly

<?
include("db.php");

$query = "UPDATE * WHERE users SET username='$username',
					               Year='$Year',
								   Color='$Color',
								   Custom_color='$Custum_color',
								   Model='$Model',
								   Engine='$Engine',
								   FI='$FI',
								   Wheels='$Wheels',
								   Tires='$Tires',
								   Hood='$Hood',
								   Fenders='$Fenders',
								   Body_kit='$Body_kit',
								   Front_bumper='$Body_kit',
								   Grill_insert='$Grill_insert',
								   Sides='$Sides',
								   Rear_bumper='$Rear_bumper',
								   exteriormods='$exteriormods',
								   interiormods='$interiormods',
								   suspensionmods='$suspensionmods',
								   performancemods='$performancemods',
								   audiomods='$audiomods', 				   WHERE id=$id";

mysql_query($query, $mysql_access);

if ($submit) {
printf ("<table width=\"800\" align=\"center\" class=\"howto\" background=\"black\">");
printf ("<tr><td class=\"topcell\">Your Profile has been updated!</td></tr>");
printf ("</table>");
?>

<P>&nbsp;</P>
<?

}
else
{
printf ("<table width=\"800\" align=\"center\" class=\"howto\" background=\"black\">");
printf ("<tr><td class=\"topcell\">Fill this form out to update your profile</td></tr>");
printf ("</table>");
?>
<TABLE borderColor=#000000 cellSpacing=0 width="90%" bgColor=#000000 
            border=1 background="Welcome_files/background2.gif">
              <TBODY>
<form method="post" action="update2.php?id=<? echo "$id"; ?>">
<tr><td>Your unique id:</td><td><input type="text" name="id">
<tr>

how do I make this work?

it comes from another script where I just have a form to enter you id with as well, and the action is

action="update2.php?id=<? echo "$id"; ?>"

thanks i'm clueless on this one part... i've gotten insert to work, query to work and even made a search but updating's just nto doing it 🙁

[nnichols]

$query = "UPDATE users SET username='$username',
                                   Year='$Year',
                                   Color='$Color',
                                   Custom_color='$Custum_color',
                                   Model='$Model',
                                   Engine='$Engine',
                                   FI='$FI',
                                   Wheels='$Wheels',
                                   Tires='$Tires',
                                   Hood='$Hood',
                                   Fenders='$Fenders',
                                   Body_kit='$Body_kit',
                                   Front_bumper='$Body_kit',
                                   Grill_insert='$Grill_insert',
                                   Sides='$Sides',
                                   Rear_bumper='$Rear_bumper',
                                   exteriormods='$exteriormods',
                                   interiormods='$interiormods',
                                   suspensionmods='$suspensionmods',
                                   performancemods='$performancemods',
                                   $audiomods='$audiomods'
                                   Type_of_How_To='$Type_of_How_To',
                                   Mod_Name='$Mod_Name' 
                                   WHERE id=$id";

That should do it. It's the first error I saw. I haven't checked it through to the end.

[dv6cougar]

thanks

trying it now 😃

no luck 🙁

[nnichols]

Run your query like this -

@mysql_query($query, $mysql_access)
	or die('MySQL error: '.mysql_error().'<br>Query: '.$query);

This should give you a meaningful error.

[dv6cougar]

thank you much!

found my own problem!

works like charm!

🙂