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

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

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

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

2003-10-20 Thread David T-G
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 :-) % % Chris Thanks 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
- -- 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! -BEGIN PGP

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

2003-10-20 Thread David T-G
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 courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage

[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 columns Hmmm... I suppose so

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

2003-10-20 Thread David T-G
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 sufficient moral courage. (work

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

2003-09-30 Thread David T-G
domain? And others can ask % for it to be installed for their accounts. You should be keeping all of the domains' mail separate anyway, so that's no big deal. % % All help mostly appreciated. I wonder how 'mostly' this input will strike you :-) % % Thanks! HTH HAND :-D -- David T-G

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

2003-08-27 Thread David T-G
Beckman Internet Guy % [EMAIL PROTECTED] http://www.purplecow.com/ % --- HTH HAND :-D -- David T-G * There is too much animal

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 my read

Re: [PHP-DB] Sorting issue

2003-08-14 Thread David T-G
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 Health http://justpickone.org/davidtg/ Shpx gur

Re: [PHP-DB] Sorting issue

2003-08-08 Thread David T-G
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 Eddy, Science and Health http://justpickone.org

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

2003-03-29 Thread David T-G
. If 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 -- David T-G

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 * There is too much animal

Re: [PHP-DB] compare php and perl

2003-03-20 Thread David T-G
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 too much animal courage in (play) [EMAIL

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 too much animal

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 (play

Re: [PHP-DB] .htaccess

2003-02-16 Thread David T-G
rather than relying on img... tags to simply point to them. 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

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 animal courage

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

2003-02-13 Thread David T-G
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 * There is too much animal courage in (play) [EMAIL

Re: [PHP-DB] backing up databases

2003-01-27 Thread David T-G
, 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 * There is too

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

2003-01-23 Thread David T-G
and 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 sufficient