[PHP] mysql and the PHP transition from 4 to 5.

2004-10-21 Thread Nick Lane-Smith
Hello php-list, I'm curious to why default mysql support was dropped from PHP 5? The separation seems to have been done for license issues with the mysql library. PHP 4.X uses a libmysql with an abandoned copyright for mysql access. Would the libmysql still work with PHP 5, or is PHP 5 dependent

Re: [PHP] SF Project: In Need of PHP & MySQL Developers

2004-09-28 Thread Matthew Sims
> I don't know if this is the right place to post this, so my fault if it > isn't. > > I am looking for PHP & MySQL Developers to help create a web-based RPG > written using the latest versions of PHP and MySQL. I unfortunately am > not a programmer, but hope to f

[PHP] SF Project: In Need of PHP & MySQL Developers

2004-09-28 Thread Michael Lauzon
I don't know if this is the right place to post this, so my fault if it isn't. I am looking for PHP & MySQL Developers to help create a web-based RPG written using the latest versions of PHP and MySQL. I unfortunately am not a programmer, but hope to find programmers that can tak

Re: [PHP] php, mySQL query character problem

2004-09-22 Thread Curt Zirzow
* Thus wrote Victor C.: > > If i copy paste the string into phpMyAdmin SQL, the query executes > successfully and returns one record. > > However, when I just do$returnValue = QueryDatabase($query); > echo > mysql_num_rows($ret

RE: [PHP] php, mySQL query character problem

2004-09-22 Thread Jay Blanchard
[snip] $query = "select * from table1 where colum1 like '$email%'"; $returnValue = QueryDatabase($query); echo mysql_num_rows($returnValue); I always get 0 for the # of records. [/snip] You have not included the code from your QueryDatabas

[PHP] php, mySQL query character problem

2004-09-22 Thread Victor C.
Hi, I have a query to mysql basically saying: $query = "select * from table1 where colum1 like '$email%'"; //where $email is defined string. When i "echo $query", I get the string : select * from table 1 where colum1 like 'testdata%' If i copy paste the string into phpMyAdmin SQL, t

Re: [PHP] very basic php mysql question

2004-09-20 Thread Jason Davidson
add mysql_error() to your die string so you can report what the error is. Jason "AMC" <[EMAIL PROTECTED]> wrote: > > Thanks, > > the script runs now, but I cannot open a connection. I know the user name, > and password are correct. What could be the cause? > > > > > $user = "aclark"; > >

Re: [PHP] very basic php mysql question

2004-09-20 Thread AMC
I figured it out - using the wrong info for host Thanks again "Amc" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Thanks, > > the script runs now, but I cannot open a connection. I know the user name, > and password are correct. What could be the cause? > > > > > $user = "aclark";

Re: [PHP] very basic php mysql question

2004-09-20 Thread AMC
Thanks, the script runs now, but I cannot open a connection. I know the user name, and password are correct. What could be the cause? "Matthew Sims" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > > > I have a php page with the code below. The page doesn't show the record > > fr

Re: [PHP] very basic php mysql question

2004-09-20 Thread Victor Saldaña D.
On Mon, 20 Sep 2004 15:17:33 -0700, AMC <[EMAIL PROTECTED]> wrote: > http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] very basic php mysql question

2004-09-20 Thread Matthew Sims
> > I have a php page with the code below. The page doesn't show the record > from > the database when it runs and I'm not sure why. I'm not getting any error > message, just a blank page. There is one record in the tabele I'm trying > to > query. > I'm brand new to php so I'd really appreciate the

[PHP] very basic php mysql question

2004-09-20 Thread AMC
Hi, I have a php page with the code below. The page doesn't show the record from the database when it runs and I'm not sure why. I'm not getting any error message, just a blank page. There is one record in the tabele I'm trying to query. I'm brand new to php so I'd really appreciate the help. -

RE: [PHP] MySQL query for average records per day OT

2004-09-16 Thread Jay Blanchard
[snip] mysql> desc dates; +--+-+--+-+-+---+ | Field| Type| Null | Key | Default | Extra | +--+-+--+-+-+---+ | the_date | date| YES | | NULL| | | number | int(11) | | | 0 | | +--

Re: [PHP] MySQL query for average records per day

2004-09-16 Thread John Holmes
From: "Greg Donald" <[EMAIL PROTECTED]> mysql> select the_date, count(number), avg(number) from dates group by the_date; ++---+-+ | the_date | count(number) | avg(number) | ++---+-+ | 2004-01-01 | 3 | 2.

