Hi,

I am working on a web application which involves create list of Restaurants in various lists like "Joe's must visit places". Now for each Restaurant and list, I have display on website which calculates

• Calculating popularity of a Restaurant
• Popularity of a list
• Number of lists a Restaurant is present in

Currently I am using MySQL statements in PHP for this but planning to switch to MySQL VIEWS and do a simple select statement in PHP...

my question is, What is Advantage/Disadvantage of using VIEWS over writing sql queries in PHP?

Using views adds a level of abstraction : you may later change the structure of your tables, and you will not have to change the code that displays the information about the lists, because you will still be querying the view (the view definition may change, though).

The main difference is that views are updated after each insertion, such that the data is "ready" whenever you query the view, whereas using your custom query will have MySQL compute everything each time (there is some caching, of course).

The bottom line is that if your lists are updated less frenquently than they are viewed, you will see some gains in performance in using views.

Ok, so here was my first question: How do I allow visitors on my site to share my photos on their facebook news feed?

After implementing it I realized what I really want is to upload the image as a photo to their photo album.

How would I got about getting an image on my site, to upload to their photo album, when they click on a facebook icon next to the image?

Any thoughts at all are appreciated.

Thank You.

Register your application at Facebook (create a Facebook app).

Authenticate the user with Facebook, at the same time user approves your app access.

Use Facebook publishing api to upload image (follow link, look for Publishing title).