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

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

(e.g. telnet) fall back to trying IPv4 if the v6 connection fails. Regards, Andy

Re: [PHP-DB] Displaying Password

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 List (http://www.php.net

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

you're using libmysqlclient or mysqli. Regards, Andy

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

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

. 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

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 dmag...@gmail.com wrote in message news:4AB6B16C. 8...@gmail.com... Niel Archer

Re: [PHP-DB] losing MySQL resource

if 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 9 November2009

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

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 Server

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] DB interface problem

! 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-3ubuntu4.2

Re: [PHP-DB] DB interface problem

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, Andy On 27 October2009, at 19:36, Giff Hammar wrote: Andy, Sometimes I'm too fast for my own good. I added

Re: [PHP-DB] DB interface problem

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

[PHP-DB] Parse Problem

manage to split the products 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

[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

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

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 mysql.h /home/andy

[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] Re: passing var array

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

[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: stuck on stupid...can't find the bloody error...

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: br /\n.mysql_error();} Hopefully that works for you. I think the problem may be the escapes quotes. Cheers, Andy -- PHP

[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

[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

[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

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

)) { $type = $row[course_id]; $typedesc =$row[dept_id]; $option_block .= OPTION value=\$type\$typedesc/OPTION; } ? SELECT name=selecttype id=selecttype ? echo $option_block; ? /SELECT thanks. John W. Holmes [EMAIL PROTECTED] wrote: From: andy amol I would like to know how to create

[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 like to know how can we

Re: [PHP-DB] Re: Regular Expression

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, it should also support spaces. eg

[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

[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

[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

[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

[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] 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',''); Should make things run just fine. Cheers, Andy Charalambos Nicolaou

[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 the fields in the query do not match up. Changing the query

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

'].%'; 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'] hasn't been SQL escaped in some way. -- Andy Armstrong, Tagish -- PHP Database Mailing List (http://www.php.net

[PHP-DB] odbc_connect() failure

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 for MyODBC and MyODBC 3.51 Drivers ; [ODBC Data Sources

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

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 inautomatically as

[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

[PHP-DB] phpMyAdmin produces error on PHP

. 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 form 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)) {

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

[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 ? function romcount($system, $counter

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

[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] schrieb im Newsbeitrag

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

'; ### 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 Mailing List (http://www.php.net/) To unsubscribe, visit

[PHP-DB] uploading images before creating db entry

with 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

[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

:-( 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$0100a8c0@stuart... Hi Andy, In answer to part two - here's a snippet of code I use to h

[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

[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

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: Hi there, I am searching for the

[PHP-DB] sucking news out of the usenet

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.OZforum.info Australia Information

[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 a phpbb forum. Same other way arou

[PHP-DB] escaping line brakes

of 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

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 Mailing List (http

[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

Re: [PHP-DB] Calculating inside query?

]">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] Calculating inside que

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. I actually create

[PHP-DB] sort problem

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

[PHP-DB] blob versus file

) to 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

Re: [PHP-DB] blob versus file

in the img tag with the statement inside and output them before sending a jpeg header with an echo) Thanx for your help, Andy Pierre-Alain Joye [EMAIL PROTECTED] schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... On Mon, 1 Jul 2002 14:17:53 +0200 andy [EMAIL PROTECTED] wrot

[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 Newsbeitrag news:[EMAIL

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

ppet 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 there, I would like to save a jpg into a blob field of mysql. The function underneath works fine if I read the im

[PHP-DB] Re: question from newbie

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$[EMAIL PROTECTED]">news:0002

[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 database of products that wi

[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! Rosen

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

[PHP-DB] addslashes for db search?

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] dumping only selected records into another table

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

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

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

','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] 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 002a01c20e80$743a3650$14ed0dd1

[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

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

[PHP-DB] date problem

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] Ho to write output of sql query to txt file?

to the 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] Re: [PHP] Ho to write output of sql query to txt file?

) 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 PROTECTED] To: 'andy' [EMAIL PROTECTED]; [EMAIL PROTECTED

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

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] php is connecting to the wrong mysql server

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

[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 displaying a set of records in differe

[PHP-DB] Problem with JOIN

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: 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 entries This statement: SELECT sex, count

[PHP-DB] indexing text fields in mysql ?

or 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] 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] problem with grant

is: Connection failed: 1045- Access denied for user: [EMAIL PROTECTED] (using password NO) What's wrong with my grant table statement? Or is there somehow a firewal involved? php works with db access. I am running it on suse7.2 Thanx for your help guys Andy -- PHP Database Mailing List (http

Re: [PHP-DB] problem with grant

can you send me the link for the english mysql user group, please. I did search a while for this link on mysql.com but did not find any. Thanx in advance, Andy Jason Wong [EMAIL PROTECTED] schrieb im Newsbeitrag news:[EMAIL PROTECTED]... On Saturday 11 May 2002 19:19, andy wrote: Hi

[PHP-DB] stmt should return user-id only once. difficult select statement.

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

Re: [PHP-DB] stmt should return user-id only once. difficult select statement.

unfortunatelly not. I did already try this. It does not make a difference. Still three results for each user do you have another idea? thanks, Andy Ryan Jameson [EMAIL PROTECTED] schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... This may only be preference but you'

  1   2   >