Re: : request

This will not work, the problem is that you are only receive the result set for the rows which are "like '%$name%'." I cannot think of an elegant solution for this problem, or even a reason for wanting to do this, but if I wanted to do this I would select all the results from the database, loop through them and find ones that match $name. Then you could use the counter method Cranky gave above. Alternativly you could add a ID field to the table which autoincrements, as long as you don't delete records then the "row number" should be correct. Regards, Peter "Pod" Pistorius peterp@podbox.co.za