hi there,
i've got an mysql database with a table in it called "links".
the table has three different fields: 'id', 'link' & 'category'.
there are 100 links in my table with 2 different categories: 'private' & 'public'.
I need to SELECT those records that have the 'category' field set to 'public' and give these records a following number.
my output should be something like:
link1=www.1stlink.com
link2=www.2ndlink.net
and so on.
This output should only take those records that have the 'category' field set to : 'public'.
hope you understand the question. i really tried to explain it as clear as poosible.
i'm writing it in php and it communicates with a mysql database... 😃
cheers and thanks a whole lot!
chris
