Greenguy's Board - View Single Post

Cleo · 2004-02-12, 04:55 PM

I GOT IT!

I was helped, a lot, by PhpMyAdmin in writing this.

UPDATE `phpads_banners` SET `target` = '_top';

While I was messing around I noticed that it would put the expression on the page for me if I modified a table.

Like this

Affected rows: 1
SQL-query : [Edit] [Create PHP Code]
UPDATE `phpads_banners` SET `target` = '_top' WHERE `bannerid` = '254' LIMIT 1 ;

Showing rows 270 - 299 (489 total, Query took 0.0049 sec)
SQL-query : [Edit] [Explain SQL] [Create PHP Code]
SELECT *
FROM `phpads_banners` LIMIT 270 , 30

Well damn it was showing me the code all along and I didn't even realize it. lol

2004-02-12, 04:55 PM	#6
Cleo Subversive filth of the hedonistic decadent West Join Date: Mar 2003 Location: Southeast Florida Posts: 27,936	I GOT IT! I was helped, a lot, by PhpMyAdmin in writing this. UPDATE `phpads_banners` SET `target` = '_top'; While I was messing around I noticed that it would put the expression on the page for me if I modified a table. Like this Affected rows: 1 SQL-query : [Edit] [Create PHP Code] UPDATE `phpads_banners` SET `target` = '_top' WHERE `bannerid` = '254' LIMIT 1 ; Showing rows 270 - 299 (489 total, Query took 0.0049 sec) SQL-query : [Edit] [Explain SQL] [Create PHP Code] SELECT * FROM `phpads_banners` LIMIT 270 , 30 Well damn it was showing me the code all along and I didn't even realize it. lol __________________ Free Rides on Uber and Lyft Uber Car: uberTzTerri Lyft Car: TZ896289