theoretical question
Posted: Sun Nov 06, 2005 7:22 am
hello guys,
i made a simple query log program using msaccess where you can search for the client in the database.
if client is found in database
you are able to enter a query under his name
if not
ask the "admin" to add the client's details.
so basic setup is every client has a unique id in a table (clientdetails) and the query is located in another table (clientquery). in each table there is a field named clientid which is the unique key (in clientdetails)
i am learning/making one in php right now and i just have a question :
*what would happen if the search string i used displayed multiple results? say i did a search using "%mich%", i'm sure a lot of "michaels" and "michel" would pop up. i could put them all in an array and display them in a table. once the user chooses the correct client that he is looking for, how can i make it so that when he clicks on the client's name, a form is opened for him to enter his query (which is attached to the client's clientid).
just a theoretical question, no code needed, i just wanted to learn how it goes in terms of php.
many thanks!
i made a simple query log program using msaccess where you can search for the client in the database.
if client is found in database
you are able to enter a query under his name
if not
ask the "admin" to add the client's details.
so basic setup is every client has a unique id in a table (clientdetails) and the query is located in another table (clientquery). in each table there is a field named clientid which is the unique key (in clientdetails)
i am learning/making one in php right now and i just have a question :
*what would happen if the search string i used displayed multiple results? say i did a search using "%mich%", i'm sure a lot of "michaels" and "michel" would pop up. i could put them all in an array and display them in a table. once the user chooses the correct client that he is looking for, how can i make it so that when he clicks on the client's name, a form is opened for him to enter his query (which is attached to the client's clientid).
just a theoretical question, no code needed, i just wanted to learn how it goes in terms of php.
many thanks!