[PHP] mysql, interbase, etc

[kachaloo]

Hi,
Which db supports trigers and stored procedures and is also free ?  I
thought mysql supports it but to my dismay it does not it will support it in
the near future 
Please help as I need to find one out soon. wht abt interbase is it anygood
?
Regards,
Vishal

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP] Suggest Table Structure

[kachaloo]

Hi guys,
I am making a table which will store articles for a site
and the feilds are :

ID int(6) NOT NULL auto_increment,
CATEORY varchar(10) NOT NULL DEFAULT 'EVENTS' ,
HEADING varchar(30) NOT NULL DEFAULT '' ,
BODY longblob ,
PICTURE longblob ,
KEYWORD varchar(30) NOT NULL DEFAULT '' ,
FILENAME varchar(50) ,
FILESIZE varchar(50) ,
FILETYPE varchar(50) ,
PRIMARY KEY (ID),
UNIQUE ID (ID)


But now I noticed some of the articles will have more than one
picture... so how do I structure my talbe ?

Thanks in advance,
Vishal

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP] Showing an Image

[kachaloo]

HI,
I want to show an image from a database but to do that I am using :
 $result = @mysql_query($sql);
 $data = @mysql_result($result, 0, PICTURE);
 $type = @mysql_result($result, 0, FILETYPE);
 Header(Content-type: $type);
 echo $data;


but after this I also want to show some text info. How can I do this ? I
will have to use something else besides header. Please Help.
Thanks,
Vishal



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]