Re: [PHP-DB] best way to stare true, false

oh... no I ment it in a different way.. somehow.. declare 1 enum value and then set it or not. Search for NULL or not NULL values instead of false /true. in this direction, but .. hey does nobody do this like that?? Andy -- http

[PHP-DB] MySQL and BLOB

kb can a blob field savin in MySQL and what do you suggest to do. Thanx, Andy -- -- http://www.globosapiens.net Worldwide Travel Community -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] full text search and how to underline keyword in results

characters? 2. Is it possible with php to underline the keyword inside the search results. This might be more tricky. Thank you for any help on that, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] full text search and how to underline keyword in results

ryed to fix that, but I fear that my php experiance lacks on this stage :-( Maybe someone else or you do have a idea for a fix? Cheers Andy "Stuart McDonald" <[EMAIL PROTECTED]> schrieb im Newsbeitrag 001901c24c45$2a5e6940$0100a8c0@stuart">news:001901c24c45$2a5e6940$01

[PHP-DB] douplicate entry

or something similar. Of course there is a unique index on the column. My question is how to prevent this error? Thank you for any help on this. Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] uploading images before creating db entry

this idea. Maybe some of you guys has a good idea on it?! Thank you for any help on this cases. Regards, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] gettin records from today, yesterday, etc.

quot;AND p.timestamp > '$start_date'"; ### But it leads to problems if I search for last week since I do a siple subtraction of integer values and not of real days. Maybe some of you guys has a better appoach? Thanx, Andy -- PHP Database Mai

[PHP-DB] Re: problems whenever changing data in database using PHPMyAdmin.

I do have the same problem since I did update to the newest version of phpmyadmin. This seems to be a bug in the new release since everything was working ok before the update. guess those guys are gonna release a .1 version pretty soon. andy "Kasper" <[EMAIL PROTECTED]> schrie

[PHP-DB] permanent db connections

connection anyway? Is is persistant when the user is browsing all the sites in my sytem? And when do I have to build the connection? Thanx for any help on that, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] cannot create database

why it is now not work. Any suggestions greatfully received. Andy -BEGIN PGP SIGNATURE- Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com> iQA+AwUBO1TyGA8TW1jK3d3CEQI9PgCYlLBjUoCKRRDLZQkFcfyvXNmlYwCdEuVA KOSk5zEaJipSxw9x3ZmutxU= =VW3P -END PGP SIG

[PHP-DB] cannot create database

why it is now not work. Any suggestions greatfully received. Andy -BEGIN PGP SIGNATURE- Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com> iQA+AwUBO1TyGA8TW1jK3d3CEQI9PgCYlLBjUoCKRRDLZQkFcfyvXNmlYwCdEuVA KOSk5zEaJipSxw9x3ZmutxU= =VW3P -END PGP SIG

[PHP-DB] DBM databases - un-clear

quot;Fatal error: Call to undefined function: dbmopen() in path/to/my/script.php on line 48" HELP! Andy.

[PHP-DB] DBM DATABASE PROBLEM!

quot;Fatal error: Call to undefined function: dbmopen() in path/to/my/script.php on line 48" HELP! Andy.

[PHP-DB] Performance problems in NC

Hi there, I have problems with the performance while using NC. It workes fine with IE. As soon as I access the db. It takes aproximatelly 1 -2 min till I see the page. Does anybody know some help? Thank you Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail

[PHP-DB] Combination of SQL statements invalid in MySQL?

Hi there, I am trying to do a combination of SQL statements like described in a SQL bóok. Is it possible, that mysql does not allow this syntax? Thanx Andy Error: Occured during executing DELETE FROM test_user_interests WHERE user_id = (SELECT user_id FROM test_user WHERE user_name

[PHP-DB] How to install gdlibrary on windows 2000?

win 2k without a deep knowledge of c? Make does not work on windows, so I need a c compiler. This is deeper than I would like to go. Can it be that complicated to get this thing working? Thanx for any help cheers Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail

[PHP-DB] NC takes forever to connect to the db

the hack is going on? Does anybody have similar experiance? Thanx for any help! Cheers Andy -- 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

[PHP-DB] Data -> countinents, countries, provinces, cities >10.000

help. cheers Andy -- 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] Is MySQL enough for a huge amount of data?

, how could I optimize the table? Thanx for you help guys Cheers Andy -- 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] MyODBC returns only SQL errors while writing with MS ACCESS to MySQL

