my problem i have a system build in php.in one part of the system i need to make the system can suggest the list of qualfied candidate which the candidate information are from mysql ,,this rule make ussing prolog backtracking technic...?
A:
if i understand correctly, you are not using prolog. you are using just php and mysql, but you want to use mysql in a way that works like prolog?
if so, that is not possible. sql and prolog are both declarative, but they are implemented very differently. the way sql is implemented does not use backtracking.
however, i am having trouble understanding why backtracking would be important. is this an issue with efficiency where you would use "cut?". making sql efficient is very different - you use "indexes" which allow the sql "compiler" to optimise the query.
so your question does not make much sense. can you explain more?
as a wild, desperate, guess perhaps what you want to use is sql cursors - these let you access a sequence of results from sql. is the information at http://dev.mysql.com/doc/refman/5.0/en/cursors.html any use?
andrew cooke
2009-12-19 12:05:00