Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Results 1 to 3 of 3
  1. #1
    Senior Member leprechaun13's Avatar
    Join Date
    May 2005
    Location
    Northampton
    Posts
    487
    Member #
    10058
    Trying to insert data from the Clicky API into a database

    the following insert query is produced from my PHP
    Code:
    INSERT INTO visitors (time_stamp,timepretty,ip_address,session_id,actions,web_browser,operating_system,screen_resoultion,javascript,language,geolocation,latitude,longitude,custom,clicky_url) VALUES('1193080851','Mon Oct 22 2007, 12:20pm','138.32.235.36','142318056','1','Internet Explorer','Windows','1280x1024','1','English','Bartlesville, OK, USA','36.7114','-95.8940','Array','http://getclicky.com/stats/actions?site_id=10&session_id=142318056'
    When i run the query through phpmyadmin it throws a
    Code:
     #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
    cannot figure this one out.
    help is appreciated as always.

    EDIT: well thats typical post it here and I spot the problem straight away, its with the time_pretty(I think).
    Regards Phil,


  2.  

  3. #2
    Member
    Join Date
    Apr 2007
    Posts
    96
    Member #
    15165

  4. #3
    Senior Member leprechaun13's Avatar
    Join Date
    May 2005
    Location
    Northampton
    Posts
    487
    Member #
    10058
    got it sorted, human error again I had no ")" to close the VALUES
    Regards Phil,



Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -6. The time now is 07:33 AM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com