[PHP-DB] Re: LAMP

2004-08-03 Thread Lester Caine
Gavin Amm wrote: I'd really like to find a Linux distro that is a LAMP system right out of the box. (Linux, Apache, MySQL, PHP) Are there any out there? Thankfully not ;) I want LAFP but LAPP seems still to be more popular on Linux. WHY does everybody run lemming like after MySQL. It STILL has to

Re: [PHP-DB] LAMP

2004-08-03 Thread Steve Davies
Hi Gav SuSE will work outta the box. Just make sure you've selected the components and Yast will configure more or less everything to work together before installing cheers Steve Gavin Amm wrote: I'd really like to find a Linux distro that is a LAMP system right out of the box. (Linux, Apache,

Re: [PHP-DB] Re: LAMP

2004-08-03 Thread Jason Wong
On Tuesday 03 August 2004 14:14, Lester Caine wrote: I want LAFP but LAPP seems still to be more popular on Linux. WHY does everybody run lemming like after MySQL. It STILL has to catch up with the better FREE database engines ;) It depends on your needs. For simple storage of data

[PHP-DB] DB2 +Windows +CLOB

2004-08-03 Thread Javier Mestre
Any example how to use CLOB,BLOB fields with PHP under Windows and DB2 ? Thanks in advance Javier Mestre -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: LAMP

2004-08-03 Thread Lester Caine
Jason Wong wrote: I want LAFP but LAPP seems still to be more popular on Linux. WHY does everybody run lemming like after MySQL. It STILL has to catch up with the better FREE database engines ;) It depends on your needs. For simple storage of data (involving few relationships) then MySQL is more

Re: [PHP-DB] Enabling LDAP support

2004-08-03 Thread Arné Klopper
Have you checked the extensions directory where the .dll file is located in the httpd.conf file. I've been running LDAP for the last 3 weeks, so if you need any help contac tme. Arné [EMAIL PROTECTED] Kind Regards Arné Klopper NetCB (Pty) Ltd.

Re: [PHP-DB] Re: LAMP

2004-08-03 Thread Jason Wong
On Tuesday 03 August 2004 15:34, Lester Caine wrote: It depends on your needs. For simple storage of data (involving few relationships) then MySQL is more than sufficient and a tried and tested solution. This probably covers the vast majority of the data storage needs of web apps. No

[PHP-DB] Re: sendmail

2004-08-03 Thread David Robley
On Tue, 3 Aug 2004 04:01, Aaron Todd wrote: So far, I have been doing ok with PHP. I feel that I have picked it up rather easily. But now I need some help. I am trying to use the sendmail functions to send data entered in a form to my email address. Currently its not working at all. I

[PHP-DB] Web page paginator that doesn't rely on the LIMIT clause

2004-08-03 Thread Ross Honniball
Hi all, I use the LIMIT statement to control paging of data, which works really well. I now have a situation where I need to use some logic in addition to the query that will result in NOT ALL records being spat out. ie. select * from x where y; foreach result if (some condition)

[PHP-DB] Re: Web page paginator that doesn't rely on the LIMIT clause

