Likes Received By koko5

ryan_uk liked koko5's post in the thread mysql query last two parts with dashes.

OK, I think all clear now. First of all you've to think on your database model. Next, such NULL values can cause problems with...

Mar 9, 2014

mcfox liked koko5's post in the thread creating functions.php in child theme.

Hi, seems you forgot } for the end of the function:

Sep 13, 2010

MyVodaFone liked koko5's post in the thread Get the last 10 id's and ORDER BY likes.

Hi, try this SELECT * FROM (SELECT * FROM `like` ORDER BY id DESC LIMIT 10) A ORDER BY likes DESC;

Aug 11, 2010

karl_murphy liked koko5's post in the thread How would I write this query?.

Hi, you can use query, provided by @Jestep If you don't want to take care about hours,minutes and seconds and compare dates only, just...

Jul 19, 2010

Silver89 liked koko5's post in the thread Very simple C Function.

It seems you forgot to include the file with testfunc(). testfunc.h holds only function prototype definition (I guess), not the...

Apr 29, 2010

s_ruben liked koko5's post in the thread Regular Expression Help.

You are welcome, I'm glad to help if I can :) Replacing (\</[^\>]+\>)? to (\</[^\>]+\>)* will do the trick: echo...

Apr 8, 2010

dadaas liked koko5's post in the thread Export specific column and row (is it possible?).

CREATE TABLE MYEXPORT (SELECT * FROM TableName WHERE category=3);Now dump MYEXPORT Regards :)

Mar 18, 2010

calcalmx123 liked koko5's post in the thread Submitting data to database error.

Hi, Show is MySQL reserved word and you use it as column name! try `show` instead: $q = mysql_query("INSERT INTO Episode (...

Mar 5, 2010

arrisweb liked koko5's post in the thread Removing records from MyISAM table.

Hi, try this DELETE FROM TableName ORDER BY Desired_field ASC LIMIT 50000; Regards :)

Feb 24, 2010

baris22 liked koko5's post in the thread i need a small help on a query.

@s_ruben he needs to know if there is any record with "No", it works, but doesn't returns desired result. OK, to simplify my previous...

Feb 16, 2010

PoPSiCLe liked koko5's post in the thread Split integer from database.

Hi, you can try this too echo preg_replace('#^(\d*)(\d{2})(\d{3})$#','$1 $2 $3','12345678'); :)

May 30, 2009

Masterful liked koko5's post in the thread Do You Know How to do this . . . ?.

Hi, I guess you'll find this link useful. pp: Myabe it's better to store value in cookie instead of copy to clipboard Regards.

Apr 17, 2009

Weirfire liked koko5's post in the thread MySQL Order by a calculation.

Hi, You don't need another column, just simulate it using control flow functions Regards