Skip navigation.

my php-driven thoughts

about web and something more

Posts tagged with "mysql"

DB problems

, , , ...

Just remembered one thing: if you have home-made-hosting "company" and you provide MySQL databases as data storage server - don't use underscores (_) in databases' names. When you grant someone all priviledges on one db named user_db, then user can create even more databases, like:
  • user0db;
  • user1db;
  • and so on...
I had that problem in my ex-work (Vilnius University IT Center). Thank God, i wasn't responsible for database administration (yet) .)

It's much better to gain such experience at 127.0.0.1 if u know what i mean .)

New and improved drop down list .)

, , ,

Ok, so i couldn't leave this topic, could i ,)

Anyway, remember the sql query with IF?
SELECT id,title,IF(id=given_id,'selected="selected"','') AS selected FROM someTable

Now i added ordering (let's say country list):
SELECT id,country,IF(id=given_id,'selected="selected"','') AS selected FROM countryTable ORDER BY selected DESC,country ASC


Cheers!

P.S. Don't forget to index the table!
December 2009
S M T W T F S
November 2009January 2010
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31