Image and Mysql capabilities

Hi list Members, I have a real doubt regarding the storage of images in the My sql database. Anyone know the alternatives to manipulate the insert and query with images? Well, let me explain...I have a lot of images that correspond to some "cars" names. I want, everytime a user select the respective car, to "bring" the respective car image with the informations of that car. I was reading about mysql, and found that it don't store images in the fields, but we can create a BLOB field and store it in binary. But, I'm afraid of the performance of the DB, cause sometimes you have thousands os images, and I know that it will occupy a lot of space!...So, I thought about putting a reference path to that image!...And print this path in a <img> tag...What do you think about it? Thanks 4 your attention, Regards, Felipe Moreno -----Mensagem original----- De: Mark Roedel [mailto:MarkRoedel@letu.edu] Enviada em: segunda-feira, 14 de maio de 2001 10:51 Para: Dragan Dinic; php-db@lists.php.net Assunto: RE: [PHP-DB] php -> MSSQL > -----Original Message----- > From: Dragan Dinic [mailto:dinic@knez.uis.kg.ac.yu] > Sent: Monday, May 14, 2001 5:11 AM > To: php-db@lists.php.net > Subject: [PHP-DB] php -> MSSQL > > > Is there any possible way to connect PHP (running on apache > 1.3.12 on Red Hat Linux 7) with Microsoft SQL server (running > on Windows 2000) ? Yep. As someone else has noted, the ODBC functions are one way. Another way, particularly if you prefer to talk to the database directly rather than through a translation layer, is to install the FreeTDS libraries (http://www.freetds.org/) on your Linux machine and then build PHP with the --with-sybase configuration parameter. This will enable the mssql_* functions. --- Mark Roedel (roedelm@letu.edu) || "There cannot be a crisis next week. Systems Programmer / WebMaster || My schedule is already full." LeTourneau University || -- Henry Kissinger -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net