Thread: Problem inserting data via PHP
05-07-13, 20:19 #1Registered User
- Join Date
- Jun 2011
Unanswered: Problem inserting data via PHP
Hello, I found the attached php script online and was wondering if someone would mind taking a look at it. I have attempted to modify the script to pull down Craigslist posts. I used the exact SQL script for creating the rssingest table, and have modified the variables (username, password, etc) to fit my environment (left them out of the file for obvious reasons). Using PHP/MySQL on Hostgator.
When I run the script, I get the message that its working, but no data is being inserted into my database:
Access key correct, proceeding...
Starting to work with feed URL 'http://sandiego.craigslist.org/reo/index.rss'"
Thinking I had some sort of column mismatch, I used Excel to pull Craigslist data into a spreadsheet via the following: Excel Blog - Pulling RSS data into Excel (or: Using Excel to Search Craigslist) - Part 1 (file attached).
It looks like it should work, IMHO. Would someone be so kind as to take a look and see if you can find what Im missing?
Thank you in advance for any and all help!
05-10-13, 05:18 #2Jaded Developer
Provided Answers: 59
- Join Date
- Nov 2004
- out on a limb
what error messages are you getting
what changes have you made to the original code
what level of error reporting have you setI'd rather be riding on the Tiger 800 or the Norton