cheers for the suggestion, will give it a try.

thanks for the really helpful posts, really appreciate them.

I've sort of got something setup, it works but I prefer your method. It looks neater and appears better practice.

At the moment, I've got it setup so that onCreate creates a new instance of a question class. In the constructor a first number and second number are generated at random and then the answer is calculated.

In my activity_class, I then use these values to set the textfields in the app.

I will let you know how I get on after a bit of refactoring here and there.

Many thanks

I'm sorry, I'm a still a little confused. At the moment, I have an addition_activity which is called on when the addition button is pressed.
I'm guessing that I could use this addition_activity as the GUI. Would I need to create a question layout in the GUI builder and then use a ViewBinder or am I going off track there?

Also,Where would you suggest I store the questions? To generate them, I was simply going to use the random function to generate 2 numbers as the basis of the question.

Thanks for the reply

got it in the end.

$sql = "SELECT StoryID, Author, PostDate, LEFT (Story,300) AS Story\n"
     . "FROM newsstory\n"
     . "ORDER BY `newsstory`.`PostDate` DESC LIMIT 0, 3";

while ($row = mysql_fetch_assoc($result)) {		
		echo '<a href="news.php"'."<h4>Date: ".$row["PostDate"]."</a></h4>"; //DATE
		echo "<p><b> Author: </b>".$row["Author"]."</p>"; //AUTHOR
		echo "<p>".$row["Story"]."...<br /> "; //STORY
		echo "<a href='"."news.php?StoryID=".$row["StoryID"]."'>Read more</a></p>"; 
}

really happy, thanks Atli

Thanks a lot for the reply, you cleared most things up for me. I'm not going to post any code just yet because I've not really hit a brick wall, just needed some advice which you provided excellently. I'm going to learn about the MySQL substing function and then go from there. I'll keep you posted though.
Thanks once again.