Re: [PHP] MySQL query for average records per day

2004-09-16 Thread Jeff Oien
John Holmes wrote: From: "Greg Donald" <[EMAIL PROTECTED]> You can't get the average and a count in the same query Sure you can. mysql> select count(number), avg(number) from numbers; Depends how you interpret his request, I guess. I took it as a request for the count of records per day and then

Re: [PHP] MySQL query for average records per day

2004-09-16 Thread Greg Donald
On Thu, 16 Sep 2004 16:08:45 -0400, John Holmes <[EMAIL PROTECTED]> wrote: > Depends how you interpret his request, I guess. I took it as a request for > the count of records per day and then the average of those counts. > > So, if you had > > D1 > D1 > D1 > D1 > D2 > D2 > D3 > > The count would

Re: [PHP] MySQL query for average records per day

2004-09-16 Thread John Holmes
From: "Greg Donald" <[EMAIL PROTECTED]> You can't get the average and a count in the same query Sure you can. mysql> select count(number), avg(number) from numbers; Depends how you interpret his request, I guess. I took it as a request for the count of records per day and then the average of those

RE: [PHP] MySQL query for average records per day OT

2004-09-16 Thread Jay Blanchard
[snip] > You can't get the average and a count in the same query Sure you can. mysql> select count(number), avg(number) from numbers; +---+-+ | count(number) | avg(number) | +---+-+ |18 | 2.3889 | +---+-+ 1 r

Re: [PHP] MySQL query for average records per day

2004-09-16 Thread Greg Donald
On Thu, 16 Sep 2004 15:15:01 -0400, John Holmes <[EMAIL PROTECTED]> wrote: > You can't get the average and a count in the same query Sure you can. > desc numbers; ++-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | ++-+--+---

RE: [PHP] MySQL query for average records per day

2004-09-16 Thread Jay Blanchard
[snip] I have a database with a date field in this format 20041016 I'd like to count how many records were made on each day (except today) and average them. Can I do this in one query or will I need to do some more PHP stuff after I get some results? Thanks. Bare bones so far: $sql = "select dat

Re: [PHP] MySQL query for average records per day

2004-09-16 Thread John Holmes
From: "Jeff Oien" <[EMAIL PROTECTED]> I have a database with a date field in this format 20041016 I'd like to count how many records were made on each day (except today) and average them. Can I do this in one query or will I need to do some more PHP stuff after I get some results? Thanks. Bare b

RE: [PHP] MySQL query for average records per day

