Simple Databse Question.
Posted on 2004-10-19
Hi, I dont want to bind my data to anything, except maybe an array which im not sure how to do, my question here is, that I would like to know the proper way in dealing wtih databases, as of right now I have two tables, I will constantly need to be searching thru each one of them for things in different fields, and I will constantly be adding to one of the tables, at a very fast rate for the most part. My question is how would I go about doing this correctly?
Would I open one connection for the db?
What would be the fastest way to search for something in say table: tblnick field: lastseen searching for: "Two" and return that row id?
Will I be updating after every entry? or is that only when i save? I will need uptodate results.
thank you =)