Re: [PHP-DB] use php variable within postgresql query

2023-06-09 Thread G. Franklin
My friends, Would not the syntax of "$query=$_GET['databasecolumn'[;" be part of the issue? I believe the brackets should be closed like this, no? "$query=$_GET['databasecolumn'];" ~G. On Fri, 9 Jun 2023 at 10:53, Aziz Saleh wrote: > Read and understand these, sho

Re: [PHP-DB] French and Spanish Accent Letters

2010-11-10 Thread Andrés G . Montañez
=utf8_unicode_ci; Cheers. -- Andrés G. Montañez Zend Certified Engineer Montevideo - Uruguay -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] big table / hadoop / map reduce

2010-10-30 Thread Andrés G . Montañez
it still work : ) I want to write some simple map reduce like the one above just to see it working and play around a bit :) cheers Art On 22 October 2010 16:49, Andrés G. Montañez andresmonta...@gmail.com wrote: Imagine you have to get track of some kind of traffic, for example, ad

Re: [PHP-DB] Variable Assignment

2010-10-28 Thread Andrés G . Montañez
the manual that corresponds to your MySQL server version for the right syntax to use near '$st=1000' at line 1 Ethan MySQL 5.1  PHP 5  Linux [Debian (sid)] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Andrés G. Montañez Zend

Re: [PHP-DB] Incrementing Primary Key

2010-10-27 Thread Andrés G . Montañez
for each site will be enough, as Jimmy suggests. -- Andrés G. Montañez Zend Certified Engineer Montevideo - Uruguay -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Incrementing Primary Key

2010-10-27 Thread Andrés G . Montañez
- From: Andrés G. Montañez [mailto:andresmonta...@gmail.com] Sent: Wednesday, October 27, 2010 9:19 AM To: Ethan Rosenberg Cc: php-db-lists.php.net Subject: Re: [PHP-DB] Incrementing Primary Key Hi Ethan, in this case, you should manage the keys by your application, and store the used ids

Re: [PHP-DB] Parsing Tab Delimited file

2010-10-24 Thread Andrés G . Montañez
-- Andrés G. Montañez Zend Certified Engineer Montevideo - Uruguay -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] How to Sync MySQL with iPhone or Google Contacts

2010-10-23 Thread Andrés G . Montañez
! - Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Karl DeSaulniers Design Drumm http://designdrumm.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Andrés G

Re: [PHP-DB] How to Sync MySQL with iPhone or Google Contacts

2010-10-23 Thread Andrés G . Montañez
-- if not completely, in part.   Again, it would be best to sync directly to the iPhone, but if the server would sync with the Google calendar and Google sync'd with the iPhone, that would be an acceptable 2nd choice. Thanks again for your reply! - Ron On 10/23/2010 5:47 AM, Andrés G. Montañez wrote

Re: [PHP-DB] How to Sync MySQL with iPhone or Google Contacts

2010-10-23 Thread Andrés G . Montañez
be tempting to build an app for this, but we don't have a single Mac in the place. Maybe syncing with Google is the way to go?  That would keep the iPhone out of the equation.  (This is not intended for the market.) Thanks, - Ron On 10/23/2010 2:16 PM, Andrés G. Montañez wrote: Hi Ron

Re: [PHP-DB] big table / hadoop / map reduce

2010-10-22 Thread Andrés G . Montañez
at it here? cheers -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Andrés G. Montañez Zend Certified Engineer Montevideo - Uruguay -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] big table / hadoop / map reduce

2010-10-22 Thread Andrés G . Montañez
with design patterns ... people who dont understand them should not write articles trying to explain them to others :P Art On 22 October 2010 15:29, Andrés G. Montañez andresmonta...@gmail.com wrote: Hi Artur, Here is an article on wikipedia: http://en.wikipedia.org/wiki/MapReduce And here

Re: [PHP-DB] NULL to 0

