Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses

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.


Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://737440]
[Corion]: erix: Heh ;) Transcribing/ writing notes is a good thing, at least for the stuff out of copyright!

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (5)
As of 2018-06-24 07:31 GMT
Find Nodes?
    Voting Booth?
    Should cpanminus be part of the standard Perl release?

    Results (126 votes). Check out past polls.