2004-09-16 Thread Gryffyn, Trevor
nal Message- > From: Jeff Oien [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 16, 2004 2:35 PM > To: PHP > Subject: [PHP] MySQL query for average records per day > > > I have a database with a date field in this format > 20041016 > I'd like to count how m

[PHP] MySQL query for average records per day

2004-09-16 Thread Jeff Oien
I have a database with a date field in this format 20041016 I'd like to count how many records were made on each day (except today) and average them. Can I do this in one query or will I need to do some more PHP stuff after I get some results? Thanks. Bare bones so far: $sql = "select date1 from

RE: [PHP] MySQL to OO

2004-09-16 Thread Jay Blanchard
[snip] I am looking for a absolute transparent interface to access each field a s a object. So if i would have a table like this: tablename: namedtable -- | id | foo | bar | -- | 01 | aaa | uuu | -- | 02 | bbb | mmm | -- I could ac

Re: [PHP] MySQL to OO

2004-09-16 Thread John Holmes
From: "Neo Theone" <[EMAIL PROTECTED]> I am searching for a MySQl to Object abstraction class. I am thinking something like WebObjects does in Java (it is just a part) in PHP. I had one for Ruby but now I have to use a DB in MySQL and such a class would make it alot easier. Are you talking about

Re: [PHP] MySQL to OO

2004-09-16 Thread Neo Theone
John Holmes wrote: From: "Neo Theone" <[EMAIL PROTECTED]> I am searching for a MySQl to Object abstraction class. I am thinking something like WebObjects does in Java (it is just a part) in PHP. I had one for Ruby but now I have to use a DB in MySQL and such a class would make it alot easier. Ar

[PHP] Re: php/MYSQL remove duplicate records

2004-09-15 Thread Sam Hobbs
I do that a lot using Microsoft Access. I just finished on a project where I had to eliminate duplicates from each of three or more queries, a couple of which have three keys. However I am not much more experienced han you are; Microsoft Access generates SQL for us so I am not sure what the SQL

Re: [PHP] MySQL to OO

2004-09-15 Thread John Holmes
From: "Neo Theone" <[EMAIL PROTECTED]> I am searching for a MySQl to Object abstraction class. I am thinking something like WebObjects does in Java (it is just a part) in PHP. I had one for Ruby but now I have to use a DB in MySQL and such a class would make it alot easier. Are you talking about

RE: [PHP] MySQL to OO

2004-09-15 Thread Jay Blanchard
[snip] I am searching for a MySQl to Object abstraction class. I am thinking something like WebObjects does in Java (it is just a part) in PHP. I had one for Ruby but now I have to use a DB in MySQL and such a class would make it alot easier. Does anybody know such a project or something similar

Re: [PHP] MySQL to OO

2004-09-15 Thread Greg Donald
On Wed, 15 Sep 2004 21:51:40 +0200, Neo Theone <[EMAIL PROTECTED]> wrote: > I am searching for a MySQl to Object abstraction class. > I am thinking something like WebObjects does in Java (it is just a part) > in PHP. I had one for Ruby but now I have to use a DB in MySQL and such > a class would ma

[PHP] MySQL to OO

2004-09-15 Thread Neo Theone
I am searching for a MySQl to Object abstraction class. I am thinking something like WebObjects does in Java (it is just a part) in PHP. I had one for Ruby but now I have to use a DB in MySQL and such a class would make it alot easier. Does anybody know such a project or something similar? I jus

Re: [PHP] php/MYSQL remove duplicate records

2004-09-14 Thread Jason Davidson
you could select out all the DISTINCT email addresses, and delete the table, and repopulate it with your selected rows add a constraint to the table to make email column unique afterwards maybe. Jason Dustin Krysak <[EMAIL PROTECTED]> wrote: > > Hi there - I have an extremely simple table that

[PHP] php/MYSQL remove duplicate records

2004-09-14 Thread Dustin Krysak
Hi there - I have an extremely simple table that has a unique Id and an email address. what I am looking for is an example of a PHP script that will poll the MYSQL database and delete the duplicate records leaving only 1 unique (email) record. can someone point me to the right place? thanks

Re: [PHP] Confused overSimple PHP mySQL date question

2004-09-14 Thread John Holmes
From: "Scott Miller" <[EMAIL PROTECTED]> I have a mysql database that has a date field and a time field. I want users to be able to enter a date and a time in text boxes on an html form and have them end up in the database. Code examples would be good here. Either way, the format for a DATE field

RE: [PHP] Confused overSimple PHP mySQL date question

2004-09-14 Thread Jay Blanchard
[snip] DATE field in a mysql database. What obvuios thing did I miss? Note I am not using the system date or time stamp, these are entered dates. [/snip] You're using a DATE field in the MySQL database. MySQL requires an ISO formatted date unless you manipulate it, such as 2004-09-14 http://dev.

[PHP] Confused overSimple PHP mySQL date question

2004-09-14 Thread Scott Miller
Hi, I have checked the recent list archives and looked up various PHP functions. I know what I want should be simple but, apparently not simple enought for me. I have a mysql database that has a date field and a time field. I want users to be able to enter a date and a time in text boxes on an

RE: [PHP] PHP/MySQL fatal error

2004-08-28 Thread gc
Please accept my appologies, it won't happen again. I didn't realize. I must have missed this in the welcome message. gene -Original Message- From: Jason Wong [mailto:[EMAIL PROTECTED] Sent: Friday, August 27, 2004 11:00 PM To: [EMAIL PROTECTED] Subject: Re: [PHP] PHP/MySQL f

Re: [PHP] PHP/MySQL fatal error

2004-08-27 Thread Jason Wong
On Saturday 28 August 2004 09:43, gc wrote: > Hi all, > > I'm Gene Candelaria and I'm a PHP and MySQL newbie. You have started a new thread by taking an existing posting and replying to it while you changed the subject. That is bad, because it breaks threading. Whenever you reply to a message, yo

[PHP] PHP/MySQL fatal error

2004-08-27 Thread gc
Hi all, I'm Gene Candelaria and I'm a PHP and MySQL newbie. I have a feeling a lot of you have seen this before. I'm teaching myself PHP/MySQL trying to setup a guestbook. I'm running latest versions of Apache, PHP and MySql on my WIN2k machine. I have them working, except

[PHP] MySql DATABASE creation date

2004-08-18 Thread Kevin
Is there any way to find out MySql DATABASE creation date using PHP and MySql functions? -- Kevin -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] PHP & MySQL Installation

2004-08-17 Thread Harlequin
Hi all. I'm probably biting off a little more than I can chew here but here goes... I've been asked to move some resources I have developed from our hosting company's server and host them locally. I know I am going to need a licence for MySQL as we are developing commercial applications and not pr

Re: [PHP] PHP/MySQL based webmail?

2004-08-11 Thread Justin Patrin
On Wed, 11 Aug 2004 18:25:34 -0700 (PDT), Hardik Doshi <[EMAIL PROTECTED]> wrote: > Hi Chris, > > Horde is little bit heavier than Squirrelmail. You can > buy a Zend acclerator to speed up the things. You can also get the free TurckMMCache to cache the parsed PHP files. > > I think your communi

Re: [PHP] PHP/MySQL based webmail?

2004-08-11 Thread Hardik Doshi
Hi Chris, Horde is little bit heavier than Squirrelmail. You can buy a Zend acclerator to speed up the things. I think your community is not that big and Horde works fine in our organization where we have 1000 users and all are pretty active. Look and feel matters in the web mail so before you

Re: [PHP] PHP/MySQL based webmail?

2004-08-11 Thread Robby Russell
On Wed, 2004-08-11 at 10:38, Justin Patrin wrote: > On Wed, 11 Aug 2004 10:15:00 -0700 (PDT), Matthew Sims > <[EMAIL PROTECTED]> wrote: > [snip] > > > > > > Yes. But both Squirrel and Horde must speak IMAP to the mail server, > > > whether on localhost or remote. IMAP's nontrivial and introduces

Re: [PHP] PHP/MySQL based webmail?

2004-08-11 Thread Justin Patrin
On Wed, 11 Aug 2004 10:15:00 -0700 (PDT), Matthew Sims <[EMAIL PROTECTED]> wrote: [snip] > > > > Yes. But both Squirrel and Horde must speak IMAP to the mail server, > > whether on localhost or remote. IMAP's nontrivial and introduces more > > load on the web app server than -- say -- a POP-based

Re: [PHP] PHP/MySQL based webmail?

2004-08-11 Thread Jason Wong
On Wednesday 11 August 2004 23:01, Chris Shenton wrote: > > IMAP doesn't HAVE to be on the same box. You can use SM to connect > > to an another server running your mail. > > Yes. But both Squirrel and Horde must speak IMAP to the mail server, > whether on localhost or remote. IMAP's nontrivial

Re: [PHP] PHP/MySQL based webmail?

2004-08-11 Thread Matthew Sims
This is probably getting a little offtopic (okay, a lot and my last for today) but I'll answer what I can. Now I can't speak for Horde but I can't see how Horde would be any different than what Squirrelmail provides. > "Matthew Sims" <[EMAIL PROTECTED]> writes: > >> Uh, well...Squirrelmail is simp

Re: [PHP] PHP/MySQL based webmail?

2004-08-11 Thread Chris Shenton
"Matthew Sims" <[EMAIL PROTECTED]> writes: > Uh, well...Squirrelmail is simply a webpage. The number of simultaneous > users is defined by the web server application, aka Apache. Perhaps we view it differently. Apache is a web server. SquirrelMail and Horde are applications, written in PHP. I'm

RE: [PHP] MySQL & PHP Examples & Training Providers Required

2004-08-11 Thread Jay Blanchard
[snip] I'm looking for some examples of sites that are purely MySQL and PHP running on Unix and that contain a few thousand records preferably held in relational databases. Rationale: I need to justify PHP as a tool of choice over say vb.net or Oracle. My recommendation, despite my limited knowle

Re: [PHP] MySQL & PHP Examples & Training Providers Required

2004-08-11 Thread Lester Caine
Robby Russell wrote: Not to start a SQL war, but have you consider PostgreSQL as well in your decisions? And how about Firebird, Oracle has roots from the same original development in the 1980's. -- Lester Caine - L.S.Caine Electronic Services -- PHP General Mailing Li

Re: [PHP] MySQL & PHP Examples & Training Providers Required

2004-08-10 Thread Robby Russell
Not to start a SQL war, but have you consider PostgreSQL as well in your decisions? PostgreSQL has more features that are more comparable to MSSQL and Oracle. Just making sure you make the right decision. ;-) -Robby On Tue, 2004-08-10 at 16:06, Harlequin wrote: > Hi all. > > This might sound l

