Best Method

[Minase]

hy there seem strange but i have a question for peoples who know PHP more than me and did create games in the past.

was wondering what is the best method for creating a game??

from my opinion is like this:

 

users (table)

items (table contain info about item)

user_items (table contain what items a user have)

 

in general i do:

get every user item with looping through all user_items and item info from items and echo them

seem to be good

but someone told me that kind of programing is for high school 

and i need to use flags if i want to make something good

i know that with flags number of querys are reduced but he is right? or just acting big?

[wildteen88]

I'm assuming you're using MySQL as your database?

 

Not sure what you mean by flags, but if you're querying two tables you can use JOINS which is much more efficient then having two queries.

 

Before setting up your table look into Database Normalisation. Once you've setup your tables look in to MySQL JOINS so you can query multiple tables at one.

[SteelSlasher]

Scrap your ideas now and take a look at compiled PHP which will let you make actual desktop applications with PHP, you will need:

• PHP->Desktop Extension
  
• PHP compiler
  

 

If you want cross platform try PHP-GTK or for just windows try Winbinder, you will need a compiler to compile the script for windows i only know of Bambalam PHP compiler and Mini PHP Studio

 

You can also make the aps to contact a server

[Minase]

he mean just to set a flag into items if user have that items

cause user_items is "slowing down" he sayd