RE: [PHP-DB] alphabetical sorting... limiting and paginatingonnext set of letter group

2003-07-29 Thread Ramil G. Sagum
looking for a all_in_one solution. Thanks for your help! Aaron -Original Message- From: Ramil G. Sagum [mailto:[EMAIL PROTECTED] Sent: July 29, 2003 11:07 PM To: Aaron Wolski Subject: Re: [PHP-DB] alphabetical sorting... limiting and paginating onnext set of letter group

RE: [PHP-DB] alphabetical sorting... limiting and paginatingonnext set of letter group

2003-07-29 Thread Ramil G. Sagum
function($char_begin, $char_end) { $q_begin = strtolower($char_begin); $q_end = chr(ord(strtolower($char_begin))+1); make that $q_end = chr(ord(strtolower($char_end))+1); sorry. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

RE: [PHP-DB] Save mySQL data into a CSV file.

2003-06-17 Thread Ramil G. Sagum
do a var_dump($result_set) to see what $result_set contains (if it's actually and array. (did you implement the code given as is? if not AND you have put line-11 in a function and $result_set as a global variable then you need to define $result_set as a global inside the function.) ramil On

Re: [PHP-DB] Password generator

2003-06-17 Thread Ramil G. Sagum
a simple way would be to : $pass = $allowable_characters[mt_rand(0,$ps_len-5)] for($i = 0; $i ($length -2); $i++) { $pass .= $allowable_characters[mt_rand(0,$ps_len-1)]; } $pass .= $allowable_characters[mt_rand(0,$ps_len-5)] // This variable contains the list of

Re: [PHP-DB] MySQL Connection

2003-06-17 Thread Ramil G. Sagum
On Wed, 2003-06-18 at 08:16, [EMAIL PROTECTED] wrote: Hello, Would be grateful if someone couldkindly point me in the right direction. Whenever I try to connect to mysql server, I get these messsage back 1. mysql GRANT ALL PRIVILEGES ON *.* TO moses@% IDENTIFIED BY cludiana; ERROR

Re: [PHP-DB] PHP Install conflicts w/ MySQL

2003-06-16 Thread Ramil G. Sagum
On Tue, 2003-06-17 at 03:08, Nathan wrote: # ./bin/mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 030616 12:04:24 mysqld ended I'm running the command as root so I don't think it's a permission issue. Does anyone know anything about the PHP install that would

Re: [PHP-DB] Get last id in postgresql

2003-06-16 Thread Ramil G. Sagum
pg_last_oid returns the last object id (an id used in the system catalogs) and not the ID/index of the row. if you need to get the last ID, you need to execute another select or write a pl/sql function. On Tue, 2003-06-17 at 10:13, Norma Ramirez - TECNOSOFT wrote: Hi all, Im starting with