[PHP] MySQL & PHP Examples & Training Providers Required

2004-08-10 Thread Harlequin
Hi all. This might sound like a strange request but here goes. I'm looking for some examples of sites that are purely MySQL and PHP running on Unix and that contain a few thousand records preferably held in relational databases. Rationale: I need to justify PHP as a tool of choice over say vb.n

Re: [PHP] PHP/MySQL based webmail?

2004-08-10 Thread Hardik Doshi
MIT is using the Horde web mail and so many other organizations are using the Horde web mail. I can't give you the numbers because i am not the one who is administrating this. We are a university and we have thousands of students so might imagine how better it scales. I personally dig into the Hor

Re: [PHP] PHP/MySQL based webmail?

2004-08-10 Thread raditha dissanayake
John W. Holmes wrote: From: "raditha dissanayake" <[EMAIL PROTECTED]> What has squirrelmail/horde scalability got to do with PHP? Is this the mantra of the PHP list, now? Come on... those are both programs written in PHP and discussing how better one is over the other is perfectly good traf

Re: [PHP] PHP/MySQL based webmail?

2004-08-10 Thread Matthew Sims
> Hardik Doshi <[EMAIL PROTECTED]> writes: > >> I strongly recommend Horde web mail. We are currently >> using it in our institute and it scales better. > > Better than what? Squirrelmail? > > Can you give us some numbers, like how many simultaneous > Horde/Squirrelmail users you can run on some nu

