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:…
$products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id…
I am trying to retrieve an integer table element (max) which is 3 or 4 depending on the course, and comparing that with the number of elements already entered into the table. Here is the code I am using to…
I'm building a web crawler which collects crawled results into MySQL table. There are Five Main Columns: URL, TITLE, DESCRIPTION, KEYWORDS, BODY. Currently I'm using FULLTEXT search function of MySQL as follows: SELECT URL,title, description, MATCH (description, keywords, title, URL)…
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 app, I am making a call to ebay API and save their categories to my local table. The API response is a list of categories. Each category could have more than one parent. Each parent category could have…
I have these usernames and passwords: User name: AmirAman Pin: **** Password: ***************1 Parallels Plesk: qatarreal password: *************2 DataBase: username: amir password: ***3 When I type this code in index.php file, it doesn't work and Internal Server Error appears: <?php…
I've a CentOS 5 Plesk server. I have an updated version of phpMyAdmin in a public folder and if I try to login with my admin details (the root user of the entire MySQL server) everything works fine. If I…
I just switched an old oscommerce installation from mysql_ to mysqli_ (by changing database.php files/functions). Some SELECT statements that previously returned: <p>Bla bla <br /> blah</p> now return _p_Bla bla _br __ blah_/p_ does anyone have a quick fix, or…