php-windows Digest 11 May 2010 09:08:55 -0000 Issue 3807
Topics (messages 30084 through 30089):
Re: older windows binaries
30084 by: Pierre Joye
30087 by: Tomasz Krawczyk
30088 by: Pierre Joye
30089 by: Richard Quadling
Re: Appending one MySQL file to another without duplicates.
30085 by: Bill Mudry
30086 by: Bill Mudry
Administrivia:
To subscribe to the digest, e-mail:
php-windows-digest-subscr...@lists.php.net
To unsubscribe from the digest, e-mail:
php-windows-digest-unsubscr...@lists.php.net
To post to the list, e-mail:
php-wind...@lists.php.net
----------------------------------------------------------------------
--- Begin Message ---
hi,
http://windows.php.net/downloads/releases/archives/
Cheers,
2010/5/10 Tomasz Krawczyk <tomkr...@gmail.com>:
> Hi!
>
> Where could I find older versions of PHP binaries?
>
> The page http://windows.php.net/download/ contains 5.3.2 and 5.2.13
> binaries. The Page http://www.php.net/releases/ does not contain 5.3.1,
> 5.3.0 binaries but only sources. Binaries of older versions of 5.2 branch
> are still available on http://www.php.net/releases/ page.
>
> I need official binaries without installer. VC6 and VC9 if it is possible.
> Does anyone can help me?
>
> --
> regards
> Tomek
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
Pierre
@pierrejoye | http://blog.thepimp.net | http://www.libgd.org
--- End Message ---
--- Begin Message ---
Pierre Joye pisze:
hi,
http://windows.php.net/downloads/releases/archives/
Cheers,
Thanks!
Is there any plan to add that archive to the download page? Or maybe a
plan to add the archive to the menu of the windows.php.net site?
--
regards
Tomek
--- End Message ---
--- Begin Message ---
hi,
I did not plan to add a specific page for the old releases. But if
someone has some spare time and like to do it, I will proudly commit
his patch :)
Cheers,
On Mon, May 10, 2010 at 11:44 PM, Tomasz Krawczyk <tomkr...@gmail.com> wrote:
> Pierre Joye pisze:
>
>> hi,
>>
>> http://windows.php.net/downloads/releases/archives/
>>
>> Cheers,
>
> Thanks!
>
> Is there any plan to add that archive to the download page? Or maybe a plan
> to add the archive to the menu of the windows.php.net site?
>
> --
> regards
> Tomek
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
Pierre
@pierrejoye | http://blog.thepimp.net | http://www.libgd.org
--- End Message ---
--- Begin Message ---
On 10 May 2010 23:45, Pierre Joye <pierre....@gmail.com> wrote:
> hi,
>
> I did not plan to add a specific page for the old releases. But if
> someone has some spare time and like to do it, I will proudly commit
> his patch :)
>
> Cheers,
>
> On Mon, May 10, 2010 at 11:44 PM, Tomasz Krawczyk <tomkr...@gmail.com> wrote:
>> Pierre Joye pisze:
>>
>>> hi,
>>>
>>> http://windows.php.net/downloads/releases/archives/
>>>
>>> Cheers,
>>
>> Thanks!
>>
>> Is there any plan to add that archive to the download page? Or maybe a plan
>> to add the archive to the menu of the windows.php.net site?
>>
>> --
>> regards
>> Tomek
>>
>> --
>> PHP Windows Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>
>
>
>
> --
> Pierre
>
> @pierrejoye | http://blog.thepimp.net | http://www.libgd.org
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
Is there any code that moves a live version to the archives?
Generating/preserving the sha1 hashes would be nice.
I know there was a RM tool. Is this anywhere near production yet?
--
-----
Richard Quadling
"Standing on the shoulders of some very clever giants!"
EE : http://www.experts-exchange.com/M_248814.html
EE4Free : http://www.experts-exchange.com/becomeAnExpert.jsp
Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498&r=213474731
ZOPA : http://uk.zopa.com/member/RQuadling
--- End Message ---
--- Begin Message ---
On Mon, May 10, 2010 at 7:03 AM, Bill Mudry
<<mailto:billmu...@rogers.com>billmu...@rogers.com> wrote:
I have seen many examples of just getting rid of
duplicate records all in the same file.
However, I need to know how to append one MySQL
table into another table without
adding duplicate records into the original file accepting the data.
I ran the following script that successfully
appended data from what I called the "tervuren_target"
table into the file that drives the species level
of my botanical wood tree, named
"species_master".
..................................................................................................................................................................................
INSERT INTO species_master (genera, name,
species_name, authorities, species_source)
SELECT genera, name, species_name, authorities,
species_source FROM 'tervuren_target'
WHERE tervuren_target.species_name != species_master.species_name;
..................................................................................................................................................................................
The last line was an attempt to avoid carrying
over duplicates from the Tervuren file into the species file
but an error said that it did not recognize species_master.species_name.
You didn't used the species_master table in you
select query, hence the mysql couldn't understand it.
Â
So, I tried putting single
quotes as 'species_master.species_name'. The
program now ran without errors and appended records
for a total of 17,685 combined records.
If you put it into quotes, the it will used as a
string, not a reference to a field.
Please correct me if I'm wrong:
You have this tervuren_target and you have to
copy every record which doesn't exists in the species_master
INSERT INTO species_master (genera, name,
species_name, authorities, species_source)
SELECT DISTINCT genera, name, species_name,
authorities, species_source FROM 'tervuren_target'
LEFT JOIN species_master
ON
tervuren_target.species_name = species_master.species_name
WHERE species_master.species_name IS NULL
Basically: we select all of the records from
tervuren_target, link with each record from
tervuren_target to species_master through the
species_name, we select only the records, where
this link is not exists
(species_master.species_name IS NULL, so we don't
have records with this species_name), to be sure, I added a DISTINCT.
Maybe you have to tweak the query a littbe bit,
because mysql is a little bit tricky, it doesnt
allow by default to insert into a row, which is
used in  the same statement as source, but with
table alias you can workaround that, or you can use a third table.
Tyrael
--- End Message ---
--- Begin Message ---
On Mon, May 10, 2010 at 7:03 AM, Bill Mudry
<<mailto:billmu...@rogers.com>billmu...@rogers.com> wrote:
I have seen many examples of just getting rid of
duplicate records all in the same file.
However, I need to know how to append one MySQL
table into another table without
adding duplicate records into the original file accepting the data.
I ran the following script that successfully
appended data from what I called the "tervuren_target"
table into the file that drives the species level
of my botanical wood tree, named
"species_master".
..................................................................................................................................................................................
INSERT INTO species_master (genera, name,
species_name, authorities, species_source)
SELECT genera, name, species_name, authorities,
species_source FROM 'tervuren_target'
WHERE tervuren_target.species_name != species_master.species_name;
..................................................................................................................................................................................
The last line was an attempt to avoid carrying
over duplicates from the Tervuren file into the species file
but an error said that it did not recognize species_master.species_name.
You didn't used the species_master table in you
select query, hence the mysql couldn't understand it.
Â
So, I tried putting single
quotes as 'species_master.species_name'. The
program now ran without errors and appended records
for a total of 17,685 combined records.
If you put it into quotes, the it will used as a
string, not a reference to a field.
Please correct me if I'm wrong:
You have this tervuren_target and you have to
copy every record which doesn't exists in the species_master
INSERT INTO species_master (genera, name,
species_name, authorities, species_source)
SELECT DISTINCT genera, name, species_name,
authorities, species_source FROM 'tervuren_target'
LEFT JOIN species_master
ON
tervuren_target.species_name = species_master.species_name
WHERE species_master.species_name IS NULL
Basically: we select all of the records from
tervuren_target, link with each record from
tervuren_target to species_master through the
species_name, we select only the records, where
this link is not exists
(species_master.species_name IS NULL, so we don't
have records with this species_name), to be sure, I added a DISTINCT.
Maybe you have to tweak the query a littbe bit,
because mysql is a little bit tricky, it doesnt
allow by default to insert into a row, which is
used in  the same statement as source, but with
table alias you can workaround that, or you can use a third table.
Tyrael
--- End Message ---
