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

How to fetch particular row in a table without mentioning it's id or other elements

P: 30
Before to my question I want to say thanks to the admin of this website for very good support to improve my knowledge... :)

Hello friends,
How to fetch a data from a particular row in a column in the table without choosing its id or other headers of the columns

For example:



From the above table I want get the result as

/* result start here */

example3.com

/* result end here */

How should I want make the sql and php codes

Please reply me friends...
Jun 16 '14 #1

✓ answered by Rabbit

That's impossible to do. You can't reference the id, you can't reference the name, you can't reference the domain. You have nothing left to identify what you want. How do you know which row and column to pull if you have nothing to identify it with?

Share this Question
Share on Google+
3 Replies


Expert 100+
P: 1,035
a sql (select-)statement always starts with: SELECT

after that you name the columns you want to see: domains

than you say from which table you want the info:
FROM domains

as last part you can add a filter:
WHERE domains = 'example3.com'


There are some online courses on the internet, you can Google for them a, pretty quick you will find sites like this:
http://www.sqlcourse.com
( i do not know this site, but it looks like its giving a sql course....)
Jun 16 '14 #2

P: 30
thanks for ur reply,

But, it cannot solution for my problem.

The example1.com, example2.com, example3.com, ...

are updated dynamically by the users of my website. So, I couldnot know the domain names listed in the column name "domains". How to get the result without mentioning example domains name?
Jun 17 '14 #3

Rabbit
Expert Mod 10K+
P: 12,359
That's impossible to do. You can't reference the id, you can't reference the name, you can't reference the domain. You have nothing left to identify what you want. How do you know which row and column to pull if you have nothing to identify it with?
Jun 17 '14 #4

Post your reply

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