Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical

Re: PERL and MySQL

by meraxes (Friar)
on Oct 19, 2007 at 15:14 UTC ( #646002=note: print w/replies, xml ) Need Help??

in reply to PERL and MySQL

If I may suggest as well, doing this using sprintf is not ideal. Using placeholders is always a better idea:

my $sql = q{ SELECT `Cats`.`Name`, `Address`.`Address`, `Address`.`City`, `Contact`.`Phone`, `Keys`.`Keywords` FROM ( `Cats` LEFT JOIN `Address` USING (`Name`) LEFT JOIN `Contact` USING (`Name`) LEFT JOIN `Keys` USING (`Name`) ) WHERE `Keys`.`Keywords` LIKE ? ORDER BY `Cats`.`Name` asc LIMIT ?,? }; # get the statement handle, assuming a valid DBI object in $dbh my $sth = $dbh->prepare( $sql ); $sth->execute( '%'.$search.'%', $start - 1, $per_page + 1 );

You also had the "order by" clause stating name. I would have thought that'd be an error since you're not specifying the table in a join. I've changed it to `Cats`.`Name`.

update: I'm an idiot. Fixed execute syntax.


Replies are listed 'Best First'.
Re^2: PERL and MySQL
by JimJx (Beadle) on Oct 20, 2007 at 07:13 UTC
    Thanks for all of the suggestions everyone!

    The '%%' was the culprit... Also, since I am working with a premade script of sorts here, I am just trying to get it to work, but I do plan on using placeholders when I get the time to do a rewrite. IMO the whole script needs it....

    Once again, thanks everyone!

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://646002]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (6)
As of 2018-02-22 05:51 GMT
Find Nodes?
    Voting Booth?
    When it is dark outside I am happiest to see ...

    Results (288 votes). Check out past polls.