#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2000
    Posts
    108
    Rep Power
    15
    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. #2
  3. .Net Developer
    Devshed Novice (500 - 999 posts)

    Join Date
    Feb 2000
    Location
    London
    Posts
    987
    Rep Power
    15
    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"







Similar Threads

  1. div style="overflow: scroll;"
    By slydero in forum HTML Programming
    Replies: 8
    Last Post: October 26th, 2004, 09:54 AM
  2. <THEAD> not printing across multiple pages
    By allanmcc in forum HTML Programming
    Replies: 2
    Last Post: September 29th, 2003, 08:47 PM
  3. HELP! how to retrieve a specific row from the database using jsp
    By chloe4irene in forum HTML Programming
    Replies: 3
    Last Post: March 23rd, 2003, 12:10 AM
  4. How to retrieve offset to particular row?
    By Ahriman in forum MySQL Help
    Replies: 1
    Last Post: April 12th, 2002, 03:17 AM

IMN logo majestic logo threadwatch logo seochat tools logo