www.webdeveloper.com
Results 1 to 2 of 2

Thread: query problem

  1. #1
    Join Date
    Jun 2006
    Location
    San Jose, CA
    Posts
    42

    query problem

    Hi all,

    In my database I build a string called description. from this:
    $description="Collection on ".$_SESSION['servicedate']." at ".$churchname." - ".$servicename; The string looks like thi:
    Collection on 05/04/2008 at Dicks Aposolic Church - Noon Service
    That is what is in the field in the table named "GL_Description";
    After making some changes, I need to update the record BUT ....
    after building the same string and using the sql of:
    $sql="select * from general_ledger where GL_Description='".$description."'";
    it returns a -1 and cannot find the record.
    I tried putting quotes around the string but that didn't work either.
    Can anyone help?
    TIA
    Dick Deeds

  2. #2
    Join Date
    Aug 2005
    Location
    The Garden State
    Posts
    5,634
    execute the sql outside of your script. are you able to get results then?
    Acceptable Use | SQL Forum FAQ | celery is tasteless | twitter

    celery is tasteless - currently needing some UI time

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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



Recent Articles