wapally Posted April 13, 2015 Share Posted April 13, 2015 Hello anyone please help me i insert my data into mysql table now i want to show my data output like 500, 500 , 25 i want to count my sql single row data not rows i want to count entry data mean for example my total is 1025 Quote Link to comment Share on other sites More sharing options...
blacknight Posted April 13, 2015 Share Posted April 13, 2015 you would need to use a while statement to list the data (if multiple rows) but we would need more info to help you like how its stored in the database (schema) and what type of mysql connection you are using Quote Link to comment Share on other sites More sharing options...
cyberRobot Posted April 13, 2015 Share Posted April 13, 2015 now i want to show my data output like 500, 500 , 25 You could look into using MySQL's CONCAT_WS() function: https://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_concat-ws Quote Link to comment Share on other sites More sharing options...
Barand Posted April 13, 2015 Share Posted April 13, 2015 cyberRobot - How do you, or any of us, know what will be of use when we don't know how s/he is storing the data? Quote Link to comment Share on other sites More sharing options...
cyberRobot Posted April 13, 2015 Share Posted April 13, 2015 cyberRobot - How do you, or any of us, know what will be of use when we don't know how s/he is storing the data? I'm just taking a stab in the dark. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.