While working on my game site I had to order related games by relevance where I had game ids as string in needed order. If I do regular mysql query SELECT * FROM games WHERE id IN(1,3,2); I get result as 1,2,3. To get result in 1,3,2 custom order mysql query should be as following. […]
Category: MySql
Wallpaper script v1.2.1 released
This version of script fixes 2 bugs related to some hosting providers. Removed all short tags as it was reported some web hosts do not allow to switch it on by changing php.ini. So all php hort tags like <?= and <? replaced with <?php echo tags. This issue is pointed out thanks to Dudeist Bulk […]
Free Wallpaper Script 1.2 released – includes bulk upload
New version of Free wallpaper script ready to download. After getting useful feedback from our users we added new features, improvements and fixed some minor bugs. Here are main changes to script: Bulk upload: Now you can upload thousands wallpapers at once via ftp and insert them to your database via Admin panel in few […]
Free Wallpaper Script 1.1 coming soon
It has been a year since first release of Free Wallpaper Script. With more than 3000 downloads we got lots of requests and how to questions during past period. Most requested features were bulk upload and localization of script. So we decided add those features in version 1.1 (no release date yet) . This release […]
Free Wallpaper Script ready for download
Free wallpaper script is a free PHP script to create wallpaper sites. I have a wallpaper site for couple years now and each year I am rewriting it in order to improve it. I am so happy with it so I decided to share script for creating wallpaper sites.
Problem with using AND, OR for single column values
I have a MySql database table as shown in image . Where table has thousands of records with any integer and varchar values in id1 and id2. I want to select values where id1=(1 and (2 or 3)). Which will result in id2=a,b,c. Result may be several hundred records for real table and I will […]