MSDN being the community news groups which tend to be easier to follow 😉
You can store the hyperlinks as regular text. All you need is to store the actual URL in the database. THen after querying, you just need to plug the URL value into the <a> tag string.
As for photos, it's much the same thing. Just store the path to the image(s) in the table. You can store the image itself inside the table; however, it can make the DB slower, and it also bloats the DB. So just store the path to the photo as a regular string, and then when you query it, just take the value of the path column for the row and plug it into the src attribute for the <img> tag.
I don't know of any online resource for specifically just that; however, if I were using mySQL, here's what it'd look like:
<?php
/*
Database connection stuff would go here...
*/
$query = "SELECT `url`, `img` FROM `tshirts`";
$result = mysql_query($query) or die(mysql_error());
if(!$result)
{
echo 'Sorry, no results were found.';
exit;
}
while($row = mysql_fetch_assoc($result))
{
echo '<a href="' . $row['url'] . '"><img src="' . $row['img'] . '" /></a>';
}
?>
MS Access has its own functions and I'm sure a slightly different syntax; however, I think that's the gist of it.
