dcsimg
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?

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