ThisIsMyName

Used structures/datagrid with paging and column sorting to display some mysql database records to a rather experienced programmer at my office, and he immediately asked me two questions I didn't have good answers to: 1) The paging looked good and all, but what about the overhead when the number of records increases from a couple hundred to several thousand? This would be in issue with users in Asia and servers in the US. 2) What about sql injection in the URL? How easy is it to monkey with this? I'm just an amateur, and now I'm thinking I should just abandon Pear and write it all from scratch, or is that silly?

Yeah, you're right, it was easy enough. Thanks!

Wondering if it's possible to create a form with a dropdown that displays a list of text options but passes an INT to MySQL, e.g, menu contains a list of cities but I update the DB with a City_ID. Is there a way to define $Miami=$1234 and put $Miami in the HTML form variable?