Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

Re: Select Specific Row Of Data From MySQL using DBI?

by meraxes (Friar)
on Jan 20, 2009 at 00:58 UTC ( #737440=note: print w/ replies, xml ) Need Help??


in reply to Select Specific Row Of Data From MySQL using DBI?

You may wish to read: How do I post a question effectively?

Uhhh... kinda vague. This isn't necessarily a Perl question. What have you done? Do you mean you've run a query that returns 100 rows or that you have a table that has 100 rows and you only want one?

If it's the former, where is the data? In an array? Then you need only reference that element in the array: $rows[50].

If it's the latter you need to adjust your SQL's WHERE or LIMIT to get only the needed row... not a Perl problem at all.

--
meraxes

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://737440]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (4)
As of 2016-06-30 03:25 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    My preferred method of making French fries (chips) is in a ...











    Results (388 votes). Check out past polls.