473,385 Members | 1,958 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

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

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?

3 1085
Luuk
1,047 Expert 1GB
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
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
12,516 Expert Mod 8TB
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

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

Similar topics

0
by: Justin Tocci | last post by:
I've found the pg_depend table, but it doesn't appear to include this info. (Or am I missing it?) I'm looking to get all view names that I need to drop to allow a particular table to DROP...
1
by: Rob Tiemens | last post by:
hello, I need to select the first and the second column of a table. But I don't know the names of the columns. Is there any way I can select only the first column from a table without knowing...
1
by: sandeep banerjee | last post by:
suppose i have got a project which uses 100 forms .there is a particular table say t_1 which is used in many forms .I want to make change in the code where ever the table t_1 ...
1
by: sasparag | last post by:
Hi Friends, I want to increase the height of my IFRAME without refreshing its contents. presently i am using following code but it refreshes the contents of IFRAME can any one suggest me a better...
1
by: judy | last post by:
I have several databases that are used to collect data for different client-projects. My intention was to collect the data, and administer mySQL so each client could see only their data. Each of...
1
by: alex250374 | last post by:
Hello to all, are not practical and db2... I need urgent help: how can count the number of select is done on a particular table in a certain period of time?
2
Ashwani Sharma
by: Ashwani Sharma | last post by:
In CSS for any first element we always use :First-Child attribute. Is there any other attribute for last or other elements to use as :First-Child? Please let me know if there is any: Thanks in...
2
by: Aniket sonmale | last post by:
hi, i am working on db2. how can i check for a particular table,the primary key of that table. for eg. in table REGISTRATION their are around 20 columns. how to check which is the primary key of...
1
by: PHPstarter | last post by:
Hello! I'm trying to write a jquery function that can be used on a select tag and run when an onchange has occured. The idea is that the option elements have values of classnames, which the...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.