Click here to Skip to main content
15,860,859 members
Home / Discussions / Database
   

Database

 
QuestionHow to get all reference of a column in a database. Pin
digvijay dobhal2-Aug-11 19:36
digvijay dobhal2-Aug-11 19:36 
AnswerRe: How to get all reference of a column in a database. Pin
Nagy Vilmos2-Aug-11 22:24
professionalNagy Vilmos2-Aug-11 22:24 
AnswerRe: How to get all reference of a column in a database. Pin
UNCRushFan3-Aug-11 1:43
UNCRushFan3-Aug-11 1:43 
GeneralRe: How to get all reference of a column in a database. Pin
digvijay dobhal3-Aug-11 1:51
digvijay dobhal3-Aug-11 1:51 
AnswerRe: How to get all reference of a column in a database. Pin
Shameel3-Aug-11 2:05
professionalShameel3-Aug-11 2:05 
GeneralRe: How to get all reference of a column in a database. Pin
UNCRushFan3-Aug-11 2:13
UNCRushFan3-Aug-11 2:13 
GeneralRe: How to get all reference of a column in a database. Pin
digvijay dobhal3-Aug-11 2:42
digvijay dobhal3-Aug-11 2:42 
Questionmysql SELECT WHERE Pin
samson radu2-Aug-11 1:33
samson radu2-Aug-11 1:33 
I`m building a web chat service and I use this query:

SELECT * FROM messages WHERE chat_room_id='$chat_room_id'

But I need to display no more than 20 rows (last 20 rows). Can`t use LIMIT because it will return the first 20 rows.
Is there a sql command? or do I have to sort it out in php?
AnswerRe: mysql SELECT WHERE Pin
Luc Pattyn2-Aug-11 2:02
sitebuilderLuc Pattyn2-Aug-11 2:02 
GeneralRe: mysql SELECT WHERE Pin
samson radu2-Aug-11 2:20
samson radu2-Aug-11 2:20 
AnswerRe: mysql SELECT WHERE Pin
Luc Pattyn2-Aug-11 2:28
sitebuilderLuc Pattyn2-Aug-11 2:28 
GeneralRe: mysql SELECT WHERE Pin
samson radu2-Aug-11 2:44
samson radu2-Aug-11 2:44 
GeneralOrder by Pin
David Mujica2-Aug-11 2:44
David Mujica2-Aug-11 2:44 
GeneralRe: Order by [modified] Pin
samson radu2-Aug-11 2:52
samson radu2-Aug-11 2:52 
GeneralRe: Order by Pin
PIEBALDconsult2-Aug-11 2:57
mvePIEBALDconsult2-Aug-11 2:57 
GeneralRe: Order by Pin
samson radu2-Aug-11 3:06
samson radu2-Aug-11 3:06 
AnswerRe: mysql SELECT WHERE Pin
Nagy Vilmos2-Aug-11 22:27
professionalNagy Vilmos2-Aug-11 22:27 
QuestionError trapping in SQL Server 2005 [modified] Pin
vanikanc1-Aug-11 7:37
vanikanc1-Aug-11 7:37 
AnswerRe: Error trapping in SQL Server 2005 Pin
jschell1-Aug-11 8:25
jschell1-Aug-11 8:25 
GeneralRe: Error trapping in SQL Server 2005 Pin
vanikanc1-Aug-11 8:29
vanikanc1-Aug-11 8:29 
GeneralRe: Error trapping in SQL Server 2005 Pin
jschell2-Aug-11 9:18
jschell2-Aug-11 9:18 
AnswerRe: Error trapping in SQL Server 2005 Pin
Shameel1-Aug-11 8:59
professionalShameel1-Aug-11 8:59 
AnswerRe: Error trapping in SQL Server 2005 Pin
Mycroft Holmes1-Aug-11 13:01
professionalMycroft Holmes1-Aug-11 13:01 
AnswerRe: Error trapping in SQL Server 2005 Pin
thatraja1-Aug-11 15:00
professionalthatraja1-Aug-11 15:00 
QuestionDynamic sort Pin
vanikanc1-Aug-11 2:54
vanikanc1-Aug-11 2:54 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.