Anyway, here's my situation:
I've been learning PHP, I have about a weeks experience at it, but with my knowledge of programming logic etc. I think I'm coming along nicely for a n00blet anyway. Well, I've coded some pages that allow users to register as a site member, with 2 different options, Personal Membership or Business Membership, I've managed to get everything working, except when the values are entered into the MySQL database, almost half the fields aren't inserted ???. Now, I'm really stuck as to why this is, when I first created the site, I checked the data on a separate .php file, now I modified it so that the php is on teh same page as the form, and things started to go weird. I had strange problems with my data validation, which I managed to fix, however, I'm at a loss as to how to combat the problem I'm currently experiencing.
Here is my SQL query, if anyone needs to see my entire php code, I'll supply it through PM or something, because its pretty long.
$sql = "INSERT INTO southport_consumers(id, username, contactname, contactnumber, mobilenumber, email, pword, postcode, housename, road, town) VALUES(0,'$busname','$busname','$contactnumber','$mobilenumber','$email','$password1','$postcode','$housename','$road','$town')"; if(mysql_query($sql))
all variable names are correct, I've checked, I put the query into myAdmin thing that handles the databases and it found no errors, but that was after I'd changed the variable instances with "Data" (so every field contained the word "Data").
I'm really at a loss as to what's happening here, so any help would be greatly appreciated.
Thanks in advance