Re: [PHP] PHP/MySQL based webmail?

2004-08-10 Thread John W. Holmes
From: "raditha dissanayake" <[EMAIL PROTECTED]> > What has squirrelmail/horde scalability got to do with PHP? Is this the mantra of the PHP list, now? Come on... those are both programs written in PHP and discussing how better one is over the other is perfectly good traffic for this list. I'd be

Re: [PHP] PHP/MySQL based webmail?

2004-08-10 Thread raditha dissanayake
Chris Shenton wrote: Hardik Doshi <[EMAIL PROTECTED]> writes: I strongly recommend Horde web mail. We are currently using it in our institute and it scales better. Better than what? Squirrelmail? Can you give us some numbers, like how many simultaneous Horde/Squirrelmail users you can run o

Re: [PHP] PHP/MySQL based webmail?

2004-08-10 Thread Chris Shenton
Hardik Doshi <[EMAIL PROTECTED]> writes: > I strongly recommend Horde web mail. We are currently > using it in our institute and it scales better. Better than what? Squirrelmail? Can you give us some numbers, like how many simultaneous Horde/Squirrelmail users you can run on some number of speci

Re: [PHP] PHP/MySQL based webmail?

2004-08-09 Thread Hardik Doshi
I strongly recommend Horde web mail. We are currently using it in our institute and it scales better. Thanks, Hardik --- Matthew Sims <[EMAIL PROTECTED]> wrote: > > On Mon, 2004-08-09 at 14:28, Alex Shi wrote: > >> Hi All, > >> > >> Can any one recommen

Re: [PHP] PHP/MySQL based webmail?

2004-08-09 Thread Matthew Sims
> On Mon, 2004-08-09 at 14:28, Alex Shi wrote: >> Hi All, >> >> Can any one recommend a strong/stable PHP/MySQL based web >> mail system? It must support large mail transfer, some times may be >> more than 10 MB for a single message. >> >> Alex >

Re: [PHP] PHP/MySQL based webmail?

2004-08-09 Thread Robby Russell
On Mon, 2004-08-09 at 14:28, Alex Shi wrote: > Hi All, > > Can any one recommend a strong/stable PHP/MySQL based web > mail system? It must support large mail transfer, some times may be > more than 10 MB for a single message. > > Alex The message size limit is cont

[PHP] PHP/MySQL based webmail?

2004-08-09 Thread Alex Shi
Hi All, Can any one recommend a strong/stable PHP/MySQL based web mail system? It must support large mail transfer, some times may be more than 10 MB for a single message. Alex -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] mySQL SQL query