2010-07-17 Thread Andrés G . Montañez
SELECT IFNULL(SUM(`my_Bible_trivia_knowledge_questions_answered`.`score`), 0) AS total_score, IFNULL(`my_Bible_trivia_knowledge_profile`.`questions_answered`, 0) AS questions_answered In these cases you must use the IFNULL function, for testing the value. -- Andrés G. Montañez Zend Certified

Re: [PHP-DB] Is this Code Correct??

2010-02-11 Thread Andrés G . Montañez
to link with: echo  Name: .a herf='$url'.$runrows['name']; Is above code is correct ?? Best, -- Guru Prasad Ubuntu Voice GTK+ Forum -- Atte, Andrés G. Montañez Zend Certified Engineer Montevideo - Uruguay -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] Is this Code Correct??

2010-02-11 Thread Andrés G . Montañez
/download.php?url=mj_bad_track01.mp3 I want to connect the url directly to the MP3 file so that user can download the MP3. Best, -- Andrés G. Montañez Zend Certified Engineer Montevideo - Uruguay -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] comparing stored timestamp with NOW()

2009-02-24 Thread Andrés G . Montañez
(UNIX_TIMESTAMP() - 1235861716) = (3600*24*7) AS valid FROM dual; +---+ | valid | +---+ | 1 | +---+ Enjoy. -- Atte, Andrés G. Montañez Zend Certified Engineer Montevideo - Uruguay -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Aborting long running DB queries with browser Stop button

2009-02-06 Thread G
Hello, I've run into a brick wall implementing functionality in my PHP scripts to detect when the user has hit the Stop button so that I can abort my long running DB queries. Apache 2.2.9, PHP 5.2.6-5 with Suhosin-Patch, MySQL 5.0.67 running on a Debian unstable machine. As a simple test case, I

Re: [PHP-DB] resources and resource types

2008-03-31 Thread Andrés G. Montañez
://www.php.net/manual/en/function.get-resource-type.php -- Atte, Andrés G. Montañez PHP Senior Técnico en Telecomunicaciones Montevideo - Uruguay -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Efficient way to access MS SQL server

2008-01-31 Thread Leo G. Divinagracia III
charlie wrote: The native SQL driver for PHP has a problem with a limit on the number of characters in a string, so can't use that. hmmm interesting. how much is the limit? i used PHP's mssql_* functions and while i only used about 20 chars on a character search string in the WHERE, i

Re: [PHP-DB] md5() function

2008-01-14 Thread Andrés G. Montañez
readable condition. Is there a function opposite to md5()?? Best Regards, M Guirao -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Atte, Andrés G. Montañez Técnico en Redes y Telecomunicaciones Montevideo - Uruguay -- PHP Database

Re: [PHP-DB] Re: backup of database record before update

2007-10-31 Thread Leo G. Divinagracia III
Stephen Sunderlin wrote: Neil, Have you had success with triggers. I couldn't get one to work and then saw discussion on the board here that MYSQL triggers were not so reliable and still somewhat problematic so I archive through the application. Just curious. i have used a couple simple

Re: [PHP-DB] What is the most efficient way to store SELECT results

2007-10-12 Thread Leo G. Divinagracia III
Robert Palmer wrote: I'm not I was clear in my question. A query returns 1,000 rows from the table. I want to store the entire result of that query in order to be able to create separate pages to return the results rather than all on one page e.g. Page 1 2 3 4 ... . Not sure if it's

Re: [PHP-DB] Looking for a small open-source PHP-DB app that utilize OOP.

2007-09-28 Thread Leo G. Divinagracia III
check out UCCASS. not only oop, but smarty as well... http://www.bigredspark.com/survey.html -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Pages not fully loading

2007-09-21 Thread Andrés G. Montañez
if there is no inusual activity, like segmentations faults, etc. Good luck. -- Atte, Andrés G. Montañez Técnico en Redes y Telecomunicaciones Montevideo - Uruguay -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] widthheigh

