Greenguy's Board - View Single Post

DangerDave · 2004-02-12, 04:15 PM

Assuming 'target' is a field in the 'phpads_banners' table...

SELECT *
FROM phpads_banners
WHERE target=""

Should get you the "empty ones", and you should be able to update them... ?

I am half way thru SQL for Super Dummies!

DD

2004-02-12, 04:15 PM	#4
DangerDave Bonged Join Date: Mar 2003 Location: BrisVegas, AUSTRALIA Posts: 4,882	Assuming 'target' is a field in the 'phpads_banners' table... SELECT * FROM phpads_banners WHERE target="" Should get you the "empty ones", and you should be able to update them... ? I am half way thru SQL for Super Dummies! DD __________________ Old Dollars >>>> Now with over 90 Hosted Free Sites <<<< DangerDave.com.au - Adult Links to Free Porn