Greenguy's Board - Good Radio Show Tuesday (I Think)

Greenguy's Board (http://www.greenguysboard.com/board/index.php)

- Chit Chat (http://www.greenguysboard.com/board/forumdisplay.php?f=12)

- - Good Radio Show Tuesday (I Think) (http://www.greenguysboard.com/board/showthread.php?t=37698)

Quote:

Originally Posted by RedCherry (Post 326848)

Good Morning All

Feeling MUCH better today after a full nights sleep and antibiotics to help calm the infection on my neck. The dr. also drained out some of the puss (YUCCH) so it doesn't feel like my neck is going to explode anymore. It is amazing what a difference 24 hours can make. :D

Today I'm doing more work on theredcherry.com dividing up categories, moving sites around.

All you php geeks, since I work in my admin, is there a way to change things using a wildcard? I tried doing something like these examples:

Code:

update dl_sites set category='73' where category='17' AND elements='1=0,2=%,3=0'  

update dl_sites set category='73' where title='%keyword%'

but it doesn't work. Also how do you use the term LIKE instead of the equal sign? Someday, I need to take classes in sql and php. I hate having to edit the suckers 30 at a time, that gets old when I could batch edit much faster.

Try

Code:

update dl_sites set category='73' where title LIKE '%keyword%'

Quote:

Originally Posted by RedCherry (Post 326848)

Code:

update dl_sites set category='73' where category='17' AND elements='1=0,2=%,3=0'  

update dl_sites set category='73' where title='%keyword%'

Code:

update dl_sites set category='73' where category='17' and elements in (1,2,3);



update dl_sites set category='73' where title like '%keyword%';

I move that we rename this board to "Sparky's Tech Support" :D

Quote:

Originally Posted by Greenie (Post 326797)

Good Tuesday Peoples |waves|

Nice & snowy here today & I have yet another nut-doctor appt today at 12:40 so I've got to get my fat ass in gear unless I can convince The Bitch that she's supposed to clean off my truck for me |thumb

We can do the Radio Show tonight - but I do need to take next week off for a Sabres game :D

Outsource it.

I did!

Quote:

Originally Posted by emmanuelle (Post 326862)

I move that we rename this board to "Sparky's Tech Support" :D

Bring on the Gimp…

I do love coding in the morning thread :D

good early evening here:) i had a good day, i am still in a good mood and thats because i went early to bed last night and slept like a baby, i mage to get rid of the trojan in my hubbies puter and i learned an other thing today, when you deal with trojans then shut down the "system restore" option in your puter....:D so Stu<--- tap herself on her back....good girl, you manage to remove all out of the puter without ruin the hard drive:D with that i also manage to keep my temper, again an other tap on my back :D. I am not gonna work this eve. I wish you all a great day!
Btw Cleo, get back to bed and get better:)