Re: [PHP-DB] LIMIT

2006-07-03 Thread JupiterHost.Net
Bastien Koert wrote: Your example predicates that the resultset it passed to an array which you then take the size of, which would only give you the LIMIT value if that clause is specified in the query... I see, I misunderstood the OPs question then they wanted to know that there are 2500

Re: [PHP-DB] LIMIT

2006-07-01 Thread JupiterHost.Net
chris smith wrote: On 7/1/06, Dwight Altman <[EMAIL PROTECTED]> wrote: Thanks, but that's an additional query. I was wondering if there may be a PHP function that can operate on the $result or perhaps $link of the single query that uses a LIMIT clause and I'm not sure how this would be don

Re: [PHP-DB] Conditional updating...

2006-06-26 Thread JupiterHost.Net
Grae Wolfe - PHP wrote: Thank you for the thought, however, I don't have a shell that I can run in, hence, I have to rely on help from others. get a GUI client then and use that... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Conditional updating...

2006-06-23 Thread JupiterHost.Net
Grae Wolfe - PHP wrote: Sorry I have been out of touch... I thought I had this problem beat, but I was wrong. I decided that the best thing to do was to filter the variables as the $sql statement was being created. I tried using the following code, and got a message back that it was inva

Re: [PHP-DB] Re: Re: Sending filing attachments using PHP

2006-05-15 Thread JupiterHost.Net
Michelle Konzack wrote: Am 2006-05-12 11:58:37, schrieb JupiterHost.Net: I was referring to building PHP/Apache in general * What do you talking about? -- I have compiled Apache and php5 the standard way and ABSOLUTLY NOTHING was missing. Great, I'm talking about managing mul

Re: [PHP-DB] Re: Sending filing attachments using PHP

2006-05-15 Thread JupiterHost.Net
Michelle Konzack wrote: Am 2006-05-12 15:39:44, schrieb JupiterHost.Net: Why not use Perl, it has all the "pros" but does not have the cons :) Oh yes it has... Perl is a memory monster... Anything is a memory monster if the task is memory intensive. many benchmark

Re: [PHP-DB] Re: Sending filing attachments using PHP

2006-05-15 Thread JupiterHost.Net
So why bother wit a language no ene knows how this crappy syntax works? Because you are mistaken based on your preference and experience and calling it "crappy" is not a very professional way to make your argument. Again I was simply pointing out some *major* drawbacks of PHP, not doing a

Re: [PHP-DB] Re: Sending filing attachments using PHP

2006-05-12 Thread JupiterHost.Net
Bastien Koert wrote: php is not the only language susceptible to x-browser attacks... seems unfair to single it out. Why not? Its the only I've seen that actually has hackability built in! (see below) So it singles itself out, thats the whole point :) And as previously pointed out, many ti

Re: [PHP-DB] Re: Sending filing attachments using PHP

2006-05-12 Thread JupiterHost.Net
Stut wrote: I think we may have to agree to disagree. I love PHP. I've never had a Ah I completely forgot about this sort of fun thing that I find in my email almost once a week, just got this one: http://forums.gentoo.org/viewtopic-t-460727.html now how many phpinfo() pages do you think

Re: [PHP-DB] Sending filing attachments using PHP

2006-05-12 Thread JupiterHost.Net
there really aren't enough effort applied to educate those outside the IT world. Working on it :) > but I still use PHP because it is still the most appropiate development > enviroment for a small or middle sized web solution. Why not use Perl, it has all the "pros" but does not have the co

Re: [PHP-DB] Re: Sending filing attachments using PHP

2006-05-12 Thread JupiterHost.Net
in PHP source: ./configure --help I've had a look and it would appear that all that switch does is install PEAR for you during the build process. That doesn't change the fact that it's still just a collection of PHP classes and does not require rebuilding of PHP to benefit from it. sure no

Re: [PHP-DB] Sending filing attachments using PHP

2006-05-12 Thread JupiterHost.Net
Bastien Koert wrote: Then Please, stop posting here...it just is not constructive... I will, but I think it is If you have these issues that need addressing to make it a better langauge, then talk to the nice people at Zend and get invovled in making things better. No thanks, trying to

Re: [PHP-DB] Re: Sending filing attachments using PHP

2006-05-12 Thread JupiterHost.Net
Stut wrote: Let me start by apologising if my posts came across as personal. Check If? How else can "What could be easier? Not having to read your ignorant emails." be taken? No worries though I understand, thanks :) What planet are you on? Seriously? Because PEAR does not need to be comp

Re: [PHP-DB] Sending filing attachments using PHP

2006-05-12 Thread JupiterHost.Net
It's a fact that I can't deny any of the bad points you have exposed about PHP. I even agree with you that most of this problems are really awful and it's pointless to hide them. But the fact that PHP is by preference the language for developing small and middle web solutions aimed to be economi

