Re: [PHP-DB] pulling images from a database

2001-05-22 Thread Gary Huntress
If you want to be efficient, store only the image metadata in the database (path, filename, creator, date, dimentions, format, etc) in the database. Keep the actual data as a file. -- Regards, Gary SuperID Huntress === FreeSQL.org offering

Re: [PHP-DB] MySQL transactions?

2001-04-18 Thread Gary Huntress
a common question. This might help http://www.mysql.com/documentation/mysql/bychapter/manual_Compatibility.html #Missing_Transactions -- Regards, Gary "SuperID" Huntress === FreeSQL.org offering free database hosting to developers Visit

Re: [PHP-DB] Query with Access

2001-04-01 Thread Gary Huntress
I'd try adding: $conn = odbc_connect("pruebas_php", "", "") or die("cannot connect to pruebas_php"); $resultado1 = odbc_exec($conn,"SELECT Nombre, Apellido1, Apellido2 FROM Personas") or die ("cannot execute query"); -- Regards, Gary "SuperID" Huntress

Re: [PHP-DB] select data from a drop down box in a form

2001-04-01 Thread Gary Huntress
There are probably a million ways to do this... here is one :) (note that the file should be named "fieldtest.php" -- Regards, Gary "SuperID" Huntress === FreeSQL.org offering free database hosting to developers Visit

Re: [PHP-DB] Yet more strings

2001-03-21 Thread Gary Huntress
When I have exact string matches fail where I don't expect them, and using a LIKE fixes it, the very first thing I check for is embedded whitespace in the data. "foo " and "foo" and " foo " are not the same. If this is the case then IMHO the best solution is to fix the data in the database, but

Re: [PHP-DB] problems configuring php and postgres - FIXED

2001-03-20 Thread Gary Huntress
My thanks to everyone who provided me info and other hints/tips. The vast majority of the problem was human error of course, sprinkling in a few bad assumptions and some configuration problems...its amazing I got it working at allbut it is :) Thanks again to everyone. Gary "Rasmus Lerdorf"

[PHP-DB] Free MySQL Database Hosting (beta! beta! beta!)

2001-03-19 Thread Gary Huntress
Hi, I'm testing out the concept of offering free MySQL database hosting. Feel free to create a database at http://superid.dyndns.org:8080/freesql/index.php There's no catch, or hidden agenda. I thought it might be fun to try and offer this as a service to people who might be learning

[PHP-DB] problems configuring php and postgres - call to undefined function

2001-03-19 Thread Gary Huntress
ned function". Any thoughts? I'm pretty much out of ideas right now. Regards, Gary Huntress -- PHP Database 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]