Oksy I was messing around with mysql trying to make a basic unprotected
login system with a saftey pin. I have it all working apart from the signup form. This is wjat im using for my sign up form:

PHP Code:

<?php

$username = $_GET['username'];
$password = $_GET['password'];
$pin = $_GET['pin'];

mysql_connect("localhost", "root", "password") or die(mysql_error());
mysql_select_db("database") or die(mysql_error());

mysql_query("INSERT INTO accounts 
(username, password, pin) 
VALUES ('$username', '$password', '$pin') ")
or die(mysql_error());   

echo "Data Inserted!";

?>

However me and my friends have been testing it and occasionally we are getting blanks in some of the fields which isnt good. It normally shows a few letters in the a usermane field and in the rest of the password and pin fields on the same row get blanked out like so:



Any help would be great and could you keep in mind that I still need to use the GET function in my signup script as I will be using it in java and vb scripts.

I once briefly tested a freeware script that would insert blank records when the submit button was pressed with all the data fileds blank. There was no valdiation for the form data.

You did not provide enough information for me to even guess that is your problem. I just wanted to mention it could be.

All info was filled in but it wasnt entered in. What info do you need?

you have nothing in the script to check if the fields are blank.
There is nothing to "sanitise" the data between form and database.
You are using a GET method which send the data in the URL and therefore visible.

I still need to use the GET function in my signup script as I will be using it in java and vb scripts

Why?? You can POST data using javascript or vbscript

I dont know how to post from java or vb and how would i go about checking for blank fields?