Change record when user chooses option from listbox

[beginneratphp]

Hi,

 

I am new here so hello everybody!!!

 

I have a combobox which has different peoples names which are pulled from fields in a database. Can anybody please show me some code that will change the recordset so say for example there were two records in the DB with three bits of data name, number and telephonenumber:

John      10      01234567544

Frank    34      07883922332

 

and somebody selects john from the select box that in the two fields it shows 10 and 0123...

and 34, 078839..... if they select frank.

 

 

Thanks in advance!!!

 

[lemmin]

"SELECT field2, field3 FROM table WHERE field1 = " . $_POST['optionname'];

 

Something like that.

[beginneratphp]

"SELECT field2, field3 FROM table WHERE field1 = " . $_POST['optionname'];

 

Something like that.

 

Sorry where would I put that?? so if textboxes were called rating & telnum and the dbfields called flrating and fltelnum??

[lemmin]

That is an sql query string. I would suggest you do a little research on php and mysql before trying to do this project.

[beginneratphp]

That doesn't help me very much I have been trying what I found on google and it isn't working.

 

I had $query_conn = "SELECT * FROM person WHERE 'name' = " . $_POST['select'];

 

and it just gives me an error

[lemmin]

This should help, then. http://www.php-mysql-tutorial.com/

[beginneratphp]

but surely this will only set the correct sql data if the select box is already on the correct  name when the page loads??

[beginneratphp]

This isn't working for me

[beginneratphp]

Could somebody just give me an example of some code that will do this?

[lemmin]

I searched this forum for "mysql drop down" and found a lot of sample code.