954,560 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Mysql select rows that hasnt been selected

Hi . I am building a live chat using mysql and the database is updated because of users entries . So the number ow rows in the table changes constantly . And need to use a query which will select the rows that hasnt been selected.
SO how do I do that ?

Thank you in advance!!!

narekm
Light Poster
25 posts since Mar 2011
Reputation Points: 10
Solved Threads: 0
 

what do u mean by "hasnt been selected"

urtrivedi
Nearly a Posting Virtuoso
1,306 posts since Dec 2008
Reputation Points: 257
Solved Threads: 270
 

It simply means in my other queries it hasnt been selected as a result that i wanted.

narekm
Light Poster
25 posts since Mar 2011
Reputation Points: 10
Solved Threads: 0
 

One query is not related to another query unless you execute both together in (one combined query).

You must have some flag in table to track the changes, buy using this flag u can filter your result.

urtrivedi
Nearly a Posting Virtuoso
1,306 posts since Dec 2008
Reputation Points: 257
Solved Threads: 270
 

This question has already been solved

Post: Markdown Syntax: Formatting Help
You