1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Recent Content by koko5

  1. koko5
    Post

    Distinct query returns different results on different servers

    Hi, imho this is the reason. Set named pipe before query should do the fix. set names utf8; Regards :-)
    Post by: koko5, Mar 28, 2014 in forum: MySQL
  2. koko5
    Post

    Help: How to have a play count and total records count?

    Total can be retrieved using group by modifiers Example: SELECT game_id,SUM(plays) FROM game GROUP BY game_id WITH ROLLUP; The grand total...
    Post by: koko5, Feb 18, 2014 in forum: PHP
  3. koko5
    Post

    build a query

    All you need is MySQL least() function
    Post by: koko5, Feb 17, 2014 in forum: MySQL
  4. koko5
    Post

    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 concatenation, but...
    Post by: koko5, Feb 14, 2014 in forum: MySQL
  5. koko5
    Post

    mysql query last two parts with dashes

    As an extension of my previous post for better understanding why in some cases regular expression is a must for more precise query, I've extended...
    Post by: koko5, Feb 14, 2014 in forum: MySQL
  6. koko5
    Post

    mysql query last two parts with dashes

    Hi, sorry, but I cannot understand your question. Which fields to be updated on table1 and table2? You can use where condition using substring...
    Post by: koko5, Feb 14, 2014 in forum: MySQL
  7. koko5
    Post

    mysql query last two parts with dashes

    Assuming `s` is your field name and `bla` is the table name: select concat('-',substring_index(s,'-',-2)) x from bla; Here is my test
    Post by: koko5, Jan 19, 2014 in forum: MySQL
  8. koko5
    Post

    Help with mySql please

    Hi, try: update `listings` set `title`=replace(`title`,'&',' ');
    Post by: koko5, Aug 10, 2012 in forum: MySQL
  9. koko5
    Post

    website inaccessible during large MySQL dump

    Hi, try running mysqldump with --skip-lock-tables option if your tables are MyISAM. For InnoDB you can try --single-transaction
    Post by: koko5, Jul 12, 2012 in forum: MySQL
  10. koko5
    Post

    Calculating Average.

    Finally... :) your query:SELECT testing.index, testing.reading, testing.`date`, ((testing.reading - t2.reading) / DATEDIFF(testing.`date`,...
    Post by: koko5, Jul 12, 2012 in forum: MySQL
  11. koko5
    Post

    Calculating Average.

    Edit: Post deleted-query returns wrong result... I'll think on it Jamie T, maybe to get index-1 we must join the table itself again as t3 with...
    Post by: koko5, Jul 12, 2012 in forum: MySQL
  12. koko5
    Post

    Calculating Average.

    OK, I made an example, because you didn't post original table structure /I saw you online.../ - hope I understood the question right: DROP TABLE...
    Post by: koko5, Jul 11, 2012 in forum: MySQL
  13. koko5
    Post

    Calculating Average.

    Can you please post the table structure here, I mean create table statement/script, few lines of data and desired result. Thanks
    Post by: koko5, Jul 11, 2012 in forum: MySQL
  14. koko5
    Post

    How to override onclick="return false"

    Did you check error console? I got errors ... this.form is null - you have no forms as I see your code. Regards :)
    Post by: koko5, Jul 10, 2012 in forum: JavaScript
  15. koko5
    Post

    What is Tee command? What does it do?

    Hi, Please check the following URL You mean notee I guess :)
    Post by: koko5, Jul 4, 2012 in forum: Databases