thanks everyone - a lot of help and I have learned loads ;-) >SELECT MAX(prop_rank)...
>"A Taylor" <[EMAIL PROTECTED]> wrote in message >[EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > howdy all, > > I was wondering if you could help me, I have a perl script that executes >a > > SQL statement: > > > > 'SELECT prop_rank FROM main ORDER BY prop_rank DESC' > > > > This returns many records but all i am interested in is the highest rank > > hence the 'ORDER BY prop_rank DESC'. > > I then retreive the highest rank like so: > > > > $rank = $sth1->fetchrow_array(); > > > > Now, my question is this: is this the right way to retreive just 1 >record, > > using fetchrow_array(); ??? or is there a more acceptable way. This does > > work, its just the 'array()' part is making me a little uneasy. > > > > Thank you all for you wisdom, > > Anadi _________________________________________________________________ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
