By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,543 Members | 2,174 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,543 IT Pros & Developers. It's quick & easy.

Data fetch from database

P: 2
Hello..

i develope a web projects of horoscope or astrology(http://demo.reallianzbussimart.com/allzodiac.aspx), there is an 12 Zodiaz sign and all the data call on this page through the Database , in this page i there is an one sql query ---- (Select Top 1 col from colour order by newid(),Select Top 1 num from number order by newid() ,Select Top 1 days from day order by newid() )

then all data call one by one change ..

when the refresh the page the value of all zodiac is change that is wrong ,,,

so what is the quary that one time in day the value off all zodiac is same next day the value has been change............................................



so please help me /...........

tell what is the process to not data change when the page refresh

Ashwnai
Sep 5 '07 #1
Share this Question
Share on Google+
4 Replies


P: 2
Hello
1. I develop a project for Astrology
2. there is an 12 zodiac.
3. all the data came from database .
4. The site is http://demo.reallianzbussimart.com/allzodiac.aspx
5. when the user refresh the page the value of all data or zodiac is change
6. my query is no data change when the page refresh.
7. In this page i put up the Query Select top 1 col from color order by newid().

Plese help me
Ashwani
Sep 5 '07 #2

azimmer
Expert 100+
P: 200
Hello
1. I develop a project for Astrology
2. there is an 12 zodiac.
3. all the data came from database .
4. The site is http://demo.reallianzbussimart.com/allzodiac.aspx
5. when the user refresh the page the value of all data or zodiac is change
6. my query is no data change when the page refresh.
7. In this page i put up the Query Select top 1 col from color order by newid().

Plese help me
Ashwani
Ashwani, I don't really see your question but the "order by newid()" clause looks nonsense anyhow: normally one orders a table on some variable that is in the table not on newly generated nearly random numbers (except if you want a random row in which case you should use RAND()).
Sep 5 '07 #3

debasisdas
Expert 5K+
P: 8,127
i dont think u have implemented any logic ,it is showing things randomly.
Sep 5 '07 #4

debasisdas
Expert 5K+
P: 8,127
Both the threads of the user are merged for better management of the Forum.
Sep 5 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.