#1
  1. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Location
    Brussels, Belgium
    Posts
    14,642
    Rep Power
    4492
    Here's some of my code. The error is given in line 88, which is the second query, $query2.

    $now = time();
    $query = mysql_db_query($database,"SELECT in_access,eq_access FROM users WHERE login='$login'",$link_id);
    $result = mysql_fetch_array($query);
    $in_access = $result["in_access"];
    $eq_access = $result["eq_access"];

    $query2 = mysql_db_query($database,"UPDATE users SET time_in='$now', remote_addr='$REMOTE_ADDR' where login='$login'",$link_id);
    echo "Error = " . mysql_error($link_id);

    The exact error is:

    Warning: MySQL: Unable to save result set in inc_functions.php on line 88

    mysql_error() does not return anything, however. I just have it in there for debugging.

    any ideas what I should/can do to fix this?

    ---John Holmes...
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    43
    Rep Power
    15
    Try to find out if the value in the time_in column is being set to zeros.
    If so then MySQL doesn't see the $now as a valid time/date.
    The time() function returns an integer number that equals the number of seconds passed since Jan. 1 1970. It doesn't return the time.
    If you knew that I apologize.
    If you have a DATE or TIME field why not use:

    "UPDATE users SET time_in=now(), remote_addr='$REMOTE_ADDR' where login='$login'"

    Try that first to see if it fixes it.


    ------------------
    lhallusa
    www.webpatron.com
  4. #3
  5. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Location
    Brussels, Belgium
    Posts
    14,642
    Rep Power
    4492
    The script works fine on a linux system, but now i'm trying to run it on solaris, and now i'm getting these problems. i'll look into the now() issue and see if that fixes anything. thanks...

    ---John Holmes...

Similar Threads

  1. Size of mysql result set using php.
    By kemiko in forum PHP Development
    Replies: 4
    Last Post: July 16th, 2003, 01:13 PM
  2. set wrap/column format mysql equivalents??
    By yas in forum MySQL Help
    Replies: 2
    Last Post: April 21st, 2003, 07:05 PM
  3. Replies: 2
    Last Post: February 19th, 2003, 06:28 PM
  4. Replies: 2
    Last Post: July 22nd, 2002, 01:23 PM
  5. how can i set the root password for mysql on xp ??
    By giosmrbig in forum MySQL Help
    Replies: 2
    Last Post: July 14th, 2002, 03:33 PM

IMN logo majestic logo threadwatch logo seochat tools logo