Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Database structure efficiency questions
I'm setting up a new mySQL backed website. Each user needs a database table with about 12 fields that are the same for each user. Users will vary in the number ofrows from about 20 to 200. I'm trying to decide if I should create a seperate table for each user with the same 12 fields or just... -
help using column alias in where
I'm trying to select stores from a database within 3 miles of a location. I have the longitude and latitude in the database stored in radians to help ease runtime computation. I want to get distance in the select, where, and order by clauses. In order not to have to do the trig multiple timesI...
