Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
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 exploiting the Monastery: (10)
As of 2015-09-01 08:38 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The oldest computer book still on my shelves (or on my digital media) is ...













    Results (368 votes), past polls