Saturday, 13 May 2017

node.js with html and mysql array

I query my db from mysql workbench and I want to use this query to html code

connection.query(
    'SELECT dealer_infor.dealer_id, dealer_infor.dealer_branch, dealer_infor.dealer_address, dealer_infor.dealer_tel, dealer_infor.dealer_contact FROM dealer_infor',
    // 'SELECT Bigbike_ID, Bigbike_name, Price FROM bigbike ORDER BY Bigbike_ID',
    function (err, results){
      if (err) throw err;

        res.render('dealer', {dealers: results});
    }
    );

});

And I want to use dealer_branch number 0 on the array



But the result is the only first character of the array

Help me please my final project

Thank you

Sorry for my bad english



via Oakko Phattharawat