hello all, having some troubles inserting images directly into database. i'd like to store them directly in database as a blob.
i have a table as follows:
column id: tinyint,null=no,auto-increment,primary key
column photo: blob, null=no
column name: text, null=no
i've read somewhere that the photo column needs to be a binary blob, but when i set it as binary, i get sql statement errors (if i take binary out, i get no errors, but i needs to be binary right?). what is the proper column structure needed to store an image directly in database?
how do i submit a image using a form? (as text or numeric?) i use dreamweaver mx to create the input form. it will submit the photo from a file field as text or numeric.
i should be able to display them fine once set up, i just need help on the structure of the column and advice on how to submit them to the column.
thanks everyone for your time 😃