2004-08-03 Thread Josh Acecool M
That will take alot of resources, but if you only want 20 then make a variable to count, $i or so, $++; each time it goes through, after 20 make it stop the script. Ross Honniball [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi all, I use the LIMIT statement to control paging of

Re: [PHP-DB] Web page paginator that doesn't rely on the LIMIT clause

2004-08-03 Thread Ignatius Reilly
1. What prevents you from implementing the conditions directly in SQL? You can achieve a lot with CASE and IF. 2. For your paging needs, you may benefit from investigating the PEAR HTML_Pager class. Ignatius _ - Original Message - From: Ross Honniball [EMAIL

RE: [PHP-DB] LAMP

2004-08-03 Thread Galbreath, Mark A
SuSE 9.1 Pro Mark -Original Message- From: Gavin Amm [mailto:[EMAIL PROTECTED] Sent: Monday, August 02, 2004 8:40 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] LAMP I'd really like to find a Linux distro that is a LAMP system right out of the box. (Linux, Apache, MySQL, PHP) Are there any

Re: [PHP-DB] Web page paginator that doesn't rely on the LIMIT clause

2004-08-03 Thread Ross Honniball
At 10:22 PM 3/08/2004, you wrote: 1. please answer to the list, not to only me (you break the thread) whoops. sorry. 2. show us your data model if you need further help AS AN EXERCISE, I would be interested to know if you can do this in one query, but I've pretty much decided to either code up or

Re: [PHP-DB] DB2 +Windows +CLOB

2004-08-03 Thread Robert Twitty
The odbtp extension has be used quite successfully with DB2. You can get it at http://odbtp.sourceforge.net. I have not personnally used it with DB2, but there are posts on odbtp's help forum pertaining to DB2. -- bob On Tue, 3 Aug 2004, Javier Mestre wrote: Any example how to use CLOB,BLOB

Re: [PHP-DB] Web page paginator that doesn't rely on the LIMIT clause

2004-08-03 Thread Ignatius Reilly
With MySQL 4.1: try this (untested) SELECT SM.key, SM.stock_on_hand COALESCE( SH.tally, 0 ) AS hist_sales FROM stock_master AS SM LEFT JOIN ( SELECT SH.key SUM( SH.jan ) + ... + SUM( SH.`dec` ) AS tally FROM stock_history AS SH WHERE SH.year = 2004 GROUP

Re: [PHP-DB] Re: LAMP

2004-08-03 Thread John W. Holmes
From: Lester Caine [EMAIL PROTECTED] I'd really like to find a Linux distro that is a LAMP system right out of the box. (Linux, Apache, MySQL, PHP) Are there any out there? Thankfully not ;) I want LAFP but LAPP seems still to be more popular on Linux. WHY does everybody run lemming

Re: [PHP-DB] Re: LAMP

2004-08-03 Thread Lester Caine
John W. Holmes wrote: Right... I find a great need for triggers and stored procedures in my guestbooks and shoutboxes. Come on people, the right tool for the right job. MySQL is supported on more hosts and fills the needs of most web developers. This is like arguing over which editor to use! And

Re: [PHP-DB] Web page paginator that doesn't rely on the LIMIT clause

2004-08-03 Thread Ross Honniball
Wow. I had no idea how little I knew about sql (well, I kind of did really). I've always found it easier to stick to the basics and rely on program logic to do anything involved. I'll take this on board and give it a go. FYI table design is way out of my control - I'm just building a report on

[PHP-DB] Re: sendmail

2004-08-03 Thread Aaron Todd
Is there any tweaking with mail()? I have it working, but it seems to not always send the email. Mainly one right after the other. I filling a web form and then sending the data off to my email. But then I do a refresh to clear the form and do it again with different data and it doesnt work.

RE: [PHP-DB] Re: LAMP

2004-08-03 Thread Gary Every
The answer to that is SPEED. Nothing short of Oracle comes even close Gary Every Sr. UNIX Administrator Ingram Entertainment Inc. 2 Ingram Blvd, La Vergne, TN 37089 Pay It Forward! -Original Message- From: Lester Caine [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 03, 2004 1:15

Re: [PHP-DB] DB2 +Windows +CLOB

2004-08-03 Thread Gerard Samuel
On Tuesday 03 August 2004 09:02 am, Robert Twitty wrote: The odbtp extension has be used quite successfully with DB2. You can get it at http://odbtp.sourceforge.net. I have not personnally used it with DB2, but there are posts on odbtp's help forum pertaining to DB2. -- bob On Tue, 3 Aug

[PHP-DB] Re: Subject: Enabling LDAP support

2004-08-03 Thread Neil Smith [MVP, Digital media]
I have copied the two required .dlls (libeay32 ssleay32) into the system folder. No, you need to copy the dll's to \winnt\system32, not \winnt\system thinking that that might make it work... but it didn't *How* didn't it work ? What did you try ? If it didn't connect, are you letting TCP port

Re: [PHP-DB] Web page paginator that doesn't rely on the LIMIT clause

2004-08-03 Thread Justin Patrin
On Tue, 03 Aug 2004 20:52:23 +1000, Ross Honniball [EMAIL PROTECTED] wrote: Hi all, I use the LIMIT statement to control paging of data, which works really well. I now have a situation where I need to use some logic in addition to the query that will result in NOT ALL records being spat

Re: [PHP-DB] Re: LAMP

2004-08-03 Thread Lester Caine
Gary Every wrote: The answer to that is SPEED. Nothing short of Oracle comes even close You must have a big cheque book. I get just as fast a system without having to pay a penny over the cost of the hardware ;) -- Lester Caine - L.S.Caine Electronic Services --

Re: [PHP-DB] Re: LAMP

2004-08-03 Thread Jason Wong
On Wednesday 04 August 2004 02:10, Lester Caine wrote: Gary Every wrote: The answer to that is SPEED. Nothing short of Oracle comes even close You must have a big cheque book. I get just as fast a system without having to pay a penny over the cost of the hardware ;) Hmm, if I'm not

RE: [PHP-DB] Re: LAMP

2004-08-03 Thread Hutchins, Richard
(tongue planted firmly in cheek...) Nyah, nyah, nyah...my database can beat up your database. Sheesh! You guys are killing me! If there was only ONE correct choice, we'd all be building online interfaces to our [EMAIL PROTECTED] Access '97 databases. And we would've missed out on the whole Pepsi

[PHP-DB] MySQL fulltext search with InnoDB table?

2004-08-03 Thread Swan, Nicole
What is the best way to simulate a fulltext search on a MySQL table of type InnoDB? Do I index the searchable fields and use the LIKE() function with appropriate wildcards? What are the performance implications with this? Switching back to a table type of MyISAM is really not an option. Is

Re: [PHP-DB] Re: LAMP

2004-08-03 Thread Lester Caine
Jason Wong wrote: The answer to that is SPEED. Nothing short of Oracle comes even close You must have a big cheque book. I get just as fast a system without having to pay a penny over the cost of the hardware ;) Hmm, if I'm not mistaken, I think he means that *unless* you have a big cheque

Re: [PHP-DB] Re: LAMP

2004-08-03 Thread Lester Caine
Jason Wong wrote: The answer to that is SPEED. Nothing short of Oracle comes even close You must have a big cheque book. I get just as fast a system without having to pay a penny over the cost of the hardware ;) Hmm, if I'm not mistaken, I think he means that *unless* you have a big cheque

[PHP-DB] Converting an MS Access DateTime in PHP

2004-08-03 Thread Andrew
If I retrieve a DateTime variable from an MS Access database, how can I convert/format it in PHP? Thanks. andrew -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: sendmail

2004-08-03 Thread Manuel Lemos
Hello, On 08/03/2004 11:16 AM, Aaron Todd wrote: Is there any tweaking with mail()? I have it working, but it seems to not always send the email. Mainly one right after the other. I filling a web form and then sending the data off to my email. But then I do a refresh to clear the form and do it

[PHP-DB] Re: Converting an MS Access DateTime in PHP

2004-08-03 Thread David Robley
On Wed, 4 Aug 2004 07:39, Andrew wrote: If I retrieve a DateTime variable from an MS Access database, how can I convert/format it in PHP? Thanks. andrew Not knowing what format Access provides its dates in, I suggest you look at the Date and Time functions that PHP has, and pick one to

[PHP-DB] php-db@lists.php.net is currently protecting themselves from receiving junk mail using Spamcease Just this once, click the link below so I can receive your emails.

2004-08-03 Thread Josh Acecool M
What is this? I received this E-Mail, and the link goes to something other than PHP.net [EMAIL PROTECTED] is currently protecting themselves from receiving junk mail using Spamcease Just this once, click the link below so I can receive your emails. You won't have to do this again. -- PHP

[PHP-DB] How To Detrmine Session End

2004-08-03 Thread Mubashar-Hotmail
Hi all, In the scenario of Who are online now on the site, how we track user If a he don't click on Logout button but directly close its browser or switch to another site. Thanks in Advance, Mubashar