Re: [PHP-DB] PHP+ postgresql help?

2001-08-20 Thread Ted Rolle
print_r? Am I about to learn something new? Be still, my beating heart! On Tue, 21 Aug 2001, speedboy wrote: $conn = pg_connect (host=localhost user=username password=password bname=dbname); $sql = SELECT * FROM database where lower('$name%') order by last;; $result =

[PHP-DB] Stress tesing a DB

2001-07-06 Thread Ted Rolle
I'm gathering data on open-source databases... is there a program that can provide comparisons between databases, such as MySQL and PostgreSQL? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To

Re: [PHP-DB] cites/states data

2001-06-30 Thread Ted Rolle
It's public info, so free, and Hah! Try to get the 9-digit ZIP code stuff. Developed with tax dollars and sold by (I believe) a private corporation. Isn't it great that we're not getting all of the government we're paying for? -- PHP Database Mailing List (http://www.php.net/) To

Re: [PHP-DB] Subtracting times?

2001-06-23 Thread Ted Rolle
check out http://www.php.net/manual/en/function.mktime.php If you still need assistance, I'm here. On Sun, 24 Jun 2001, Matthew Cothier wrote: I really need help here. What I am trying to do is the following. - $today = date(m.d.y); $time = date(g:i a); if($row[3] ==

Re: [PHP-DB] Testing MySQL failed ???

2001-03-31 Thread Ted Rolle
Mysql isn't up? On Sun, 1 Apr 2001, Szeto wrote: Hello The code below i use in testing the connection (written in php4) ? if(!mysql_connect("localhost","khaimun","akyweb")) { print "could not connect to mysql!"; } mysql_select_db("focalmail"); ? ---

Re: [PHP-DB] Testing MySQL failed ???

2001-03-31 Thread Ted Rolle
Excellent diagnosis, sir! However, it is woefully and pitifully short on curative information. On Sun, 1 Apr 2001, Felix Kronlage wrote: On Sun, Apr 01, 2001 at 06:50:24PM +0800, Szeto wrote: I am new to Linux environment so what. You could still read the error-message: |

Re: [PHP-DB] Storing sensitive information in MySQL

2001-03-01 Thread Ted Rolle
Ahhh my favorite subject. Privacy. There are two PHP functions that do _exactly_ what you're looking for. Mcrypt_encrypt and mcrypt_decrypt. If you're looking for just enough encryption to keep the curious out, use a single password for all encryption. If you want military-grade