2004-08-06 Thread Brian Kell
On Thu, 5 Aug 2004 08:48:01 -0500, Jay Blanchard <[EMAIL PROTECTED]> wrote: [snip] [snip] A quickie for you: How do I say SELECT * FROM mytable where the sum of this field + this field + this field < x I can't say I've done one of those before. [/snip] How many SQL queries can a PHP list handle

Re: [PHP] MySQL Result Handling

2004-08-06 Thread Matthew Sims
> The one technique that I have a bit of a question about is realted to the > handling of MySQL results. It seems that when you query the database with > their system, it takes all the results and outputs them into a string > similar to: > > I have a question<:>I have an answer > > which is then in

[PHP] MySQL Result Handling

2004-08-06 Thread Jed R. Brubaker
Hi all! I have a quite a brain puzzler here that I would love to hear some people's feedback on. I have inherited a PHP system that is definately on the strange side. I am stuck with the situation of either adding to the beast, or simply reprogramming the entire site. The one technique that I hav

Re: [PHP] MySql Tables

2004-08-05 Thread John Nichel
On Thursday 05 August 2004 08:58, Jay Blanchard offered up the following tid-bit of information : > [snip] > How many records can be in a MyIsam table? > [/snip] > > Bazillions. Only limited by your storage capacity and ability to manage > large sets of records. Now wait a minute, my table hit a

Re: [PHP] MySql Tables

2004-08-05 Thread John Nichel
On Thursday 05 August 2004 08:51, DIFF FanneHH offered up the following tid-bit of information : > How many records can be in a MyIsam table? > Thanks I'm sure they could tell you on the MySQL mailing list. -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 [EMAIL PROTECTED] -- PHP General

Re: [PHP] Graphing Webstats using MRTG/PHP/MYSQL?

2004-08-02 Thread Fernando Gutierrez
see cacti: http://www.raxnet.net/products/cacti/ On Thu, 29 Jul 2004 14:03:08 +0800, Louie Miranda <[EMAIL PROTECTED]> wrote: > has anyone know any tools related to this? > > Graphing Webstats using MRTG/PHP/MYSQL? > > -- > Louie Miranda > http://www.axishift.com &g

RE: RE: [PHP] php mysql--mysqli persistent connections...

2004-07-30 Thread John Holmes
> i'm going to need to do transactional processing across > multiple pages for a test app. Not going to happen. That's not how persistant connections work and not what they are for. You'll need to come up with a different method. ---John Holmes... UCCASS - PHP Survey System http://www.bigred

RE: RE: [PHP] php mysql--mysqli persistent connections...

2004-07-30 Thread bruce
[EMAIL PROTECTED] Subject: Re: RE: [PHP] php mysql--mysqli persistent connections... > php/mysql supported persistent connections.. Have you ever used persistant connections. I don't think they work the way you are thinking. Persistant connections rarely had any benifit except in certai

Re: RE: [PHP] php mysql--mysqli persistent connections...

2004-07-30 Thread John Holmes
> php/mysql supported persistent connections.. Have you ever used persistant connections. I don't think they work the way you are thinking. Persistant connections rarely had any benifit except in certain server configurations. ---John Holmes... UCCASS - PHP Survey Sys

RE: [PHP] php mysql--mysqli persistent connections...

2004-07-30 Thread bruce
php/mysql supported persistent connections.. i had assumed that mysqli would as well it appears that it doesn't... -bruce -Original Message- From: John Holmes [mailto:[EMAIL PROTECTED] Sent: Friday, July 30, 2004 10:54 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re:

Re: [PHP] php mysql--mysqli persistent connections...

2004-07-30 Thread John Holmes
> without using persistent connections/transactional > processing, how is one > supposed to accomplish handling db transactions across > multiple pages..??? At what point was this ever allowed or even capable of being done? Are you saying you're doing this now? ---John Holmes... UCCASS - PHP Su

[PHP] php mysql--mysqli persistent connections...

2004-07-30 Thread bruce
hi.. in looking over mysqli/mysql constructs, i noticed that mysqli doesn't appear to support persistent connections. is this correct, did i miss something..??? without using persistent connections/transactional processing, how is one supposed to accomplish handling db transactions across multipl

Re: [PHP] Graphing Webstats using MRTG/PHP/MYSQL?

