[RESOLVED] hyperlink problem

fibonacci

hi..

i have a problem on hyperlink using <a href>.
i have a table like this;

table: search
id
title
url
description
keyword

below is my php code...

$keywords=$_POST['keywords'];


$result = mysql_query(" SELECT title,url, description FROM search WHERE description LIKE '%$keywords%'") or die(mysql_error());

while ($row = mysql_fetch_array($result)){
if($result >0){

	echo '<table>';

	echo '<h1><p><tr><b><a href=".$row["url"].">'.$title=$row["title"].'</a></b></tr></p></h1>';

	echo '<p><tr>'.$description=$row["description"].'</tr></p>';
	echo "</table>";
}else{
	echo "No result found";
	}
}

can anyone help me how can i use the hyperlink after i click on the "title",
then the link should be link to the 'url' address from the database shows at this line

echo '<h1><p><tr><b><a href=".$row["url"].">'.$title=$row["title"].'</a></b></tr></p></h1>';

and could anyone spot anything with my if else code as my 'else' did not return any result...just a blank page 😕

bogu

Your 'if' should be:

if (mysql_num_rows($result)) {
    ...
} else {
    ...
}

About your a href problem, I dont know what problem do u encounter, but u could view source to see if your html code is K...

ClarkF1

Try

echo "<h1><p><tr><b><a href=\"".$row['url']."\">".$row['title']."</a></b></tr></p></h1>";

I'm not sure why you have $title=$row["title"] in your coding.

You could put $title=$row["title"]; in your script and then just use $title in the echo statement.

fibonacci

clarkF1 : yeah i put it coz i dont want to declared it in my script
bogu: thanks, it help me solve it

but, i still can't link my Title to the url in my database..
if anybody can help me or i have to explain a lil bit clear.. 😕

actualy i have a database called SEARCH with id, title, url, desc in it.
using my code above, i echoed the title. I wanted the title to be link to it's url from the database. let say;

table SEARCH;
id: 01
title: The Apple
url: http://apple.com
desc: this is an apple

so, when i used this code;

echo ".$row['title'].";

i want it to automatically link to the http://apple.com.

so, can anyone help me here??

scoppc

well, the normal structure of an <a> tag is:

<a href="http://www.phpbuilder.com">phpBuilder</a>

If you are not aware of this, the http:// must be there. If not, your link wont work.]
HTH

fibonacci

well Scoppc, thanks for the reply

i already know the use of ' http:// ' .. in basic html...
that's why i already put on my previous code something like this

echo "<tr><a href=\"".$row['url']."\">".$row['title']."</a></tr>";

here, i need the The Apple to read the url of http://apple.com straight away
after i click the title or any other title & url in my database (using array function).

fibonacci

heyya..
thank god..

someone help me with this code n it works

echo "<h1><tr><td><b><a href=\"".$row['url']."\">".$row['title']."</a></b></td></tr></h1>";