in reply to Retrieval of ID# as Integer from MySQL
1. don't be afraid to use whitespace:
Makes the SQL much much more readable - but what about the question mark? That's #2:$header_id = $dbh->prepare(" SELECT id FROM press_release WHERE header = ? ");
2. Use bind variables instead of interpolated statements. If this statement is to be executed again and again, using bind variables will increase performance. So, how do you tell DBI what the value of the question mark is? Inside the execute function:
Check out Programming the Perl DBI for more DBI goodness.$header_id->execute($header);
jeffa
|
|---|