Re: [PHP-DB] Current web page being displayed

2005-08-07 Thread Matthew Weier O'Phinney
it. On Sat, 6 Aug 2005, Ron Piggott wrote: What is the correct $_SERVER that tells me what page is currently being displayed? Ron -- Matthew Weier O'Phinney Zend Certified Engineer http://weierophinney.net/matthew/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit

[PHP-DB] Re: Php with MySQL replication

2005-08-06 Thread Matthew Weier O'Phinney
is connecting to the master db server when performing the write operation? -- Matthew Weier O'Phinney Zend Certified Engineer http://weierophinney.net/matthew/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: a basic question

2005-07-03 Thread Matthew Weier O'Phinney
to ensure it doesn't occur. However, if the error isn't critical, and your script can continue to function even if it occurs, suppressing the error often is a viable option. -- Matthew Weier O'Phinney Zend Certified Engineer http://weierophinney.net/matthew/ -- PHP Database Mailing List (http

[PHP-DB] Re: ini_set()

2005-06-06 Thread Matthew Weier O'Phinney
, and you're using Apache): .htaccess: php_value session.use_cookies 0 Try that and see if it works. -- Matthew Weier O'Phinney | WEBSITES: Webmaster and IT Specialist | http://www.garden.org National Gardening Association| http://www.kidsgardening.com 802-863-5251 x156

[PHP-DB] Re: sql injection attack, protection from

2005-05-17 Thread Matthew Weier O'Phinney
and prevent headaches later on. By the way, if you want some best practices for escaping data before placing into a database, the manual page for mysql_real_escape_string has some examples: http://php.net/mysql_real_escape_string -- Matthew Weier O'Phinney | WEBSITES: Webmaster

[PHP-DB] Re: phpdocumentor

2005-05-04 Thread Matthew Weier O'Phinney
or is there really no problem? There's no problem. PhpDoc goes into comments; there's no interaction with code whatsoever. -- Matthew Weier O'Phinney | WEBSITES: Webmaster and IT Specialist | http://www.garden.org National Gardening Association| http://www.kidsgardening.com 802-863-5251

Re: FW: [PHP-DB] mime-type related to extension?. .

2005-04-27 Thread Matthew Weier O'Phinney
element returned by getimagesize() is the image MIME type. -- Matthew Weier O'Phinney | WEBSITES: Webmaster and IT Specialist | http://www.garden.org National Gardening Association| http://www.kidsgardening.com 802-863-5251 x156 | http://nationalgardenmonth.org mailto

[PHP-DB] Re: 'OR' logic in mySQL query

2005-04-17 Thread Matthew Weier O'Phinney
with: SELECT * FROM table WHERE date_received LIKE '$todays_date' OR date_received LIKE '$yesterdays_date' ORDER BY prayer_request_reference ASC -- Matthew Weier O'Phinney | WEBSITES: Webmaster and IT Specialist | http://www.garden.org National Gardening Association

Re: [PHP-DB] Join on single table

2005-02-12 Thread Matthew Weier O'Phinney
be done quite quickly. Anyways, it's a moot question now -- I've got the data in, and I'm pretty happy with the results I've seen. On Friday 11 February 2005 11:56 am, Matthew Weier O'Phinney wrote: * Micah Stevens [EMAIL PROTECTED]: Sounds like a self join should work wonders. I didn't

Re: [PHP-DB] Join on single table

2005-02-11 Thread Matthew Weier O'Phinney
* Martin Norland [EMAIL PROTECTED]: Matthew Weier O'Phinney wrote: I have a table which contains the following: id (primary key, auto incrementing) app_id (integer, foreign key) resource_id (integer, foreign key) word score (This is a search index.) I want

Re: [PHP-DB] Join on single table

2005-02-11 Thread Matthew Weier O'Phinney
) completely fixed, and it may be something I can't fix. On Thursday 10 February 2005 07:56 pm, Matthew Weier O'Phinney wrote: I have a table which contains the following: id (primary key, auto incrementing) app_id (integer, foreign key) resource_id (integer, foreign key

[PHP-DB] Join on single table

2005-02-10 Thread Matthew Weier O'Phinney
that this is reasonable. In a previous incarnation of the script, I was looping through each word of each resource_id and then selecting out of tmp1 based on the single word value. The results were very different (very few matches), and, again, the script ran long. Any ideas? -- Matthew Weier