2007-03-30 Thread Andrés G. Montañez
. -- Atte, Andrés G. Montañez Técnico en Redes y Telecomunicaciones Montevideo - Uruguay -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Email Article, Print Article

2005-10-03 Thread Leo G. Divinagracia III
to strip out all of the fancy tables and graphics and stuff in the printed page option. plus, i use this trick to read a site that separates the article into multipages. when you click on the PRINTED option, it dumps the whole article into a graphics free format... ;) -- Leo G. Divinagracia

[PHP-DB] Postgres Bytea Field + Adodb

2005-06-14 Thread Andrés G . Montañez
Hi, someone can helpme with inserting a binary data (from a file) to a Postgres Database with the ByteA field, i'm using the ADOdb class. THX -- Atte, Andrés G. Montañez Técnico en Redes y Telecomunicaciones Montevideo - Uruguay -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

Re: [PHP-DB] Newbie with mail problem

2005-06-07 Thread Andrés G . Montañez
Use a real hostname, not 'localhost'.- -- Atte, Andrés G. Montañez Técnico en Redes y Telecomunicaciones Montevideo - Uruguay -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] How many rows for 100 questions?

2005-05-28 Thread Andrés G . Montañez
select a pre-defined answer OR input, a MIX of both solutions. -- Atte, Andrés G. Montañez Técnico en Redes y Telecomunicaciones Montevideo - Uruguay -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] multiple queries, one transaction - REWORDED

2005-05-22 Thread Andrés G . Montañez
If (! (INSERT . (order, ItemID (the array key), ItemQty (the array value of the key))...)) rollback transaction break end foreach commit transaction So if the insert is failed, you rollbackit. No need for a DELETE -- Atte, Andrés G. Montañez Técnico en Redes y Telecomunicaciones

Re: [PHP-DB] PHPMySQL left/substring etc problem

2005-04-19 Thread Andrés G . Montañez
But when I tried, select left (loc1,3) from openart_table where.. Try without the space between 'left' and '(', I mean... LEFT(loc1, 3) where loc1 is the name of the column, and 3 the characters you want to show. -- Atte, Andrés G. Montañez Técnico en Redes y Telecomunicaciones Montevideo

Re: [PHP-DB] stuck on module of apache

2005-04-17 Thread Andrés G . Montañez
is located # will be used by default. It is recommended that you always supply # an explicit drive letter in absolute paths, however, to avoid # confusion. -- Atte, Andrés G. Montañez Técnico en Redes y Telecomunicaciones Montevideo - Uruguay -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] using POST data for a readfile

2005-04-13 Thread Andrés G . Montañez
I didn't mean to offend or say your way was wrong. I was just offering an alternative method. Oh no, you didn't offended me in anyway! I was saying that my example should not be used, because it do not work. -- Atte, Andrés G. Montañez Técnico en Redes y Telecomunicaciones Montevideo

Re: [PHP-DB] using POST data for a readfile

2005-04-12 Thread Andrés G . Montañez
I give the exaple just as an guide not a working one. -- Atte, Andrés G. Montañez Técnico en Redes y Telecomunicaciones Montevideo - Uruguay -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] using POST data for a readfile

2005-04-11 Thread Andrés G . Montañez
You should use some JavaScript. Try something like this: form name=downloads medoth=post action=callFile.php input type=hidden value=test.pdf a href=# onclick=document.downloads.submit(); target=_blank /form -- Atte, Andrés G. Montañez Técnico en Redes y Telecomunicaciones Montevideo - Uruguay

Re: [PHP-DB] DATETIME MySQL - using only month and date

2005-04-10 Thread Andrés G . Montañez
)) -- Atte, Andrés G. Montañez Técnico en Redes y Telecomunicaciones Montevideo - Uruguay -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] dbase and Debian

2005-03-23 Thread Leo G. Divinagracia III
Ricardo Markiewicz wrote: Unfortunately, I can't convert the dbf files to SQL tables, so, i need dbase support in PHP :( connect via ODBC, perhaps? then ADOdb or PEAR it? -- Leo G. Divinagracia III [EMAIL PROTECTED] z -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

