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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...