php-general Digest 19 Oct 2006 18:44:58 -0000 Issue 4410

Thu, 19 Oct 2006 11:47:40 -0700 

php-general Digest 19 Oct 2006 18:44:58 -0000 Issue 4410

Topics (messages 243329 through 243359):

Re: Object-Oriented PHP Courses in the UK
        243329 by: Roman Neuhauser

Re: PHP 5.16 and Sihuson
        243330 by: Google Kreme

Re: What is the smallest, fastest web server to run PHP and SSL (on a soekris 
box)
        243331 by: Google Kreme

Problems with open_basedir
        243332 by: Patrik Jansson
        243347 by: Colin Guthrie

Re: How to recognise url in a block of text
        243333 by: Robin Vickery

Re: Creating thumbnails using Image Functions, then saving to folders
        243334 by: Al
        243356 by: Børge Holen

regex
        243335 by: Bagus Nugroho
        243336 by: John Nichel
        243338 by: Google Kreme
        243339 by: Google Kreme
        243340 by: Stut
        243346 by: Robin Vickery

Creating Tree Structure from associative array
        243337 by: Angelo Zanetti
        243348 by: Roman Neuhauser

IMAP extension causing delays
        243341 by: Edward Kay
        243342 by: Jochem Maas
        243343 by: John Nichel
        243344 by: Edward Kay
        243345 by: John Nichel
        243349 by: Edward Kay

worst sites / standard format
        243350 by: Chuck Stearns
        243351 by: Ed Lazor
        243352 by: Skip Evans
        243353 by: Chuck Stearns

Creating new table from distinct entries
        243354 by: Alan Milnes
        243358 by: Ed Lazor

Telemarketing Script/Tracking Application
        243355 by: Jay Blanchard
        243357 by: Curt Zirzow

User question for PHP
        243359 by: Tom Ray [Lists]

Administrivia:

To subscribe to the digest, e-mail:
        [EMAIL PROTECTED]

To unsubscribe from the digest, e-mail:
        [EMAIL PROTECTED]

To post to the list, e-mail:
        php-general@lists.php.net


----------------------------------------------------------------------
--- Begin Message --- 
# [EMAIL PROTECTED] / 2006-10-18 16:28:04 +0100:
> I'm relatively new to object-oriented PHP.  I'm loving things like 
> Symfony and Smarty etc but really need a little more guidance!
> 
> Does anyone know of a good object-oriented PHP course
> available in the UK?
> 
> Perhaps something my company could send me on or I could
> do in the evenings.

    Does self study count as a course? :)

    I can recommend the following books:
    
    - Design Patterns, Gamma, Johnson, Vlissides, Helm
    - Refactoring, Fowler
    - Patterns of Enterprise Application Architecture, Fowler
    - Test-Driven Developmnet By Example, Beck

-- 
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man.  You don't KNOW.
Cause you weren't THERE.             http://bash.org/?255991

--- End Message ---
--- Begin Message --- 
On 19 Oct 2006, at 02:30 , Roman Neuhauser wrote:

# [EMAIL PROTECTED] / 2006-10-18 10:57:52 -0600:

php -v
PHP 5.1.6 with Suhosin-Patch 0.9.5 (cli) (built: Oct 18 2006 08:36:59) 
Copyright (c) 1997-2006 The PHP Group
Zend Engine v2.1.0, Copyright (c) 1998-2006 Zend Technologies


    The Suhosin patch only reports the double free() in PHP so if
    anything it's PHP that's not ready for production. You can disable
    the patch but that won't fix the bug in PHP.


I've been told the problem is the Zend Engine.


--
No one ever thinks of themselves as one of Them. We're always one of Us. It's Them that do the bad things.
--- End Message ---
--- Begin Message --- 
On 18 Oct 2006, at 17:25 , Daevid Vincent wrote:
I need to run a httpd server that can serve up PHP, SQL Lite, and SSL on a 
little Soekris box (ie. a 486 with 32MB RAM and 32MB CF storage).
There's thttp which is really really small. However, keep in mind, Apache has been around for long enugh that at one time a 486 with 32MB of RAm was state of the art. 