blem. Thanx for any help Cheers, Andy -- 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] MyODBC problem with MySQL and ACCESS

it as Memo and this works. How about integer? This does not work at all? Is there anywhere a table flying around where I can see which datatypes I have to use? Thanx for any help, Cheers Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For

[PHP-DB] How to speed up querries in a humangous db?

: char2 field3 : tinyint2 I have an index on field 2 and 3 The SQL Querry is searching for: field 2 AND field 3 Does anybody have an Idea how to spead this up? Thanx in advance, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

Re: [PHP-DB] How to speed up querries in a humangous db?

this is my sql statement: $stmt= " SELECT * from $geo_T3 WHERE country_code = '$country' AND province = '$province' order by city ASC "; cheers Andy "Miles Thompson" <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PRO

[PHP-DB] Backup of huge DB fails because of max execusion time

\07_production\actual\mysqladmin\tbl_dump.php on line 27 Does anybody know how to get this huge table transfered to my providers machine? Thanx in advance, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED

[PHP-DB] Potential for optimizing a huge table for querries?

: country_code province Type: MyISAM Querry on country_code AND province Does anybody know if this has potential to optimize? Cheers Andy -- 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

[PHP-DB] Iinserting into 250 tables filtered data automaticly. delaytime??

and the for loop requests the next one. So it does not work. Is there a delay function to make php wait for 3 min before proceeding, or does anybody have a better idea? Cheers Andy PS: Here is the code: $sql = " select country_code from countries "; $result2 = execute_stmt($

[PHP-DB] BUG in MySQL 3.23.42-nt

. Did anybody make the same experiance? Cheers Andy -- 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] How to write this querry?

something like that: delete from cities where NOT cities.province_id = provinces.province_id Does not work though :-( Can anybody help please? cheers Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED

[PHP-DB] db not visible if created from remote server

Hi there, I was uploading my db from my local machine to a server. mysqldump geodata | mysql -h 192.168.1.1 -u root geodata; Everything went ok. But the db is not visible for my application! I can see the db in mysqladmin, but my app does not? Anybody know what to do? Cheers Andy -- PHP

[PHP-DB] Making a Querry on two db possible?

Andy -- 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] How to compress a jpeg (qualitysetting) before saving it to the server?

;.jpg"); Thanx for any help. Cheers Andy -- 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] How to querry two db in a single statement?

Hi there, I would like to make a querry on 2 db. There is info in tables I would like to compare. As I know, there has first to be a conect on the db before the querry. But how to do this on 2 db?? Thanx for any help. Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

[PHP-DB] Array not supported for strings???

the same experience? Thanx for any help buddys. Regards Andy -- 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: Array not supported for strings???

try_code = '$country_id[$i]' "; if ( !($result = execute_stmt($stmt, $link) )){ HEADER("Location:empty"); } while ($row = mysql_fetch_object($result)){ //$country[] = $row->country; }; }; }; ####

[PHP-DB] Is this kind of querry possible in MySQL?

ly the ones with the proper country. I guess there has to be a subselect ore something like this. Maybe one of you guys have an idea. Cheers Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[PHP-DB] Logicproblem in WHERE statement

should also show all users from canada. How would this look like? SELECT * FROM table WHERE sex=1 AND country='CA' This is wrong I know. But how does it work??? Thanx for any help cheers Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROT

[PHP-DB] How to design a user table with 1 mio entries

and girls, Andy -- 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] How can recommend a book for SQL and DB design

Hi, I am searching for a good book on how to design a db for web apps. Normalisation rools, performancejust describing how to do it on a proffesional way. The second one, I am searching for is a book about SQL for MySQL. Any good books on the market? Thanx for the recommendation Andy

[PHP-DB] A-Z Listings

Hi There., I have a script that lists directorys then how many files are in each. although it won't list in an A-Z format, would anyone know how i would do this? Any help would be greatly appreciated and all required code is included below TIA Andy $system($co

Re: [PHP-DB] HELP! Manage MySQL

You can use phpMyAdmin at www.phpwizard.net Rosen wrote: > Hi, > Can someone tell me how can I manage > MySQL database on remote server ( With what software ) ? > > Thanks, > Rosen Marinov > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For

RE: [PHP-DB] Apache not compiling php

alk about php3 files, does that mean they have the extension .php3? In which case you will also need to add a line similar to; AddType application/x-httpd-php3 .php3 Hope that gives you some starters :-; -- Andy Flisher 'We are but packets in the Internet of Life'

