I am a beginner in PhP and mysql.
I am having trouble with connecting my vb6 program to my php script.

So far I have a textbox and a command button in vb6 . When I press the comand button I want to add the text into my MySql datbase.
the textbox name is: "username.text"

I need to know how to make my text field in vb6 connect to the php script.

my php script:

$dbh = mysql_connect ("localhost","bill","clinton") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("mydatabase");

$query = "INSERT INTO clickdb (username) VALUES ('$username' )";
$result = mysql_query($query);
$rows = mysql_affected_rows($result);
echo "good";

if this code is correct, then it might be my vb code I have trouble with, see it here:
Private Sub Command5_Click()
Downloaded = Me.itcHTTP.OpenURL(localhost & "signup.php?username=" & username.Text)
End Sub

when I use these codes it makes a new entry in my database but the fields are emty!?!? please help