Results 1 to 3 of 3
  1. #1

    Is there something wrong with this query?

    Hi,

    Is there something wrong with this query? I keep getting "Couldn't update pick".

    mysql_query("UPDATE pp_picks SET pickheading = '$pickheading', pick = '$pick', pickday = '$pickday', pickmonth = '$pickmonth', pickyear = '$pickyear', rating = '$rating', sport = '$sport', comment = '$comment', capper = 'The Admin' WHERE pickheading = '$passthis', AND pickday = '$oldpickday' AND pickmonth = '$oldpickmonth' AND pickyear = '$oldpickyear'") or die("Couldn't update pick.");

    Thanks...

    Nick
    Last edited by NickMahon; 10-03-2002 at 07:38 PM.
    - Nick Mahon
    Vereor.com
    Professional Web Development

  2. #2
    Join Date
    Sep 2002
    Location
    Dallas, TX
    Posts
    205
    WHERE pickheading = '$passthis', AND pickday = '$oldpickday'
    Get rid of the comma after '$passthis'
    justin 'at' abrogo.com
    http://www.abrogo.com
    Shared Unix Hosting

  3. #3
    Thanks.
    - Nick Mahon
    Vereor.com
    Professional Web Development

Posting Permissions

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