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 trying to create a filter output of images by joining five tables. I need the five tables joined because of my where statements. My sql is the following: SELECT `files`.`id` AS `id`, `files`.`name` AS `name`, `files`.`size` AS `size`, `files`.`type`…
I Have a vps server with PHP 5.3.3 installed ,I added a new version 5.3.28 and switch my hosting to use FastCGI with PHP-5.3.28 now i get this "Database connection error (1): The MySQL adapter 'mysql' is not available.".I beleive…
what I need to do in my website is to show a list of jpg images stored in a Mysql database using Blob type (I don't want to use any other way). but instead of the image I got strings…
what I need to do in my website is to show a list of jpg images stored in a Mysql database using Blob type (I don't want to use any other way). but instead of the image I got strings…
I've been trying to work out the best way of copying structure & data from one database to another but the PHPMyAdmin export seems to churn out pretty poor scripts. The most obvious example is if I export a database…
Can't get this. How to determine size of an tep_db_fetch_array inside a while loop? I would like to do this: $i=0; while($a = tep_db_fetch_array($query)){ if($i==5){ // start a div i.e. } //do sth here if($i>=count($a)){ //close the div i.e. }…
I have a CentOs server with Plesk, it has a 24 cpu core and 32 GB of RAM. When I use TOP in linux, I see mysql cpu usage is about 200% despite the total system cpu being about 2…
I'm new to javascript and I'm really confused about what I need to do. I have added a javascript countdown timer to my site, it was easy to add. This is the javascript: <script LANGUAGE="JavaScript"> // This following statement must…