Welcome Guest ( Log In | Register)



 
Reply to this topicStart new topic
> Mysql, Several files in one field.
bluechip
post Jun 3 2008, 04:47 PM
Post #1


Newbie [Level 1]
*

Group: [HOSTED]
Posts: 24
Joined: 6-May 08
Member No.: 61,795



Hi guys. I want t know if it is posible to have so many entries for one object in a field in MySQL. I know my question may not be clear because I lack in terminology but pliz try and help. What I want to do is for axample have a database of my clients with the following fields for every client:
fname, lname, more than one photos, contrubutions(comments, jokes, testimonials posted) etc. I want to have the things like the photos in the same field but they have to be unique so that my php code can deal with them individually llike they are coming from different fields.
Go to the top of the page
 
+Quote Post
gogoily
post Jun 11 2008, 02:33 AM
Post #2


Advanced Member
*******

Group: Members
Posts: 100
Joined: 30-October 05
Member No.: 13,571



I suggest you not store images into mysql database. Instead, just store the images' path into mysql. Then you can verify the images by their path.
Go to the top of the page
 
+Quote Post
hitmanblood
post Jun 11 2008, 03:06 AM
Post #3


Privileged Member
*********

Group: [HOSTED]
Posts: 792
Joined: 13-April 07
From: mreža
Member No.: 41,558



Yes gogoily is right the easiest way to store it would be in fact to store path. Another way would be to store binary data of the picture but this is harder way and probably if beginner you will fail.

The other thing is that there is already discussion about this topic on the forum however I am not able to find it now. But if you need this very much then search forums more thoughtfully and you will be able to find it. I remember that there were many more posts on this topic there.

good luck with this.
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic

Collapse

> Similar Topics

Topics Topics
  1. Good Places To Storage Files(2)
  2. Another Good Place To Host Files(0)
  3. Website Building- E-mail Forwarding & Downloads(9)
  4. Webpage Design- Autodownloading Hosted Files(1)
  5. Php Tutorial - Basics...up To Mysql/file Commands(1)
  6. Mysql Infos(2)
  7. Mysql Tool(0)
  8. Mysql And Ms Access(1)
  9. What If You Forget Mysql Root Password(2)
  10. Mysql Host Adress(4)
  11. Import From Excel File Into Mysql Database(9)
  12. Php And Mysql Problem(8)
  13. Tips On Creating Your Own Search(1)
  14. Syndicate Your Content Using Php And Mysql(0)
  15. Phpbb And Mysql Relations?(2)
  1. How Do You Combine Multiple Mysql Databases Into One Database?(3)
  2. Host Files On Other Site(3)
  3. Merging Database Php Mysql(5)
  4. Which Data Type To Use In Mysql Table(4)
  5. Another Question On Mysql Table Data Type(1)
  6. Accessing Mysql From Javascript(4)
  7. Mysql + Php Question(5)
  8. Treating .csv Files As Database Data(2)
  9. Index In A Mysql Database(3)
  10. Naming Web Page Files(9)
  11. Auto-upload Files With Filezilla And Autohotkey(0)


 



- Lo-Fi Version Time is now: 6th September 2008 - 06:15 AM