|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Generate data entry and reporting .NET Web apps in minutes, straight from your database. Read our FREE whitepaper “Build Web 2.0 Applications Without Hand-Coding” Download now! |
|
#1
|
|||
|
|||
|
Hello.
What is the best way to retrieve a specific row from a SELECT return (in Perl DBI)? For example, if I have a table with First Name Last Name Phone # First Name Last Name Phone # First Name Last Name Phone # If I wanted to access the information in the third row, what is the most efficient way to do this? (Right now, I am using a while loop, going through and fetching the row 3 times) Thanks! http://www.datera.com |
|
#2
|
||||
|
||||
|
use Select statement with where condition.
If you add a sno (auto_increment) field in your database,you can perform this kind of action very easliy with select query. "SELECT * FROM tblname where sno=3" |
![]() |
| Viewing: Dev Shed Forums > Databases > MySQL Help > Best way to retrieve a row? (fetchrow) |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|