Text to Link??

[Anon]

Hello,
I'd like to pull 30 or 40 text items from a mysql table, then display them in a browser window as links. When clicked, a int value counts up one. (Like a poll function)

My table has unique id for each item as well as item_title and num_votes.

Any ideas or can anyone point me in the right direction ?
Regards,
Mick

[[deleted]]

hello mick

i think this is the way to do it.

you run the query up ($query = "select id,fld_name from $tblName") on a mysql connection as $result = mysql_query($result).

while($row=mysql_fetch_row($result))
{

 $dispStr .= "<a href=".xxx?fldId=$row[0]."</a>"

}

once you get that query string passed (id) you can pick that up after the post or get variables and then update your hit count.

"update $tblName set hits=hits+1 where id=".$fldId"

i hope i have got that right.maybe that helps you.
sorry for the loose ends.