[PHP-DB] phpMyAdmin produces error on PHP

ation. DOCUMENTATION (link)" I have checked the documentation, and it says to install a package called PHP-MySQL. I have downloaded this and (i think) installed it. But the error message remains. I am not that great with Linux - so any help you can provide will be very appreciated. Thank you Andy

Fw: [PHP-DB] PhpmyAdmin from external computers

I do not get an error message as such. I goto http://serverIP/phpmyadmin/index.php - and it logs me inautomatically as localhost, i can see the database lists on the side panel etc. I click on a database or create a new database and the login screen comes up. I try entering the root password a

Fw: [PHP-DB] PhpmyAdmin from external computers

Im afraid ive already tried that. - Original Message - From: "mike karthauser" <[EMAIL PROTECTED]> To: <> Sent: Thursday, December 04, 2003 3:10 PM Subject: Re: [PHP-DB] PhpmyAdmin from external computers > > I goto http://serverIP/phpmyadmin/index.php - and it logs me > > inautomati

[PHP-DB] PhpmyAdmin from external computers

Hi I have phpMyAdmin installed on my red hat 8 box with mysql 3. It works fine on that computer and phpmyadmin gives me full access to the database. However, when i connect to that computer from my windows computer and go to the phpmyadmin url it wont let me do anything. Ive set all the priveleg

[PHP-DB] odbc_connect() failure

works fine, so I am also ruling out a MySQL configuration issue (such as localhost not being in the grant tables). Does anyone know what else I should be looking for here? I will paste the contents of my odbc.ini file as well if this would help anyone. Thanks, Andy ; ; odbc.ini configuration fo

Re: [PHP-DB] how to do query on partial field contents ???

t: $query .= " AND `model` LIKE '%".$_GET['search']."%'"; Is it will return many results if $_GET['search'] is very small like one letter. And bear in mind that there's could be a nasty SQL injection problem with that code if $_GET['search

[PHP-DB] Re: insert data in mysql table

From what I can see, the order that you created the table with and the order of the fields in the query do not match up. Changing the query to: $add_all = "INSERT INTO $table values('','$name','$day','$question','$email',''

[PHP-DB] Re:*FIX* insert data in mysql table

Oops. I left a field in. Change it to: $add_all = "INSERT INTO $table > values('','$name','$day','$question','$email')"; Andy Andy Ladouceur wrote: From what I can see, the order that you created the table with and the order of

[PHP-DB] I am new to PHP

Hi. This is the qmail-send program at pb1.pair.com.I'm afraid I wasn't able to deliver your message to the following addresses.This is a permanent error; I've given up. Sorry it didn't work out.<[EMAIL PROTECTED]>:ezmlm-manage: fatal: I don't accept messages at this address (inlocal and/or inho

[PHP-DB] I am new to PHP

Hi, I have a problem with the second file. I am not able to update the data from the php program. Any help on that would be appreciated. Any modification which would be reduce the code like directly using the Update command would be appreciated. thanks in advance. Here are the 3 files. /

[PHP-DB] Hi I am new to PHP

I have posted my problem at No: 33892 of this mailing list. I have received 1 reply. No: 33897 My exact problem with second file is as follows: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource on line 15 Can you help me to solve problem, any help would be app

[PHP-DB] Hi I am new to PHP

Hi, I have a problem with the second file. I am not able to update the data from the php program. Any help on that would be appreciated. Any modification which would be reduce the code like directly using the Update command would be appreciated. thanks in advance. My exact problem with sec

[PHP-DB] Basic Doubts

hi, I want to know the following things. 1. How can we maintain referential integrity (rather check) using PHP Any example code will be helpful. 2. I want to display the column of the tables, how to do that. 3. I want to align the text and the text box on the page. 4. I also want to che

[PHP-DB] Regular Expression

Hi, I would like to test whether a given sting contains only character, it should also support spaces. eg "Course Book String". I am able to test "CourseBookString". Also I would like to know how can we avoid wild chars like *, or any other char apart from alpha numeric char. Thanks.

[PHP-DB] Re: Regular Expression

A regexp like this should work: /^([a-zA-Z]|\s)+$/ Cheers, Andy Ladouceur Andy Amol wrote: Hi, I would like to test whether a given sting contains only character, it should also support spaces. eg "Course Book String". I am able to test "CourseBookString". Also I would

