Lines 238-250
$query = '
Link Here
|
238 |
INSERT INTO creator_batches |
238 |
INSERT INTO creator_batches |
239 |
(batch_id , item_number, borrower_number, |
239 |
(batch_id , item_number, borrower_number, |
240 |
timestamp, branch_code, creator) |
240 |
timestamp, branch_code, creator) |
241 |
VALUES (?,?,?,?,?,?)'; |
241 |
VALUES (?,?,?,NOW(),?,?)'; |
242 |
$insert_sth = $dbh->prepare($query); |
242 |
$insert_sth = $dbh->prepare($query); |
243 |
$insert_sth->execute( 11, $item_number1, $borrowernumber1, 'now()', $library1->{branchcode}, 'Labels' ); |
243 |
$insert_sth->execute( 11, $item_number1, $borrowernumber1, $library1->{branchcode}, 'Labels' ); |
244 |
|
244 |
|
245 |
$insert_sth->execute( 12, $item_number2, $borrowernumber2, 'now()', $library2->{branchcode}, 'Labels' ); |
245 |
$insert_sth->execute( 12, $item_number2, $borrowernumber2, $library2->{branchcode}, 'Labels' ); |
246 |
|
246 |
|
247 |
$insert_sth->execute( 12, $item_number3, $borrowernumber3, 'now()', $library3->{branchcode}, 'Labels' ); |
247 |
$insert_sth->execute( 12, $item_number3, $borrowernumber3, $library3->{branchcode}, 'Labels' ); |
248 |
|
248 |
|
249 |
########################################################### |
249 |
########################################################### |
250 |
# Testing Subs |
250 |
# Testing Subs |
251 |
- |
|
|