Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
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


Comment on Re: Select Specific Row Of Data From MySQL using DBI?
Select or Download Code

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 wandering the Monastery: (5)
As of 2014-09-16 07:59 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    My favorite cookbook is:










    Results (157 votes), past polls