Re: [PHP-DB] MySQL problem..

2004-11-10 Thread Leo G. Divinagracia III
List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Leo G. Divinagracia III [EMAIL PROTECTED] z -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MySQL backup software

2004-10-28 Thread Leo G. Divinagracia III
Perry, Matthew (Fire Marshal's Office) wrote: Does anyone know a free MySQL backup program to schedule regular backups? mysql has the ADMINISTRATOR, well at least for win32... does timed backups. -- Leo G. Divinagracia III [EMAIL PROTECTED] z -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] Generate Menu based on database structure

2004-10-14 Thread Leo G. Divinagracia III
graeme wrote: Hi, Rather than writing a recursive function I'd suggest that you create a menu class and store each record as an object of the class. why reinvent the wheel: http://www.destroydrop.com/javascripts/tree/ -- Leo G. Divinagracia III [EMAIL PROTECTED] z -- PHP Database Mailing

Re: [PHP-DB] User Activities

2004-10-01 Thread Leo G. Divinagracia III
. that is diff from the way MYSQL works. -- Leo G. Divinagracia III [EMAIL PROTECTED] z -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] mySQL searching through serialized arrays

2004-09-06 Thread rolando g
I am storing array of user IDs as TEXT using the serialize() function on the array, since several users, one or none can be part of each record... and I noticed that the serialized array has the values in double quotes like :21; for example... so since I know that the values will be enclosed,

[PHP-DB] Re: Unable to parse message

2004-07-26 Thread Harry G
getting mail parsing errors. In addition, you have your From set as: Harry G harry (removethis)@gabha.net Likely, ( and ) aren't supposed to be in there (invalid chars) and it also makes it impossible to reply to you. There is no other from or reply to in the headers. Answer to your question

Re: [PHP-DB] Joining Tables for Search

