[PHP-DB] Comparing ADODB with PEAR DB, Metabase and Native MySQL
PEAR DB, ADODB and Metabase are database abstraction libraries. I decided to benchmark some of the most common database abstraction libraries using a simple SELECT statement and measure the overhead compared to using native mysql_* function calls: Benchmark was to select 82 rows from the products table 200 times. The tests were repeated 5 times. Connection times were excluded from the benchmark. Values are in seconds. MySQL 1.12 1.12 1.17 1.15 1.14 ADODB 1.43 1.47 1.47 1.44 1.45 PEAR 3.14 3.13 3.22 3.12 3.16 M'base 4.99 4.72 4.71 4.71 4.72 Average Overhead MySQL 1.14 - ADODB 1.4527% PEAR 3.15 176% M'base4.77 318% I was still surprised at how slow some of the libraries were, even though a code inspection had already given strong hints on the expected performance of the class libraries. Methodology Results on Pentium 800 Mhz running Win 2000, PHP 4.0.6 ISAPI on IIS5 with MySQL 3.23, all on the same machine. Source code for these tests is available from http://phplens.com/lens/adodb/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] connecting to msql...
With a basic php document, I am trying to create a table. I have a good code for the table (I think) but I cannot connect to the SQL server. I have the SQL server name, SQL username, SQL password, and SQL database name. I have tried too many options to list here. It is not a localhost. I'm using the function msql_connect(); I can't figure out how to properly write the server name in between to parentheses. I keep get fatal errors, and parsing errors, and all kinds of crazy errors. Spent most my night researching this, to no avail. Any response will be greatly appreciated.
[PHP-DB] how to restore what I input
When I input some value inside the textbox in the search engine and click "send", I will find what I want ; however, when I click "Back" in the brower, the value what I input was dismissed, how to restore this as it is so trouble that I need to type it again in the text box. Thanks Keldo -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Check Boxes!
I still can't get my damn code working :( :( :( All I want to do is have any records with a checked check box given the value of 1 in the AuthStatus row. Can anyone help me please? - JobID; for ($i = 0; $i <= $Max_JobID; $i++) { if($HTTP_POST_VARS["chkAuthStatus_$i"] = 'on') { $JobID = $i; } if($JobID){ $sql = "UPDATE vacancies SET AuthStatus='1' WHERE (JobID = '$JobID')"; mysql_query($sql,$dbconnect); } } } ?> _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] MSSQL Errors
First post, yay. Anyways, I have a win2k server box, with all the critical updates and blah blah blah to secure it, and I have PHP installed and tested, and phpinfo(); works. Then I attempted to install SQL 2000, and thats where everything went downhill. I test my script, and on the server side it gives me the error: Unable To Load Dynamic Link Library 'c:\winnt\system32\php_mssql.dll' - Access Is Denied And the odd thing is, were running as Admin, and accessing the script in a Password protected folder as Admin, so I am my collegues are baffled completely. Any input would be helpful. Thanks. - Tj Corley [EMAIL PROTECTED] The Planet
Re: [PHP-DB] variable operators in queries
> Is it possible to put variable operators in queries? =I can see no reason why not - you're not actually putting the 'variable' in the 'query', just using a PHP-variable to build a PHP-string which will be sent to MySQL as a SQL query... > I tried this (the real variable comes from a form) > $Date_Operator =(">="); > sql="SELECT * FROM poeple WHERE age $Date_operator 20"; > $result_id = mysql_query($sql); > > It doesn't work like this. I also tried: > sql="SELECT * FROM poeple WHERE age \"$Date_operator\" 20" > $result_id = mysql_query($sql); > it didn't work either. Sander, First of all, may I recommend the liberal use of 'debug echo's. At this stage you don't know if the fault is in the construction of the query, or within the PHP-MySQL interface, or... Recommend you insert something like echo "Query is $sql" for your own health/sanity. Secondly how are you viewing the 'results' from the database to judge that "it doesn't work"? The reason for this comment is that "people" is spelled incorrectly, and unless this misspelling is consistent... In similar vein, you have used the term "sql" in the assignment statements, but (rightly) $sql within the query and the odd semi-colon (;) is missing too! Regards, =dn -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] variable operators in queries
Hello, Is it possible to put variable operators in queries? I tried this (the real variable comes from a form) $Date_Operator =(">="); sql="SELECT * FROM poeple WHERE age $Date_operator 20"; $result_id = mysql_query($sql); It doesn't work like this. I also tried: sql="SELECT * FROM poeple WHERE age \"$Date_operator\" 20" $result_id = mysql_query($sql); it didn't work either. Or should I use a have to make a IF-Then construction? If $Date_Operator == (">=") then { sql="SELECT * FROM poeple WHERE age >= 20" } etc... Can anybody help me with this? Thanks in advance! -- Met vriendelijke groet / With Greetings, Sander Peters site: http://www.visionnet.nl/ email: mailto:[EMAIL PROTECTED] webmail: mailto:[EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: Problem with a form
Hi, disregard this post - i found the error - a little mistyping :-( Michael "Michael J. Eisner" <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi, > > I have a form with two dropdown fields. When ever one of them is changed, a > javascript function is called that reloads the whole PHP-Page. > > The first dropdown has values in the form like '19.10.2001' or '25.10.2001' > the second one only one charakter like 'V', 'M' or 'F'. > > When I change the form with the date-values, everything is OK, I got the > parameters '&DateSet=[selected value]' in the URL. > But when ever I change the second field, the URL reads > '...&DateSet=%25d.10.2001' > The value of the second field is always correct in the URL. > > Where the heck is the error > > Michael > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] help connecting to ODBC
Anthony, Then enable ODBC tracing in the ODBC Administrator and see where the calls are failing. Or try a different ODBC driver - you can download free ones from our site for most databases. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Data Integration Technology Providers > -Original Message- > From: Anthony [mailto:[EMAIL PROTECTED]] > Sent: Friday, October 19, 2001 1:21 PM > To: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] help connecting to ODBC > > > yes, I can use the source from other programs. The source is a System > DSN, based on a file DSN for the driver. The I_USR_ user > has the correct access rights to the files being accessed and to the > file DSN driver. > > > Andrew Hill wrote: > > > Anthony, > > > > Is the DSN usable from the ODBC Administrator control panel? > > E.g. test it there first. Also, you mention File DSNs? PHP > can only use > > System DSNs on Windows, AFAIK. > > > > Best regards, > > Andrew Hill > > Director of Technology Evangelism > > OpenLink Software http://www.openlinksw.com > > Universal Data Access & Data Integration Technology Providers > > > > > >>-Original Message- > >>From: Anthony [mailto:[EMAIL PROTECTED]] > >>Sent: Friday, October 19, 2001 1:01 PM > >>To: [EMAIL PROTECTED] > >>Subject: [PHP-DB] help connecting to ODBC > >> > >> > >>I can't connect to an ODBC data source. I have done this before many > >>times. I am now trying to connect to a new driver for new data. This > >>is the first time I have tried to access a file DSN. I have the driver > >>setup as a system DSN on win2k and IIS 5. PHP 4.06. when I attempt to > >>connect to the data source I get "SQL error: , SQL state S1000 in > >>SQLConnect". What does this mean? does anyone know where I can get a > >>list of SQL errors and their meaning? Thanks to anyone that can lend > >>their thoughts. > >> > >>- Anthony > >> > >> > >>-- > >>PHP Database Mailing List (http://www.php.net/) > >>To unsubscribe, e-mail: [EMAIL PROTECTED] > >>For additional commands, e-mail: [EMAIL PROTECTED] > >>To contact the list administrators, e-mail: [EMAIL PROTECTED] > >> > >> > >> > >> > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Problem with a form
Hi, I have a form with two dropdown fields. When ever one of them is changed, a javascript function is called that reloads the whole PHP-Page. The first dropdown has values in the form like '19.10.2001' or '25.10.2001' the second one only one charakter like 'V', 'M' or 'F'. When I change the form with the date-values, everything is OK, I got the parameters '&DateSet=[selected value]' in the URL. But when ever I change the second field, the URL reads '...&DateSet=%25d.10.2001' The value of the second field is always correct in the URL. Where the heck is the error Michael -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Access to MySQL Conversion question
select max(idfield) from table > -Original Message- > From: Brad Harriger [mailto:[EMAIL PROTECTED]] > Sent: Thursday, October 18, 2001 7:32 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Access to MySQL Conversion question > > > I have several MS Access databases that I need to convert to MySQL. > Each table is indexed on an ID field. How do I find the last index > number in the existing table so that I can increment it for the next > record that is added? > > Thanks, > > Brad > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] inserting NULL value
Null values are displayed as NULL. NULL is NOT the same as "". "" is an empty string. NULL means no value is assigned. -Original Message- From: Adv. Systems Design [mailto:[EMAIL PROTECTED]] Sent: Friday, October 19, 2001 11:15 AM To: PHP List Subject: [PHP-DB] inserting NULL value Hello * I am trying to batch load data into MySQL 3.23.39 from data that I am preparing using MS Excel, converting to tab-delimited txt file and uploading using phpMyAdmin... ...the problem is in trying to load the NULL value for some columns...if I leave the column empty it just gets truncated, and even if I put something into the first cell of the "null" column, half ways down the tab delimited file, excel just drops the field...if I use the word NULL, the value appears in the db as "NULL" not as "". ...how do you batch load NULL values? Thanks Luis __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] PHP and Oracle
Imbalance of double-quotes on line 43! Thus // comments have all been included in quoted string and hence strange text output. =dn - Original Message - From: "GEORGINA ELAINE BAILEY" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: 19 October 2001 18:26 Subject: [PHP-DB] PHP and Oracle > Can anyone tell me why my results will display when I just use text, but > won't display when I try to put them into a table. I keep getting a message > saying there is a parse error on line 50 of my script, but as far as I acn > see, line 50 is commented out. > > Georgina > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] PHP and Oracle
Can anyone tell me why my results will display when I just use text, but won't display when I try to put them into a table. I keep getting a message saying there is a parse error on line 50 of my script, but as far as I acn see, line 50 is commented out. Georgina Project Database - Search Results "; echo " ORIGINATORTITLEPROJECT NUMBERAVAILABILITYSPECIAL SKILLS //retrieve the results of the query statement and present them in the following way while (ocifetch($qry_statement)) { //echo ""; //echo "The Originator is:" .OCIresult($qry_statement, 'ORIGINATOR').""; //echo "The title is:" .OCIresult($qry_statement, 'TITLE').""; //echo "The projectID is: ". OCIresult($qry_statement, 'PROJECTID').""; //echo "The availabilty is: ". OCIresult($qry_statement, 'AVAILABILITY').""; //echo "The special skills are: ". OCIresult($qry_statement, 'SPECIALSKILLS').""; //echo ""; echo ""; echo "" .OCIresult($qry_statement, 'ORIGINATOR'). ""; echo "" .OCIresult($qry_statement, 'TITLE'). ""; echo "" .OCIresult($qry_statement, 'PROJECTID'). ""; echo "" .OCIresult($qry_statement, 'AVAILABILITY'). ""; echo "" .OCIresult($qry_statement, 'SPECIALSKILLS'). ""; echo ""; } //log off the database OCILogoff ($connection); } ?> http://www.aber.ac.uk";>Return to UWA Home Page http://www.aber.ac.uk/compsci";>Return to Computer Science Home Page Return to Project Database Main Menu Project Database - Project Search Project Search http://users.aber.ac.uk/geb97/search1.php4"; method="POST"> Please select the relevant module and then check the area(s) that may interest you If, for example, you would like to see all projects that involve Java, check the Java box. If you would like only those that involve both Java and databases, check both boxes. You must check at least one box CS39030 CS39110 CS49060 CSM9060 CSM9260 Java Telematics Artificial Intelligence Databases 68HC11 Assembly Language Web Development Other Programming Languages http://www.aber.ac.uk";>Return to UWA Home Page http://www.aber.ac.uk/compsci";>Return to Computer Science Home Page Return to Project Database Main Menu -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] help connecting to ODBC
yes, I can use the source from other programs. The source is a System DSN, based on a file DSN for the driver. The I_USR_ user has the correct access rights to the files being accessed and to the file DSN driver. Andrew Hill wrote: > Anthony, > > Is the DSN usable from the ODBC Administrator control panel? > E.g. test it there first. Also, you mention File DSNs? PHP can only use > System DSNs on Windows, AFAIK. > > Best regards, > Andrew Hill > Director of Technology Evangelism > OpenLink Software http://www.openlinksw.com > Universal Data Access & Data Integration Technology Providers > > >>-Original Message- >>From: Anthony [mailto:[EMAIL PROTECTED]] >>Sent: Friday, October 19, 2001 1:01 PM >>To: [EMAIL PROTECTED] >>Subject: [PHP-DB] help connecting to ODBC >> >> >>I can't connect to an ODBC data source. I have done this before many >>times. I am now trying to connect to a new driver for new data. This >>is the first time I have tried to access a file DSN. I have the driver >>setup as a system DSN on win2k and IIS 5. PHP 4.06. when I attempt to >>connect to the data source I get "SQL error: , SQL state S1000 in >>SQLConnect". What does this mean? does anyone know where I can get a >>list of SQL errors and their meaning? Thanks to anyone that can lend >>their thoughts. >> >>- Anthony >> >> >>-- >>PHP Database Mailing List (http://www.php.net/) >>To unsubscribe, e-mail: [EMAIL PROTECTED] >>For additional commands, e-mail: [EMAIL PROTECTED] >>To contact the list administrators, e-mail: [EMAIL PROTECTED] >> >> >> >> > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] help connecting to ODBC
Anthony, Is the DSN usable from the ODBC Administrator control panel? E.g. test it there first. Also, you mention File DSNs? PHP can only use System DSNs on Windows, AFAIK. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Data Integration Technology Providers > -Original Message- > From: Anthony [mailto:[EMAIL PROTECTED]] > Sent: Friday, October 19, 2001 1:01 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] help connecting to ODBC > > > I can't connect to an ODBC data source. I have done this before many > times. I am now trying to connect to a new driver for new data. This > is the first time I have tried to access a file DSN. I have the driver > setup as a system DSN on win2k and IIS 5. PHP 4.06. when I attempt to > connect to the data source I get "SQL error: , SQL state S1000 in > SQLConnect". What does this mean? does anyone know where I can get a > list of SQL errors and their meaning? Thanks to anyone that can lend > their thoughts. > > - Anthony > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] help connecting to ODBC
I can't connect to an ODBC data source. I have done this before many times. I am now trying to connect to a new driver for new data. This is the first time I have tried to access a file DSN. I have the driver setup as a system DSN on win2k and IIS 5. PHP 4.06. when I attempt to connect to the data source I get "SQL error: , SQL state S1000 in SQLConnect". What does this mean? does anyone know where I can get a list of SQL errors and their meaning? Thanks to anyone that can lend their thoughts. - Anthony -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] inserting NULL value
Hello * I am trying to batch load data into MySQL 3.23.39 from data that I am preparing using MS Excel, converting to tab-delimited txt file and uploading using phpMyAdmin... ...the problem is in trying to load the NULL value for some columns...if I leave the column empty it just gets truncated, and even if I put something into the first cell of the "null" column, half ways down the tab delimited file, excel just drops the field...if I use the word NULL, the value appears in the db as "NULL" not as "". ...how do you batch load NULL values? Thanks Luis __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Authentication
Hi all. I'm trying to find a way to use apache authentication trough php/mysql. I mean that users/passwords need will be stored in mysql database but Apache will athomatically request authentication for any access to protected folder _and its subfolders_. For not to make something like "access.php" that will send "HTTP/1.0 401 Unauthorized" header and check login/pass.. This method requires include of "access.php" to _all_ scripts in _all_ subdirectiries, that doesn't look "fine" :). Can anyone give me an idea? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Re: Newbie: odbc_prepare & parameters
Hmm! Sometimes tracing needs to be turned off and then back on. The driver manager in Windows can be buggy. Also, select some drive level file to be safe, like c:/sql.log Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Data Integration Technology Providers > -Original Message- > From: Michael J. Eisner [mailto:[EMAIL PROTECTED]] > Sent: Friday, October 19, 2001 6:27 AM > To: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] Re: Newbie: odbc_prepare & parameters > > > Andrew, > > you mean to activate the ODBC-Tracing of the OperatingSystem? When I > activate this, nothing is being logged. > > OS is WIN2000 Prof. > Database: ACCESS 2000 > Diver: normal MS ODBC-Driver of WIN2000 > > Michael > > > > "Andrew Hill" <[EMAIL PROTECTED]> schrieb im Newsbeitrag > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > Michael, > > > > Have you generated an ODBC trace? > > You can see what values are being passed into ODBC and where > the error is > > occurring. > > > > Also, knowing what driver/database/platform would help :) > > > > Best regards, > > Andrew Hill > > Director of Technology Evangelism > > OpenLink Software http://www.openlinksw.com > > Universal Data Access & Data Integration Technology Providers > > office:781.273.0900 x 27 mobile:781.608.4217 > > > > > -Original Message- > > > From: Michael J. Eisner [mailto:[EMAIL PROTECTED]] > > > Sent: Thursday, October 18, 2001 1:53 PM > > > To: [EMAIL PROTECTED] > > > Subject: [PHP-DB] Re: Newbie: odbc_prepare & parameters > > > > > > > > > Hi all, > > > > > > sorry, there was a mistake: > > > > > > > $sql="SELECT fldCaptain, fldCaptID, fldCaptStat, fldCaptTR, > fldCaptDuty, > > > > fldFO, fldFOID, fldFOStat, fldFOTR, fldFODuty, fld_F_Reserved, > > > fld_F_Flown > > > > FROM tblBookings WHERE fldFlight = '?' AND fldBookDate > > > =#".$EngDatum."#"; > > > > > > should read > > > > > > FROM tblBookings WHERE fldFlight = ? AND fldBookDate > =#".$EngDatum."#"; > > > ^^ > > > there should the parameter be used. > > > > > > Michael Eisner > > > > > > > > > "Michael J. Eisner" <[EMAIL PROTECTED]> schrieb im Newsbeitrag > > > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > > > Hi all, > > > > i'm really new in php (working on my first project9 and i got the > > > following > > > > situation: > > > > > > > > i have a loop going through a result set of an odbc-query. > each row of > > > this > > > > loop has to be checked if there is an entry in another table. so as > the > > > last > > > > odbc-query is the same for each row except they key-field, i > > > tried to use > > > > the odbc_prepare function and a parameter array. but it > doesn't work. > > > > I got no errormessages. > > > > > > > > this is how it looks like - and doesn't work: > > > > ** > > > > ... > > > > ... > > > > $sql="SELECT fldCaptain, fldCaptID, fldCaptStat, fldCaptTR, > fldCaptDuty, > > > > fldFO, fldFOID, fldFOStat, fldFOTR, fldFODuty, fld_F_Reserved, > > > fld_F_Flown > > > > FROM tblBookings WHERE fldFlight = '?' AND fldBookDate > > > =#".$EngDatum."#"; > > > > > > > > $ergDispatch=odbc_prepare($conDispatch,$sql); > > > > > > > > While (odbc_fetch_into($ergRouten, &$datRouten)) > > > > ... > > > > ... > > > > $Para = array($datRouten[0]); > > > > odbc_execute($ergDispatch,$Para); > > > > ... > > > > ... > > > > * > > > > The array is filled correctly, but the odbc_execute > function doesNn't > > > bring > > > > back any value, but there are definitvly rows where there > should be a > > > > result. > > > > > > > > Thanks in advance! > > > > > > > > Michael J. Eisner > > > > > > > > > > > > > > > > > > > > > > > > -- > > > PHP Database Mailing List (http://www.php.net/) > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > To contact the list administrators, e-mail: > [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] DBM module
Hello, Currentlu testing the dbm functions (for a wrapper class), stopped with dbm. Configure does not recognize the dbm library (db-3.3.11). gdbm, db3 has been recognized. Wich library do I need to use the dbm function (with or without dba), any link ? thank's pa -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: importing BLOBs from MSSQL
Switch to odbc. There are some limitations with mssql extension. Regards, john M0sh3 <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi, i'm trying to import tables containing TEXT fields from MSSQL 2K, so far > tried different ways, one of them DTS, but unsuccessfully. > > It gives error: "Query-based insertion or updating of BLOB values is not > supported." > > Any help will be very much appreciated :) > > Moshe > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Newbie Question: Convert SELECT to DELETE statement in mysql
No need to defrag/compact...MySQL will reuse the space. Since posting my original message, I've learned that version 4.0 (alpha) of MySQL was released on 15 October. In Paragraph 6.4.6 of the MySQL manual, we read: The multi table delete format is supported starting from MySQL 4.0.0. Bottom line: if you don't mind unstable, ever-changing, in-development application for mission-critical applications, you can use vers 4.0. Otherwise, you need to follow the algorithm you've laid out. Or, if your web-host has the option, investigate table of TYPE=INNODB. These tables support FOREIGN keys which may allow multi-table deletion. In version 3.23, your web-host must be running the MYSQLD-MAX binary. In version 4.0, INNODB support is in all binaries. -Original Message- From: Shaun Honsvick [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 18, 2001 6:35 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Newbie Question: Convert SELECT to DELETE statement in mysql No, I am not trying to delete with a select statement. That was just there to show my tables, fields, etc. So if I understand what you are saying I can not do a delete statement with a join in it. I would have to query each individual row for the ID that need to be deleted, delete the row in the first table, then delete the row in the second table, third table, etc. Then loop for the next intance. Theres got to be a better way. Also, after this is done should I run some sort compact or defrag on the database that restore wasted space? Thanks, Shaun "Rick Emery" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]... > Are you trying to delete records with a SELECT statement? That can't be > done. > > To delete from two different tables, you must use two different DELETE > statements. > > -Original Message- > From: Shaun Honsvick [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 16, 2001 3:59 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Newbie Question: Convert SELECT to DELETE statement in > mysql > > > I am trying to run a delete on a mysql database. The delete query needs to > delete from 2 tables. The select statement is: > > SELECT tinvoices.*, ttrackingnumbers.* FROM tinvoices LEFT JOIN > ttrackingnumbers ON tinvoices.InvoiceID = ttrackingnumbers.InvoiceID WHERE > Date < '2001-08-01'; > > I can't seem to get a delete statement to work. (This is my first project) > > Thanks, > Shaun > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Question in french about IMG SRC
"; break; } } ?> je souhaite faire apparait une l'image ki est donné dans ma base pour $colonne2["IMG"]>. Il m'affiche bien le bon texte qd je met echo $colonne2["IMG"]; , mais j'aimerai qu'il mettent cette valeur en img src. J'espere etre assez clair :) David, Je pense que c'est assez clair, mais je veut d'ecrire on anglais: In this line of PHP code: echo ""; Double quotation marks (") are used for two different purposes. They cannot be 'nested'. echo ''; may solve the problem. A bientot, =dn -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Question in french about IMG SRC
Bonjour la liste "; break; } } ?> je souhaite faire apparait une l'image ki est donné dans ma base pour $colonne2["IMG"]>. Il m'affiche bien le bon texte qd je met echo $colonne2["IMG"]; , mais j'aimerai qu'il mettent cette valeur en img src. J'espere etre assez clair :) Merci David -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Re: Newbie: odbc_prepare & parameters
Hi Andreas, what I forgot: the queries connect both to different databases, so they use a different connection. Michael "Andreas Karajannis" <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Michael J. Eisner wrote: > > > >>>i have a loop going through a result set of an odbc-query. each row of > >>>this loop has to be checked if there is an entry in another table. so as the > >>>last odbc-query is the same for each row except they key-field, i tried to > >>>use the odbc_prepare function and a parameter array. but it doesn't work. > > If Access supports subqueries, you should consider this approach, e.g. > > > $sql="SELECT fldCaptain, fldCaptID, fldCaptStat, fldCaptTR, fldCaptDuty, > fldFO, fldFOID, fldFOStat, fldFOTR, fldFODuty, fld_F_Reserved, > fld_F_Flown > FROM tblBookings WHERE fldFlight in (select ... from ... where ...) > AND fldBookDate=#".$EngDatum."#"; > > with the subquery being essentially your $ergRouten statement. > > > HTH, > Andreas > > -- > Andreas Karajannis > mediaworx berlin AG > > Fon (0 30) 2 75 80 - 266 > Fax (0 30) 2 75 80 - 200 > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Re: Newbie: odbc_prepare & parameters
Hi Andreas, the problem is that not every row of the $ergRouten statement has a row in the $ergDispatch statement. I also tired a UNION query, but this took longer for execution than it does now and brings me more timeout problems then I have now. Michael "Andreas Karajannis" <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Michael J. Eisner wrote: > > > >>>i have a loop going through a result set of an odbc-query. each row of > >>>this loop has to be checked if there is an entry in another table. so as the > >>>last odbc-query is the same for each row except they key-field, i tried to > >>>use the odbc_prepare function and a parameter array. but it doesn't work. > > If Access supports subqueries, you should consider this approach, e.g. > > > $sql="SELECT fldCaptain, fldCaptID, fldCaptStat, fldCaptTR, fldCaptDuty, > fldFO, fldFOID, fldFOStat, fldFOTR, fldFODuty, fld_F_Reserved, > fld_F_Flown > FROM tblBookings WHERE fldFlight in (select ... from ... where ...) > AND fldBookDate=#".$EngDatum."#"; > > with the subquery being essentially your $ergRouten statement. > > > HTH, > Andreas > > -- > Andreas Karajannis > mediaworx berlin AG > > Fon (0 30) 2 75 80 - 266 > Fax (0 30) 2 75 80 - 200 > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Re: Newbie: odbc_prepare & parameters
Michael J. Eisner wrote: >>>i have a loop going through a result set of an odbc-query. each row of >>>this loop has to be checked if there is an entry in another table. so as the >>>last odbc-query is the same for each row except they key-field, i tried to >>>use the odbc_prepare function and a parameter array. but it doesn't work. If Access supports subqueries, you should consider this approach, e.g. $sql="SELECT fldCaptain, fldCaptID, fldCaptStat, fldCaptTR, fldCaptDuty, fldFO, fldFOID, fldFOStat, fldFOTR, fldFODuty, fld_F_Reserved, fld_F_Flown FROM tblBookings WHERE fldFlight in (select ... from ... where ...) AND fldBookDate=#".$EngDatum."#"; with the subquery being essentially your $ergRouten statement. HTH, Andreas -- Andreas Karajannis mediaworx berlin AG Fon (0 30) 2 75 80 - 266 Fax (0 30) 2 75 80 - 200 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] newbie - problems with Select and timestamp(14) calculation
Finally this is working as required!! I ended up changing the column type that stores the time to an INT and inserting a UNIX TIMESTAMP into it, below is the code that works fine, it may be useful to somebody else as a flood control, I hope it is fairly self-explanatory /***Variable to insert UNIX_TIMESTAMP into DB first time round*** column for time is INT UNSIGNED NOT NULL*/ $pw_time = time (); /***/ //users current IP $pw_userIP = getenv("REMOTE_ADDR"); $sql = "SELECT (UNIX_TIMESTAMP() - log_time) AS timediff FROM clinic_log WHERE user_ip = '$pw_userIP' "; $sql_result = mysql_query($sql,$connection) or die("Couldn't execute query"); if (mysql_num_rows($sql_result)!=0) { while($row = mysql_fetch_array($sql_result)) { if($row[timediff]<360) //**number of seconds to block resubmission { die("ERROR: Your question has already been submitted."); } } } What a frustrating experience it was to get this sorted out, still I have learnt a lot in the process, which is what it's all about I guess! Thanks again Paul - Original Message - From: "p.whiter" <[EMAIL PROTECTED]> Subject: Re: [PHP-DB] newbie - problems with Select and timestamp(14) calculation : Thanks to everyone for your help!! : : I have plenty to try here, I'll let you know how I get on with it : : Regards : Paul -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Re: Newbie: odbc_prepare & parameters
Hi Rick, no, where the '?' stands should be the value of the parameter given by the odbc_execute function. And this value changes everytime when a new result row of the other query is selected. Michael "Rick Emery" <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Does fldFlight contain the character "?" > > If it does, you must use: WHERE fldFlight='?' > > Are you using ? as a wildcard? > > -Original Message- > From: Michael J. Eisner [mailto:[EMAIL PROTECTED]] > Sent: Thursday, October 18, 2001 12:53 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Re: Newbie: odbc_prepare & parameters > > > Hi all, > > sorry, there was a mistake: > > > $sql="SELECT fldCaptain, fldCaptID, fldCaptStat, fldCaptTR, fldCaptDuty, > > fldFO, fldFOID, fldFOStat, fldFOTR, fldFODuty, fld_F_Reserved, fld_F_Flown > > FROM tblBookings WHERE fldFlight = '?' AND fldBookDate =#".$EngDatum."#"; > > should read > > FROM tblBookings WHERE fldFlight = ? AND fldBookDate =#".$EngDatum."#"; > ^^ > there should the parameter be used. > > Michael Eisner > > > "Michael J. Eisner" <[EMAIL PROTECTED]> schrieb im Newsbeitrag > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > Hi all, > > i'm really new in php (working on my first project9 and i got the > following > > situation: > > > > i have a loop going through a result set of an odbc-query. each row of > this > > loop has to be checked if there is an entry in another table. so as the > last > > odbc-query is the same for each row except they key-field, i tried to use > > the odbc_prepare function and a parameter array. but it doesn't work. > > I got no errormessages. > > > > this is how it looks like - and doesn't work: > > ** > > ... > > ... > > $sql="SELECT fldCaptain, fldCaptID, fldCaptStat, fldCaptTR, fldCaptDuty, > > fldFO, fldFOID, fldFOStat, fldFOTR, fldFODuty, fld_F_Reserved, fld_F_Flown > > FROM tblBookings WHERE fldFlight = '?' AND fldBookDate =#".$EngDatum."#"; > > > > $ergDispatch=odbc_prepare($conDispatch,$sql); > > > > While (odbc_fetch_into($ergRouten, &$datRouten)) > > ... > > ... > > $Para = array($datRouten[0]); > > odbc_execute($ergDispatch,$Para); > > ... > > ... > > * > > The array is filled correctly, but the odbc_execute function doesNn't > bring > > back any value, but there are definitvly rows where there should be a > > result. > > > > Thanks in advance! > > > > Michael J. Eisner > > > > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Re: Newbie: odbc_prepare & parameters
Andrew, you mean to activate the ODBC-Tracing of the OperatingSystem? When I activate this, nothing is being logged. OS is WIN2000 Prof. Database: ACCESS 2000 Diver: normal MS ODBC-Driver of WIN2000 Michael "Andrew Hill" <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Michael, > > Have you generated an ODBC trace? > You can see what values are being passed into ODBC and where the error is > occurring. > > Also, knowing what driver/database/platform would help :) > > Best regards, > Andrew Hill > Director of Technology Evangelism > OpenLink Software http://www.openlinksw.com > Universal Data Access & Data Integration Technology Providers > office:781.273.0900 x 27 mobile:781.608.4217 > > > -Original Message- > > From: Michael J. Eisner [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, October 18, 2001 1:53 PM > > To: [EMAIL PROTECTED] > > Subject: [PHP-DB] Re: Newbie: odbc_prepare & parameters > > > > > > Hi all, > > > > sorry, there was a mistake: > > > > > $sql="SELECT fldCaptain, fldCaptID, fldCaptStat, fldCaptTR, fldCaptDuty, > > > fldFO, fldFOID, fldFOStat, fldFOTR, fldFODuty, fld_F_Reserved, > > fld_F_Flown > > > FROM tblBookings WHERE fldFlight = '?' AND fldBookDate > > =#".$EngDatum."#"; > > > > should read > > > > FROM tblBookings WHERE fldFlight = ? AND fldBookDate =#".$EngDatum."#"; > > ^^ > > there should the parameter be used. > > > > Michael Eisner > > > > > > "Michael J. Eisner" <[EMAIL PROTECTED]> schrieb im Newsbeitrag > > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > > Hi all, > > > i'm really new in php (working on my first project9 and i got the > > following > > > situation: > > > > > > i have a loop going through a result set of an odbc-query. each row of > > this > > > loop has to be checked if there is an entry in another table. so as the > > last > > > odbc-query is the same for each row except they key-field, i > > tried to use > > > the odbc_prepare function and a parameter array. but it doesn't work. > > > I got no errormessages. > > > > > > this is how it looks like - and doesn't work: > > > ** > > > ... > > > ... > > > $sql="SELECT fldCaptain, fldCaptID, fldCaptStat, fldCaptTR, fldCaptDuty, > > > fldFO, fldFOID, fldFOStat, fldFOTR, fldFODuty, fld_F_Reserved, > > fld_F_Flown > > > FROM tblBookings WHERE fldFlight = '?' AND fldBookDate > > =#".$EngDatum."#"; > > > > > > $ergDispatch=odbc_prepare($conDispatch,$sql); > > > > > > While (odbc_fetch_into($ergRouten, &$datRouten)) > > > ... > > > ... > > > $Para = array($datRouten[0]); > > > odbc_execute($ergDispatch,$Para); > > > ... > > > ... > > > * > > > The array is filled correctly, but the odbc_execute function doesNn't > > bring > > > back any value, but there are definitvly rows where there should be a > > > result. > > > > > > Thanks in advance! > > > > > > Michael J. Eisner > > > > > > > > > > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > > > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] WildCard ok How bout search in blob?
Hello all again, I forgot to ask that with wild card i can search in blobs to? like select * from text where text like '%admin%' ?? Thanks Sir Thomas "omega" Henning -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Re: Sessions and Frames
i don't think frames are the problem. check again if you printing anything in same frame before session_start(); "Tjaybelt" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I have a site that is successfully using sessions and authentication. > However, I am working on another site, and it uses Frames. The first site > does not use frames, so including the unit that has the session stuff first > works. But on the frames site, it gives the following error : > > 'Cannot add header information - headers already sent by ' > > I know that this is when something is trying to print before the session is > started. > > I just don't know how to accomplish this if the page I am loading is inside > a frame... so by the time the session stuff starts, html is already output > to the browser. > > thanks for any help you can give. > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] importing BLOBs from MSSQL
Hi, i'm trying to import tables containing TEXT fields from MSSQL 2K, so far tried different ways, one of them DTS, but unsuccessfully. It gives error: "Query-based insertion or updating of BLOB values is not supported." Any help will be very much appreciated :) Moshe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] ask for help about php install with mysql :undefined reference to `mysql_module_entry'
Hi there, I encounter the following problem when trying to build a LAMP Box with Mysql-4.0.0+PHP-4.0.5+Apache-1.3.22. 1. Mysql Installed ok 2. when trying to make php with "./configure --with-apache=/home/user/apache_1.3.22 --with-mysql=/usr/local/ db/mysql --with-config-file-path=/usr/local/apache/ini --enable-track-vars;m ake;make install", it response : /usr/local/php-4.0.5/main/internal_functions.c:60: undefined reference to `mysql_module_entry', and of course the same happend when trying to build apache. Any Help will be very appreciated, Thanks in advance. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] MSSQL.DLL <-> MSSQL70.DLL ?
Sorry, natürlich benutze auch ich mssql_connect(). Der Zugriff funktioniert aber leider nur, wenn sich der SQL-Server und der WEB-Server auf dem gleichen Host befinden. Ein Zugriff über das Internet auf einen anderen Server ist nicht möglich. Und genau das ist mein Problem. Thorsten Hock ([EMAIL PROTECTED]) "Jens Wichmann" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:<9qolca$d44$[EMAIL PROTECTED]>... > Hallo, > die php_mssql70.dll ist veraltet, > alle funktionen sind in der php_mssql.dll enthalten > die du mit der Ver. 4.0.6 mit geliefert bekommst. > > gegenfrage, wo hast du den befehl mssql_open() denn her? > der servr wir doch mit mssql_connect() geöffnet um dann mit > mssql_select_db() die db auszuwählen. > > mache es bei mir jedenfalls so und es klappt hervorragend. > nachzulesen unter > http://www.php.net/manual/de/function.mssql-select-db.php > > Jens > > > Thorsten Hock <[EMAIL PROTECTED]> schrieb in im Newsbeitrag: > 9qohjf$qr1$[EMAIL PROTECTED] > > Hi, > > > > ich habe bei mir die PHP-Version 4.0.6 installiert. Allerdings finde ich > die > > in der Dokumentation erwähnte php_mssql70.dll nicht, sondern nur eine > > php_mssql.dll. Welches ist denn nun die richtige um auf den SQL-Server > > Version 7.0 zuzugreifen ? > > > > Wie greift mssql_open() auf die Datenbank zu ? Named Pipes, TCP/IP, > Welcher > > Port ? Meine Firewall zeigt keinen Zugriffsversuch auf Port 1433 an wenn > ich > > die extension php_mssql.dll aktiviere und mssql_open() aufrufe . > > Irgendwelche Ideen, Links oder Ratschläge ? > > > > Vielen Dank für Eure Mühe, > > Thorsten Hock > > ([EMAIL PROTECTED]) > "Jens Wichmann" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:9qolca$d44$[EMAIL PROTECTED]... > Hallo, > die php_mssql70.dll ist veraltet, > alle funktionen sind in der php_mssql.dll enthalten > die du mit der Ver. 4.0.6 mit geliefert bekommst. > > gegenfrage, wo hast du den befehl mssql_open() denn her? > der servr wir doch mit mssql_connect() geöffnet um dann mit > mssql_select_db() die db auszuwählen. > > mache es bei mir jedenfalls so und es klappt hervorragend. > nachzulesen unter > http://www.php.net/manual/de/function.mssql-select-db.php > > Jens > > > Thorsten Hock <[EMAIL PROTECTED]> schrieb in im Newsbeitrag: > 9qohjf$qr1$[EMAIL PROTECTED] > > Hi, > > > > ich habe bei mir die PHP-Version 4.0.6 installiert. Allerdings finde ich > die > > in der Dokumentation erwähnte php_mssql70.dll nicht, sondern nur eine > > php_mssql.dll. Welches ist denn nun die richtige um auf den SQL-Server > > Version 7.0 zuzugreifen ? > > > > Wie greift mssql_open() auf die Datenbank zu ? Named Pipes, TCP/IP, > Welcher > > Port ? Meine Firewall zeigt keinen Zugriffsversuch auf Port 1433 an wenn > ich > > die extension php_mssql.dll aktiviere und mssql_open() aufrufe . > > Irgendwelche Ideen, Links oder Ratschläge ? > > > > Vielen Dank für Eure Mühe, > > Thorsten Hock > > ([EMAIL PROTECTED]) > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: RE: [PHP-DB] Order By for search results ???
>Maybe I'm slow...I'm trying to decipher what you're trying to do. Show us your table >layout >Show us your search criteria and code >Show us a dump of your table so we can see what the data look like ahhh give the chap a break, this is 4th (or so) posting. he thinks we're all wonderful! Let's not mess that up for him: You had it when you said: "..how do I ORDER BY and then.." SELECT * FROM WHERE foo LIKE '%bar%' ORDER BY LIMIT * You could set in your code or have it as a variable set from the web-page: "Click table headings to sort by that field" etc etc * You could also have set as a number from a select menu again on the web page of search results. Good luck! Russ PS Where is this search engine? can I have a look??? go on - you know it makes sense On Thu, 18 Oct 2001 12:46:25 -0500 Rick Emery <[EMAIL PROTECTED]> wrote: > Maybe I'm slow... > > I'm trying to decipher what you're trying to do. > > Show us your table layout > Show us your search criteria and code > Show us a dump of your table so we can see what the data look like > > > -Original Message- > From: Chris Payne [mailto:[EMAIL PROTECTED]] > Sent: Thursday, October 18, 2001 12:08 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Order By for search results ??? > > > Hi there everyone, > > I am happy, I have my search engine working almost perfectly (Touch wood :-) > but there is one problem. When I search - say for Backpacking in Australia > it doesn't bring up the results in that order as I have to order by country, > city or whatever. What I want to know is, how do I ORDER BY and then my > search results so that I get the nearest matches at the top of the search? > > Thank you all for your help, this list is the best place to be for PHP :-) > > Chris > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > #---# "Believe nothing - consider everything" Russ Michell Anglia Polytechnic University Webteam Room 1C 'The Eastings' East Road, Cambridge e: [EMAIL PROTECTED] w: www.apu.ac.uk/webteam www.theruss.com #---# -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Newbie Question: Convert SELECT to DELETE statement in mysql
Hi! In MySQL-4.0.0 you can delete from several tables in a join: DELETE t1, t2 FROM t1, t2, t3 WHERE ...; But 4.0.0 is still alpha, and it will take some months for it to stabilize. No compact or defrag is normally needed with MySQL. Regards, Heikki http://www.innodb.com Shaun Honsvick wrote in message <[EMAIL PROTECTED]>... >No, I am not trying to delete with a select statement. That was just there >to show my tables, fields, etc. > >So if I understand what you are saying I can not do a delete statement with >a join in it. I would have to query each individual row for the ID that need >to be deleted, delete the row in the first table, then delete the row in the >second table, third table, etc. Then loop for the next intance. Theres got >to be a better way. Also, after this is done should I run some sort compact >or defrag on the database that restore wasted space? > >Thanks, >Shaun > > >"Rick Emery" <[EMAIL PROTECTED]> wrote in message >news:[EMAIL PROTECTED]... >> Are you trying to delete records with a SELECT statement? That can't be >> done. >> >> To delete from two different tables, you must use two different DELETE >> statements. >> >> -Original Message- >> From: Shaun Honsvick [mailto:[EMAIL PROTECTED]] >> Sent: Tuesday, October 16, 2001 3:59 PM >> To: [EMAIL PROTECTED] >> Subject: [PHP-DB] Newbie Question: Convert SELECT to DELETE statement in >> mysql >> >> >> I am trying to run a delete on a mysql database. The delete query needs to >> delete from 2 tables. The select statement is: >> >> SELECT tinvoices.*, ttrackingnumbers.* FROM tinvoices LEFT JOIN >> ttrackingnumbers ON tinvoices.InvoiceID = ttrackingnumbers.InvoiceID WHERE >> Date < '2001-08-01'; >> >> I can't seem to get a delete statement to work. (This is my first project) >> >> Thanks, >> Shaun >> >> >> >> -- >> PHP Database Mailing List (http://www.php.net/) >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> To contact the list administrators, e-mail: [EMAIL PROTECTED] >> > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] MSSQL.DLL <-> MSSQL70.DLL ?
Hi, >I need to access my MS-SQL-Sever V7.0. In a lot of messages I the extension >php_mssql70.dll is mentioned, but the latest release of php is shipped with >php_mssql.dll instead. Is that okay ? it's the same, just try to check your php.ini [extensions] block, to reflect the exact name of your dll. >The use of the mssql_open() function fails every time and my firewall log >doesn't show any access at all on port 1433 (neither a deny not an allow). >How does the mssql_open() function tries to establish the link ? Via TCP/IP >on port 1433 ? Do I have to add the port information to the hostname by >myself ? this is configured at the web server, at control panel, ODBC settings, looking at client configuration. That's where you establish access to "mysqlserver" via tcp/ip, named pipes, and so on. Usually you have "Named Pipes" by default towards some server, and php just tries to use that system-wide setting. Greetings, F.J. Ortiz 10/19/01 9:55:21 AM, "Thorsten Hock" <[EMAIL PROTECTED]> wrote: >Hi ! > >I need to access my MS-SQL-Sever V7.0. In a lot of messages I the extension >php_mssql70.dll is mentioned, but the latest release of php is shipped with >php_mssql.dll instead. Is that okay ? > >The use of the mssql_open() function fails every time and my firewall log >doesn't show any access at all on port 1433 (neither a deny not an allow). >How does the mssql_open() function tries to establish the link ? Via TCP/IP >on port 1433 ? Do I have to add the port information to the hostname by >myself ? > >I really would appreciate any help or hint on this topic. > >Thorsten Hock >([EMAIL PROTECTED]) > > > > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: [EMAIL PROTECTED] > > ___ Francisco Javier Ortiz Torre ComuNET,S.A. mailto:[EMAIL PROTECTED] ComuNET, S.A Gral. Concha 39,6º 48012 Bilbao España Tel: +34 944 700 101 Fax: +34 944 700 185 http://www.comunet.es ___ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] MSSQL.DLL <-> MSSQL70.DLL ?
Hi ! I need to access my MS-SQL-Sever V7.0. In a lot of messages I the extension php_mssql70.dll is mentioned, but the latest release of php is shipped with php_mssql.dll instead. Is that okay ? The use of the mssql_open() function fails every time and my firewall log doesn't show any access at all on port 1433 (neither a deny not an allow). How does the mssql_open() function tries to establish the link ? Via TCP/IP on port 1433 ? Do I have to add the port information to the hostname by myself ? I really would appreciate any help or hint on this topic. Thorsten Hock ([EMAIL PROTECTED]) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]