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

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] 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] 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

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] 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] 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] 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] 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] 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] 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] 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

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

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

[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

[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

[PHP-DB] PHP compile error: Cannot find mysql header files

onfiguring PHP, I'm using this: [EMAIL PROTECTED] mysql]# ./configure --with-apache=../apache_1.3.31 --with-mysql=/usr/bin/mysql This is the Error: configure: error: Cannot find MySQL header files under /usr/bin/mysql When I search for mysql.h, I get this: [EMAIL PROTECTED] local]$ locate mys

[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

[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] 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] 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] 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: 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

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] 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

[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.

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] 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

[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] 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] 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] 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] 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] 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] 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] 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',''

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] 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

[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

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

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

[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

[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] 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_

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] 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

[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] 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

[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] 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] 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] 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] 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

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] 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

[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

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

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

hmm.. thats how I am doing it right now. There might be a better way?! "Raquel Rice" <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > On Sat, 10 Aug 2002 16:46:54 +0200 > "andy" <[EMAIL PROTECTED]> wrote:

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

, but cant remember where and how, all tryes did not succeeed so far. 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] Re: sucking news out of the usenet

sorry for posting into the wrong forum. My mistake! "Andy" <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi guys, > > I am trying to build a usenet gateway which is collecting usenet posts and > puts them into

[PHP-DB] sucking news out of the usenet

se help me, many thanks sebastian . Lots of text.. puhh! I hope this is somehow possible. Maybe one of you guys has a good idea on that. You can just cut and past the code underneath and try it out by yourself. Thanx for any help on that. Andy - http://www.OZforu

[PHP-DB] escaping line brakes

that? Thanx for any help, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] how can this be? GET instead of POST -> db error

where this GET request could come from. This has caused a empty sql statement and therefore a db error. How can could this be achieved? By clicking back in the browser window? I dont think so since the same user was on another site before. Has anybody a idea on that? Andy -- PHP Database Ma

[PHP-DB] sort problem

sort the other arrays with the same sorting algo? Or a way to include a iff clause in the query? currently I am doing: SELECT u_name, id, points FROM user WHERE points > 0 ORDER by points desc LIMIT 5 and the top10 reports extra. Has anybody a good idea on that? Andy --

Re: [PHP-DB] Calculating inside query?

oh I see! There have been '' values in some columns. Thanx Andy "Ryan Jameson" <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... do both of the fields contain values and are they both numeric? It sure seems strange to me

Re: [PHP-DB] Calculating inside query?

[EMAIL PROTECTED]">news:[EMAIL PROTECTED]... i assume you're using MySQL because of the Limit clause, but what error are you receiving? -Original Message- From: andy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 10, 2002 10:34 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] C

[PHP-DB] Calculating inside query?

see the error: Mysql: SELECT ID, rating_total / ratings_amount AS top10 FROM rating ORDER BY top10 desc LIMIT 10 Thanx for any help, Andy query -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] resizing images comming out of blobs

Hi there, I am wondering how to resize an image which is stored in a mysql blob field. With files this workes just fine, but how to do this with the image comming from blob? Has anybody done this already? Thank you for any help on that, andy -- PHP Database Mailing List (http

[PHP-DB] storing content data outside the application

by the client anymore. Does anybody know a good method to store the images outside the rootfolder and still access them the old fashion way? Any suggestions are appreciated. Thanx, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] blob versus file

schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > On Mon, 1 Jul 2002 14:17:53 +0200 > "andy" <[EMAIL PROTECTED]> wrote: > > > Hi there, > > > > I am wondering if anybody has experiance in saving images to blob in mysql. > &

[PHP-DB] blob versus file

show up on the site. Is there a way to improve the performance, and why is this happening? I thought the performance might even boost after storing them to blobs. Thank you for any comments on that, Andy PS: I was planing to store all the other images (20 - 50 KB) to blobs as well (thousands

[PHP-DB] Re: [PHP] saving temporary image to database

t;>news:[EMAIL PROTECTED]... > There is no imagejpeg() call in the code snippet you provided. And you > don't say how it is failing. You haven't provided us with enough data to > answer this question. > > -Rasmus > > On Sat, 29 Jun 2002, andy wrote: > > > Hi

[PHP-DB] Re: MySQL query from multiple tables

tables with the same id*/ AND pf.yourcriteria = whatever /* put your criteria for table 2 here*/ Hope this helps a bit, Andy -- -- http://www.globosapiens.net Global Travellers Network "Matthew Nock" <[EMAIL PROTECTED]> schrieb im

[PHP-DB] Re: question from newbie

use you are not allowed to start with an OR. But you get the idea? Hope this helps, Andy -- http://www.globosapiens.net Global Travellers Network! "Chris Barnes" <[EMAIL PROTECTED]> schrieb im Newsbeitrag 000201c21ace$65e66ba0$[EMAI

[PHP-DB] Re: Converting values from text to numerical

and y. Good luck, Andy -- http://www.globosapiens.net Global Travellers Network! "Matthew Nock" <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I am about to build a dat

[PHP-DB] Re: Resetting auto_incremented values

sorry buddy, as far as I know you can't. The only thing you can do is to set the counter higher but you can't return to a value under the given row. Please correct me if I am wrong, Andy -- http://www.globosapiens.net Global

[PHP-DB] Re: Copy table

the easiest way would be if you install myphpadmin which is a awesome free mysql webadmin tool. You can get it at http://www.hotscripts.com/Detailed/7180.html Have fun, Andy -- http://www.globosapiens.net Global Travellers Network

[PHP-DB] dumping only selected records into another table

put: INSERT INTO beaches VALUES ('','Carrabelle Beach','US','9'); does anybody know how to do this? Thanx for any help, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] dumping only selected records into another table

