Re: [PHP] Re: storing a mysql query in mysql

On Wed, 2010-02-17 at 11:47 -0600, Shawn McKenzie wrote:

> Matt Giddings wrote:
> > Whats the best way to store a mysql query in mysql. I'm trying to store a mysql query in a debug log table if there is a problem with the query. I've tried using addslashes and a few other commands. I don't have a problem putting the data into the database but when I view it with sqlyog its f'ed up beyond belief. Is there another/better way to store this information? 
> > 
> > Thanks, 
> > Matt 
> > 
> 
> What's f'ed up?  I mean, I know what it means, but what does it look
> like when you view it?
> 
> -- 
> Thanks!
> -Shawn
> http://www.spidean.com
> 


Don't use addslashes for entering content into the database, as it won't
guarantee the data is safe for a database. Instead, use
mysql_real_escape_string, which uses the character set of your current
connection to fix the string.

Thanks,
Ash
http://www.ashleysheridan.co.uk