Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13
  1. #11
    Join Date
    Sep 2006
    Location
    Hobart, Australia
    Posts
    593
    Tokens
    0

    Default

    What is your database schema? Like, what fields have you got? Are you sure you're not making the ID NULL or 0? Looking at the SQL you're running, it looks like you might be...

  2. #12

    Default

    Quote Originally Posted by benzoenator View Post
    What is your database schema? Like, what fields have you got? Are you sure you're not making the ID NULL or 0? Looking at the SQL you're running, it looks like you might be...
    slot
    time
    id

  3. #13
    Join Date
    Sep 2006
    Location
    Hobart, Australia
    Posts
    593
    Tokens
    0

    Default

    You're settting you're ID column to NULL...

    Try this:

    PHP Code:
     mysql_query("UPDATE `timetest` SET (slot, time) VALUES ('', '22:00') WHERE `id` != '1' ;") or exit("Could not import the sunday timetable data"); 

Page 2 of 2 FirstFirst 12

Posting Permissions

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