2004-07-26 Thread Harry G
Thanks Pablo, that worked. Pablo M. Rivas [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hello Harry, you can use left join: http://dev.mysql.com/doc/mysql/en/JOIN.html $query = SELECT members.id, firstname, familyname, middlename, fathername,

[PHP-DB] Match Against Query with Integers

2004-07-26 Thread Harry G
Hi Here's the senario... Table 1- members id - firstname - middlename - - country - region3 Fields country and region3 hold the integer codes for country and region3 is state Table 2- country id - countryname Countryname is where the actual Country name is stored and id is the country code

[PHP-DB] Joining Tables for Search

2004-07-25 Thread Harry G
Hi, I want to run a query on a table while joining it with other tables. Table 1- members id - firstname - middlename - - country - region3 Fields country and region3 hold the integer codes for country and region3 is state Table 2- country id - countryname Countryname is where the actual

[PHP-DB] What's wrong with this QUERY??

2004-07-22 Thread Harry G
Hi, I have a database with members details and PK is id. $thing = [EMAIL PROTECTED]; $query = SELECT id, email, familyname FROM members WHERE email=$thing; $result = mysql_query($query); If i do a query where id=$thing. and $thing=20; this works fine and I get the desired result. But what is

[PHP-DB] Re: What's wrong with this QUERY?? - Thanks all.

2004-07-22 Thread Harry G
Thank you everybody. Harry G [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi, I have a database with members details and PK is id. $thing = [EMAIL PROTECTED]; $query = SELECT id, email, familyname FROM members WHERE email=$thing; $result = mysql_query($query); If i do

[PHP-DB] php, javascript and db - your help is needed

2004-07-18 Thread G. Cohen
that, please let me know. Best Regards, G. Cohen -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] HELP: best way to TEXT dump a MySQL table to a local file...

2004-06-10 Thread Leo G. Divinagracia III
project i'm working with, his host died or something. but, the phpMyadmin (on that host) can NOT do a backup of 200mb table without running out of memory or something weird. so what is the best way to text dump the table? i thought i would (pseudo-code): open DB do while not EOF grab 1000

Re: [PHP-DB] HELP: best way to TEXT dump a MySQL table to a local file...

2004-06-10 Thread Leo G. Divinagracia III
:/... this (AFAI) does not cause memory issues Ignatius _ - Original Message - From: Leo G. Divinagracia III [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 10, 2004 11:39 AM Subject: [PHP-DB] HELP: best way to TEXT dump a MySQL table to a local file... project

Re: [PHP-DB] where to find tutorial

2004-06-04 Thread David T-G
filled in. So what did you mean and what do you want? HTH HAND PS -- Change your name to SuSE; it's better than RedHat :-) :-D -- David T-G [EMAIL PROTECTED] http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! pgpkK3rYoq22M.pgp Description: PGP signature

Re: [PHP-DB] no temp var for mysql_fetch_array results

2004-05-12 Thread David T-G
Justin, et al -- ...and then Justin Patrin said... % % David T-G wrote: % % ...and then Justin Patrin said... % % ... % % Of course, this leaves the result handle open. It's best to store the % % result handle and free it with mysql_free_result(). % % Makes sense. I actually hadn't thought

Re: [PHP-DB] Linux/PHP/Access Database - oh boy :(

2004-05-12 Thread David T-G
T-G [EMAIL PROTECTED] http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! pgp0.pgp Description: PGP signature

Re: [PHP-DB] no temp var for mysql_fetch_array results

2004-05-12 Thread David T-G
that mysql_result ( resource result , int row ) will jump to row $row in the output but says nothing about returning me a given fields. Any other thoughts? % HTH % Jeff TIA again HAND :-D -- David T-G [EMAIL PROTECTED] http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg

Re: [PHP-DB] no temp var for mysql_fetch_array results

2004-05-12 Thread David T-G
sure; the email addresses are unique, so I'd only get back one. And since mysql_result() is supposed to jump to a certain row it shouldn't matter whether I get back one or more... Still confused, :-D -- David T-G [EMAIL PROTECTED] http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf

Re: [PHP-DB] no temp var for mysql_fetch_array results

2004-05-11 Thread David T-G
= mysql_result(mysql_query($q,$dbro),0); Oooh! Cool! Just right. % HTH % Jeff Thanks HAND :-D -- David T-G [EMAIL PROTECTED] http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! pgp0.pgp Description: PGP signature

Re: [PHP-DB] no temp var for mysql_fetch_array results

2004-05-11 Thread David T-G
Justin, et al -- ...and then Justin Patrin said... % % David T-G wrote: % % ...and then [EMAIL PROTECTED] said... % % ... % % How about: % % $i = mysql_result(mysql_query($q,$dbro),0); % % Oooh! Cool! Just right. ... % % Of course, this leaves the result handle open. It's best

[PHP-DB] no temp var for mysql_fetch_array results

2004-05-11 Thread David T-G
= mysql_fetch_array($r)[0] ; somehow? TIA HAND :-D -- David T-G [EMAIL PROTECTED] http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! pgp0.pgp Description: PGP signature

Re: [PHP-DB] RE: [tcphp] Hella fun project I'm about to throw at some tech col lege students

2004-05-03 Thread David T-G
languages. You may end up having to go with prolog :-) Good luck HAND :-D -- David T-G [EMAIL PROTECTED] http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! pgp0.pgp Description: PGP signature

Re: [PHP-DB] Re: [PHP] What's wrong with this IF statement?

2004-04-30 Thread Leo G. Divinagracia III
in a pull down form object. -- Leo G. Divinagracia III [EMAIL PROTECTED] z -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] getting one line of info at a time

2004-04-12 Thread David T-G
something like Array ( [ta] = a b c [i] = a b c ) for its input. You can just use a foreach to walk through the list, or explode based on newlines for multiword input, or whatever you need to do. HTH HAND :-D -- David T-G [EMAIL PROTECTED] http://justpickone.org

[PHP-DB] php to mysql client problem.

2004-02-07 Thread Michael G. Tracey
to Mysql: Works. ==C:\mysql -u mike -p ==Enter password: ==Welcome to the MySQL monitor. Commands end with ; or \g. ==Your MySQL connection id is 28 to server version: 5.0.0-alpha-max-nt ==Type 'help;' or '\h' for help. Type '\c' to clear the buffer. PhpInfo Shows: ==MySQL Support enabled

[PHP-DB] connection problem??

2004-02-03 Thread Michael G. Tracey
; consider upgrading MySQL client I dropped the same version as before. Cannot remember if I specified another authentication protocol or how I did it. Michael G. Tracey ___ Join Excite! - http://www.excite.com The most personalized portal on the Web

Re: [PHP-DB] getting font size from browser

2004-01-31 Thread Roy G. Vervoort
thanks, wil use a java group next time, did not know that roy Miles Thompson [EMAIL PROTECTED] schreef in bericht news:[EMAIL PROTECTED] PHP is SERVER side, not browser side. That's a Javascript question. Miles At 11:14 AM 1/30/2004 +0100, Roy G. Vervoort wrote: Is it possible to retreive

[PHP-DB] getting font size from browser

2004-01-30 Thread Roy G. Vervoort
Is it possible to retreive the font size or view size from the browser. In the browser it is possible to change the screenview (make it larger or smaller for people with a visual aid). I would like to ineract my stylesheet with these default settings. thans Roy -- PHP Database Mailing List

Re: [PHP-DB] Wonder Program Question

2004-01-29 Thread David T-G
Paul -- 1) You've hijacked this thread. Don't do that. You don't even get the benefit of explanation, however, because ... 2) What does this have to do with PHP (or, worse yet, PHP with databases)? 3) STFW HAND :-D -- David T-G * There is too much animal courage

