Display specific row

gaz

how can i display just one row from a table on a mysql database?

HalfaBee

I think more info is needed.

You can use LIMIT 1 on the query to return just 1 row.

Halfabee

hi-liter

if you're looking for a specific record, use a where clause:

http://www.mysql.com/doc/en/Where_optimisations.html

will bring back a record, or records, all depeding..unique or not.

gaz

so how could i make a link to say the fifth row in a table?

laserlight

you would select with the index of that row (e.g. an AUTO_INCREMENT PRIMARY KEY column)

You could also select and use
LIMIT 4, 1

Weedpacket

Remember, though that "the fifth row in the table" doesn't really mean much for a database - it just means that there are four rows already in the table that had been inserted earlier. It's possible that certain (admittedly drastic) manipulations of the table may see the order being changed - what those manipulations are depends onthe DBMS.

If you're trying to locate specific records, it pays to have a particular field you can use to identify them. Not least because it allows the DBMS to optimise the queries before running them.

gaz

You could also select and use
LIMIT 4, 1

could you show me how you would put this into a mysql query

and could i not just have a link to record_id=5 or something like that to link to the specific record?

laserlight

Yes, that is a method.
However, the actual value may not may not be "5", since you may delete rows as you go along.

An example would be:

SELECT * FROM tablename LIMIT 4, 1

gaz

If i did this

<a href="<? echo $PHP_SELF; ?>?record_id=<?php echo $row_table['id']; ?>">click</a>

It would link to what ever the record id of the record was, say if i was displaying the contents of a table and i wanted each record to link to just that record on its own

and could i use that query as this... <a href="<? echo $PHP_SELF; ?>" onclick="<? SELECT * FROM tablename LIMIT 4, 1 ?> ?

cgraz

php is server-side; javascript is client side. PHP gets processed on the server before any javascript. If you try to use an onclick with php, you're saying when someone clicks this, process something that should have already been processed. It won't work that way.

Cgraz