Kevin Castro Posted August 12, 2016 Share Posted August 12, 2016 i want to show the record from mysql database when the users are not paid the initial amount? my database look like this: i've a table called roombooking in that field i've several columns like name,mob ,paid_amount and balance_amount.. so i want to retrieve a data who are all not paid the initial amount.... can u please tell me how to show it? Thanks in advance Link to comment Share on other sites More sharing options...
justsomeguy Posted August 12, 2016 Share Posted August 12, 2016 I don't know what the initial amount is, but you use a where clause to filter the records returned by a query. Link to comment Share on other sites More sharing options...
Kevin Castro Posted August 15, 2016 Author Share Posted August 15, 2016 I've table with 2 columns like name and amount.Assume that the table has some records.Some of the records would have the values in the amount column and some of them are not.I just want to count how many records should have values in the amount column? Link to comment Share on other sites More sharing options...
justsomeguy Posted August 15, 2016 Share Posted August 15, 2016 You can use the count function to count rows: http://dev.mysql.com/doc/refman/5.7/en/counting-rows.html Link to comment Share on other sites More sharing options...
Kevin Castro Posted August 16, 2016 Author Share Posted August 16, 2016 Thank u i found the ans Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now