Re: [PHP-DB] where to find tutorial

2004-06-04 Thread David T-G
re goodies 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
absolutely 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/ Shp

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

2004-05-12 Thread David T-G
row 0 on MySQL result index 4... Now this makes some sense; the manual says 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 [EMAI

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

2004-05-12 Thread David T-G
amp; 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-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 se

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

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

2004-05-11 Thread David T-G
% How about: % $i = 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

[PHP-DB] no temp var for mysql_fetch_array results

2004-05-11 Thread David T-G
want a field from just this one row (not looping), could I just $i = 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
choose between 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] getting one line of info at a time

2004-04-12 Thread David T-G
de based on newlines for multiword input, or whatever you need to do. HTH & HAND :-D -- David T-G [EMAIL PROTECTED] http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! pgp0.pgp Description: PGP signature

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 an

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

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 PRO

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

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

2004-01-09 Thread David T-G
xcel. Yep. % 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

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

2004-01-09 Thread David T-G
elsewhere, 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 * T

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

2004-01-09 Thread David T-G
lds export 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

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

2004-01-09 Thread David T-G
# end the row $total[$d]++ ; # keep count } # 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 muc

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=1071585&r=1&w=2 Thanks! % % -- % % Regards, % Manuel Lemos HAND & Happy Holidays :-D -- David T-G * There

Re: [PHP-DB] Reading emails with PHP

2003-12-19 Thread David T-G
t up a *NIX box at home and start playing with it. The second easiest way is to read lots of man pages, but that's a very good approach because you'll find out ALL about each piece. Another way is to just beg/buy an account on a *NIX box and then pester the admin / help staff :-) % on

Re: [PHP-DB] Reading emails with PHP

2003-12-19 Thread David T-G
de at execution time. This, IMHO, is a pretty slick feature; it essentially turns your query string + resource connection into a function that accepts your varying input and then executes the call. So there you have it... This perl script is only 58 lines long and handles just about every sort

Re: [PHP-DB] Reading emails with PHP

2003-12-18 Thread David T-G
o php code 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) [EMA

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 coura

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

2003-11-29 Thread David T-G
27;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] Downloading PHP source from a PHP filename, possible?

2003-11-28 Thread David T-G
t I'm going to have to go and think about including and recursion 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

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

2003-11-28 Thread David T-G
ood imitation. *grin* % % Can 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, % % Georg

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

2003-11-27 Thread David T-G
check those rows for problems. [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 &a

Re: [PHP-DB] Splitting a CSV file

2003-11-25 Thread David T-G
od way to check 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
Hi again! ...and then ÍÉÊÏÓ ÃÁÔÓÇÓ said... % % Thank you for reply, but the 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

Re: [PHP-DB] - ereg_replace

2003-11-14 Thread David T-G
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 a

Re: [PHP-DB] No tuples available

2003-11-13 Thread David T-G
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 --

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

2003-11-12 Thread David T-G
s the subject line. Then trim away 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, "Scienc

Re: [PHP-DB] BRU Help

2003-11-10 Thread David T-G
t's safe to say I'm pretty new 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 nee

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

2003-10-29 Thread David T-G
ked babelfish 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...

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

2003-10-29 Thread David T-G
PROTECTED] I'd 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 PROTECT

[PHP-DB] Re: running total (was "Re: [PHP] php|cruise ...")

2003-10-20 Thread David T-G
nd. We need John to update us once a month or so -- or for you to bug him and then YOU update us once a month or so. Thanks again to all, including John, & HTH & HAND :-D -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not suf

[PHP-DB] Re: looping over $row (was "Re: [PHP-DB] Using two colomns ...")

2003-10-20 Thread David T-G
John, et al -- ...and then CPT John W. Holmes said... % % From: "David T-G" <[EMAIL PROTECTED]> % % > can't think of a practical example for which I would loop over $row... % > Care to help me out?] % % How about a dynamic query where you do not know the number of

[PHP-DB] Re: crosstab (was "Re: [PHP-DB] Using two colomns ...")

2003-10-20 Thread David T-G
tall to wide. Basically doing exactly what the OP had asked for. If Hmmm... You mean like taking results 1 a 2 b 3 c 4 d and changing it to 1 2 3 4 a b c d or such? I'm certainly confused. TIA & HAND :-D -- David T-G * There is too much animal c

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

2003-10-20 Thread David T-G
- -- 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
ny query is % to iterate through it's result set. Well, I typically do loop over the result set but typically don't loop over the fields in each record, so I don't know that I can agree with the weight you put on that. But at least I see why I could care :-) % % C

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 = &quo

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

2003-10-20 Thread David T-G
led down the primrose path. % % Chris 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://justpi

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

2003-10-20 Thread David T-G
freaks.com 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 Pbzzha

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

2003-10-20 Thread David T-G
etch_array instead of % figuring out whether I 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 -- D

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

2003-10-20 Thread David T-G
s being helpful, though, % > when I made my response. % % It didn't seem like he was shooting you down. No, but IMNSHO he shot a rather rude hole in Ignatius. % % Chris TIA & HTH & HAND :-D -- David T-G * There is too much animal courage in (play) [EM

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

2003-10-20 Thread David T-G
whether I 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, &

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

2003-10-20 Thread David T-G
uggestion, will do 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.

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

2003-10-20 Thread David T-G
\tName: {$row['name']}\n" ; } to just run through the data. I'm sure others here know of even better ways to print a roster :-) % % Any help would be wonderful! :) HTH & HAND :-D -- David T-G * There is too much animal courage in (play)

Re: [PHP-DB] Email bouncer Program(s) - know any?

2003-09-30 Thread David T-G
ou could certainly cock up the mail system so that nothing gets in, no matter what domain, but you'd have to work a bit at that). % can use to just use for my domain? And others can ask % for it to be installed for their accounts. You should be keeping all of the domains' mail separa

Re: [PHP-DB] MySQL, PHP or ghost?

2003-08-27 Thread David T-G
Peter, et al -- ...and then Peter Beckman said... % % On Wed, 27 Aug 2003, David T-G wrote: % % > Looks like it, though I admit that the manual doesn't adequately explain % > your results. Check out section 6.2.2.4 for details. % % I did; see my previous (moments ago) email on

Re: [PHP-DB] MySQL, PHP or ghost?

2003-08-27 Thread David T-G
| 3 | 2000 | +-+--+ 3 rows in set (0.00 sec) Note that I sometimes get warnings and sometimes don't. I haven't dug into them, though. % % Beckman % --- % Peter Beckman Internet Guy % [EMAIL PROTECTED]

Re: [PHP-DB] Sorting issue

2003-08-14 Thread David T-G
as you expected against "14000" in a varchar field). 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 Heal

Re: [PHP-DB] Sorting issue

2003-08-08 Thread David T-G
ad so far. . I know what you mean :-) Spend a *lot* of time with the manual! 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 Ed

Re: [PHP-DB] Related to WAR - 1

2003-03-29 Thread David T-G
you want to show how you've used php to create an anti-war site, then that's great. If you want to ask for help in your php project praising GWBush, then do so. If you want to talk/evangelize/whine about war, however, then go and do it elsewhere. It is NOT welcome here. TIA :-D --

Re: [PHP-DB] Generating view of tree?

2003-03-28 Thread David T-G
Craig -- ...and then Craig Kohtz said... % ... % The script I've included works for a table named "structure" with the % following fields: Sounds interesting. Care to actually post the script? ;-) I'd like to see it. TIA & HAND :-D -- David T-G

Re: [PHP-DB] compare php and perl

2003-03-20 Thread David T-G
obviously haven't found the beginners, beginners-cgi, and db lists at perl.org yet :-) % for my Perl scripting. (This last may sound like sucking up, but it's the % honest truth.) Hey, these *are* awesome lists :-) HTH & HAND :-D -- David T-G * There is t

Re: [PHP-DB] compare php and perl

2003-03-20 Thread David T-G
;d say to pick up bother because of the awesome depth of functionality available through CPAN, a collection of modules and tools for perl that already do, and generally quite well, anything most people are likely to want to do :-) HTH & HAND :-D -- David T-G * There is to

Re: [PHP-DB] disable right-click in all frames.

2003-02-22 Thread David T-G
spit out the leading javascript and then passthru the actual file. Note that those of us who have javascript turned off can use the right mouse button all we want :-) It may not be worth your effort. HTH & HAND :-D -- David T-G * There is too much animal courage in (

Re: [PHP-DB] .htaccess

2003-02-16 Thread David T-G
Matt -- ...and then Matt said... % % I have a php script that accesses a folder, and displays all the photos % inside the folder. I want to use this script to display images that people % upload from the anonymous ftp account. I know that when they upload a photo, % it goes into the: % % /home/u

Re: [PHP-DB] List Server Configuration; Was [Import text file]

2003-02-13 Thread David T-G
e implemented as a change to the list % server. I invite you to surf over to http://www.unicom.com/pw/reply-to-harmful.html and have a read on why this is such a bad idea. % % -- Mitch Now back to our regularly schedule discussions... HTH & HAND :-D -- David T-G

Re: [PHP-DB] How can i upload files

2003-02-13 Thread David T-G
; this comes up at least twice a month. After that you could take a look at the Fine Manual and read the Fine Example and try it out. That's all there is to it! % % Thanks in advance, % % Gabriel, HTH & HAND :-D -- David T-G * There is too much anima

Re: [PHP-DB] backing up databases

2003-01-27 Thread David T-G
(php CLI, perl, shell, whatever) to do the dump and then just call it from your web click or, better yet, from a crontab. % % Any examples would be really appreciated :-) Answers first, grasshopper :-) % % Thank you. % % Regards % % Chris HTH & HAND :-D -- David T-G

Re: [PHP-DB] PHP-DB - ot browser compatibility

2003-01-23 Thread David T-G
6.0 % Mozilla 1.1 No lynx? bash-2.05a$ lynx --version Lynx Version 2.8.4rel.1 (17 Jul 2001) Built on freebsd4.5 Jan 23 2002 07:28:38 I'm crushed! ;-) HAND :-D -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not suffi