[SOLVED] fetch info from mysql for a specific table field

[johnwayne77]

i am thinking of making a shipment tracking system and this is my logic:

 

user enters a tracking # in a text field. the form sends the number via _GET to a template php page.

 

the template page populates with a number of predefined fields fetched from the mysql database (for example: sender's name; sender's address; delivery date; etc.).

 

now, when the scripts see the number from the _GET, it will run a check with the mysql db to see if it exists.

 

if it does, then it will use all the other info related to the number in the predefined fields from the template. good.

 

and if it doesn't then i suppose i'll redirect to an error page.

 

i have two questions:

 

1) how do I check the _GET result with the db table

2) how do I fetch the mysql results only for the _GET result?

 

Any suggestion are greatly appreciated, thanks!

[ldsmike88]

Did this just get answered in your other post?

[johnwayne77]

yep, invalid post

 

problem resolved