the results of a query, as hyper link

sanoop

Can we by any chance display the results of a query, as hyper link? Also is it possible to retain the rest of web page as such ?

Blulagoon

Not really sure what you are trying to achieve here, but if you want to very simply display the individual results as hyperlinks just wrap <a href> tags around them:

echo "<a href='".$row['myvar']."'>This is a link</a>
or
echo "<a href='mysite.com/process.php?myvar=".$row['myvar']."'>This is a link</a>

sanoop

Hi ,

I am trying to excute one query while clicking on an alphabet in the alphabet listing.The result(author listing with that alphabet) is again displayed as hyperlink to another page where the books will be displayed by that author. I have written the following code, but keeping on getting errros. Expecting some help.....

<?php
/ Connecting, selecting database /
$link = mysql_connect ("localhost", "database", "password") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db("morete5_quotes") or die("Could not select database");
$sor = $_GET['by'];

/* Performing SQL query */
$query = "SELECT DISTINCT Author FROM Quotes WHERE Author LIKE '$sor%'";
$result = mysql_query($query) or die("Query failed : " . mysql_error());

/* Printing results in HTML */
print "<table>\n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
    print "\t<tr>\n";
    foreach ($line as $col_value) {

echo "<a href='http://www.mysite.com/Author_A1.php?by=".$col_value"'">$col_value</a>
}
print "\t</tr>\n";
}
print "</table>\n";

/* Free resultset */
mysql_free_result($result);

/* Closing connection */
mysql_close($link);

Blulagoon

It might be easier to do it something like this ?

/* Printing results in HTML */
print "<table>\n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
print "\t<tr>\n";

echo "<a href='http://www.mysite.com/Author_A1.php?by=".$line['Author']."'>".$line['Author']."</a>";

Blu

sanoop

Thanks Blu for your help,

The code is working.. But the issue is if the name of author is Aaron Burr . It displays the 2 words in two lines.like
Aaron
Burr

Is there a way to display this in a single line?

Blulagoon

Do you use a tool like PHP My Admin, can you see if that line break is in the data in the db ?

Also you should try this purely for debugging purposes:

while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { 
echo $line['Author']; 
echo "<br>";

This should echo out the authors names, each on a new line. If it still insists on
putting that extra line spacing in, take a look at the browser page source to see if you can see what is causing the problem

HTH - Blu

sanoop

Thanks .. Blu..

I was playing with the code and when I modified the below statement ,including <td> and </td> the result was proper.I mean the first and second name came in same line.

echo "<td><a href='http://www.mysite.com/Author_A1.php?by=".$line['Author']."'>".$line['Author']."</a></td>";

cretam

Hi Sanoop,
I am trying to do exactly what you have done here, I was wondering if you could share all your code or email it to me. I am having trouble here please view my thread http://www.phpbuilder.com/board/showthread.php?t=10328766 and see if you can help.