I have a project that requires a Lyrics Script.� I have one but it has no backend and the code is loaded with German (I think) modifiers.� I am at the place where I could build a back end but really don’t want to waste the time.

Here are the two decent ones it seems:

Basically there is MiLyrics by Microscripts and� RightInPoint’s script.

They don’t look that different.� The MiLyrics has some things native that RIP (funny) charges for but theirs has a bunch of add-ons.

Any input from my 2 readers?

I am no programmer that is for sure, but when you are the head of marketing, sales, development, and IT at your company, (we call that an internet marketer) you have to figure things out.

So I have a site that is run off of a bunch of MySQL tables. I wanted to display the latest entry from a few specific tables on the front page of the site. I could pay someone $150 and give them access to my mortgage payment or I can figure it out myself. I decided on the later.

So here it is:

Lets assume that you have a table named “entries” and that the primary key is “id.” Every time you make a new entry, the entry gets an id number higher than the last. What we want is the highest number “id” and its data to be displayed. So what I discovered is that this is a two step process.

1. Get the information
2. Display the information

At some point in the beginning of your php page you have to connect to the database. If you are working on an existing site it is probably already at the top of the page.

Step 1 Get the information

I used this to get the latest entry:

<?$sql = "SELECT * FROM entries ORDER BY id DESC LIMIT 1";$rs = $db->Execute( $sql );?>

Then I had to display the info:

  <h2><?=$rs->fields['title']?></h2> <?=$rs->fields['thumbnail']?>

I hope this helps someone in the future.

I am working on a social media project and am pretty sure I am going with handshakes.� I need the functionality of using myspace layouts without major modifications or a 15 step process for the user.

If you have a handshakes license for sale please let me know.� It has to be upgraded to the latest version which I think is 3.3.� I don’t need your user database.� A layout mod would be nice but not absolutely necessary.

Ok, so the Affiliate Summit East was a week ago. I know. But I wanted to post some observations. In this post, I would like to give a few pointers to people who might have paid the $5k to $7.5 k to be an exhibitor.This Affiliate Summit in Miami was my first for this industry but I have been an exhibitor in trade shows in the financial arena and have walked the floor at several more in cities throughout the US and the rules are the same.

1. Put people in your booth who know what your product is and can answer at least a few of the basic questions. I was amazed at how many semi-attractive women would hand out a flyer but could not answer even the basics of what the company did. This is not a post about women. There were more than a bunch of women at the summit who were experts in their field but I was amazed at the lack of information available from people manning the booths.
   At mortgage trade shows there are often models not wearing enough clothes handing out crap. You know not to ask them any questions. If you want questions answered, you find someone dressed like a business person and you ask them. Not so here.
2. Put people in your booth who are not actively pledging a fraternity. I went up to one booth and the guy dropped two f bombs and told me about his hangover in the first 30 seconds cough cough pepperjam cough cough. The guy stank of alcohol and asked what parties I had gone to the night before. I told him I spent the night with my wife and kids. He looked at me funny.
   Incidentally, I asked him, “What exactly does pepperjam do?” He said, “Everything.”
   Hopefully that includes running detox centers.
3. If you are an affiliate network, have an answer to the question, “What makes you guys different?” There seemed to be 30 affiliate networks there. If you can’t answer this question, you may want to reconsider your business plan. One company said, “Look, we all have the same offers. The difference with us is we will actually return your calls.” Excellent response. Now that affiliate companies are little more than commodity brokers you have to sell service. Without that you really have nothing to offer.
4. Affiliates do not care about your technology. In response to the above question one guy started telling me about the interface. I said, “So I get your code, put it on my site and when people click through and perform an action I get money. Right?” He said, “Yeah. Basically.” Thanks for the pen. Moving on.
5. Go to Azoogle and Copeac’s booths. I use Azoogle. Went to their booth. They acted like they cared that I am an affiliate. The woman in the booth gave me her card and told me to call her if I need anything even though she is not my manager. Went to Copeac. The two guys there were actively trying to recruit my business, found products they had that were comparable to what I was running, gave me the name of the guy who would be my affiliate there at the show. When I got home, the guy sent me an email within the first 2 days with an offer sheet. Nice!
6. Don’t waste your time talking to people trying to get your business. Let’s think this through logically. You leave your business for a week. You fly yourself (and possibly some employees) across the country and pay for hotel rooms and food. You set up your $4k trade show display, handouts and trade show crap in your $7k floor space. You stand on your feet all day answering the same questions all in the hopes of landing a few new clients. A new, interested client comes to your booth but you don’t talk to him because you are talking to the guy trying to sell you something. The guy who did not spend the $4k on the display, the $7k on the booth space, the handouts, the …
   There were four different exhibitors that I waited and waited to talk to, ultimately to no avail, while they stood there and got pitched a product. In the trade shows I exhibited at, I would have gone to the operators and had them thrown out. They cheapen the product the trade show offers. Why put up a booth if I don’t have to? I can see one guy getting trapped but this was a plague.
7. Follow up! the trade show was a week ago and I have gotten 3 emails. I handed out almost 100 cards. Why exactly did you do everything in #6?

All this week I will be posting my review of the Affiliate Summit. Check out some really positive things tomorrow.

This weeks posts has been sponsered by CPA Affiliates. They gave me tickets to the show and I am really grateful. Thanks Guys!

I could do a long post here but you know the drill.

I am not at all concerned about page rank. If you post a comment here you will get a trackback from now on. I joined the no-nofollow group at bumpzee though I don’t really know why.

If you want to know why you should make your blog dofollow, here is a pretty good description.

I still will have no mercy on spammers but the rest get link love!