Re: [PHP-DB] History of MySQL support in PHP
Indeed, the book writing is no bad guess, but with slightly different focus than PHP ancestry. But wondering how long mysql is supported is more or less personal interest. Thx to both of you for answering and greetings from Germany to China and California, USA Stefan Reimers ___ Forest Liu wrote: Maybe he is writing a book "Leading to Creativity: the road of PHP and its father" haha just joking my pleasure to read the post from Mr.Lerdorf and best wishes from all Chinese PHP programer. On Sat, 19 Mar 2005 07:41:55 -0800, Rasmus Lerdorf <[EMAIL PROTECTED]> wrote: The actual code for the first MySQL extension was just a search and replace of "msql"->"mysql" in the original msql extension I wrote before that. I found 1995'ish documentation for that the other day: http://lerdorf.com/php/msql.html And that extension was based on the original msql support in PHP version 1 dating back to around March or April of 1995. You can see that code in the PHP 1.0.8 tarball located at http://museum.php.net. Unfortunately I didn't use CVS in the early days so we don't have revision history going back that far. But I am curious, why do you want to know? -Rasmus -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] History of MySQL support in PHP
Maybe he is writing a book "Leading to Creativity: the road of PHP and its father" haha just joking my pleasure to read the post from Mr.Lerdorf and best wishes from all Chinese PHP programer. On Sat, 19 Mar 2005 07:41:55 -0800, Rasmus Lerdorf <[EMAIL PROTECTED]> wrote: > The actual code for the first MySQL extension was just a search and > replace of "msql"->"mysql" in the original msql extension I wrote before > that. I found 1995'ish documentation for that the other day: > >http://lerdorf.com/php/msql.html > > And that extension was based on the original msql support in PHP version > 1 dating back to around March or April of 1995. You can see that code > in the PHP 1.0.8 tarball located at http://museum.php.net. > Unfortunately I didn't use CVS in the early days so we don't have > revision history going back that far. > > But I am curious, why do you want to know? > > -Rasmus > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- Sincerely, Forest Liu(åäè) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] History of MySQL support in PHP
The actual code for the first MySQL extension was just a search and replace of "msql"->"mysql" in the original msql extension I wrote before that. I found 1995'ish documentation for that the other day: http://lerdorf.com/php/msql.html And that extension was based on the original msql support in PHP version 1 dating back to around March or April of 1995. You can see that code in the PHP 1.0.8 tarball located at http://museum.php.net. Unfortunately I didn't use CVS in the early days so we don't have revision history going back that far. But I am curious, why do you want to know? -Rasmus -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MySQL - Query within a query
I am looking to do the following w/ MySQL and PHP. Have 1 query that
gets
results, then use those results in another query:
$l = 2;
$result1 = ("SELECT * FROM Drivers WHERE League = $l");
$result2 = mysql_query("SELECT DriverID, Driver, CarNbr FROM Drivers
LEFT
JOIN $LeagueList ON Drivers.DriverID = $Result1.DriverID
WHERE $Result1.DriverID) Is Null ORDER BY Drivers.DriverID");
If you're using MySQL 4.1, which supports subqueries, you might be able
to write this all up as one nice query (using a sub-select).
Larry
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] History of MySQL support in PHP
You can find many interest thing from this page: http://cvs.php.net/phpfi/ChangeLog as you see, that is php/fi (or so called php2). from this page, I find the oringin support to MySQL is added in PHP/FI 1.198 by rasmus ,Mon Dec 2 13:19:17 1996 (8 years, 3 months ago): "Add initial rough mysql support <[EMAIL PROTECTED]>" A historial time. :) On Sat, 19 Mar 2005 14:26:44 +0100, Stefan Reimers <[EMAIL PROTECTED]> wrote: > The changelog reaches back to the first beta of PHP4 > > Forest Liu wrote: > > I think you can check the changelog on www.php.net > > > > > > On Sat, 19 Mar 2005 14:13:44 +0100, Stefan Reimers > > <[EMAIL PROTECTED]> wrote: > > > >>Hi list, > >> > >>can anyone tell me, when PHP originally started the MySQL support? I > >>downloaded the php 3.0.17 version from php.net and it already supports > >>MySQL. > >> > >>Thx in advance > >>Stefan > >> > >>-- > >>PHP Database Mailing List (http://www.php.net/) > >>To unsubscribe, visit: http://www.php.net/unsub.php > >> > >> > > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- Sincerely, Forest Liu(åäè) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] History of MySQL support in PHP
The changelog reaches back to the first beta of PHP4 Forest Liu wrote: I think you can check the changelog on www.php.net On Sat, 19 Mar 2005 14:13:44 +0100, Stefan Reimers <[EMAIL PROTECTED]> wrote: Hi list, can anyone tell me, when PHP originally started the MySQL support? I downloaded the php 3.0.17 version from php.net and it already supports MySQL. Thx in advance Stefan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] History of MySQL support in PHP
I think you can check the changelog on www.php.net On Sat, 19 Mar 2005 14:13:44 +0100, Stefan Reimers <[EMAIL PROTECTED]> wrote: > Hi list, > > can anyone tell me, when PHP originally started the MySQL support? I > downloaded the php 3.0.17 version from php.net and it already supports > MySQL. > > Thx in advance > Stefan > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- Sincerely, Forest Liu(åäè) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] History of MySQL support in PHP
Hi list, can anyone tell me, when PHP originally started the MySQL support? I downloaded the php 3.0.17 version from php.net and it already supports MySQL. Thx in advance Stefan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] MySQL - Query within a query
Unlike ASP, $result1 is a handle to the dataset, not the data set itself.
You need to access the data first and then incorporate that into your query
like this:
$l = 2;
$result1 = ("SELECT * FROM Drivers WHERE League = $l");
$row = mysql_fetch_array($result1);
$driverID = $row['DriverID'];
$result2 = mysql_query("SELECT DriverID, Driver, CarNbr FROM Drivers LEFT
JOIN $LeagueList ON Drivers.DriverID = $driverID
WHERE $driverID) Is Null ORDER BY Drivers.DriverID");
hth
Bastien
From: "Pete Ruby" <[EMAIL PROTECTED]>
Reply-To: "Pete Ruby" <[EMAIL PROTECTED]>
To: php-db@lists.php.net
Subject: [PHP-DB] MySQL - Query within a query
Date: Wed, 16 Mar 2005 00:03:19 -0500
I am looking to do the following w/ MySQL and PHP. Have 1 query that gets
results, then use those results in another query:
$l = 2;
$result1 = ("SELECT * FROM Drivers WHERE League = $l");
$result2 = mysql_query("SELECT DriverID, Driver, CarNbr FROM Drivers LEFT
JOIN $LeagueList ON Drivers.DriverID = $Result1.DriverID
WHERE $Result1.DriverID) Is Null ORDER BY Drivers.DriverID");
I can do it w/ Access and MSSQL, but if I try in MySQL, i get an error,
both
in DBManager (MySQL interface), and in PHP.
Any help is appreciated. Thanx!
Pete
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] where can i get "fixed" mssql extension??
If you are looking for precompiled win32 binaries you can find them here: http://kromann.info/php.php or included in the zip files on http://snaps.php.net - Frank > Does Anyone know where can i get the latest and already fixed mssql extensions?? > > thank you > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] where can i get "fixed" mssql extension??
Does Anyone know where can i get the latest and already fixed mssql extensions?? thank you -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
