Thanks for your message. I always thought if we create a PK-FK, relation it speeds up the queery when we join two tables in a queery..is this not true? because like you said Foreign key will slow down the speed.

I wonder that why then we create a PK-FK relation then.
Thanks

The advantage of creating the reltionship, is that it enforces the external logic about the system that the data represents. The dowside, is that anything like this inevitably slows things down, because it requires the database manager to check the things you have stipulated to it before blindly carrying out the actions you request.

This applies to any constraint you apply to your data. For a simpler example, we could, if we wanted, store all the results of a question which has a simple "Yes" or "No" answer in a field of type char (storing either 'Y' or 'N', respectively). It makes more sense, however, to store it in a field of type ENUM('Y', 'N'), or even ENUM 'Yes', 'No'), since a char field will quite happily take a value of 'G' or '$', or any other member of the ASCII characterset without complaining. The penalty is, that the database manager must check what is being given and ensure that it is either a 'Y' or a 'N', before inserting it. This penaly is so vanishingly small, however, that it simply isn't worth dispansing with the ENUM field type.

At a more complex level, it would be much quicker to store all data that you search very frequently on the basis of its date and time values by using UNIX timestamps for all the date and time values in fields of type INT (inserting and retrieving them via the UNIX_TIMESTAMP and FROM_UNIXTIME functions). However, to do so would mean losing MySQL's impressive battery of Date and time-handling functions, as well as causing all your date and time data to become essentially unreadable as date and time data. Any such implementation would therefore be almost worthless since Unix timestamp is one of the date and time formate which MySQL doesn't natively support. The time penalty incurred in using the programmed-in intelligence of the database manager is almost always less than the penalty of storing dates as values which differ from on another by - I think it's something like 84,600 seconds, but I can't be bothered doing the calculation - I'm sure you get my drift... :)

Likewise, the use of foreign keys enforces the external logic of what your data is ment to represent in the real world, and prevents illogical things being done, or the accumulation of redundant data (as an example, it stops you deleting an organiser for an event until you first delete the event, for instance, since your design stipulates that an event without an organiser would throw as major a spanner in the external logic of your application, as would a test for "has this event been deleted?" getting a response of "$").

Take it easy
Dan

what i suggest is try installing phpmyadmin this is the link
http://prdownloads.sourceforge.net/p...2.zip?download
but before you should install php on your server. advantage of phpmyadmin is it's moreeasier to work around mysql and mush easier at least i am kind on new to php and mysql but using phpmyadmin will make it more easier for you

Best Regards,
Hamed Gholamian

thanks, i downloaded phpadmin from that link, and unzipped file, but i don't see any executable file in the folders to launch and install phpadmin.

Follow this and i can promise you won't have any problem
1- Unzip it into a folder(phpmyadmin)
2- Then right click on that folder and select sharing.(new window will open)
3- From there choose web sharing
4- Select web sharing and in the alias box enter the name(best name is phpmyadmin)and click on ok and ok again.
5- Now goto to your iis manager(i am assuming you have php installed already if not download it from this link http://uk2.php.net/get/php-4.3.7-ins.../from/a/mirror)
6- When you open your iis you should see phpmyadmin
7- Right click on phpmyadmin folder(in your iis manager) and select properties.
8- Select Documents
9- Select add and on Default Document name type this index.php and click on ok
close this windows
10- Again right click on phpmyadmin folder and this time choose browse
11- you should see the phpmyamin page now.(you might need to click on phpmyadmin folder in your iis manager and from there find index.php and right click on that file and select browse if you see blank page)

and thats it if you have problem email me and i will provide you with images


Best Regards,
Hamed Gholamian

I hope you are ok now please let me know what happened

Best Regards,
Hamed Gholamian