troubleshooting Question

Insert image path into db

Avatar of darja22
darja22 asked on
PHPMySQL Server
10 Comments1 Solution1151 ViewsLast Modified:
Hi,
I want to insert images with their paths into my MySQL db and later retrieve them.
But, when tried to execute a query, it says that there was a problem with syntax?  
The "ad_file" column is BLOB.
Here is the code.
$query = "INSERT INTO ad_file SET imageURL = '/public_html/ads/music-468x60.png', '/public_html/ads/music-728x90.png',  '/public_html/ads/smileys-300x250.JPG', '/public_html/ads/smileys-600x160.PNG', '/public_html/ads/smileys1-300x250.PNG'";
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 10 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros