[PHP-DB] Sum

2004-09-04 Thread balwantsingh
hi, i am developing a webpage by using PHP for inserting / displaying data on daily basis and storing the database in Mysql. now i want to make one report which gives sum on monthly basis. my table is containining two fields 1) date (in -MM-DD format) 2) unit_consumed (integer) with

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-04 Thread Lester Caine
Hans Lellelid wrote: No, that's true; no Firebird yet. Drivers needed :) It's basically a slightly modified version of the JDBC API for PHP. Now THAT might be the correct way forward. I already use the Firebird-Jaybird interface when running plug-ins on Eclipse without any problems, but I

Re: [PHP-DB] Which Database Abstraction Layer ?

2004-09-04 Thread Lester Caine
Lester Caine wrote: No, that's true; no Firebird yet. Drivers needed :) It's basically a slightly modified version of the JDBC API for PHP. Now THAT might be the correct way forward. I already use the Firebird-Jaybird interface when running plug-ins on Eclipse without any problems, but I

[PHP-DB] Displaying Text From A Data File

2004-09-04 Thread Ron Piggott
I am still new to PHP and I wanted to ask a question. I am wanting to create a PHP script to randomly display one of many greeting messages on my web site. I was going to store them in a text based file. I wanted PHP to randomly select one of them and display it each time the script was loaded.

RE: [PHP-DB] Re: Newbie Questions

2004-09-04 Thread Pete Holsberg
On Fri, 3 Sep 2004, Hutchins, Richard wrote: -Original Message- From: Pete Holsberg [mailto:[EMAIL PROTECTED] Sent: Friday, September 03, 2004 11:59 AM Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Re: Newbie Questions On Thu, 2 Sep 2004, Torsten Roehr wrote: I

[PHP-DB] About PHP 5.0.1

2004-09-04 Thread Daniel A. Betancourt
Hi: So far I´ve read that PHP 5.0.1 has Object Oriented capabilities and it can be used to construct GUI regarding OO programing style, That it has Class, constructors, and alike. I´m new to this, that´s why I wondered for a RAD enviroment on PHP as soon as I installed it. Isn´t there any?. Must

[PHP-DB] Re Displaying Text From A Data File

2004-09-04 Thread Neil Smith [MVP, Digital media]
It's actually very simple : Just use SELECT * FROM tbl_name ORDER BY RAND() LIMIT 1 Cheers - Neil At 17:35 04/09/2004 +, you wrote: Message-ID: [EMAIL PROTECTED] From: Ron Piggott [EMAIL PROTECTED] To: PHP DB [EMAIL PROTECTED] Date: Sat, 4 Sep 2004 14:00:56 -0400 MIME-Version: 1.0

Re: [PHP-DB] Re Displaying Text From A Data File

2004-09-04 Thread Peter Ellis
If it were a database, this would make sense. He's asking about a text- based file. This isn't really a database issue -- there's a lot of what are called fortune scripts out there that do exactly what you want. Do a search on Google. -- Peter Ellis - [EMAIL PROTECTED] Web Design and

Re: [PHP-DB] Re: Newbie Questions

2004-09-04 Thread Torsten Roehr
SELECT firstname, lastname, address FROM TABLENAME ORDER BY lastname ASC; Use ASC or DESC to order your query results. When you iterate over the result as Torsten indicated, everything will be in the order you specify. In the database table itself, right? Does it make more sense to do

[PHP-DB] Re: Displaying Text From A Data File

2004-09-04 Thread Torsten Roehr
Ron Piggott [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I am still new to PHP and I wanted to ask a question. I am wanting to create a PHP script to randomly display one of many greeting messages on my web site. I was going to store them in a text based file. I wanted PHP to

[PHP-DB] chmod

2004-09-04 Thread Remember14a
Dear friends, In quiz there is a dir called saved and chmod it to 0755 How do I chmod directory to 0755 Guidance, please.

[PHP-DB] Re: chmod

2004-09-04 Thread Torsten Roehr
[EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Dear friends, In quiz there is a dir called saved and chmod it to 0755 How do I chmod directory to 0755 Guidance, please. Typing chmod into the search input field on php.net (search whole site) would have lead you to:

Re: [PHP-DB] Re: Newbie Questions

2004-09-04 Thread Pete Holsberg
On Sat, 4 Sep 2004, Torsten Roehr wrote: SELECT firstname, lastname, address FROM TABLENAME ORDER BY lastname ASC; Use ASC or DESC to order your query results. When you iterate over the result as Torsten indicated, everything will be in the order you specify. In the database

[PHP-DB] mysql results with limit

2004-09-04 Thread Michael Gale
Hello, Right now I have a mysql select statement with the LIMIT option of 500. Is there a way to find what the total number of selected results would of been with out doing a mysql select first with out the limi and using mysql_num_rows ? Thanks -- Hand over the Slackware CD's and back

Re: [PHP-DB] mysql results with limit

2004-09-04 Thread Doug Thompson
Michael Gale wrote: Hello, Right now I have a mysql select statement with the LIMIT option of 500. Is there a way to find what the total number of selected results would of been with out doing a mysql select first with out the limi and using mysql_num_rows ? Thanks You could use