[RESOLVED] PHP Output

jynx

Hello All,

First post in this forum hope you guys will be kind enough to help a noob. I'm wondering how to get PHP to output my mysql results as links. I have a list of names in my database which I want to make clickable links and I have no idea how to do this? can anyone help? or point me in the right direction for tutorials that will help..many thanks 🙂

Kudose

Can you please post the code you have? It will be very easy to create links from your results after we have that.

jynx

Thank you for your response here is my code

<?PHP

$link = mysql_connect("****","*****","");
mysql_select_db("****");


$query = "SELECT designer_name FROM designer WHERE left (designer_name,1) ='c'";

$results = mysql_query($query);

echo "<?xml version=\"1.0\"?>\n";
echo "<designers>\n";

while($line = mysql_fetch_assoc($results)) {
		echo "<designer><![CDATA[ <br />" . $line["designer_name"] . "]]> </designer>\n";
}

echo "</designers>\n";


mysql_close($link);


?>

Kudose

A link in the traditional sense is used in HTML, but you are working with XML.

Generating HTML, you could use this code:

echo '<a href="http://phpbuilder.com">' . $line["designer_name"] . '</a>';

jynx

Thank you very much seems to have worked, what if each name needs to go to a seperate link that was my original dilemma?

Many Thanks if you can help me

Kudose

I am assuming you want to query the specific item via link here ...

echo '<a href="item.php?id=' . $line['designer_id']. '">' . $line["designer_name"] . '</a>';

From there ... item.php

echo $_GET['id'];

jynx

Thanks again for the reponse, not sure thats what I need to do. As you helped me the first time I just want the letters to go to different webpages. I am doing a Flash application which is why I'm using XML and just need each name to go to a different link such as http://www.phpbuilder.com/. Sorry if im confusing...thanks for your paitence

Kudose

Something like:

echo '<a href="' . $line['designer_url']. '" target="_blank">' . $line["designer_name"] . '</a>';

Kudose

Unfortunately I can't help you with Flash.

jynx

Its The PHP I need to modify flash is just reading my outputted XML, don't need any help with Flash. I literally just need the different names to go to different links instead of only being able to go to phpbuilder.com which you helped me with in the first example. the 2nd name for example might need to go to www.facebook.com...3rd name www.myspace.com..just examples

Thank you for your help, I really appreciate it Kudose

jynx

would designer URL be a column in my database with listed URLS?

Kudose

jynx;10938905 wrote:
would designer URL be a column in my database with listed URLS?

Exactly.

jynx

Thank you very much!!!!!