Re: [PHP-DB] Re: Regular Expression

called the previous form, so it clears all the values. Any help in appreciated. Thanks in advance. bye. Kelly Hallman <[EMAIL PROTECTED]> wrote: Apr 18 at 11:01pm, Andy Ladouceur wrote: > Andy Amol wrote: > > I would like to test whether a given sting contains only character, i

[PHP-DB] Drop-down box in php

hi, I would like to know how to create and populate drop down boxes in php. I want the value to be populated from database. What I am try to do is to provide the forign key value as combo box option, so that I do not have to check for referential integrity. Thanks in advance.

[PHP-DB] Drop-down box in php

hi, I would like to know how to create and populate drop down boxes in php. I want the value to be populated from database. What I am try to do is to provide the forign key value as combo box option, so that I do not have to check for referential integrity. Also if you can help me with a date

Re: [PHP-DB] Drop-down box in php

hi, I am using the following code, but it is not populating my script. If you can help I would be grateful. I am using mysql as database. $typedesc"; } ?> thanks. "John W. Holmes" <[EMAIL PROTECTED]> wrote: From: "andy amol" > I would like to

[PHP-DB] Re: stuck on stupid...can't find the bloody error...

echo "\n"; } else {echo "OOPS! Your programmer is an idiot!\n";} Try this: if (([EMAIL PROTECTED]($query_insert)) != FALSE) { ... echo HTML ... } else {echo "Oops! Your programmer is broken. Oh and here's what MySQL said: \n".mysql_error();} Hopefully t

[PHP-DB] How to display table columns

hi, I want to display the table coulumns along with those values below it. I am only able to display the table values, now I want to diplay the corresponding table attribut above the value. eg : name age sex abc1m xyz 2f I want to displa

[PHP-DB] Re: How to display table columns

I think what you may be looking for is the DESCRIBE command. It allows you to get information about table columns. http://dev.mysql.com/doc/mysql/en/DESCRIBE.html Andy Andy Amol wrote: hi, I want to display the table coulumns along with those values below it. I am only able to display the

[PHP-DB] Re: passing var array

You can pass arrays via GET using the syntax: http://localhost/index.php?val[1]=one&val[2]=2&...val[key]=value Andy Pete M wrote: http://localhost/index.php?val_one=one&val2=2 on index.php print_r($_GET) will show the array echo "val l=".$_GET['val_one']; echo

[PHP-DB] login script

hi, does anyone have a login script which will take data from the table and decide whether the given user is a admin or a normal user. thanks in advance. Also if there is some help on session variable I would like to know. - Do you Yahoo!? Win

[PHP-DB] Load balancing and SQLite

there be a noticeable performance impact when opening the database files remotely? Thanks in advance for any responses, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] airport codes db

Or you could go here: http://flyaow.com/airportcode.htm Andy -Original Message- From: Edward Peloke [mailto:epeloke@;echoman.com] Sent: Wednesday, November 13, 2002 1:32 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP-DB] airport codes db great idea...I am setting up a

Re: [PHP-DB] listing

s his class to allow the templating of summary rows as well as individual data rows--both subtotals and totals for a given field or fields--all specified in your HTML template separate from the PHP code.) Yours, Andy At 11:41 AM -0700 on 8/23/01, you wrote: > >>Hello again, >> &

[PHP-DB] Re: appear in Text file

Hi Jack, The 'black box' you see is a newline, which can be removed by doing this: $string=str_replace("\n","",$string); $string=str_replace("\r","",$string); That will replace \n (The newlines) and \r (The returns) with nothing, getting rid of

[PHP-DB] PHP + Interbase / Firebird extensions

Many thanks! Andy Neillans -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] MySQL query failing on apostrophe in data

