Shake to view random SQL entry

[therabbitfactory]

Hi all

So im a little bit of a noob when it comes to objective C and object oreintated programming and well I have landed quite a nice job but they would like me to build them a IPhone App. What they want is basically a view that contains the company logo with a label. When the user shakes the phone a random 'Tip' appears from a SQL database.

Ideally I would want the app to connect to the server hosting the database at start up to check if there is a update however I am all for the easy way, so I figured that I could import the DB into XCODE and when the DB needs updateing release a updated APP?

Anyways I am fine with the shake I can get the device to show a string in the label when the device is shaken how ever this is a static string, I want it to be random based on a field in a database.

Would you be able to point me in the right direction?

Thanks in advance for your help!

[zeolite]

1. Get a list the ids of all rows in your table. I'm assuming you have one column for the row id and another holding the tip as a VARCHAR.

2. Pick a random number "r" between 0 and (the number of rows in your table - 1)

3. Get the row id of the row "r"

4. Select the row with this id

1. SELECT row_id FROM my_table // store this in "rows_returned"

2. SELECT COUNT(*) from my_table // store this as "the_count"

srand([[NSDate date] timeIntervalSince1970]); // seed random number generator
int r = rand() % (the_count - 1);

3. int row_id = rows_returned[r].row_id

4. SELECT my_tip FROM my_table WHERE row_id = [r]

[mariano_donati]

You can make the database do the job:

SELECT tip FROM tips order by random() limit 1

[therabbitfactory]

Thanks for your comments guys...

I already know the logic behind it as I have programmed in other languages such as PHP, VB but well were would I enter the query and how would I return the result to the label?

Thanks for your help

[mariano_donati]

I thought you were using sqlite. Aren't you?

[therabbitfactory]

Yes I am as I think that this is the best way to do this?

I have literally imported the sql file to XCODE and imported the framework to the project, any ideas on how to implement the classes so that one result is returned?

Again apologies for my lack of understanding, I am a complete noob but hey, we all have to start some were