[RESOLVED] A browser refresh question

ali_p

Hi,

I'm not sure if i can do this with PHP but i am very keen to find out.
I want to basically change my image and data that is being pulled out of a database everytime the browser is refreshed.

Heres the scenario i have 2 tables, rentals and sales that contain some of the same fields such as property name description and cost (theres an image too ). I need a way to change what is displayed every browser refresh, so one time the data might come from one table the next the other table.

I was thinking along the lines of setting up a holding table that stores the info from the two table , but i dont know how to tell it to change the data.

Any help will be greatly appreciated.

coreyp_1

I assume by "tables" you mean MySQL?

psuedocode:

if (rand(0,1)){
  // SELECT ... FROM my_table1 ORDER BY RAND() LIMIT 1
  // output appropriate info
} else {
  // SELECT ... FROM my_table2 ORDER BY RAND() LIMIT 1
  // output appropriate info
}

if the 2 tables have the same structure, then you can output the info after the IF...ELSE statement, rather than using the same code twice

ali_p

Thank you for answering my query

what does this do ?

(rand(0,1)

bubblenut

There's a special place that has answers to lots of questions like these.It's called the manual!! Please read it at your leisure.

I'm sorry if this seems a little harsh but really, if the question is as simple as "what is this function" then just look it up in the bloody manual, it would be quicker for you.

coreyp_1

if you're wanting to know the reason it's there, is because, basically, it returns a 0 or 1 (false or true) at random, which will ultimately get information from one table or the other, just as you stated in your post.

Roger_Ramjet

Het, bubblenut, did you get out of bed on the wrong side or what?

bubblenut

All I have to say to that is, my double exclamation mark beats your red color so nah nah nah nah nah nah :p

ali_p

Thanks for your help Corey.

I'll leave this playground now....