try putting a \ before the apostrophe -Original Message- From: Dillon, John [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 12:59 PM To: 'PHP-DB' Subject: [PHP-DB] MySQL query failing on apostrophe in data How do I avoid the problem in the subject hereto? SELECT query uses va

[PHP-DB] session variables when accessing the same page

Working with storing and reusing session variables. If I use t1.php to generate a form, and the form calls t2.php, the session vars are available. If upgrade t1.php to recognize if it is the first time it has been called versus the second time e.g. if (isset($some_session_var)) { generate_

[PHP-DB] Re: session variables when accessing the same page

Figured it out. I was trying to use the same associative array under the tag as I was trying to save under the session. Using two different variable constructs worked. Andy Cantrell wrote: Working with storing and reusing session variables. If I use t1.php to generate a form, and the form

[PHP-DB] Need help with a tricky query

I'm trying to write a query that pulls details on a game record, as well as the officials assigned to the game (up to 4 officials may be assigned to each game, but that's not always the case). Game details are in the games table, and assignments are in the games_referees table (which I alias as re

Re: [PHP-DB] Displaying Password

e are two-way encryption methods requiring the use of a common key, and an initialization vector for some protocols - see the mcrypt library which PHP can use (I had a play around with it quite recently.) http://uk2.php.net/manual/en/function.mcrypt-decrypt.php Regards, Andy -- PHP Database Mailing

Re: [PHP-DB] Displaying Password - orale...

;t know of any other companies that do PHP qualifications, but as Zend is "the PHP company" anyway they probably mean more :P Hope this helps you anyway. Regards, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] RE: Help for a beginner

calhost" creates an IPv6 connection. Some utilities (e.g. telnet) fall back to trying IPv4 if the v6 connection fails. Regards, Andy

[PHP-DB] Parse Problem

and categories correctly. If there weren't multiple products for each category I think I would have it. Any help would be a start. Thanks in advance Andy ARD Drive Consultants Drive to Perfection Rolls-Drew, Andrew Director ARD Drive Consultants Ltd 169 Nottingham Roa

Re: [PHP-DB] DB interface problem

etter! Andy On 27 October2009, at 12:48, Giff Hammar wrote: I started having trouble with a DBI interface to my PostgreSQL database after I built a new Ubuntu machine. The Postgres version is 8.3 and the DBI was written several years ago (by someone else). I'm using PHP version 5.2.6-3ubun

Re: [PHP-DB] DB interface problem

res" is. And lastly, you could get a back-trace of the rows() method call to see if it's being called before $this->res has been assigned - just add the line "var_dump(debug_backtrace());" between lines 201 and 202. Hope this gives you a starting pointer! Regards, And

Re: [PHP-DB] DB interface problem

27;s not happening - it's getting further down the line, which is why I think $this->res is not being persisted across method calls. Andy

Re: [PHP-DB] DB interface problem

/manual/en/function.pg-prepare.php http://www.php.net/manual/en/function.pg-query.php After a quick glance through your code, I think pg_query is what you want. HTH, Andy On 27 October2009, at 22:06, Giff Hammar wrote: Andy, Thanks for your help! The var_dump after the pg_execute showed that

Re: [PHP-DB] Very old question: Mysql and old authentication

MySQL client library (libmysql) instead of the newer mysqlnd. Andy On 29 October2009, at 20:05, SuNcO wrote: Recently we update our Local Server to this: Apache Version : 2.2.11 PHP Version : 5.3.0 MySQL Version : 5.1.36 All works fine locally, but when we want to connect to a Remote Mysql S

Re: [PHP-DB] Very old question: Mysql and old authentication

-Remote Server "old_passwords" "ON" "version" "5.0.45" That's probably why - as I said in my previous e-mail, the mysqlng driver doesn't support the old authentication mechanism. If you cannot change the remote server, you need to re-compile PHP with the MySQL client library (libmysql)

Re: [PHP-DB] losing MySQL resource

s if the connection is alive and valid - if it isn't, it reconnects it before running the query. Andy On 9 November2009, at 16:46, Stan wrote: How do I make an Object persistant for the duration of a Session? Thanks, "Chris" wrote in message news:4AB6B16C. 8...@gmail.com...

Re: [PHP-DB] losing MySQL resource

it's a valid resource (is_resource() springs to mind.) If it isn't valid, you need to re-create it (using mysql_connect). The reason for this is that PHP isn't running between session requests, so it cannot maintain and monitor the database connection across requests. Andy On

Re: [PHP-DB] Multiple instances of mysql_connect() in single PHP document.

ation to another database. Regards, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Combing PDO with mysql_pconnect connections in one application -- will this degrade performance?

that server and use your previous connection. As Chris pointed out, make sure PDO will also use persistent connections. Regards, Andy

Re: [PHP-DB] Combing PDO with mysql_pconnect connections in one application -- will this degrade performance?

mysql_* family of functions anyway so it shouldn't make a difference whether you're using libmysqlclient or mysqli. Regards, Andy

<    1   2