Unfortunately I know all about things that should be easy but turn into huge headaches. I've been noticing the progress on the front page, looks like you've almost got it!
This part really confuses me. I don't know why all that would be in a cell that should just have a url. If I'm understanding the next part then this may not matter.
If I understand this part, then you're saying you've done something like:
$event = mysql_query("SELECT etc.");
If you haven't, hopefully my answer will still help you. If you have, then the thing is that the mysql_query() function returns a recordset(even if it's only one record), not an array. And you can't just retrieve a value from a recordset. The mysql_fetch_array() function takes a recordset as input, returns an array on the current record, and moves to the next record in the recordset. So, to get an actual value from a recordset you have to loop through it with the mysql_fetch_array() function. Here's how I did it, hopefully the sample code with comments will clarify everything.
# this gives me my recordset
$result = mysql_query("SELECT * FROM `htsrc`.`news` ORDER BY `date` DESC") or die(mysql_error());
# this function tells me how many records are in the recordset, so I know how many times to loop
$rows = mysql_num_rows($result);
for ($i = 1; $i <= $rows; $i++){
# this gives me the array, from which I can actually retrieve values
$row = mysql_fetch_array($result);
# if all I wanted to do with each record is create a cell in a table containing a link which comes from a field in the record called url, I'd do something like this
echo "<td><a href='$row[url]'>LINK</a></td>";
# note the syntax for retrieving a value from an array: $arrayname[fieldname]
}
[/PHP]
Sorry if I'm totally on a different page here.
Ask away, I'm about as familiar with css as I am with php. I'm happy to help if I can.