Advertisement

Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - darkhelmet

Pages: 1 ... 53 54 [55] 56
811
Entrepreneurial Minds / Re: Thai Thao from Sounders and FFS
« on: October 18, 2011, 03:28:14 PM »
So a niece calls up and says she lives one hour away and would like to catch up because we're family and all.  We don't know her but only know her parents so we said sure, why not let's have dinner, bring the husband and kids over.  The day comes and she arrives, not with husband and kids but with her FFS "mentor".  So we've been cleaning the house and cooking all day, looking forward for our meeting with them and it turns out we made dinner for a bunch of crooked sales people.  I hate these kind of people.  I wasn't rude, I let them do their spill but didn't buy anything.  Damn how low will you go to get a sale?  Even down to tricking your own family member!

812
Computer & Technology / Re: www.cleverbot.com
« on: September 13, 2011, 01:14:58 PM »
this bot is so dumb.  it did not answer any of my questions.  looks like it probably based on AIML, alicebot.


Bot:   Can you help me with something?
Me:   Would you like to have some love?
Bot:   No thank you I just ate.
Me:   You eat love?
Bot:   No. I am Hindu.

813
Computer & Technology / anyone get the $99 hp touchpad?
« on: August 21, 2011, 11:19:19 PM »
woohoo, i got two!  O0
one for the kids to surf the net.

814
Computer & Technology / Re: how to get rid of malware?
« on: May 02, 2011, 11:55:27 PM »
you have caught a pretty nasty virus.  you need to get rid of it asap.  if you use any ftp client and have saved the password, it will hack your sites.

follow the direction here
http://support.kaspersky.com/viruses/solutions?qid=208280684

then run an anti-virus software and do a complete scan

good luck

815
Computer & Technology / looking for web dev work
« on: May 02, 2011, 09:01:30 AM »
Hi,
I've been doing freelance work for a few months now and would like to continue building my customer base.  If you know of any gigs out there or looking for someone to help/assist with web dev, please let me know.  I primarily focus on website development (html, css, javascript/jquery, php, 3rd party api, cms (primarily MODx: modules, addon, etc)), mysql, some graphic design.

Please PM.  Thanks!

816
Computer & Technology / Re: anybody having problem with internet explorer?
« on: February 18, 2011, 03:16:53 PM »
Internet Explorer doesn't work after 3am, then when all the hackers strike.

817
Computer & Technology / my crawler is at it again
« on: January 27, 2011, 09:24:57 PM »
Okay some of you know I have a crawler going through PH looking for pictures at http://phpix.freevar.com/ which is located on a super slow free webhost (sorry).

So a friend of mine introduced me to this hmong music site called ehmongmusic.co m, which I'm sure most of you have heard or been to.  The sites pretty good with a lot of music files but can't download anything off of it!

Saw a few post about people using software to try to get them and a youtube where this guy shows you how to get it from your cache.  These are all pretty crude way of getting it so I decided to try writing a crawler to retrieve the files for me.

Here's it in action, the crawler automatically creates the a folder and names the files.  Makes it all nice and tidy for me :)


818
Computer & Technology / Re: Print screen...
« on: January 27, 2011, 09:09:54 PM »
depends on the keyboard...on mine it is, fn+prt sc

819
Computer & Technology / Re: ph pictures
« on: November 11, 2010, 09:00:37 AM »
Ah, no worries, I already have a way around it.  I like a good challenge.  ;D

I've got it to crawl for topics.....nex t I need it to crawl into each topic and get the pictures.  More work, but no problem.  I just need a little more time, but I'm only doing this for fun so it's not a priority.

Just take a look!

http://phpix.freevar.com/



820
Hmong Websites & Resources / PH Pix View
« on: November 08, 2010, 09:03:40 AM »
The easy way to view pictures posted on PH.

http://phpix.freevar.com/

821
Computer & Technology / ph pictures
« on: November 08, 2010, 09:02:13 AM »
Sharing something I created over the weekend because I don't really have time to be on PH but I love to look at photos posted by users here.  Thought it might be useful for someone too.

http://phpix.freevar.com/

822
Computer & Technology / Re: php mysql query
« on: September 29, 2010, 02:08:34 PM »
thanks jetter, you have the right answer and i understand what you're saying.  my bad, my table was wrong.  the field `id` do have dupes so grouping by id is appropriate.  sorry, just got sloppy in my post.  

the counting is required...the table i posted above is just a very very shortened version of the one i'm working on.
the count is for couting the number of 'type' because i need to be able to search by any number of type, it counts the number of matches and the total count must match the number of types i'm searching for.

thanks for your input.





this will return duplicates since you are grouping by ID and id are different for each entry but has the same name.  This query is way to slow because it uses too many built in SQL functions that you do not need.  What is the purpose of counting id?  You are not using it and by Grouping by ID?  what is that used for since the id are unique anyway; so this makes the having clause pointless because the id will all have 1 as their count and the sql will error out because group by clause requires every field in the returning tuples to be group also.

823
Computer & Technology / Re: php mysql query
« on: September 29, 2010, 02:00:01 PM »
jbutton, thanks for the input.  i originally had used the same query as you suggested but gave too many results.

Did you try my code?  Did it work?

824
Computer & Technology / Re: php mysql query
« on: September 29, 2010, 09:51:49 AM »
I got a seasoned developer to answer my question.

It seems like you can do it in one query.  Something like this

SELECT a.name, count( id ) as value_count FROM table AS a WHERE  ( (type = region AND value IN (9000)) OR (type = service AND  value IN (6000)) ) GROUP BY a.id HAVING value_count = 2

825
Computer & Technology / Re: php mysql query
« on: September 29, 2010, 08:45:42 AM »
I think i know where you're going with this.  It might just work with some tweaks.  I'm going to do some test right now.


Wow, then it's going to be difficult. I'm not even sure if you can do it in one query.
Because you'll have to test for the Type= Region AND Value=9000, but then you can't test for Type=Service again...
unless you did more than one query. Plus that entails that you do filtering in your php code.

If doing more than one query isn't an issue than I would suggest:

SELECT Name FROM table WHERE Type='Region' AND Value='9000'

Then take the result and use it in a new query:

SELECT * FROM table WHERE Name='result' AND Type='Service' AND Value='6000'

That's all I can think of without actually writing the code and testing it. Hope this helps.

Pages: 1 ... 53 54 [55] 56
Advertisements