Adam

..to show them all? What's the point in using a ticker then?

I posted a link that should contain all the information you need.

What do you mean, how can you remove it?

It's just an element (most likely a DIV) with the CSS property overlfow set to "hidden", and then JavaScript decreasing/increasing the top property of an "absolute" positioned inner div.. Obviously there's a lot more too it to, but that's the basics behind it.

What?

Well who's login do you want to use then..? You can't access Facebook without authentication.

That's because you need to be logged in. I found. http://developers.facebook.com/docs/guides/web

Do you simply mean..? http://www.php.net/manual/en/reserved.variables.get.php http://www.php.net/manual/en/reserved.variables.post.php

There's an example. A html form and php handling for it. I did wonder if you'd be wanting to use radio style selection instead of text, but... No offence, but that's a bad way to do it. For that actual quiz storage, you'll want to set up a table within the database to store the questions, with a unique question ID for each. Another table to store the answers (with a foreign key linking to the question ID), again with a unique ID for each. Then depending upon whether you want to store the users' answers, you'll need a third table for the results (with 2 foreign keys linking to the question ID and answer ID). If not then you could temporarily store their answers within a session variable. As I was getting at before though, the exact fields for the tables could vary depending upon the logic of the quiz.

Look into Facebook's API.

So.. you don't have the logic all planned out? That's probably going to be the most crucial part of your application. By logic I don't mean PHP logic, I just mean general logic of the quiz; e.g. if the user answers 'a' to every question he's x personality.

Actually they can. Edit: Although you may be on the right track there. Try adding grave accents (`) around the field names..

To add, remember you only return once. Think of the behaviour like a function..

Correct.

Can you echo out $query and post the SQL?

Sorry by logic I mean, how do the answers to the 8 questions map against the 6 personalities?

Deep. How often do you make personality quizzes? I don't think he's after the logic though, sounds like that's already prepared he just needs to put it to code.

We really need to know more about the logic behind the quiz, how do the 8 questions relate to the 6 personalities? What decides which you fall under?

Take a look around example 5 and 6 area: http://php.net/manual/en/function.include.php

In English..

I saw some old bat mawing her lawn at 7:30 this morning, and it was wet. Anyway.. I agree with both sides here. It could do with some style, more colour, better fonts, simple imagery, etc. Currently it just looks like a page of writing, not all that interesting to look at. From the other perspective though, from a visual point of view, it does the job. The only problem is it sucks for search engines. The only people who'll see this website are those that already know about it, and so what's the point? Forget the visual side of things for now and read up on some simple SEO tips and tricks.

You may want to post this within the freelance section..?

Cheers for all the suggestions Found a solution though, but it's a little hacky in that you have to set the 'rowcount' manually and declare a table variable with an auto-incrementing key. Example: declare @vu_temp table ( row_count smallint identity(1,1), id smallint, ); insert into @vu_temp (id) select * from (...); -- optional to select the total count select count(id) as count from @vu_temp; -- limit the number of records returned set rowcount @LengthParameter; select vu.* from vanity_urls vu, @vu_temp tmp where vu.id = tmp.id -- set the offset and tmp.row_count >= @OffsetParameter;

Are you actually joking?

You're just wasting resources calling that function every time. Why not just populate the array and access the total by it's key..? echo $totals[0];