How small can Apache get?
Pretty darn small. You might find SSL is larger, and certainly SQL Lite will have more of an impact.
I'd try it with apache with as much disabled as possible. You're going to find better support tools for apache anyway. However, the 'throttling' aspect of thttp might be useful in a low-resource setting. 


Related, does anyone know of a tutorial or something that will help to
reduce Apache to only the things really needed for PHP, mySQL, SSL? Right 
now, our Apache memory footprint is an astounding 120MB !!
How are you counting that? If you've only got 32MB it CAN'T be using 120MB. Unless you are counting VRAM, which is a mistake. 


--
We will fight for Bovine Freedom and hold our large heads high
We will run free with the Buffalo or die

--- End Message ---
--- Begin Message --- 
Hello,
I'm having some difficulties with open_basedir. If I include the prefix /home/web25637/ in open_basedir shouldn't it include every directory within this? We're getting this error:
Warning: file_exists() [function.file-exists]: open_basedir restriction in effect. File(/home/web25637/domains/abc.ssf.scout.se/public_html//components/com_sef/sef.php) is not within the allowed path(s): (/home/web25637/:/tmp/:/var/www/:/usr/local/lib/php/:/etc/virtual/:/var/uploads/:/var/squirrelmail) in /usr/home/web25637/domains/abc.ssf.scout.se/public_html/index.php on line 46
As you can se, the file is within the prefix which is listed in allowed paths. How could it be the case that we're experiencing open_basedir restriction here? 

Cheers,
Patrik

--- End Message ---
--- Begin Message --- 
Patrik Jansson wrote:
> Hello,
> I'm having some difficulties with open_basedir. If I include the prefix
> /home/web25637/ in open_basedir shouldn't it include every directory
> within this? We're getting this error:
> 
> Warning: file_exists() [function.file-exists]: open_basedir restriction
> in effect.
> File(/home/web25637/domains/abc.ssf.scout.se/public_html//components/com_sef/sef.php)
> is not within the allowed path(s):
> (/home/web25637/:/tmp/:/var/www/:/usr/local/lib/php/:/etc/virtual/:/var/uploads/:/var/squirrelmail)
> in /usr/home/web25637/domains/abc.ssf.scout.se/public_html/index.php on
> line 46
> 
> As you can se, the file is within the prefix which is listed in allowed
> paths. How could it be the case that we're experiencing open_basedir
> restriction here?

I ran into problems with openbase_dir when using symlinks... They only
really reared their ugly head when I upgraded to 5.1.6 before that they
were OK (tho' if memory serves I had to add both the symlink location
and the directory it pointed to.

Anyway, are symlinks to blame here?

Other than that I don't really know.

Col.

--- End Message ---
--- Begin Message --- 
On 18/10/06, AYSERVE.NET <[EMAIL PROTECTED]> wrote:

Hello Guys,
I thought I was home and dry when the program worked fine on my windows
but when I ran from my Linus server, I keep getting a url like:
http://www.website.com/pdf/ED1.pdf%A0 instead of
http://www.website.com/pdf/ED1.pdf.


I'd look at the text that you're working on rather than the regexp. It
looks like some characterset conversion is going wrong - 0xA0 is the
latin-1 non-breaking space character. I'm expect that on your linux
machine that it's being converted to %0A at some point which is
perfectly valid in a URL.

But I'm just guessing.

-robin

--- End Message ---
--- Begin Message --- 
Børge Holen wrote:

On Wednesday 18 October 2006 20:55, Al wrote:

Matthews, Chris wrote:

Good Morning:

I am looking to create a thumbnail from an uploaded image, and then save
it to a directory.

I don't have any problem with the image functions, and can successfully
create the thumbnail and push it to the browser or, as is currently set
up, store the data in a database.

What I want to do instead, however, is take that dynamically created
thumbnail and write it to a folder on the server.

If I simply write the file, however, it appears I need to have a folder
chmod'd world read/writable for the process to work.  My network guys do
not want this.

I tried the FTP functions, which work great for copying a file that
already exists somewhere into another folder, but I can't seem to get it
to recognize the buffer as a valid source file location...

Is there a way to use a php FTP function to FTP the file out of the
buffer to a directory on the server, or some other way to write a file to
a folder without making that folder 0777?

Chris Matthews
eGovernment Information Officer
Washoe County, Nevada
775.328.3719
http://www.washoecounty.us

Director, West Region
National Association of Government Webmasters
http://www.nagw.org

Have your program create the folder and assign it 754 or 755, don't create
it via Apache. Thus, the owner will be the famous "nobody".  The 754 means
nobody [your program] has full rights; but the world only has reading
rights.  You'll see all your standard folders created by the system are
755, which is safe also.


and how do apache create directories again?


With tomahawks and bows and arrows.

Some folks make dumb mistakes occasionally especially when in a hurry.

However, the approach of having the script create the folders with 755 or 754 
is correct. Is it not?

--- End Message ---
--- Begin Message --- 
On Thursday 19 October 2006 14:47, Al wrote:
> Børge Holen wrote:
> > On Wednesday 18 October 2006 20:55, Al wrote:
> >> Matthews, Chris wrote:
> >>> Good Morning:
> >>>
> >>> I am looking to create a thumbnail from an uploaded image, and then
> >>> save it to a directory.
> >>>
> >>> I don't have any problem with the image functions, and can successfully
> >>> create the thumbnail and push it to the browser or, as is currently set
> >>> up, store the data in a database.
> >>>
> >>> What I want to do instead, however, is take that dynamically created
> >>> thumbnail and write it to a folder on the server.
> >>>
> >>> If I simply write the file, however, it appears I need to have a folder
> >>> chmod'd world read/writable for the process to work.  My network guys
> >>> do not want this.
> >>>
> >>> I tried the FTP functions, which work great for copying a file that
> >>> already exists somewhere into another folder, but I can't seem to get
> >>> it to recognize the buffer as a valid source file location...
> >>>
> >>> Is there a way to use a php FTP function to FTP the file out of the
> >>> buffer to a directory on the server, or some other way to write a file
> >>> to a folder without making that folder 0777?
> >>>
> >>> Chris Matthews
> >>> eGovernment Information Officer
> >>> Washoe County, Nevada
> >>> 775.328.3719
> >>> http://www.washoecounty.us
> >>>
> >>> Director, West Region
> >>> National Association of Government Webmasters
> >>> http://www.nagw.org
> >>
> >> Have your program create the folder and assign it 754 or 755, don't
> >> create it via Apache. Thus, the owner will be the famous "nobody".  The
> >> 754 means nobody [your program] has full rights; but the world only has
> >> reading rights.  You'll see all your standard folders created by the
> >> system are 755, which is safe also.
> >
> > and how do apache create directories again?
>
> With tomahawks and bows and arrows.
>
> Some folks make dumb mistakes occasionally especially when in a hurry.
>
> However, the approach of having the script create the folders with 755 or
> 754 is correct. Is it not?

Yes, "user" is then set as the "apache user" witch in my case works 
flawlessly. all rights to apache. 
These directories on the other hand is the only writable directories on my 
servers together with /tmp.

-- 
---
Børge
Kennel Arivene 
http://www.arivene.net
---

--- End Message ---
--- Begin Message --- 
Hi All,

If we have variable like :

$var1 = 'abcde 12';
$var2 = 'abcdefghi 34';
$var3 = 'abc 20 def';

Then we want output like :
$var1 = 'abcde';
$var2 = 'abcdefghi';
$var3 = 'abc def';

How regex can help us?.

Thanks in advance.
bgs

--- End Message ---
--- Begin Message --- 
Bagus Nugroho wrote:

Hi All,

If we have variable like :

$var1 = 'abcde 12';
$var2 = 'abcdefghi 34';
$var3 = 'abc 20 def';

Then we want output like :
$var1 = 'abcde';
$var2 = 'abcdefghi';
$var3 = 'abc def';

How regex can help us?.



Use preg_replace to replace all numbers with nothing.

$var = preg_replace ( "/\d+/", "", $var );

--
John C. Nichel IV
Programmer/System Admin (ÜberGeek)
Dot Com Holdings of Buffalo
716.856.9675
[EMAIL PROTECTED]

--- End Message ---
--- Begin Message --- 
On 19 Oct 2006, at 07:49 , Bagus Nugroho wrote:


Hi All,

If we have variable like :

$var1 = 'abcde 12';
$var2 = 'abcdefghi 34';
$var3 = 'abc 20 def';

Then we want output like :
$var1 = 'abcde';
$var2 = 'abcdefghi';
$var3 = 'abc def';

How regex can help us?.


Well, stripping the digits is easy

s/ \d+//
(have that space before the number if there will ALWAYS be a space before the nu,bers you want to remove. 


--
You try to shape the world to what you want the world to be. Carving your name a thousand times won't bring you back to me. Oh no, no I might as well go and tell it to the trees. Go and tell it to the trees, yeah.
--- End Message ---
--- Begin Message --- 
On 19 Oct 2006, at 07:56 , John Nichel wrote:

$var3 = 'abc 20 def';
Then we want output like :
$var3 = 'abc def';
How regex can help us?.


Use preg_replace to replace all numbers with nothing.

$var = preg_replace ( "/\d+/", "", $var );


Nope, that will leave

$var3 = 'abc  def';

(note the double space)

it will also leave $var1 = 'abcdef ';


--
The trouble with being a god is that you've got no one to pray to.

--- End Message ---
--- Begin Message --- 
Bagus Nugroho wrote:

If we have variable like :

$var1 = 'abcde 12';
$var2 = 'abcdefghi 34';
$var3 = 'abc 20 def';

Then we want output like :
$var1 = 'abcde';
$var2 = 'abcdefghi';
$var3 = 'abc def';

How regex can help us?.
It's very difficult to get the right solution to a problem when all you provide is examples. If you want accurate help please provide an accurate description of the problem you're trying to solve rather than a few before and afters. 

-Stut

--- End Message ---
--- Begin Message --- 
On 19/10/06, Bagus Nugroho <[EMAIL PROTECTED]> wrote:

Hi All,

If we have variable like :

$var1 = 'abcde 12';
$var2 = 'abcdefghi 34';
$var3 = 'abc 20 def';

Then we want output like :
$var1 = 'abcde';
$var2 = 'abcdefghi';
$var3 = 'abc def';



$re = '/^\s+|\d+\s*|\s*\d+\s*$/';

$var1 = preg_replace($re, '', $var1);

It may or may not be what you're after, but it handles all your examples.

-robin

--- End Message ---
--- Begin Message --- 
Hi all,
I have an associative array, which contains parent and child relationships. I've searched the web for creating a tree structure from this and found a few good sites but doesnt help 100% perhaps someone can point me in the correct direction? I've started to code it got to a point where I cant go any further, the code is pseudo code and dont want to reinvent the wheel. 

any suggestions would be really appreciated.

Thanks in advance

--
------------------------------------------------------------------------
Angelo Zanetti
Systems developer
------------------------------------------------------------------------

*Telephone:* +27 (021) 469 1052
*Mobile:*       +27 (0) 72 441 3355
*Fax:*            +27 (0) 86 681 5885
*
Web:* http://www.zlogic.co.za
*E-Mail:* [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>

--- End Message ---
--- Begin Message --- 
# [EMAIL PROTECTED] / 2006-10-19 16:08:58 +0200:
> Hi all,
> 
> I have an associative array, which contains parent and child 
> relationships. I've searched the web for creating a tree structure from 
> this and found a few good sites but doesnt help 100% perhaps someone can 
> point me in the correct direction? I've started to code it got to a 
> point where I cant go any further, the code is pseudo code and dont want 
> to reinvent the wheel.
> 
> any suggestions would be really appreciated.

    I don't think there's any graph-manipulation library for PHP
    (there's a bit of addEdge(), addNode() stuff in Image_GraphViz[1]
    but it doesn't seem useful). Until someone wraps Agraph or
    Boost.Graph in a module: check out Iterator, Builder, and Composite
    in Design Patterns[2].

    [1] http://pear.php.net/package/Image_GraphViz
    [2] http://www.amazon.com/dp/0201633612

-- 
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man.  You don't KNOW.
Cause you weren't THERE.             http://bash.org/?255991

--- End Message ---
--- Begin Message --- 
Hello,

I need PHP's IMAP extension for my web app but it is really slowing my 
server up.

My setup: Fedora Core 5, Apache 2.2.2, PHP 5.1.4 (run as CGI with suPHP), 
PHP IMAP extension - all standard FC5 RPMs. The test page is simple - just a 
call to phpinfo().

Without the IMAP extension, the response time is almost immediate. With the 
IMAP extension it takes 2-3 seconds to respond - sometimes as much as 4 
secs.

Watching with 'top', I can see php-cgi is called immediately when the 
request is received. With the IMAP extension installed, after php-cgi 
starts, it then drops to the end of the 'top' list, consuming 0% CPU and 
2.0% memory. It remains there for the 2-3 second delay before coming into 
play again an running the script quickly. Without the IMAP extension, it 
just ends quickly having finished the request.

>From this, it is clear to me there is some major delay being introduced by 
the loading of the IMAP extension. Any ideas on how to resolve this?

Thanks,
Edward

--- End Message ---
--- Begin Message --- 
Edward Kay wrote:
> Hello,
> 
> I need PHP's IMAP extension for my web app but it is really slowing my 
> server up.
> 
> My setup: Fedora Core 5, Apache 2.2.2, PHP 5.1.4 (run as CGI with suPHP), 
> PHP IMAP extension - all standard FC5 RPMs. The test page is simple - just a 
> call to phpinfo().
> 
> Without the IMAP extension, the response time is almost immediate. With the 
> IMAP extension it takes 2-3 seconds to respond - sometimes as much as 4 
> secs.
> 
> Watching with 'top', I can see php-cgi is called immediately when the 
> request is received. With the IMAP extension installed, after php-cgi 
> starts, it then drops to the end of the 'top' list, consuming 0% CPU and 
> 2.0% memory. It remains there for the 2-3 second delay before coming into 
> play again an running the script quickly. Without the IMAP extension, it 
> just ends quickly having finished the request.
> 
> From this, it is clear to me there is some major delay being introduced by 
> the loading of the IMAP extension. Any ideas on how to resolve this?

use php as an apache module - thereby the startup delay is only noticed when
the webserver starts - this assumes that the problem is a startup problem ...

what you describe could be down to a dns configuration error - i.e. the imap 
extension
is trying to resolve some domainname and having a hard time of it.... I can't 
remember
the specifics of such issues but I know that the archives of this list will 
turn up more info
regarding dns config problems (that cause slow downs)

> 
> Thanks,
> Edward 
>

--- End Message ---
--- Begin Message --- 
Edward Kay wrote:

Hello,
I need PHP's IMAP extension for my web app but it is really slowing my server up.
My setup: Fedora Core 5, Apache 2.2.2, PHP 5.1.4 (run as CGI with suPHP), PHP IMAP extension - all standard FC5 RPMs. The test page is simple - just a call to phpinfo().
Without the IMAP extension, the response time is almost immediate. With the IMAP extension it takes 2-3 seconds to respond - sometimes as much as 4 secs.
Watching with 'top', I can see php-cgi is called immediately when the request is received. With the IMAP extension installed, after php-cgi starts, it then drops to the end of the 'top' list, consuming 0% CPU and 2.0% memory. It remains there for the 2-3 second delay before coming into play again an running the script quickly. Without the IMAP extension, it just ends quickly having finished the request.
From this, it is clear to me there is some major delay being introduced by 
the loading of the IMAP extension. Any ideas on how to resolve this?



If you don't have to, don't run it as a cgi.
A /possible/ solution, and I don't even know if it's possible, is to compile two versions of the cgi; one with and one without. While I know that part is at least possible, I don't know if you can make your webserver *choose* which version of the cgi to run depending on the need.
Can the cgi in PHP5 dynamically load modules? dl() is available in PHP4, but I think they got rid of it in PHP5 

--
John C. Nichel IV
Programmer/System Admin (ÜberGeek)
Dot Com Holdings of Buffalo
716.856.9675
[EMAIL PROTECTED]

--- End Message ---
--- Begin Message --- 
> >
> > From this, it is clear to me there is some major delay being
> introduced by
> > the loading of the IMAP extension. Any ideas on how to resolve this?
>
> use php as an apache module - thereby the startup delay is only
> noticed when
> the webserver starts - this assumes that the problem is a startup
> problem ...

No can do. I need to run my PHP scripts as different users and to interact
with the file system.

> what you describe could be down to a dns configuration error -
> i.e. the imap extension
> is trying to resolve some domainname and having a hard time of
> it.... I can't remember
> the specifics of such issues but I know that the archives of this
> list will turn up more info
> regarding dns config problems (that cause slow downs)

This sounds very plausible. It certainly seems as if the delay is due to a
timeout or similar. I'll see what I can find on this in the archives.

Thanks!

--- End Message ---
--- Begin Message --- 
Edward Kay wrote:

From this, it is clear to me there is some major delay being

introduced by

the loading of the IMAP extension. Any ideas on how to resolve this?

use php as an apache module - thereby the startup delay is only
noticed when
the webserver starts - this assumes that the problem is a startup
problem ...


No can do. I need to run my PHP scripts as different users and to interact
with the file system.
You can still do this running php as a module. Just enable suexec in Apache (and configure it safely of course). 

--
John C. Nichel IV
Programmer/System Admin (ÜberGeek)
Dot Com Holdings of Buffalo
716.856.9675
[EMAIL PROTECTED]

--- End Message ---
--- Begin Message --- 
Thanks for your suggestions John. At the moment, I do need to run it as a
CGI as I need different php.ini files for each virtual host.

I think there may well be some issues with DNS, as suggested by Jochem. My
configuration of DNS stuff locally is a bit patchy :) I'll investigate this
avenue first...

>
> If you don't have to, don't run it as a cgi.
>
> A /possible/ solution, and I don't even know if it's possible, is to
> compile two versions of the cgi; one with and one without.  While I know
> that part is at least possible, I don't know if you can make your
> webserver *choose* which version of the cgi to run depending on the need.
>
> Can the cgi in PHP5 dynamically load modules?  dl() is available in
> PHP4, but I think they got rid of it in PHP5
>
> --
> John C. Nichel IV
> Programmer/System Admin (ÜberGeek)
> Dot Com Holdings of Buffalo
> 716.856.9675
> [EMAIL PROTECTED]
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>

--- End Message ---
--- Begin Message --- 
hey, check out the bar on the side of the ones with main.html.

http://www.997thelake.com/main.html
http://www.cool929fm.com/main.html
http://www.star933.com/
http://www.wzzo.com/main.html
http://www.929nin.com/main.html
guess we have our work cut out for us, eh? we need to find a distinct, unarguable value for this product, and i believe that it's the fact that the link redistributes to amazon, whereas there is a greater value if they can sell the songs themselves. 

problem is, what agreement dot hey have with amazon?

anyway, that's what i found.

later

/cs

--- End Message ---
--- Begin Message --- Sorry, how does this relate to PHP? It seems like you're just trying to get us to visit your sites to bump up traffic. 


On Oct 19, 2006, at 8:44 AM, Chuck Stearns wrote:


hey, check out the bar on the side of the ones with main.html.

http://www.997thelake.com/main.html
http://www.cool929fm.com/main.html
http://www.star933.com/
http://www.wzzo.com/main.html
http://www.929nin.com/main.html
guess we have our work cut out for us, eh? we need to find a distinct, unarguable value for this product, and i believe that it's the fact that the link redistributes to amazon, whereas there is a greater value if they can sell the songs themselves. 

problem is, what agreement dot hey have with amazon?

anyway, that's what i found.

later

/cs

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--- End Message ---
--- Begin Message --- Me thinks Chuckie boy here is spamming our list and needs to get booted.
Sorry, Chuckie, only the best tasting tuna get to be Starkist. 

Skip

Ed Lazor wrote:
Sorry, how does this relate to PHP? It seems like you're just trying to get us to visit your sites to bump up traffic. 


On Oct 19, 2006, at 8:44 AM, Chuck Stearns wrote:


hey, check out the bar on the side of the ones with main.html.

http://www.997thelake.com/main.html
http://www.cool929fm.com/main.html
http://www.star933.com/
http://www.wzzo.com/main.html
http://www.929nin.com/main.html
guess we have our work cut out for us, eh? we need to find a distinct, unarguable value for this product, and i believe that it's the fact that the link redistributes to amazon, whereas there is a greater value if they can sell the songs themselves. 

problem is, what agreement dot hey have with amazon?

anyway, that's what i found.

later

/cs

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php





--
Skip Evans
Big Sky Penguin, LLC
61 W Broadway
Butte, Montana 59701
406-782-2240

--- End Message ---
--- Begin Message --- shoot, sorry guys, i was working on an email to a buddy, and didn't realize i was still on my newsgroup program til it was too late... won't happen again... 

/cs

Skip Evans wrote:

Me thinks Chuckie boy here is spamming our list and needs to get booted.

Sorry, Chuckie, only the best tasting tuna get to be Starkist.

Skip

Ed Lazor wrote:
Sorry, how does this relate to PHP? It seems like you're just trying to get us to visit your sites to bump up traffic. 


On Oct 19, 2006, at 8:44 AM, Chuck Stearns wrote:


hey, check out the bar on the side of the ones with main.html.

http://www.997thelake.com/main.html
http://www.cool929fm.com/main.html
http://www.star933.com/
http://www.wzzo.com/main.html
http://www.929nin.com/main.html
guess we have our work cut out for us, eh? we need to find a distinct, unarguable value for this product, and i believe that it's the fact that the link redistributes to amazon, whereas there is a greater value if they can sell the songs themselves. 

problem is, what agreement dot hey have with amazon?

anyway, that's what i found.

later

/cs

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--- End Message ---
--- Begin Message --- 
PHP 4.4.4
MySQL 4.1.21-community-nt
I have a table in my database that has a Primary key on 2 fields (MyID and MyChange) and a field that indicates if there is a problem with the record (MyError)- I want to create a new table that only has unique MyIDs and where there is more than 1 I only want the record with the highest MyChange number. The table has about 50 fields so I have the following code:-
$myquery="CREATE TABLE mystats SELECT *, DISTINCT MyID FROM oldstats WHERE MyError IS NULL ORDER BY MyChange DESC ;"; 
$myresult = mysql_query($myquery);

but I am getting an MySQL error #1064.

Any ideas or suggestions as to where I am going wrong?

Alan

--- End Message ---
--- Begin Message --- This is definitely something you'll want to run by the MySQL mailing list. 



On Oct 19, 2006, at 10:02 AM, Alan Milnes wrote:


PHP 4.4.4
MySQL 4.1.21-community-nt
I have a table in my database that has a Primary key on 2 fields (MyID and MyChange) and a field that indicates if there is a problem with the record (MyError)- I want to create a new table that only has unique MyIDs and where there is more than 1 I only want the record with the highest MyChange number. The table has about 50 fields so I have the following code:-
$myquery="CREATE TABLE mystats SELECT *, DISTINCT MyID FROM oldstats WHERE MyError IS NULL ORDER BY MyChange DESC ;"; 
$myresult = mysql_query($myquery);

but I am getting an MySQL error #1064.

Any ideas or suggestions as to where I am going wrong?

Alan

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--- End Message ---
--- Begin Message --- 
Is anyone aware of a PHP/MySQL app that would be used by telemarketing
staff to track calls, do follow-ups, allow scripting, etc.? We could
write something in house but we are pressed for time. I have been poking
around the web this morning, but have not found much.

TVMIA!

--- End Message ---
--- Begin Message --- 
On 10/19/06, Jay Blanchard <[EMAIL PROTECTED]> wrote:

Is anyone aware of a PHP/MySQL app that would be used by telemarketing
staff to track calls, do follow-ups, allow scripting, etc.? We could
write something in house but we are pressed for time. I have been poking
around the web this morning, but have not found much.

TVMIA!


Something like a CRM, the best ones cost some money like SugarCRM.

Curt.

--- End Message ---
--- Begin Message --- Is it possible to have a PHP script execute as the user of the domain instead of the webserver? So when I upload files through a PHP script they are owned by me and not "wwwrun" or "nobody"?
--- End Message ---

Reply via email to