Help with print command

25lez25

Newbie question

I am trying to see how to get the following sequence to run and print out a series of links. In particular, not sure how to code the print step (?print or echo or printf and the syntax ).

<body>

<?php
$db = mysql_connect("localhost", "user", "password");
mysql_select_db("databasename",$db);
$sql= "select someid, topic from table order by someid asc limit number";
$result= mysql_query($sql,$db);

while($Row = mysql_fetch_array($result))
{

(? need help with how to print and correct the syntax on the following link command so the URL of each link ends up as:
http://www.justamadeupsitexyz.com/somefile.php?someid=number and the name for link is "topic")

<a href="http://www.justamadeupsitexyz.com/somefile.php?someid=<?=$Row["someid"]?>"
<=$Row["topic"])
</a>) ");

}
?>

</body></html>

Thank you

Gary_King

Try this:

<html> 
<head></head> 

<body> 


<?php 
$db = mysql_connect("localhost", "user", "password"); 
mysql_select_db("databasename",$db); 
$sql= "select someid, topic from table order by someid asc limit number"; 
$result= mysql_query($sql,$db); 

while($Row = mysql_fetch_array($result)) 
{

print "<a href=\"http://www.justamadeupsitexyz.com/somefile.php?someid=".$Row["someid"]."\"".$Row["topic"]."</a>";

} 
?> 
</body></html>

25lez25

Thanks; but.......

I tried it with fields from my table but just get a blank page
If I kept everything the same and just put in the following echo in place of the link command it prints out a series of NothingtoDisplays so I know it works until the last line;

echo("Nothing to Display!");

I must still be doing something wrong-I have been going over it to check for my errors-still looking but so far havent found anything

25lez25

Actually the blank page that is generated, when I check the view source, it shows the equivalent of:

How can I end up with just the underlined links for these URL's and the name above the underlined link to be the respective topic?

Gary_King

I didn't close the <a>. Fixed it now. I'm not sure what exactly you want, so try what I have for you, and tell me if you need some changes made to it.

<html> 
<head></head> 

<body> 


<?php 
$db = mysql_connect("localhost", "user", "password"); 
mysql_select_db("databasename",$db); 
$sql= "select someid, topic from table order by someid asc limit number"; 
$result= mysql_query($sql,$db); 

while($Row = mysql_fetch_array($result)) 
{

print $Row["topic"]."<br><a href=\"http://www.justamadeupsitexyz.com/somefile.php?someid=".$Row["someid"]."\">http://www.justamadeupsitexyz.com/somefile.php?someid=".$Row["someid"]."</a><p>";

} 
?> 
</body></html>

25lez25

That works nicely and thank you. But it gives me the following output (with the Topic above and below is the actual URL written out and underlined as a link)

“Topic”

………/somefile.php?someid=a number fully written out and visible

What I would prefer if possible is the following 1 line output:

“Topic”

where "Topic" is underlined, and when you click the link where it says “Topic” you are taken to the URL ........../somefile.php?someid=a number, but the actual URL is not visible until the mouse is placed over the link.

I hope this is not too confusing

Thank you

Gary_King

No problem.

<html> 
<head></head> 

<body> 


<?php 
$db = mysql_connect("localhost", "user", "password"); 
mysql_select_db("databasename",$db); 
$sql= "select someid, topic from table order by someid asc limit number"; 
$result= mysql_query($sql,$db); 

while($Row = mysql_fetch_array($result)) 
{

print "<a href=\"http://www.justamadeupsitexyz.com/somefile.php?someid=".$Row["someid"]."\">".$Row["topic"]."</a><br>";

} 
?> 
</body></html>

This will output all of the rows in the table, with their topic name and their link.

25lez25

Thank you. It worked fine