Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re: Re: MySQL and Perl - Shorthand

by broquaint (Abbot)
on Sep 21, 2002 at 13:06 UTC ( [id://199744]=note: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    $sth = $db->prepare("SELECT the_name FROM the_table WHERE id=?");
    $sth->execute(3);
    my ($the_name) = $sth->fetchrow_array;
    
  2. or download this
    my ($the_name) = $dbh->selectrow_array(<<SQL, undef, 3);
    SELECT the_name FROM the_table WHERE id = ?
    SQL
    

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others sharing their wisdom with the Monastery: (5)
As of 2024-04-16 17:54 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found