Chris Rossi

I was asked today how to add a tab to a Facebook Page to allow your fans to suggest the page to their friends.

Here’s the code:

<fb:request-form method="GET" type="YOUR PAGE" invite="true" content="DESCRIBE YOUR PAGE">
<fb:req-choice url="http://www.facebook.com/YOURPAGE" label="Check out!" />
<fb:multi-friend-selector actiontext="Tell your friends about YOUR PAGE" rows="5" cols="3" showborder="false" />
</fb:request-form>

Obviously you’ll need to add the new Static FBML tab to your page first, I won’t explain how to do this.

Read more on How to add an “Invite” tab to a Facebook Page…

This is a handy PHP function I wrote to prepare values for insertion into a MySQL database.

For example, if you prefer to use arrays of data and have a function automatically join them together:

$data = array();
$data['field1'] = 'value1';
$data['field2'] = 'value2';
$sql = build_sql_insert('table',$data);
// Returns INSERT INTO `table` (`field1`, `field2`) VALUES ('value1', 'value2');
$sql = build_sql_update('table',27,$data);
// Returns UPDATE `table` SET `field1`='value1', `field2`='value2' WHERE `id` = 27 LIMIT 1;

Read more on PHP Variable Preparation Function for MySQL…