i'm trying to figure out how to display the query syntax correctly...
lets say i have:
INSERT INTO cheats (gametitle,code,name,timepost,system,gameid,cheattype) VALUES ('Wild Arms','
<B>GAME SHARK CODES</B>
Quick Level Gain Cecilia
80133e74ffff
Quick Level Gain Jack
80133e40ffff
Quick Level Gain Rudy
80133e0cffff
Infinite Gella
801341dcffff
Infinite MP Cecilia
80133e5c03e7
Infinite MP Jack
80133e2803e7
Infinite HP Cecilia
80133e580500
Infinite HP Jack
80133e240500
Infinite HP Rudy
80133df00500
Infinite Bullets Rudy
801341500008
','Sweetleaf','February 18, 2003, 9:47 pm','ps1','3716','gameshark');
but i want to show it as:
INSERT INTO pending_cheats (gametitle,code,name,timepost,system,gameid,cheattype) VALUES ('Wild Arms', '\r\n<B>GAME SHARK CODES</B>\r\n\r\nQuick Level Gain Cecilia \r\n80133e74ffff\r\n\r\nQuick Level Gain Jack \r\n80133e40ffff\r\n\r\nQuick Level Gain Rudy \r\n80133e0cffff\r\n\r\nInfinite Gella \r\n801341dcffff\r\n\r\nInfinite MP Cecilia \r\n80133e5c03e7\r\n\r\nInfinite MP Jack \r\n80133e2803e7\r\n\r\nInfinite HP Cecilia \r\n80133e580500\r\n\r\nInfinite HP Jack \r\n80133e240500\r\n\r\nInfinite HP Rudy \r\n80133df00500\r\n\r\nInfinite Bullets Rudy \r\n801341500008\r\n\r\n \r\n', 'Sweetleaf', 'February 18, 2003, 9:47 pm', 'ps1', 0, 3716, 'gameshark');
basically, just want to know how to get it to show the \r\n whatever line codes if there are line spaces???
how would i do this? i have searched but do not understand
thanks in advance for any help...