Re: [PHP-DB] test

2004-01-28 Thread David T-G
Florian -- ...and then Florian Habegger said... % % test Please don't post tests here. We got this and your THREE copies of your oci8 question (for which I can only wish you good luck). HAND :-D -- David T-G * There is too much animal courage in (play) [EMAIL

[PHP-DB] PhP 5.0, Mysql4.11,Apache2.0.48

2004-01-19 Thread Michael G. Tracey
. Will try sometime this week. I want to use MySQL to access some MS-Access databases from a program I use at work [With ODBC]. The manual says support is built in to PhP for MySQL. But I thought it was'nt any longer. Michael G. Tracey ___ Join Excite

Re: [PHP-DB] Re: L'utente Fabio Farinelli ha cambiato indirizzo di posta elettronica.

2004-01-16 Thread David T-G
Hi, all -- ...and then Justin Patrin said... % % Ignatius Reilly wrote: % % Somebody with admin rights to this list please castrate this Farinelli % user. % % +1 on that! for(;;++); :-D -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED

Re: [PHP-DB] csv export...?

2004-01-13 Thread David T-G
Andre, et al -- [Sorry for the delay...] ...and then Andre Speelmans said... % % Hi David, Hi! % % On Fri, Jan 09, 2004 at 11:04:21AM -0500, David T-G wrote: % %header (Content-Type: application/csv;) ; # this is a CSV %header (Content-disposition: attachment

Re: [PHP-DB] csv export...?

2004-01-09 Thread David T-G
} # if($age||$ftime) // }}} } # if(is_file) } # while(readdir)// }}} % % Anyone care to help? There ya go :-) HTH HAND Happy New Year :-D -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral

Re: [PHP-DB] csv export...?

2004-01-09 Thread David T-G
in a particular order when they were stored differently, so I loop through my format array to get the order of the keys to pull from the data array. HTH HAND HNY :-D -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient

Re: [PHP-DB] csv export...?

