Re: [PHP-DB] pls clue in the clueless..:)

At 12:27 AM 1/8/03 -0800, Shantu Roy wrote: Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /usr/www/htdocs/test.php on line 2 Could not connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) It is not a

Re: [PHP-DB] join query/relational database question

At 04:09 PM 1/6/03 -0500, Doug Parker wrote: I have a relational database issue that I'll simplify for the sake of this post. I have one table, called clients, that has an id and the company name. For example: id | company --- 46 Jones Inc. 54 Baker Inc. etc.

Re: [PHP-DB] Newbie q: problem with mysql_connect() on hosted service

At 10:45 AM 12/27/02 +0100, Baumgartner Jeffrey wrote: Fatal error: Call to undefined function: mysql_connect() in /home/.sites/22/site13/web/werks/formtest2.php on line 8 This means that MySQL is not enabled within PHP. There is nothing you can do about it. The hosting company needs to

Re: [PHP-DB] Help Needed

At 02:36 PM 12/26/02 +0700, dufronte wrote: Hi. I juz installed a RedHat 8.0 on my machine. But then I have a problem in configuring Apache 2.0.4 to use PHP 4.20.. Apache 2 and PHP are not ready for prime time. If you must use Apache 2 with PHP, you are on the bleeding edge, and should plan

Re: [PHP-DB] How can I use PHP to duplicate a mysql template database?

At 07:59 PM 12/16/02 -0800, Daevid Vincent wrote: I need to use PHP to duplicate the schema of a database. This seems like it should be a simple task -- taking a 'template' db and cloning it with a new name. The easiest way I know of is at the command line: mysqldump -p -u root

RE: [PHP-DB] foreach loop from MySQL select query to HTML select list

At 10:40 AM 11/29/02 +1100, Gavin Amm wrote: hmm, interesting to know the mysql_fetch_array() by default returns an array that's associative AND numeric - very useful to know something i'll have to look into more, thanks Jason. Using PHP's built in template system... $result_dept =

Re: [PHP-DB] Enum table entry

At 11:48 PM 10/18/02 -0500, Shiloh Madsen wrote: For instance, a series of checkboxes with items such as abjuration, conjuration, divination, and others, which will all have a numeric value which gets plugged into the enum field. for instance, if a user selected abjuration, and divination,

Re: [PHP-DB] Server Upgrade and DB Move(s)

At 03:14 PM 10/15/02 -0400, [EMAIL PROTECTED] wrote: I am in the process of upgrading my UNIX hardware and moving web sites from two different servers on to one server. I am curious as to opinions about moving/replicating the databases and peoples experiences. For the two that i have already

RE: [PHP-DB] enum and bad planning

At 03:35 PM 10/1/02 -0400, John W. Holmes wrote: You should BENCHMARK the two solutions and see which is faster. Or use EXPLAIN to see if there is any difference. I have no doubt this will be slower. Oh well, he wanted to keep the table definitions. Don't forget to consider the time required

Re: [PHP-DB] Date Concat?

At 07:07 AM 9/20/02 -0500, Rankin, Randy wrote: SELECT DATE_FORMAT(start_date, '%M %d, %Y') as start_date, DATE_FORMAT(end_date, '%M %d, %Y') as end_date FROM training This produces the following: start_date: September 16, 2002 end_date: Sepetember 20, 2001 Based

Re: [PHP-DB] Split Fields into 2 Tables or All in One?

At 02:18 PM 7/26/02 -0400, Monty wrote: Anyone have any tips or links to tips about update multiple tables based on data received from a form? If you use varchar fields the cost of empty fields is very small. The decision on using a separate table should be based in things like how many

Re: [PHP-DB] PHP database

Hello I'm to have database, but server's administrator refuses to install MySQL nor PHP MySQL support :( He told me he won't install it and I should use textfiles if I want to have database. Sounds like time too find another hosting provider. Rick -- PHP Database Mailing List