[PHP-DB] html in mysql
Hello to all! I am a bit confused :-) I have html in mysql for a content management system. I am working on a search function, and have this working fine, however, when my results get returned, there is html code in the results like img src=../images/img.gif..how do I get php to not try and load the image and just give me text in my results only? I have been looking at html special chars...but that's not it.. Anyone? Many thanks! Cory -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] html in mysql
I just found it...strip_tags doh!~ Thanks to all who answered! Cory On Mon, 2004-02-23 at 12:07, Stuart wrote: Cory Hicks wrote: how do I get php to not try and load the image and just give me text in my results only? I have been looking at html special chars...but that's not it.. http://php.net/strip_tags -- Stuart -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Need some MySQL Optimization suggestions - uber slow queries
Matt, Have you tried an EXPLAIN query yet? Start with this and send the result of the query back to the list...that would give everyone a better sense of what is happening. Cory On Fri, 2003-09-26 at 09:58, Matt Babineau wrote: I have a page that when all said and done is super slow. The queries are running a bunch of JOINs and SORTs and WHEREs. I recently implemented the my-large.cnf file in hopes it would help out the situation, but the change appears negligible. Does anyone have any suggestions for speeding up the query process...a lot? Thanks, Matt -- Cory Hicks [EMAIL PROTECTED] TRI International -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] PHP Paging
FAW, I would look at PEAR and then run, don't walkand get the DB_Pager It smokes anything else I have tried... Cory On Thu, 2003-06-12 at 06:19, F-A-W wrote: Hi all, I have some data that need to be shown in pages. How can I do paging in PHP? Any code snippet or links are welcome. Thanks FAW - Do you Yahoo!? Free online calendar with sync to Outlook(TM). -- Cory Hicks [EMAIL PROTECTED] TRI International -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] update and join?
Hello to all! Quick questionis it possible to do an update query w/ a join yet? If not, what is your preferred method? Would you take care of it on the PHP side? I need to update a table w/ data from another table if certain conditions are true, i.e the fields in the table to be joined are NULL Any help as always is greatly appreciated Thanks, Cory -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php