Re: [PHP-DB] Mysql autentication problem

2007-03-02 Thread Ted Fines
if that works. Increase the password complexity from there... Ted On 3/2/07, Roberto F Tavares Neto [EMAIL PROTECTED] wrote: Hello, I'm trying to do a very simple thing: create a database and a user to use it. So, initially, I use the web interface phpmyadmin. Logged as root, I created

Re: [PHP-DB] Mysql autentication problem

2007-03-02 Thread Ted Fines
'; Ted On 3/2/07, Roberto F Tavares Neto [EMAIL PROTECTED] wrote: Ted, I try the classic abc and had the same problem... Roberto Ted Fines escreveu: Hi, So it works from PHP w/o a password, but with a password does not? What are you using for a password? I don't mean post it here

[PHP-DB] mysql_connect problem

2006-12-09 Thread Ted Fines
was: --with-mysql=shared,$BLIB/mysql ...where $BLIB was set to /opt/apache-php/libs Thanks, Ted

[PHP-DB] PHP-MySQL CMS Generator

2006-10-03 Thread Ted Weatherly
Does anyone know of a program that can generate a good Content Management System? For example, it would ask which fields to add to a database table, the types of the fields, etc and create the database in MySQL and php's to manage the data. I did find a few such programs already (AppGini,

Re: [PHP-DB] If else Question

2002-03-27 Thread ted
Jennifer: Did you ever get your If else Question answered? On Mon, 25 Mar 2002, Jennifer Downey wrote: Hi all, I have a table called pets, here is a partial dump: At this time this is all I am working with. uid int(10) NOT NULL default '0', num_pet tinyint(1) NOT NULL default '1',

Re: [PHP-DB] PHP and Foxpro Databases

2002-03-27 Thread ted
Does FoxPro have an ODBC module? I'm in the midst of putting a web front-end on an Access database; we've put MySQL as the back end to Access using the ODBC connection. Then PHP can process queries on the MySQL db and the local operators see it as an Access db. We first tried PostgreSQL

Re: [PHP-DB] Beginner query about mysql...

2002-02-17 Thread ted
The manual is at http://www.php.net/manual/en The function you need is mysql_insert_id. On Mon, 18 Feb 2002, michele wrote: I have a table with a ID field 'auto_increment', when i insert a record in the table, how can i know the value of the ID inserted by the mySQL? Thank's, Michele.

Re: [PHP-DB] Problem with mail function

2002-01-14 Thread ted
Hi, Faye. There's a parm in the configuration file (php.ini) cleverly called max_execution_time. Its default setting is 30. There's also a set_time_limit() function that allows massaging this variable. Does this help? On Mon, 14 Jan 2002, Faye Keesic wrote: Don't know anything about ole 30

RE: [PHP-DB] Re: Moving from MySQL to MSSQL Server 2000

2002-01-13 Thread ted
Yes. PostgreSQL. On Sun, 13 Jan 2002, Boaz Yahav wrote: It's not just that... For example, when I want to backup the MySQL server (and we are talking of a few GB of data) the server is practically dead while making the dump. MSSQL Server 2000 (for example) does that in the background and

Re: [PHP-DB] PHP/MySQL Library Catalog System

2002-01-10 Thread Ted
I just saw this which is new on Hotscripts PhpMyLibrary http://www.hotscripts.com/Detailed/13279.html On Thursday 10 January 2002 15:26, Daniel Barton wrote: Hi all, I've noted that a least a couple of people on this list work with library catalog systems - I'm interested in finding out

RE: [PHP-DB] How to insert to DB from txt??? Please help

2002-01-04 Thread ted
egrep_split? But then, there's the learning curve for grep... On Fri, 4 Jan 2002, Leotta, Natalie (NCI/IMS) wrote: There are a few ways to split up text based on a delimiter. I recommend you look at split and explode on the PHP.net site and see what seems to be best for your situation.

Re: [PHP-DB] Date problem with new year

2002-01-02 Thread ted
Did you convert the dates to PHP's Julian format before subtracting? On Wed, 2 Jan 2002, Faye Keesic wrote: I have a db site that always displays the most recent occurrence of news stories The last occurrence of stories was last year (2001-12-31) and up to the new year rolling over, I

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