in reply to Lot's of simple question about CGI

Well . . . I'll make a few assumptions and see if it makes sense. Lets assume your mysql table looks like this:

create table IMAGES( ID int(4) primary key auto_increment, data MEDIUMBLOB, type int(4), name char(10), width int(3), height int(3) ); create table IMAGETYPES( ID int(4) primary key auto_increment, name char(10), description char(10) );


Then your sql to insert an image would be:

insert into IMAGES(data,name,width,height) values(?,?,?,?)


Ok, that SQL is then primed to go into a DBI call using execute (after prepare) or by a do. As its an insert I recommend a 'do' call.

The second table allows you (by using a JOIN) to retrieve the image type and hence print the correct header when printing the image (assuming thats what you want).

As for SendMail - get Linux.
LiveStreaming - you could try something with Real using a RAM file under Apache. But its probably a little advanced. I would get the image stuff working first.

Replies are listed 'Best First'.
A reply falls below the community's threshold of quality. You may see it by logging in.