• Some users have recently had their accounts hijacked. It seems that the now defunct EVGA forums might have compromised your password there and seems many are using the same PW here. We would suggest you UPDATE YOUR PASSWORD and TURN ON 2FA for your account here to further secure it. None of the compromised accounts had 2FA turned on.
    Once you have enabled 2FA, your account will be updated soon to show a badge, letting other members know that you use 2FA to protect your account. This should be beneficial for everyone that uses FSFT.

Recent content by specterious

  1. S

    MySQL version differences

    Oh, duh, group by product_id. I kept trying to group by image_id. Thanks, this gets me what I need.
  2. S

    MySQL version differences

    Yea, I've tried to rewrite it but I can't think of anything that would replicate the limiting of 1 row. select p.product_id, i.image_id from `products` as p left join `product_images_links` as i on (p.product_id = i.product_id) There are multiple products and multiple images per...
  3. S

    MySQL version differences

    I created a select query that works in version 4.1 and does not in 4.0 It goes a little something like this... select * from `table1` left join (select `id` from `table2` order by `id` limit 1) on table1.id = table2.id This works in 4.1, but 4.0 gives an error at left join ( so I...
  4. S

    Map question

    Maybe you shouldn't use the API, but instead just link to the directions you want to display on google maps. Maybe an iframe would work?
  5. S

    Map question

    You can put the google maps on a business website as long as people don't have to pay to view the map.
  6. S

    Can wireless range expanders relay other relays?

    I'm looking at using a Linksys WRE54G range expander to strengthen the signal throughout a large home. Can you relay the signal from an already relayed signal? Go from range expander to range expander or does each one have to get the signal directly from the base station?
  7. S

    Anchor points and linking to them.

    Try using id instead of name?
  8. S

    Pairing a Dell 2407 with a 20.1 inch monitor

    You can do pretty much anything you can imagine with dual displays. I use UltraMon for extra options. In WoW I have the game fullscreen on the 2407 and I can still surf the web and have ventrilo up on the 2001fp.
  9. S

    Table formating problem.

    Add cols="2" to your table tag.
  10. S

    MySQL query optimization

    I think I figured it out. Using MAX() seems to get the highest timestamp value. select users.*, d.cnt as documents, p.cnt as photos, l.cnt as logins, l.datetime as lastlogin from users left join (SELECT userid, count(*) as cnt FROM documents GROUP BY userid) d on d.userid =...
  11. S

    MySQL query optimization

    One more query I'd like to merge into this one is getting the last login time for each user. I tried this: select users.*, d.cnt as documents, p.cnt as photos, l.cnt as logins, ll.timestamp as lastlogin from users left join (SELECT userid, count(*) as cnt FROM documents GROUP BY...
  12. S

    MySQL query optimization

    Oh wow that is much faster. Down to 0.003 seconds. Thanks
  13. S

    MySQL query optimization

    This is for a document mangement script I've been working on. I have 4 tables so far: users documents photos logins For each user i'd like to count up the # of documents, photos, and logins. They are related by a userid (primary in the users table). The first thing I did was query...
  14. S

    Simple Dreamweaver Question

    Currently the column containing the image has a percent width: <td width="27%" nowrap> Change that to a static width: <td width="185" nowrap>
  15. S

    Create an image made from many smaller images (montage?)

    Is there any program or Photoshop plug-in that can take a source image like a photograph, and using lots of smaller images, create an image that resembles the source photo? I've been searching Google for montage tutorials but all I find is how to merge a few pictures together to make some...
See more
Back
Top