Re: Displaying results either side of an Query?

Joseph: Not to answer your immediate question, but do be careful about two entrants having the same name. In the lookup form, when a user types in a name, you should take them to a listing of all runners with that name. Each name should have their runner ID next to it, hyperlinked like: <ul> <li><a href="results.htm?Runner=53">53</a> John Doe, Cleveland, OH</li> <li><a href="results.htm?Runner=99">99</a> John Doe, Brooklyn, NY</li> </ul> Then, clicking on the hyperlink will display that specific runner's results. By the way, you might want to take a look at my SQL Solution class. It can make this process simpler for you: http://www.analysisandsolutions.com/code/sql/ Enjoy, --Dan -- PHP scripts that make your job easier http://www.analysisandsolutions.com/code/ SQL Solution | Layout Solution | Form Solution T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y 4015 7 Ave, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409