www.webdeveloper.com

Search:

Type: Posts; User: qrizly

Search: Search took 0.01 seconds.

  1. Thats a little bit incorrect, so just for future...

    Thats a little bit incorrect, so just for future ref:


    INSERT INTO <table_a> (col1, col2, col3) select col1, col2, col3 FROM <table_b>
    This query will skip all other columns present in table_a...
  2. Replies
    14
    Views
    2,940

    you'r welcome. You can also use the same logic to...

    you'r welcome. You can also use the same logic to pair up the primary key, etc.
    Have you already decided what to do with your routing (based on answer) functionality?
  3. Replies
    14
    Views
    3,529

    get rid of all the quotes then your query is...

    get rid of all the quotes then your query is fine.
    Or you have to backtick your columns like this:


    `U1`.`userid`//Note the . is now an actually <table> / <column> delimiter instead of another...
  4. Replies
    2
    Views
    1,458

    thats really easy to achieve just use the php...

    thats really easy to achieve just use the php function header:


    header("location: http://www.google.nl");

    But you need to change your editor. You have some whitespace or a "invisible"...
  5. Replies
    1
    Views
    1,554

    You can also see what the code is doing from...

    You can also see what the code is doing from looking to it with a different angle.
    Just use:


    var_dump($GLOBALS);

    and get the code it is spitting with "ob_start()" and "ob_get_clean()"....
  6. Replies
    6
    Views
    1,535

    Try this: $query=" SELECT SUM(hours1) +...

    Try this:


    $query="
    SELECT SUM(hours1) + SUM(hours2) as `total_hours`, `name`
    FROM `lss`
    GROUP BY `name`";
  7. Replies
    4
    Views
    1,216

    You can create a kind of NoSQl server out of...

    You can create a kind of NoSQl server out of Mysql, that even will outperform most of the current NoSQL implementation.
    Just google Handler Socket (mysql). It can query up till 750.000 request a...
  8. You haven't forgot to set the appropriote header...

    You haven't forgot to set the appropriote header i guess ?
    Like:


    header("Content-type: text/css");

    And you should look into weak Etag implementation, this can cache your css and all other...
  9. yes you need to repair ALL the tables holding a...

    yes you need to repair ALL the tables holding a fulltext index.
    should work as well.
  10. Replies
    14
    Views
    2,940

    You are already pointing out the reason why you...

    You are already pointing out the reason why you should use an enum (or perhaps a SET).
    Without any explaination you cannot know what that column means, so a future developer needs to read thru your...
  11. if you want to fetch ALL the records of previous...

    if you want to fetch ALL the records of previous month then this will work better:


    select * from empadvanceamount where
    MONTH(date) = MONTH(now() - INTERVAL 1 MONTH)
    AND
    YEAR(date) =...
  12. Replies
    6
    Views
    2,670

    All four querys works SELECT * FROM PRODUCTS...

    All four querys works


    SELECT * FROM PRODUCTS WHERE NOT is_null(manufacturer)

    SELECT * FROM PRODUCTS WHERE length(manufacturer) >= 0

    SELECT * FROM PRODUCTS WHERE manufacturer is not null
    ...
  13. Replies
    4
    Views
    3,178

    well if you want to do show the information like...

    well if you want to do show the information like this:


    WALLPAPER A
    RESOLUTION 1 OF WALLPAPER A
    RESOLUTION 2 OF WALLPAPER A
    RESOLUTION 3 OF WALLPAPER A

    WALLPAPER B
    RESOLUTION 1 OF...
  14. Replies
    2
    Views
    1,750

    aj you need to do this handle this differently: ...

    aj you need to do this handle this differently:

    first you need to store the 'thank you' condition as a DateTime column instead of an enum, so you can check the last thank you time.
    secondly what...
  15. Replies
    4
    Views
    1,496

    SELECT * FROM tbl_events WHERE...

    SELECT *
    FROM tbl_events
    WHERE fld_event_start_date BETWEEN '2011-05-24' AND '2011-06-24'
    AND fld_event_end_date BETWEEN '2011-05-24' AND '2011-06-24'
  16. you have to change the internal setting of mysql...

    you have to change the internal setting of mysql to achieve a shorter search string.
    in my.cnf you have to add:



    [mysqld]
    ft_min_word_len=1

    restart mysql with perhaps:
  17. Replies
    1
    Views
    1,122

    if you include prototype js...

    if you include prototype js, you can do something like:


    <textarea name="Comments" id="Comments" maxlength="250" cols="60" rows="10"></textarea>

    <script type="text/javascript">
    // <![CDATA[
    ...
  18. Replies
    4
    Views
    1,671

    change this for every link:

    change this for every link:



    <a onmouseover="changePicture('b1', 'images/aa1.jpg');num=0;slideshow(0);return false" href="aa.html" onmouseout="changePicture('b1', 'images/aa2.jpg');"><img...
  19. Replies
    3
    Views
    10,930

    navicat http://www.navicat.com/ can connect to...

    navicat http://www.navicat.com/ can connect to various types of databses, creates reports, builds querys, etc. Mysql workbench http://wb.mysql.com/ is also a good one
  20. Replies
    1
    Views
    1,655

    jQuery you can use the javascript function eval ...

    you can use the javascript function eval



    $.get("/data.php?getMarkers=true", function(markers) {
    eval(markers);
    });

    But that is normally bad practise. You can send over the...
  21. Replies
    14
    Views
    2,940

    i would change: CREATE TABLE survey_responses...

    i would change:

    CREATE TABLE survey_responses (
    user_id mediumint(5) unsigned NOT NULL default '0',
    question_id mediumint(5) unsigned NOT NULL,
    answer_id mediumint(5) unsigned NOT NULL,...
  22. Replies
    5
    Views
    1,389

    oops "$_POST['delete']" should be...

    oops "$_POST['delete']" should be "$_GET['delete']", but i think you should get the picture
  23. Replies
    5
    Views
    1,389

    if (get_magic_quotes_gpc()) { $dname=...

    if (get_magic_quotes_gpc()) {
    $dname= stripslashes($_GET["delete"]);
    }
    else {
    $dname= $_POST['delete'];
    }

    $dname = mysql_real_escape_string($dname);

    mysql_query("DELETE FROM...
  24. Replies
    3
    Views
    1,719

    you have to leave the "%" chars out of the query...

    you have to leave the "%" chars out of the query and then it will work:


    $profilesSQL="SELECT * FROM profiles WHERE MATCH(name, rel) AGAINST ('$query') LIMIT 10";

    You might want to look here:...
  25. Replies
    0
    Views
    385

    browser feature detection for events

    how can you check if a certain event is available in the browser?
    i want to test if event "touchmove" is present.

    Many thx
Results 1 to 25 of 25
HTML5 Development Center



Recent Articles