SitePoint Sponsor

User Tag List

Results 1 to 5 of 5

Threaded View

  1. #1
    SitePoint Enthusiast
    Join Date
    Apr 2004
    Location
    The Netherlands
    Posts
    46
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySQL Updating awkwardly

    i execute an SQL statement:
    Code:
    UPDATE online 
    SET 
        loc=2,
        dos=1085514101,
        ip='127.0.0.1' 
    WHERE 
       id = 1
    after the execution the row looks like
    Code:
    +----+-----+-----+------------+-------------+
    | id | loc | rid | dos        | ip          |
    +----+-----+-----+------------+-------------+
    |  1 |   0 |   0 | 1085514101 | 192.168.1.1 |
    +----+-----+-----+------------+-------------+
    any ideas?

    also, it sometimes does what it's supposed to do, but most of the time not. The SQL query is in both cases exactly the same.
    Last edited by Sheqel; May 25, 2004 at 13:18.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •