Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- results2 = [];
- categories2 = [];
- // SQL Query > Select Data
- const query2 = client.query('SELECT * FROM entries ORDER BY id desc');
- // Stream results back one row at a time
- query2.on('row', (row) => {
- results2.push(row);
- });
- const query3 = client.query('SELECT * FROM categories ORDER BY id desc');
- // Stream results back one row at a time
- query3.on('row', (row) => {
- categories2.push(row);
- });
- // After all data is returned, close connection and return results
- query3.on('end', () => {
- done();
- return res.render('index2.ejs',{results:results2,categories: categories2});
- });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement