Triming down a MySQL query

[runvik]

Hi!

I wonder how I, in the best way, can trim/format/strip down a MySQL query so that I can present the values of it in a confirm window?

Example:

INSERT INTO `test` ( `id` , `car` , `category` , `date` )VALUES (NULL , 1, 3, 20070825);

----->

id : NULL
car : 1
category : 3
date: 20070825


I would love geting some help with this issue...

/Daniel

[acoder]

Welcome to TSDN!

You can't connect to MySQL using Javascript. What language are you using?

[runvik]

Welcome to TSDN!

You can't connect to MySQL using Javascript. What language are you using?

Thanks!

No, I know. I'm using PHP, javascript and Ajax, but the only thing I want to know is how to use replace or some other function in javascript to strip down or trim a MySQL query so that it just looks like the example I used above..

[acoder]

If it's just a string, you could use regular expressions in javascript. There's no trim function in Javascript, but you can easily create one yourself.