|
|
Posted by Hilarion on 07/14/05 18:49
Luigi Donatello Asero wrote:
> > > I wonder whether I could write links within a table at mysql as text so
> > > that the user could follow these links which would be displayed on the
> > > table on the webpage.
I replied:
> > I think you should try thinking for yourself and read some manuals before
> > asking questions on usenet, cause your questions are getting a bit
> > annoying.
Luigi replied:
> Please do not answer my questions if you think that they are annoying.
I'm afraid it's too late. I already did answer your questions. Maybe if you'd
try to read and understand the answers people here are giving you, you would
not have to ask same questions again and again. You probably noticed that not
many readers of this newsgroup have answered your questions and those who did
stopped responding your further questions. Think about that and read again the
replies you got, because they do answer your questions.
Remember also that even if someone decides not to answer your posts, one
is still forced to read ("manually" or using some news client software filters)
the post header to check if it's from you or not, and even then one could see
your texts in replies to your posts. So the problem is not me (or someone else)
answering your questions or not answering your questions, but you asking them.
Hilarion
As I do not like posts totally not referring to thread topic I will try to
answer your URL problem in a simplier way. It would be easier if you posted
your current code, but I'll try to do it based on previous one.
<?php
/*
Place proper doctype here, but USE it. This means following the rules
of the doctype, not only placing it's declaration here.
Check this site (it validates your webpage against the doctype declaration
you used):
http://validator.w3.org/check?uri=https%3A%2F%2Fwww.scaiecat-spa-gigi.com%2Fsv%2Fboende-i-italien.php
*/
?>
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1" />
</head>
<body>
<?php
// connecting to DB
$db = mysql_connect( 'localhost', 'user', 'password' );
if ($db===FALSE)
{
die( 'Connection error: ' . mysql_error() );
}
// selecting database
if (!mysql_select_db( 'databas', $db ))
{
die( 'Error selecting DB: ' . mysql_error() );
}
// executing query
$result = mysql_query(
'SELECT Region, Ort, Sovplatser, Rum, Avstlnd_km, Terrass, Lagenhetsnummer, URL ' .
'FROM some_table',
$db
);
if ($result===FALSE)
{
die( 'Error executing select statement: ' . mysql_error() );
}
// table header
?>
<table summary="semesterbostäder" border="1" cellspacing="0" cellpadding="3">
<caption>Semesterbostäder i Italien</caption>
<col />
<col />
<col align="right" />
<col align="right" />
<col align="right" />
<col align="center" />
<col align="right" />
<col />
<thead>
<tr>
<th id="t1">Region</th>
<th id="t2">Ort</th>
<th id="t3">Sovplatser</th>
<th id="t4">Rum</th>
<th id="t5">Avstlnd till havet i km</th>
<th id="t6">Terrass</th>
<th id="t7">Lägenhetsnummer</th>
<th id="t8">URL</th>
</tr>
</thead>
<tbody>
<?php
// fetching results
$indent = ' ';
while ( $mycolumn = mysql_fetch_array( $result, MYSQL_NUM ) )
{
echo $indent . "<tr>\n";
for ( $i=1; $i <= 7; $i++ )
{
echo $indent . ' <td headers="t'.$i.'">';
echo htmlspecialchars( $mycolumn[$i] );
echo "</td>\n";
}
echo $indent . ' <td headers="t8">';
echo '<a href="' . htmlspecialchars( $mycolumn[8] ) . '">';
echo htmlspecialchars( $mycolumn[8] );
echo '</a>';
echo "</td>\n";
echo $indent . "</tr>\n";
}
?>
</tbody>
</table>
</body>
</html>
[Back to original message]
|