2004-01-09 Thread David T-G
, using header(), but with % existing files... % I guess I need to learn how to use fwrite? Only if you plan to store the result file on your server, and since you have the DB there I don't see why you would. HTH HAND HNY :-D -- David T-G * There is too much animal courage

Re: [PHP-DB] csv export...?

2004-01-09 Thread David T-G
. % That's the code I'm working on here today... Look at the header() lines in my reply outside of this subthread. % % ho hum... is it the weekend yet ;-) Not quite, but you're closer :-) HTH HAND HNY :-D -- David T-G * There is too much animal courage in (play

Re: [PHP-DB] Reading emails with PHP

2003-12-22 Thread David T-G
. Agreed. Full VERPing can be done if the client is interested :-) % % This has just been discussed here: % % http://marc.theaimsgroup.com/?t=1071585r=1w=2 Thanks! % % -- % % Regards, % Manuel Lemos HAND Happy Holidays :-D -- David T-G * There is too much

Re: [PHP-DB] Reading emails with PHP

2003-12-19 Thread David T-G
and then goes and updates two DB tables with the info it pulls out. It's called from the apparent sender's .qmail (like .forward) file, which also dumps a copy of the message onto a mail spool for us to review if we ever need to. HTH HAND :-D -- David T-G * There is too much

Re: [PHP-DB] Reading emails with PHP

2003-12-19 Thread David T-G
on your messages, but if you could I'd sure appreciate it. HTH HAND Happy Holidays :-D -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http

Re: [PHP-DB] Reading emails with PHP

2003-12-18 Thread David T-G
like it, so I overrode my client's desire for PHP with his desire for savings :-) % % Oh and Merry Christmas / Happy Holidays. And to you! % % Chris HTH HAND Happy Holidays :-D -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society

Re: [PHP-DB] {PHP-DB} password generator

2003-12-10 Thread David T-G
string, like $password = strtolower(substr(md5(uniqid(time())), 0, 7)); or so (here N = 8 and so we're using chars 0..7). % Thanx HTH HAND :-D -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work

Re: [PHP-DB] Downloading PHP source from a PHP filename, possible?

2003-11-29 Thread David T-G
it to be downloadable, and I still don't recommend it. % % Thanks for your time. That's why we're here :-) % % Jerry HTH HAND :-D -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED

Re: [PHP-DB] Buy beer and smoke at ANY age

2003-11-28 Thread David T-G
someone un-subscribe this email. Ban godaddy.com could be a good % idea as well, as I am not aware of any legitimate users coming from % there. Surely you don't *really* think that this actually came from godaddy, do you? % % Thanks, % % George HAND :-D -- David T-G

Re: [PHP-DB] Downloading PHP source from a PHP filename, possible?

2003-11-28 Thread David T-G
for a bit, starting with how to do it for some specific other file. It could be as easy as print file(blah.php) ; or such... HTH HAND :-D -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work

Re: [PHP-DB] a LITTLE bug with my CSV importer :-)

2003-11-27 Thread David T-G
. [You haven't shown us sample data -- no, I don't want all thousand rows! -- so it's tough to be more specific.] Don't think of it as hassling the group; think of it as coming for help :-) It's why we're all here! HTH HAND good luck :-D -- David T-G * There is too much

Re: [PHP-DB] Splitting a CSV file

2003-11-25 Thread David T-G
this sort of thing is to look at phpinfo() output and see what could be keeping you back. In my case, I didn't have _filesize and so I could watch the files spool up in /var/tmp and then suddenly disappear even before the upload finished! HTH HAND :-D -- David T-G

Re: [PHP-DB] - ereg_replace

