[SOLVED] entering empty value in query in php

[ali_2kool2002]

hi i have a customer table and it has an auto increment for the customer id, and a user name field. However, if i want to enter

in php a new customer i dont want to be entering a value as it should automatically be created, so all i need to enter is the user name. How do i make php understand that i want to only enter the first name as the rest should be entered itself in mysql...? do i enter a blank value and pass it on like below?:

 

insert_query = "insert into customer ''', '$fn'";

 

 

[wildteen88]

This is more of a MYSQL question rather than PHP. What you will want to do is this:

insert_query = "INSERT INTO customer(`username`) VALUES ('$fv');"

[redarrow]

for the id you need not to use auto_increment as your need

to add your own like a random number use rand ok.

[Barand]

rand() will not guarantee uniqueness so you will always have to test that it hasn't been used already. Auto_increment OTOH will guarantee a unique id.

[ali_2kool2002]

thanks wild teen i got it now ...

 

INSERT INTO test(`name`) VALUES ('name');

 

dont need to even say anthing about the id field it does it itself!!  :o