SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Thread: About Mysql

  1. #1
    SitePoint Member
    Join Date
    Apr 2005
    Posts
    10
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    About Mysql

    Hi Everyone,

    How do you access file that I stored in databas and this files have ID Number which is the primary key of the table that I want to access. Here is how database is designed.

    mysql> DESCRIBE rss_data;
    +-------------+--------------+------+-----+---------+----------------+
    | Field | Type | Null | Key | Default | Extra |
    +-------------+--------------+------+-----+---------+----------------+
    | id | int(11) | | PRI | NULL | auto_increment |
    | filename | varchar(255) | | | | |
    | mimetype | varchar(50) | | | | |
    | description | varchar(255) | | | | |
    | filedata | mediumblob | YES | | NULL | |
    | size | int(11) | | | 0 | |
    +-------------+--------------+------+-----+---------+----------------+
    6 rows in set (0.21 sec)

    Can anyone suggest how to access this tables with php.

    Thanks in advance

  2. #2
    Woof! Woof! elel1138's Avatar
    Join Date
    Apr 2004
    Location
    Warsaw, Poland
    Posts
    202
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Leszek Leszczyński
    www.hazelsoft.com
    --- Real programmers don't document. If it was hard to write,
    it should be hard to understand. ---


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •