Search:

Type: Posts; User: mike_g; Keyword(s):

Page 1 of 10 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    1
    Views
    245

    Re: Java and MySQL error *Urgent

    I'm not sure, but you are using a database engine that supports references right? IIRC the default, MyISAM, does not, you need InnoDB or something.

    Also, you could start you statement with:
    ...
  2. Replies
    6
    Views
    883

    Re: SDL + (2 by 2) TileMap = SLOW?

    Probably not.

    Its not hardware accelerated, but it should be fine for most 2D games, unless it has really flashy graphics. After all, games were written with SDL for hardware that was around in...
  3. Re: Mysql is unstable and server sometimes freezes

    Sound like you need to add flood protection to your site.

    For Apache, heres a module that should do it:...
  4. Re: Mysql is unstable and server sometimes freezes

    Some ideas could be:


    cache as much of your sites content as possible to reduce redundant queries
    enable slow query logging in my.cnf to find where your bottleneck queries are
    make sure all...
  5. Thread: mysql

    by mike_g
    Replies
    1
    Views
    240

    Re: mysql

    If you are worried about multiple simultaneous inserts screwing things up, then you could try using MyIASM engine, as it supports concurrency:
    ...
  6. Replies
    11
    Views
    803

    [SOLVED] Re: Very Quick Java Help

    For some reason IE craps out sometimes with code like this. To hide IEs crappyness its best to do it the way The Cog did - getting the element as a variable first before doing things with it....
  7. Replies
    10
    Views
    711

    Re: I really need help linking tables MYSQL

    For your user table set the id as auto increment. the MySQL code would be like:


    CREATE TABLE user(
    id INTEGER AUTO_INCREMENT,
    ...
    PRIMARY KEY(id)
    )
    The profile table will then have a...
  8. Replies
    1
    Views
    613

    Re: Breadth First Search Problems

    Perhaps a compliable program, or a little explanation would help. Do you get any errors? Or are you getting stuck in a loop?
  9. Replies
    9
    Views
    356

    Re: PHP SQL question.

    Remove the "AND/OR" part of your query and replace it with "OR". OR returns true if either or both conditions are met. XOR only returns true when one, not both conditions are true.
  10. Replies
    13
    Views
    820

    Re: Help with some python

    try:
    return {
    1 : 'st',
    2 : 'nd',
    3 : 'rd',
    }[num]
    except KeyError:
    return 'th'
    I fail to see what is so cool about this....
  11. Replies
    10
    Views
    706

    Re: When trying to make a game...

    One of the largest apps I ever wrote was a map editor. That was a long time ago and I kept adding features and bugs until it became a bit of a mess.

    Heres some code for a simple map editor I made...
  12. Replies
    7
    Views
    976

    Re: xml vs html vs flash website?

    Modern search engines can crawl through swfs, but I dont like flash for anything more than games, framing videos, or simple presentation slideshow things.

    My biggest problem is that flash sites...
  13. Re: Javascript/ajax/php making drop down menu populated by a database...

    In your first dropdown you change the state when a country is selected:

    <select name="id" id="country" onChange="getState(this.value)">
    But when you select a state there is no onChange trigger:
    ...
  14. Replies
    8
    Views
    441

    Re: [php] I need some big help

    Ok, good luck with it :)

    Perhaps it may be worth going through some existing forum software too to see how they do things VBullitin and PHPbb are my favorites.

    I never wrote forum software...
  15. Replies
    8
    Views
    441

    Re: [php] I need some big help

    How you gob about this kinda depends on your database schema. But these are the steps I would take:

    1) get the root board id for the subforums.
    2) use recursion to get all the subforum ids from...
  16. Re: Java awt question (JScrollPane and JTextArea)

    Maybe you could post the code?

    I did a very quick mockup in netbeans which works for me:

    import javax.swing.*;
    import java.awt.*;
    import java.awt.event.*;

    public class Window extends...
  17. Re: SQL to select unique record based on a single field

    Queries with a GROUP BY clause can only pull columns which are either the result of an aggregate function aggregate (IE: COUNT, AVG, etc) or the group by field. I think you might need a sub query...
  18. Replies
    2
    Views
    24,265

    Can I exclude a directory with diff?

    I have a backup of a website. I want to diff the source to see what files have been changed. My problem is that theres a folder with lots of files in it that I want to ignore. I tried this:

    diff...
  19. Replies
    3
    Views
    844

    Re: mySQL databases accross websites

    Yes, you just have to create a connection to the remote server.
  20. Replies
    0
    Views
    674

    Getting a simple Swing Applet to display

    I'm trying to make a simple applet using swing, but nothing gets displayed. Spent a while going through a load of useless stuff so now I'm bored and going to bed. Heres my code:

    import...
  21. Replies
    1
    Views
    609

    MySQL GROUP BY with Ordering Problem

    I'm modifying a gallery component. This query gets a list of last commented pictures. It shows a duplicate image thumbails for each comment and I want to only display each image once with the most...
  22. Re: Need script or Program to count lines of source code

    Or you could just call wc from the shell, but Idont think you can exclude comments with it.
  23. Replies
    3
    Views
    13,680

    Re: Oops. Lost security passwords for XAMPP

    Sounds like you need to reset the mysql root password.
    http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html#resetting-permissions-unix
  24. Replies
    2
    Views
    501

    Re: Firefox / sqlite time issues

    Looks like this might solve your problem:

    http://stackoverflow.com/questions/381371/sqlite-currenttimestamp-is-in-gmt-not-the-timezone-of-the-machine/571691
  25. Replies
    11
    Views
    929

    Re: [C] Wanna get out of recursion!

    It looks as if you have tired to create an iterative way of solving the problem, then added recursion on top of it.

    The current way you are iterating wont run through all permutations. What is i...
Results 1 to 25 of 250
Page 1 of 10 1 2 3 4