Re: [PHP-DB] Sending filing attachments using PHP

2006-05-12 Thread JupiterHost.Net
Dwight Altman wrote: " Right after rebuilding php and apache and breaking PHP funtionality for everyone, just so you can send a semi complex MIME message? That is the epitome of PHP's lameness and why I can't sit quietly by and not recommend an easy to install and use and maintain solution."

Re: [PHP-DB] Re: Sending filing attachments using PHP

2006-05-12 Thread JupiterHost.Net
What planet are you on? Seriously? Because PEAR does not need to be compiled into PHP. Zend Optimizer is no different to the optimizers I was referring to --with-pear, sorry "compiled" was not the right word * available for other scripting languages. Version mismatches are a fact I was refe

Re: [PHP-DB] Sending filing attachments using PHP

2006-05-12 Thread JupiterHost.Net
Edward Vermillion wrote: You've made it obvious by all of your replies that you have no idea what you're talking about, so maybe it would be a good time to *not* reply and let the folks that know what they're talking about actually try to help people? Eh? Maybe? a) Im speaking in genera

Re: [PHP-DB] Sending filing attachments using PHP

2006-05-12 Thread JupiterHost.Net
Edward Vermillion wrote: Ummm... dude... Zend Framework is NOT a "system wide binary"... Semantics. The point is its more fiddling, why fiddle (and likely break something) when you don't need to. besides is like way beta right now... fun to play with, sure, but they're not really reco

Re: [PHP-DB] Re: Sending filing attachments using PHP

2006-05-12 Thread JupiterHost.Net
Alister Bulman wrote: On 12/05/06, JupiterHost.Net <[EMAIL PROTECTED]> wrote: You're piping a hand crafted mime message to sendmial via mail()? You are a glutton for pain :) (and oh yeah theres about a zillion MIME issues you've overlooked that will come back an

Re: [PHP-DB] Sending filing attachments using PHP

2006-05-12 Thread JupiterHost.Net
Chris wrote: JupiterHost.Net wrote: Ing. Edwin Cruz wrote: Have a look on this: http://framework.zend.com/manual/en/zend.mail.attachments.html It seems to be easy with zend framework How about a way to do it without having to install a huge system wide binary and configruation

Re: [PHP-DB] Re: Sending filing attachments using PHP

2006-05-12 Thread JupiterHost.Net
Ron Piggott (PHP) wrote: I came up with some code today. I started e-mailing myself file attachments to see what my e-mail program did in preparing them and when I opened the e-mails I changed the view to "show e-mail source". The biggest challenge is the boundary that separates the e-mail

Re: [PHP-DB] PDF BLOB to Email

2006-05-11 Thread JupiterHost.Net
At the risk of extending empathy where none is given, perhaps you should I do appreciate that thanks :) tell us what experiences have led to your negativism. You've been a subscriber to this list for quite a while, and as far as I can remember, your posts have never been critical of the lang

Re: [PHP-DB] Sending filing attachments using PHP

2006-05-11 Thread JupiterHost.Net
Ing. Edwin Cruz wrote: Have a look on this: http://framework.zend.com/manual/en/zend.mail.attachments.html It seems to be easy with zend framework How about a way to do it without having to install a huge system wide binary and configruation that might potentially break apache and all PHP

Re: [PHP-DB] PDF BLOB to Email

2006-05-11 Thread JupiterHost.Net
I think you're confusing php (the language) with bad programming practices (the developers). They aren't the same. A true enough statement, except what i am referring to is that PHP (the language) lends itself to bad practice and has extremely bad security issues (example: your config info

Re: [PHP-DB] PDF BLOB to Email

2006-05-11 Thread JupiterHost.Net
Most PHP folks have this image that since its so shiny its just the best which in fact is the opposite: the nice graphic designers that skin PHP projects do very well (images/css/html which are all independant of PHP), but its like dressing up a turd in silk, its still crap underneath :) A bit

Re: [PHP-DB] PDF BLOB to Email

2006-05-11 Thread JupiterHost.Net
Adrian Bruce wrote: [snip] No, not "Obviously", PHP is not well suited for many tasks (or has a high cost to get the suit tailored) :) [/snip] "Obviously " because i am posting to a PHP list, numpty! but thank you for the recommendation anyway. Obvious in that sense sure ,but just poin

Re: [PHP-DB] PDF BLOB to Email

2006-05-11 Thread JupiterHost.Net
Adrian Bruce wrote: Hi Hello, I have pdf's stored as a blob in a MySQL database, how can i set a script (PHP obviously!) to email these blobs as pdf files. The only way No, not "Obviously", PHP is not well suited for many tasks (or has a high cost to get the suit tailored) :) If you

Re: [PHP-DB] auto_increment

