[PHP] php/mysql search. need help

2001-09-07 Thread lizlynch
i have a form where a user inputs a home service type and this results in a list of that value, eg a user inputs 'plumber' and a list of plumbers is displayed. if a user accidentally types plumbar no results are displayed. is there anyway of making php/mysql recognise the first three letters

[PHP] mysql query . need help!!!!!

2001-09-04 Thread lizlynch
i have two tables here, i want to insert the customername from the Username table and insert it into the Classification table. is the below query correct cause i can't seem to get it to work. $query = INSERT INTO Classification (Customername) (SELECT Customername) FROM Username WHERE

[PHP] mysql_insert_id. need help!

2001-08-29 Thread lizlynch
hi, i have three tables: customer username classification the user will enter my web site enter the relevant customer details (which are transfered to the database) (s)he will then enter their prefered username, password and a password hint (again all sent to the database). once they are

[PHP] mysql_insert_id NEED HELP

2001-08-29 Thread lizlynch
hi, i have three tables: customer username classification the user will enter my web site enter the relevant customer details (which are transfered to the database) (s)he will then enter their prefered username, password and a password hint (again all sent to the database). once they are