wth.... my INSERT INTO script is weird

[dv6cougar]

not sure what i'm doing wrong here but when the page is loaded, it ads an auto incremented id.

then once the form is filled out it does ti's job correctly.... but why is it doing this? any ideas?

$query = "INSERT INTO users (username, 
                               Year,
							   Color, 
							   Custom_color,
							   Model, 
							   Engine, 
							   FI,
							   Wheels, 
							   Tires, 
							   Hood,
							   Fenders,
							   Body_kit, 
							   Front_bumper,
							   Grill_insert,
							   Sides,
							   Rear_bumper,
							   exteriormods, 
							   interiormods,
							   suspensionmods,
							   performancemods,
							   audiomods,
							   gallery'
							   exteriorneons,
							   interiorneons) ";
$query .= "VALUES('$username',
				 '$Year', 
				 '$Color',
				 '$Custom_color',
                  '$Model',
                  '$Engine',
				  '$FI',
                  '$Wheels',
				  '$Tires',
				  '$Hood',
				  '$Fenders',
                  '$Body_kit',
				  '$Front_bumper',
				  '$Grill_insert',
				  '$Sides',
				  '$Rear_bumper',
                  '$exteriormods',
                  '$interiormods',
				  '$suspensionmods',
				  '$performancemods',
				  '$audiomods',
				  '$gallery',
				  '$exteriorneons',
				  '$interiorneons')";


mysql_query($query);

after this i have a

<?
if ($submit) {
//a table that says your profile has been entered into the database.

} 
else
{
?>
<!--my form is here-->
<?
}
?>

thanks all again 🙂

almost got this script down and once I do it's gonna be amazing.

also... i am having one issue with <a href=""> inside of a form value=""

it works but my problem is that the first field in teh form is username, which I am then using as a $username so it looks like this

<input type="text" name="username">
<!--rest of form goes here-->
<input type="hidden" name="gallery" value="<a href=http://../../<? echo "$username"; ?>/><? echo "$username"; ?>'s Gallery</a>

i have tried without out the ; after echo too, no luck.

i have tried href=" and it thros me an error whenever i do it that way... any ideas?😃

thanks 🆒

[craigh]

put

if ($submit) {

BEFORE the query.

[dv6cougar]

Originally posted by craigh
put

if ($submit) {

BEFORE the query. [/B]

oh ya, that would make sense!

anyone know who to do my link 🙁

thanks

[craigh]

trying to embed HTML into HTML probably is poor planning. Since nobody can see it, why not just send the username in the hidden field and then in your form action page, modify the value as needed? Or am I completely misunderstanding your question?

[dv6cougar]

Originally posted by craigh
trying to embed HTML into HTML probably is poor planning. Since nobody can see it, why not just send the username in the hidden field and then in your form action page, modify the value as needed? Or am I completely misunderstanding your question?

DUDE! excellent idea!

AMAZING! WOO HOO! leaves me with one less field in my huge db too!

thanks 🙂

[craigh]

Originally posted by dv6cougar
DUDE! excellent idea!

Heh - glad I could help.😉

[dv6cougar]

hey it worked with flying colors too 🙂