I stumbled upon this issue and can't seem to get the hang of it. I have three tables: MSG_V3_THREAD MSG_V3_THREAD_USERS MSG_V3_THREAD_PARTNERS Now, what I need to do is to get this table in the end: (NOTE: the above image is…
I have a table software (id_software, software_name, category) What SQL query to show only 2 software for each category ? For example I want to get : |id_software | software_name | category| -+------------+---------------+---------+- | 1 | Photoshop | 5 |…
Well, I've a table called keywords and there are 2 columns. 1) kid 2) keywords (keyword value) and I've another table called contact_details where there a column called keyword. In this keyword column I'm inserting many keyword from keywordstable. So…
I'm trying to connect to a remote ms sql db (not a localhost), but everytime it timeouts before it sucseeds... I'm pretty sure that the problem is the $serverName variable, is there anyway to check via Plesk Parallels what is…
I have a software names database which i need to search ,now i am trying to find a query which will select the right software by name . The software name field is a VARCHAR Example software list in DB:…
I just deleted a plesk subscription thinking I could restore it from my backup. It looks however like the backup for that subscriptions is not there. Is there anything I can do to restore a recently deleted subscription? Or recover…
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…