Jump to content
Kevin Castro

Selecting No of records in php & mysql

Recommended Posts

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

Share this post


Link to post
Share on other sites

I don't know what the initial amount is, but you use a where clause to filter the records returned by a query.

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×