Re: - Resizeing Images stored in mysql db

Thanx but, first I dont know the real size of the stored pictures and second I dont think that is a good idea to shrink a 50k photo. ----- Original Message ----- From: "Frisley Velasquez" <frisleyv@delta.com.gt> To: "Nikos Gatsis" <nikos@qbit.gr> Sent: Monday, February 16, 2004 4:16 PM Subject: Re: [PHP-DB] - Resizeing Images stored in mysql db > Hi, the only thing you need to do, is to add a varible where you specify the > width and the height of the pics. then add the var in the query. This to be > parsed not just as a <img src=".."> but as <img src="..." > width="..." > height="...">, so your images will be the width and height you want. > > Or if you would like dif. sizes, add a column in the table so you can enter > the width and height of each one, so you can call this ones(width and > height) in each case. > > ----- Original Message ----- > From: "Nikos Gatsis" <nikos@qbit.gr> > To: "PHP-mailist" <php-db@lists.php.net> > Sent: Monday, February 16, 2004 6:56 AM > Subject: [PHP-DB] - Resizeing Images stored in mysql db > > > > Hello list > > > > I store images in a mysql table and use then in a web site. > > > > Is possible to change the size of these images; > > > > > > Following the code I'm allredy use. > > > > $query="SELECT photoxl FROM books WHERE books_id = '$books_id'"; > > $result=mysql_db_query($database, $query, $conn) or Die > > ("...".mysql_error()); > > list($photoxl)=mysql_fetch_row($result); > > $type = $photoxl_type; > > if (!empty($photoxl)) { > > header("Content-Type: {$type}"); > > echo $photoxl; > > } > > > > Thank you in advance > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > >