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

No comments:

Post a Comment