2006-05-01 Thread JupiterHost.Net
Ron Piggott (PHP) wrote: I am using mySQL In that case, mysql.com woudl have MySQL specific resources since it has nothgin to do with PHP (aside form that is apparently what you're using to interact with MySQL) Please read http://www.catb.org/~esr/faqs/smart-questions.html#forum the ent

Re: [PHP-DB] auto_increment

2006-05-01 Thread JupiterHost.Net
Ron Piggott (PHP) wrote: How do I change the auto_increment / auto_index value? Ron Do a query that does what you want. Without knowing the type of DB you're using (and since this is a "PHP and Database" list not just specific DB list) or any other info, there really isn't much you can g

Re: [PHP-DB] Manipulate an image automatically

2006-04-13 Thread JupiterHost.Net
Henry Ortega wrote: What is the quickest way to manipulate an image? I have a 300x100 image of something (template), and I want text to be inserted to that graphic at a certain coordinate (e.g. lower right), how would I do that? This has nothing to do with databases and PHP, I think you wan

Re: [PHP-DB] Unable to Send Mail

2006-03-15 Thread JupiterHost.Net
We are having problem with ONE function. Any time a php script or form is supposed to send a response or email to us or a user, or the mail is not sent. We have tried various formail.php versions, sendmail.php and written our own most basic scripts. This would be more appropiate for a general

Re: [PHP-DB] test

2006-03-15 Thread JupiterHost.Net
Paul Anderson wrote: new user test please don't do tests to a public list, its spam -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Passwords

2006-03-10 Thread JupiterHost.Net
Dwight Altman wrote: Sure, mysql.com and seasrch for crypt. Not sure why this is asked on a PHP list since it has nothing to do with PHP. b) every language has a crypt function Then I guess it's okay to have crypt questions/answers on "every language" list. Sure whatever, its just this

Re: [PHP-DB] Passwords

2006-03-09 Thread JupiterHost.Net
Bastien Koert wrote: Not PHP? Correct, not PHP. most DB engines have built in encryption funtions for use in their INSERT (IE "store the password in the DB so that it is encrypted") and SELECT (for verifying it with the same funtion you used in INSERT) http://us3.php.net/crypt yes "

Re: [PHP-DB] Passwords

2006-03-09 Thread JupiterHost.Net
Benjamin Stambaugh wrote: Hi, I have created a user login/registration page. As of now I am using a MySQL database to store the info of the user. To validate the user I also have the password stored in the same DB. I was wondering if there is a way that I can store the password in the DB

Re: [PHP-DB] Renaming a table once it has been created

2006-03-08 Thread JupiterHost.Net
Ron Piggott (PHP) wrote: Is there a way to re-name a table once you have created it? Ron Depending on the type of DB some sort of ALTER TABLE statement I imagine, not sure what this has to do with PHP though... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] Mail Function

2006-03-01 Thread JupiterHost.Net
Mark Bomgardner wrote: I have been racking my brain for the better part of a day with a simple mail function. I am trying to generate a list of events from MySQL and then use the php Mail function to email the list in an html email to a mailing list. I keep getting a parse error on a sectio

Re: [PHP-DB] Future Event

2006-02-20 Thread JupiterHost.Net
Mark Bomgardner wrote: Is there a way in php to execute a SELECT statement in the future? What only if its running in the future :) You can trigger it when a visitor visits your page but what are the chances someone will visit it at 2:000 AM exactly every night? You can run it as a daem

Re: [PHP-DB] --with-mysqli and --with-mysql

2006-02-14 Thread JupiterHost.Net
So PHP5 can't so mysql and mysqli together? Perhaps this project would be better suited by Perl or Python since apparently PHP5's mysql support is too ambiguous. JupiterHost.Net wrote: JupiterHost.Net wrote: Howdy list, http://us2.php.net/manual/en/ref.mysqli.php under "I

Re: [PHP-DB] --with-mysqli and --with-mysql

2006-02-13 Thread JupiterHost.Net
JupiterHost.Net wrote: Howdy list, http://us2.php.net/manual/en/ref.mysqli.php under "Installation" is says: "If you would like to install the mysql extension along with the mysqli extension you have to use the same client library to avoid any conflicts." So, ass

[PHP-DB] --with-mysqli and --with-mysql

2006-02-13 Thread JupiterHost.Net
Howdy list, http://us2.php.net/manual/en/ref.mysqli.php under "Installation" is says: "If you would like to install the mysql extension along with the mysqli extension you have to use the same client library to avoid any conflicts." So, assuming PHP5 and MySQL > 4.1.3: These are the two way

[PHP-DB] --with-mysqli and --with-mysql

2006-02-13 Thread JupiterHost.Net
Howdy list, http://us2.php.net/manual/en/ref.mysqli.php under "Installation" is says: "If you would like to install the mysql extension along with the mysqli extension you have to use the same client library to avoid any conflicts." So, assuming PHP5 and MySQL > 4.1.3: These are the two way