in one form use one variable twice?

dv6cougar

so in my form the user inputs a username

<input type="text" name="username">

later on i need this to work but I cannot get it....

value="<? echo "<a href=http://wwww.dv6cougar.com/picturedb/memberpics/$username/>$username 's Gallery</a>"; ?>"

now the print query i set up for now shows it all right...

INSERT INTO users (username, year etc etc gallery) 
VALUES ('dv', '1999', etc etc '\'s Gallery')// <-- show as a link that doesn't add the $username to it

why's this not working?

i also thought maybe I could get $_POST["username"] to possible work but no luck...

why isn't dv showing up in my link? and where is the \ coming form in my link?

also in the link, i could not use the href=" or it would mess up with the value="

any ideas? or can I just not use the $username as an input before after the form has gone through?

how would I do this? I tried setting up $username = $usergal; too but that didn't work either

thanks alot

one more thing in the php portion where i show how my printed query shows up..... there is \ in there but doesn't show up, so it looks like this '\'s Gallery

weird?

dv6cougar

ok wow the \ dissapeared again.... i think i know what I must do 🙂

let me try

dv6cougar

doh no luck

any help is appreciated

thanks

dv6cougar

anyone know how I can accomplish this 🙁

thanks

khaldryck

if you want to use variables from your form before submiting it, you need to use javascript instead of PHP. (but then no inserts into D😎 using this :

document.form1.username.value

else, all you need to do is to declare

<form name="form1" action="your action page.php" method="post">

and add a submit button to your form.

in the called page, you do the insert using $username
or

 $_POST["username"]

at the end of your script you can then redirect to a display page
using

header("Location: displaypage.php");

this way, you'll only insert once even if the user hits the refresh button.

hopes this helps.

Regards

dv6cougar

thanks

i got it all figured out already 🙂

but that's not a bad idea for my next script 🙂