Im now using phpmyadmin to build & test my db structures. Trouble is when I run a SELECT * from table query the record I submitted shows but where I have blob fields the record simply states [blob]. Why is this?
Because the blob field may be : 1. huge 2. in a format not automatically recognized by the browser 3. its the default action for blob fields...
So the value is there but phpmyaadmin cannot show it?
At best it will show [blob - 4.5Kb], if the blobs are all images, there is a setting to show thumbnails...
What is a blob anyways?
The only ones I use are Int, Varchar, and Text.
It can show images if PMA is set up to allow it this book is an excellent guide.
Blobs are Binary Large OBjects (images files PDFs etc) that you can store in the db