My Plesk control panel shows only 3 databases (2 for one domain and 1 databases for the second). When I use command line mysql> show databases, it shows around 20 databases. Why is there a difference between Plesk mysql> show…
In my osCommerce store I want to fetch the parent_id of categories that either have no sub category or child categories. I used the following in my code: $categories_query = tep_db_query("select c.categories_id, cd.categories_name from " . TABLE_CATEGORIES . " c,…
I am having difficulties because of the database structure on a game website similar to http://box10.com. I attempted to change table structure a bit but I made it worse, and now I must not do another mistake to keep my…
I have a database called apsc and if I run SHOW TABLES; on it, these are the results: mysql> show tables; +------------------------------------+ | Tables_in_apsc | +------------------------------------+ | aps_application | | aps_application_backup | | aps_application_resource | | aps_package | | aps_package_configuration…
How many queries in one webpage is good performance? If that page is home page that is viewed many times. and how about.... $sql1 = mysql_query("SELECT * FROM a", $db1); while($row = mysql_fetch_assoc($sql1)){ $sql2 = mysql_query("SELECT * FROM b WHERE…
My OSCommerce site includes a separately programmed feature for which I use SQL tables. I've decided to host its tables on a remote site offering free SQL accounts. I'd like to know if there could be any disadvantages to this…