2003-11-14 Thread David T-G
? The ^ (beginning) and $ (ending) anchors are probably messing you up. If your format *is* like this, you could do a quick preg_replace('/$/',' target=_blank',$string) (untested) and be done with it :-) % Thanx HTH HAND :-D -- David T-G * There is too much animal courage in (play

Re: [PHP-DB] - ereg_replace

2003-11-14 Thread David T-G
Hi again! ...and then ÍÉÊÏÓ ÃÁÔÓÇÓ said... % % Thank you for reply, but the a is not the only tag in my string. You're quite welcome, and now we definitely know that ^ and $ are not what you need. HTH HAND :-D -- David T-G * There is too much animal courage in (play

Re: [PHP-DB] No tuples available

2003-11-13 Thread David T-G
to an expression in PHP, any error messages that might be generated by that expression will be ignored. I'd bet a twinkie that you get it when you have no more data. You should implement the PEAR FutureGaze module so that you know to stop one row earlier ;-) HTH HAND :-D -- David T-G

Re: [PHP-DB] RE: Adding in MySQL

2003-11-12 Thread David T-G
everything. % % Regards, % % John HTH HAND :-D -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx

Re: [PHP-DB] BRU Help

2003-11-10 Thread David T-G
to it. Less than sixty seconds with google led me to BMTMicro's Tech Support page where I see I am an end user. I am having all sorts of problems. Can you help me? Yes we can help you. which certainly seems like the sort of thing you need. Go there. HTH HAND :-D -- David T-G

Re: [PHP-DB] UNSUBSCRIBE PLEASE (FW: L'utente Fabio Farinelli ha cambiato indi rizzo di posta elettronica.)

2003-10-29 Thread David T-G
say if we all start forwarding these to this address Fabio might take care of it himself :-) HTH HAND :-D -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy

Re: [PHP-DB] UNSUBSCRIBE PLEASE (FW: L'utente Fabio Farinelli ha cambiato indi rizzo di posta elettronica.)

2003-10-29 Thread David T-G
and it looks more like an autoresponder saying that your mail will be forwarded on to Fabio at this new address within 60 minutes or so but to change your addressbook. We'll see; I just bounced two messages there. Maybe I'll forward the next one to give it a return path... HTH HAND :-D -- David T-G

Re: [PHP-DB] Using two colomns of mysql data as key/value pairs in arrays

2003-10-20 Thread David T-G
a roster :-) % % Any help would be wonderful! :) HTH HAND :-D -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org

Re: [PHP-DB] Using two colomns of mysql data as key/value pairs in arrays

2003-10-20 Thread David T-G
the job. I didn't think it worth shooting down someone who was being helpful, though, when I made my response. HTH HAND :-D -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED

Re: [PHP-DB] Using two colomns of mysql data as key/value pairs in arrays

2003-10-20 Thread David T-G
want mysql_fetch_row, mysql_fetch_assoc, or both. % % Chris HTH TIA HAND :-D -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http

Re: [PHP-DB] Using two colomns of mysql data as key/value pairs in arrays

2003-10-20 Thread David T-G
a rather rude hole in Ignatius. % % Chris TIA HTH HAND :-D -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org

Re: [PHP-DB] Using two colomns of mysql data as key/value pairs in arrays

2003-10-20 Thread David T-G
want mysql_fetch_row, mysql_fetch_assoc, or both. % David T-G [EMAIL PROTECTED] wrote in message % news:[EMAIL PROTECTED] Dude, your quoting *really* needs some help... Oh, Outhouse. My condolences. Thanks HAND :-D -- David T-G * There is too much animal courage in (play

Re: [PHP-DB] Using two colomns of mysql data as key/value pairs in arrays

2003-10-20 Thread David T-G
HAND :-D -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! pgp0

Re: [PHP-DB] Using two colomns of mysql data as key/value pairs in arrays

2003-10-20 Thread David T-G
Thanks HAND :-D -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg

Re: [PHP-DB] Using two colomns of mysql data as key/value pairs in arrays

2003-10-20 Thread David T-G
Devon -- ...and then Devon said... % % David T-G wrote: % % Note that I don't recommend this as the best approach, and I don't think ... % doing it in two steps of loading your $everyone and then spitting out I'd % probably do something like % % $sql = select id,name from a_table order

  1   2   3   >