Greenguy's Board


Go Back   Greenguy's Board > Chit Chat
Register FAQ Calendar Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Search this Thread Rate Thread Display Modes
Old 2007-01-23, 12:14 PM   #26
Fonz
Former pr0n slinger.
 
Fonz's Avatar
 
Join Date: Aug 2003
Location: Antwerp, Belgium
Posts: 7,932
Quote:
Originally Posted by RedCherry View Post
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.

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%'
__________________
See how I abuse little trees on my Shumi no Bonsai Blog
Fonz is offline   Reply With Quote
Old 2007-01-23, 12:29 PM   #27
cd34
a.k.a. Sparky
 
cd34's Avatar
 
Join Date: Sep 2004
Location: West Palm Beach, FL, USA
Posts: 2,396
Quote:
Originally Posted by RedCherry View Post
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%';
__________________
SnapReplay.com a different way to share photos - iPhone & Android
cd34 is offline   Reply With Quote
Old 2007-01-23, 12:35 PM   #28
emmanuelle
0100011101100101011001010 1101011001000000100001101 1010000110100101100011
 
emmanuelle's Avatar
 
Join Date: Mar 2004
Location: Montreal
Posts: 1,441
Send a message via ICQ to emmanuelle
I move that we rename this board to "Sparky's Tech Support"
emmanuelle is offline   Reply With Quote
Old 2007-01-23, 02:10 PM   #29
GonZo
You can now put whatever you want in this space :)
 
GonZo's Avatar
 
Join Date: Apr 2003
Location: Atlanta,Ga
Posts: 893
Quote:
Originally Posted by Greenie View Post
Good Tuesday Peoples

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

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

I did!
GonZo is offline   Reply With Quote
Old 2007-01-23, 02:20 PM   #30
Cleo
Subversive filth of the hedonistic decadent West
 
Cleo's Avatar
 
Join Date: Mar 2003
Location: Southeast Florida
Posts: 27,936
Quote:
Originally Posted by emmanuelle View Post
I move that we rename this board to "Sparky's Tech Support"
Bring on the Gimp…
__________________
Free Rides on Uber and Lyft
Uber Car: uberTzTerri
Lyft Car: TZ896289
Cleo is offline   Reply With Quote
Old 2007-01-23, 02:30 PM   #31
Greenguy
The Original Greenguy (Est'd 1996) & AVN HOF Member - I Crop Pics For Thumbs In My Sleep
 
Greenguy's Avatar
 
Join Date: Feb 2003
Location: Blasdell, NY (shithole suburb south of Buffalo)
Posts: 41,929
Send a message via ICQ to Greenguy
I do love coding in the morning thread
__________________

Promote POV Porn Cash By Building & Submitting Galleries to the Porn Luv Network
Greenguy is offline   Reply With Quote
Old 2007-01-23, 02:34 PM   #32
stuveltje
Live and learn. And take very careful notes!
 
stuveltje's Avatar
 
Join Date: Apr 2003
Location: Sunny Holland
Posts: 6,157
Send a message via ICQ to stuveltje
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.... so Stu<--- tap herself on her back....good girl, you manage to remove all out of the puter without ruin the hard drive with that i also manage to keep my temper, again an other tap on my back . I am not gonna work this eve. I wish you all a great day!
Btw Cleo, get back to bed and get better
stuveltje is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 06:56 PM.


Mark Read
Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
© Greenguy Marketing Inc