put: INSERT INTO beaches VALUES ('','Carrabelle Beach','US','9'); does anybody know how to do this? Thanx for any help, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] dumping only selected records into another table

put: INSERT INTO beaches VALUES ('','Carrabelle Beach','US','9'); does anybody know how to do this? Thanx for any help, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] dumping only selected records into another table

put: INSERT INTO beaches VALUES ('','Carrabelle Beach','US','9'); does anybody know how to do this? Thanx for any help, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] addslashes for db search?

I have to change this db entries, and if how? How should they look like and is there a good method to change all this thousands of records at once? Thanx in advance, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: MyCC Problem

maybe you do not have the propper rights set. Check your grant privillegs on the db. Andy -- http://www.globosapiens.net Global Travellers Network! "César l . aracena" <[EMAIL PROTECTED]> schrieb im Newsbeitrag 002a0

[PHP-DB] Re: Slow performance (PHP & MYSQL)

PHP is known to be verry fast. MySQL as well. So your problem my be somewhere else. I am doing a similar thing on my site with thumbnails. Check it out on http://www.globosapiens.net Andy -- http://www.globosapiens.net Global Travellers

[PHP-DB] date problem

stamp june 1, 02 SELECT COUNT(*) AS c FROM users_table WHERE UNIX_TIMESTAMP( user_regdate ) > '1022882400' Thanx for any help on that, andy query -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] date problem

stamp june 1, 02 SELECT COUNT(*) AS c FROM users_table WHERE UNIX_TIMESTAMP( user_regdate ) > '1022882400' Thanx 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] how to create a graph from a db?

Hi Chris, this is very easy done with a library called jpgraph. Check out: http://www.aditus.nu/jpgraph/ A nice example can be found on my website at: http://www.globosapiens.net/community/03010001.html Hope this helps, Andy -- http

[PHP-DB] Converting non latin characters

lp on that, Andy http://www.globosapiens.net Global Travellers Network! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: [PHP] Ho to write output of sql query to txt file?

OK, 35 rows affected (0.04 sec) Records: 35 Deleted: 0 Skipped: 0 Warnings: 630 The warning already tells it. the datasets are totally empty. Only default of the columns is set. do u have an idea why? Thanx, Andy - Original Message - From: "Jay Blanchard" <[EMAIL PR

[PHP-DB] Ho to write output of sql query to txt file?

other db on the other machine. Is this possible? Thank you for any help, andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] php is connecting to the wrong mysql server

running but how could I tell php to connect to the right server? 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] problems with storing image data to the db

o the db, but it did not change anything. Thank you so much for any hint, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] How to store an image into a db?

Hi there, I recently heard about storing images in a blob column in MySQl. Now I am wondering how to do that. I mean isn't there a potential security problem because of buffer over flow? How would I do that with php anyway? Thank you guys for any hint. Andy -- PHP Database Mailing

[PHP-DB] Problem with JOIN

'3' Somehow my syntax must be wrong, but I can not find the error :-( Maybe one of you guys does know why. Thanx in advance, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: displaying records

table_name WHERE criteria LIMIT 1,10 This will pull out the first 10 records http://www.mysql.com/doc Hope this helps, Andy "Natividad Castro" <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi to all, > I'm displ

[PHP-DB] Re: 50.000 records, 2 values and 1.5 s to find out?!!

oh... on MySQL "Andy" <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi there, > > I have a user table, containing a column on gender. Type is tinyint(1) and 1 > is male 2 is female. No index. 5 entr

[PHP-DB] 50.000 records, 2 values and 1.5 s to find out?!!

? SELECT count(*) AS c FROM .user where sex = 1 takes about half the time :-) So maybe some of you guys do have some experiance on that. This is just way to long. I appreciate every help on that, Thanx in advance, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

[PHP-DB] mysql crashed and created huge .MYI files. All data lost? :-((

anybody know what happened here? I hope I do not need to role out my backup tapes :-( Thanx for any help, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] indexing text fields in mysql ?

smalltext columns as the info may vary between 1 and 1000 chars. 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] sw for printing out a db shema for mysql

Hi there, I am wondering if there is already a sw for printing out db shema. Like all tables with its structure. Maybe someone has already done some nice php code on that? thanx, Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

  1   2   >