getting the query (i did that) and update not workign?

[dv6cougar]

ok so my goal here is to actually print the rows and that part is working.... but then after they have been printed... have them be able to add on to what they have in the field and/or edit it too.

$id = 59;
$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' ,
								   gallery='$gallery',
								   exteriorneons='$exteriorneons',
								   interiorneons='$interiorneons',
								   WHERE id=$id";
				//line 

$query2 = "SELECT * FROM users WHERE id=$id";
$result = mysql_query($query2);
$row = mysql_fetch_row($result);


mysql_query($query);

that's the main php portion(database is connected from a 2nd script which is included)

now the values DO show up as I want them to in the table...

and this is only a test for id=59 for now..

here's an eample of a row that needs to be able to can update

<tr><td>Wheels:</td><td align="center"><input type="text" name="Wheels" value="<? echo $row["8"]; ?>"></td></tr>

what am i doing wrong? it does echo row 8 too, just won't update upon submit.

any help is greatly appreciated thanks

[whaites]

Drop the comma in the last line of your update before the WHERE clause:
___________________________________interiorneons='$interiorneons',

[dv6cougar]

got it! thanks

now how come I can't use WHERE username=$username???

i need to be able to do that

thanks 🙂

[whaites]

Use single quotes around character strings

echo " WHERE username='".$username."'";

[dv6cougar]

thanks

i got it now i used $_GET