Ok -- if I take the following code that works:
<?php
mysql_connect("localhost","13579","acegikmo") or die("Unable to connect");
@mysql_select_db("hot_dogs") or die("Unable to select database");
$result = mysql_query("SELECT * FROM url_store WHERE title LIKE '%$searchterm%' OR
description LIKE '%$searchterm%' OR keywords LIKE '%$searchterm%' OR location LIKE '%$searchterm%'
OR channel LIKE '%$searchterm%'");
$num = mysql_num_rows($result);
if ($num != "0") {
while ($row = mysql_fetch_row($result)) {
echo "$row[1], $row[2], $row[3]";
}
} else {
echo "No matches";
}
?>
How do I get the row "title" to hyperlink itself with the row "url" automatically?
Also, when formatting the results -- do I just use multiple echo statements to move the row results around, giving them some format?
Regards,
Guido