2004-07-29 Thread Louie Miranda
i was thingking more of php+mysql, then mrtg will get all the data from the sql or the php. something like that On Thu, 29 Jul 2004 10:50:09 +0300, Skippy <[EMAIL PROTECTED]> wrote: > Quoting Louie Miranda <[EMAIL PROTECTED]>: > > has anyone know any tools related to this?

Re: [PHP] Graphing Webstats using MRTG/PHP/MYSQL?

2004-07-29 Thread Skippy
Quoting Louie Miranda <[EMAIL PROTECTED]>: > has anyone know any tools related to this? > Graphing Webstats using MRTG/PHP/MYSQL? Why MRTG _and_ PHP? AFAIK MRTG produces its own HTML and images. You can either use MRTG with whatever data (webstats) you collected or you can use PHP+My

[PHP] Graphing Webstats using MRTG/PHP/MYSQL?

2004-07-28 Thread Louie Miranda
has anyone know any tools related to this? Graphing Webstats using MRTG/PHP/MYSQL? -- Louie Miranda http://www.axishift.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] mysql and mysqli

2004-07-27 Thread Marcus Bointon
I've got mysql 4.1.13 installed on RH EL 3 and I'm trying to build PHP5 against it with both mysql and mysqli extensions. It's quite happy to config and make with --with-mysql=/usr/local or --with-mysqli, but if I specify them both together (in either order), I get thousands of errors like this: /

Re: [PHP] PHP - mySQL query question

2004-07-25 Thread Jason Davidson
single quote 'y' Jason On Sun, 25 Jul 2004 11:05:23 -0400, Karl-Heinz Schulz <[EMAIL PROTECTED]> wrote: > I have a simple question (not for me). > > Why does this query does not work? > > $links_query = mysql_query("select id, inserted, title, information, > international from links WHE

Re: [PHP] PHP - mySQL query question

2004-07-25 Thread John W. Holmes
Karl-Heinz Schulz wrote: I have a simple question (not for me). Why does this query does not work? $links_query = mysql_query("select id, inserted, title, information, international from links WHERE international = y; order by inserted desc LIMIT 0 , 30"); The information for the "internati

[PHP] PHP - mySQL query question

2004-07-25 Thread Karl-Heinz Schulz
I have a simple question (not for me). Why does this query does not work? $links_query = mysql_query("select id, inserted, title, information, international from links WHERE international = y; order by inserted desc LIMIT 0 , 30"); The information for the "international" fields are: Fie

[PHP] mysql connection question

2004-07-15 Thread JOHN MEYER
Hi, For a long time, on all of my mysql pages, I've done something like this $conn = mysql_connect($server,$username,$password) or die("Could not connect") mysql_select_db($db); I've finally put that into its own script file, moved it to my include files, and simply included it whereever I neede

[PHP] [mysql]Problem with PHP5

2004-07-14 Thread Ciprian Constantinescu
I have installed PHP5 and i get the following error from a script that was working on PHP4 "Fatal error: Call to undefined function mysql_pconnect() in D:\htdocs\cdalex\Connections\listacon.php on line 9 " -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.ne

Re: [PHP] MySQL/PHP Tunneling

2004-07-11 Thread Karam Chand
Hello, Well, I know there are issues regarding this (security as well as others). But tools like MySQL-Front and DBTools are just doing that and it just happens that the project i am working on needed something like that, so I was just asking :) Regards, Karam --- Curt Zirzow <[EMAIL PROTECTED]>

Re: [PHP] MySQL/PHP Tunneling

2004-07-11 Thread Curt Zirzow
* Thus wrote Karam Chand: > --- Curt Zirzow <[EMAIL PROTECTED]> wrote: > > Now, many of the ISPs blokc 3306 for security reason > and you cannot access MySQL from a 3rd party tool and > have to use phpMyAdmin which is able to access the > MySQL server as it is running on the same box. > Sometimes,

Re: [PHP] MySQL/PHP Tunneling

2004-07-11 Thread Jason Wong
On Sunday 11 July 2004 13:07, Karam Chand wrote: > Sorry. But I just didnt remember the email addy so I > took that way :). Can't resist picking on this one. All posts to the list should/would have the list address in the To: header. It's not that hard to copy paste the address into a *new* mai

Re: [PHP] MySQL/PHP Tunneling

2004-07-10 Thread Karam Chand
--- Curt Zirzow <[EMAIL PROTECTED]> wrote: > > First off, when starting a new topic, don't reply to > message and > then change the topic. Sorry. But I just didnt remember the email addy so I took that way :). > > * Thus wrote Karam Chand: > > Hello, > > > > Recently lot of MySQL clients try t

