Search Results

Search found 2 results on 1 pages for 'joff'.

Page 1/1 | 1 

• Architecture for a farmville/yoville/cafe world type game?

  - by Joff

  I'm thinking of building a game along the lines of Farmville - items, events, time management system etc. Options I am thinking of: 1) Flash UI frontend that uses AMFPHP to get all data for the view from a PHP powered backend. 2) Actionscript to power the whole game Any input is appreciated. My concern with Actionscript is scaling, my concern with PHP is having to build an update system that would need a lot of back and forth xmlhttprequests which might get complicated. If there's a better way to build something like this, I'm all ears :)

  Read the article

• Select in a many-to-many relationship in MySQL

  - by Joff Williams

  I have two tables in a MySQL database, Locations and Tags, and a third table LocationsTagsAssoc which associates the two tables and treats them as a many-to-many relationship. Table structure is as follows: Locations --------- ID int (Primary Key) Name varchar(128) LocationsTagsAssoc ------------------ ID int (Primary Key) LocationID int (Foreign Key) TagID int (Foreign Key) Tags ---- ID int (Primary Key) Name varchar(128) So each location can be tagged with multiple tagwords, and each tagword can be tagged to multiple locations. What I want to do is select only Locations which are tagged with all of the tag names supplied. For example: I want all locations which are tagged with both "trees" and "swings". Location "Park" should be selected, but location "Forest" should not. Any insight would be appreciated. Thanks!

  Read the article

1