Re: [PHP] mysql persistent connection...

2004-07-10 Thread Jason Wong
On Sunday 11 July 2004 10:03, bruce wrote: > i'm trying to get a better understanding of how to implement persistent > connections with mysql in either perl/php > > basically i'm trying to solve the issue of whether a web app has to > essentially perform a new mysql_connect on every page that's goi

[PHP] mysql persistent connection...

2004-07-10 Thread bruce
i'm trying to get a better understanding of how to implement persistent connections with mysql in either perl/php basically i'm trying to solve the issue of whether a web app has to essentially perform a new mysql_connect on every page that's going to be doing any database access. using mysql_con

Re: [PHP] mysql and session vars...

2004-07-10 Thread Jason Wong
On Sunday 11 July 2004 07:59, bruce wrote: > not sure what you mean by hijacking... FYI: You have started a new thread by taking an existing posting and replying to it while you changed the subject. That is bad, because it breaks threading. Whenever you reply to a message, your mail client gener

RE: [PHP] mysql and session vars...

2004-07-10 Thread bruce
e the session var in another page ideas/comments welcome.. thanks.. -bruce -Original Message- From: Marek Kilimajer [mailto:[EMAIL PROTECTED] Sent: Saturday, July 10, 2004 4:42 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [PHP] mysql and session vars... Please d

Re: [PHP] mysql and session vars...

2004-07-10 Thread Marek Kilimajer
s the connection more or less maintained throught the life of the app. You have to connect to mysql on every page, it's not possible to store the connection in session. That's how it works. an additional question. the resource identifier is required to initiate a given php mysql function. i would

RE: [PHP] mysql and session vars...

2004-07-10 Thread bruce
o: [EMAIL PROTECTED] Subject: [PHP] mysql and session vars... hi... if i create a site that hits a back mysql db... i don't want to do a mysql_connect for every page that has to access the db. so the question is where should the mysql_connect occur. also, if i were to do it once when the app

[PHP] mysql and session vars...

2004-07-10 Thread bruce
t the life of the app. an additional question. the resource identifier is required to initiate a given php mysql function. i would assume that the resource identifier should probably be stored in some session var searching mysql/php/google didn't result in clarfification for these issues...

Re: [PHP] MySQL/PHP Tunneling

2004-07-10 Thread Curt Zirzow
First off, when starting a new topic, don't reply to message and then change the topic. * Thus wrote Karam Chand: > Hello, > > Recently lot of MySQL clients try to overcome host > based privilege system of MySQL by using PHP tunneling > method. > > In this method they call up a PHP file in the

[PHP] MySQL/PHP Tunneling

2004-07-10 Thread Karam Chand
Hello, Recently lot of MySQL clients try to overcome host based privilege system of MySQL by using PHP tunneling method. In this method they call up a PHP file in the server and the PHP file executes a query and sends the data in XML format. I am using C API() and I was just wondering if somebo

Re: [PHP] MySQL Database Connection Question

2004-07-08 Thread John Nichel
Harlequin wrote: I have a user registration form that asks new users to register. However, Do I post the MySQLconnection string in the page they are completing or in the later page that the data is posted to, or both...? Not sure I follow what you're asking, but you only need to open a connection

Re: [PHP] MySQL Database Connection Question

2004-07-08 Thread James E Hicks III
On Thursday 08 July 2004 09:59 am, Harlequin wrote: > I have a user registration form that asks new users to register. However, > Do I post the MySQLconnection string in the page they are completing or in > the later page that the data is posted to, or both...? I don't think I understand your ques

[PHP] MySQL Database Connection Question

2004-07-08 Thread Harlequin
I have a user registration form that asks new users to register. However, Do I post the MySQLconnection string in the page they are completing or in the later page that the data is posted to, or both...? -- - Michael Mason Arras People www.arraspeople.co.uk

Re: [PHP] MySql DB access upon browser close

2004-07-06 Thread Eric Emminger
Hi Frank, I think you could use window.location="test.php?time=xxx" in the onUnload instead of opening a new window. Eric On Mon, 5 Jul 2004 14:08:14 -0400, Frank Voorburg <[EMAIL PROTECTED]> wrote: > Hi, > > Any help with the following is appreciated. I want to use php to store the > time t

<    9   10   11   12   13   14   15   16   17   18   >