joshgarrod Posted July 24, 2007 Share Posted July 24, 2007 Hello, this script is proving a pain, lol. i cant seem to get the URL in the search results to become a link... please help echo "<b>URL - Click here to view more details: </b>"; echo $result["<a href='URL'></a>"]; echo "<br>"; echo "<hr>"; Quote Link to comment Share on other sites More sharing options...
piznac Posted July 24, 2007 Share Posted July 24, 2007 echo "<a href=\"$results[url]\">My Link</a>"; Does that work? Quote Link to comment Share on other sites More sharing options...
stlewis Posted July 24, 2007 Share Posted July 24, 2007 Well, in the code that you've displayed there, you've got no anchor text for the URL, so technically, nothing would display. If $result is a collection of data that you've pulled in from a database search, make sure that the data you're echoing back is actually a URL too :-) Quote Link to comment Share on other sites More sharing options...
keeB Posted July 24, 2007 Share Posted July 24, 2007 <?php // ex 1 $url = "http://ohboy.com"; echo '<a href="$url">some text</a>'; //ex2 $url = array("url"=>"http://ohboy.com", "name" => "Oh Boy!"); echo '<a href=$url[url]>$url[name]</a>'; ?> Quote Link to comment Share on other sites More sharing options...
joshgarrod Posted July 24, 2007 Author Share Posted July 24, 2007 Piznac, that sort of works but its not pulling the URL from the URL field in my table, it is linking back to my homepage? Quote Link to comment Share on other sites More sharing options...
piznac Posted July 24, 2007 Share Posted July 24, 2007 That would give me the impression that the $results field is not being pulled right. With you saying that I assume there is a url in the db field. Can you give me an example of a url in the field? Quote Link to comment Share on other sites More sharing options...
joshgarrod Posted July 25, 2007 Author Share Posted July 25, 2007 Here is an example, http://www.webpurchase.co.uk/Graham/mh2.nsf/df930f6bbcc4ea9f802571cd001c4052/f81ad4a24486686b8025732200348993!OpenDocument Quote Link to comment Share on other sites More sharing options...
joshgarrod Posted July 25, 2007 Author Share Posted July 25, 2007 I tried this same piece of code on another working search script and it does the same thing, just links back to the homepage so i assume it must be something in the code. Quote Link to comment Share on other sites More sharing options...
dg Posted July 25, 2007 Share Posted July 25, 2007 i think it should be this way......... $url = array("url"=>"http://ohboy.com", "name" => "Oh Boy!"); echo "<a href=\"$url\">$url[name]</a>"; Quote Link to comment Share on other sites More sharing options...
dg Posted July 25, 2007 Share Posted July 25, 2007 sorry missed out </a> $url = array("url"=>"http://ohboy.com", "name" => "Oh Boy!"); echo "<a href=\"$url\">$url[name]</a>"; Quote Link to comment Share on other sites More sharing options...
joshgarrod Posted July 25, 2007 Author Share Posted July 25, 2007 but how is that using the information from the database? Quote Link to comment Share on other sites More sharing options...
dg Posted July 25, 2007 Share Posted July 25, 2007 from the database u r getting in terms of array right ....... like $result["URL"] and $result["name"]...... check the field name are proper Quote Link to comment Share on other sites More sharing options...
joshgarrod Posted July 25, 2007 Author Share Posted July 25, 2007 could you please show me where this would go in my script? That would help loads, thanks <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Search for spares</title> <style type="text/css"> <!-- .style1 {font-family: Arial, Helvetica, sans-serif} --> </style> </head> <body> <h2 class="style1">Search</h2> <form action="<?=$PHP_SELF?>" method="post" name="search" class="style1"> Seach for: <input type="text" name="find" /> in <Select NAME="field"> <Option VALUE="Make" selected="selected">Make</option> <Option VALUE="Model">Model</option> <Option VALUE="Engine">Engine</option> <Option VALUE="Berth">Berth</option> <Option VALUE="Year">Year</option> </Select> <input type="hidden" name="searching" value="yes" /> <input type="submit" name="search" value="Search" /> </form> <p class="style1"> <?php $find = $_POST['find']; //This is only displayed if they have submitted the form if ($searching =="yes") { echo "<h2>Results</h2><hr>"; //If they did not enter a search term we give them an error if ($find == "") { echo "<p>Please enter a search term"; exit; } // Otherwise we connect to our Database mysql_connect("sdffh", "dsfh", "dasfhsd") or die(mysql_error()); mysql_select_db("sto21") or die(mysql_error()); // We preform a bit of filtering $find = strtoupper($find); $find = strip_tags($find); $find = trim ($find); //Now we search for our search term, in the field the user specified $find_array = explode(" ", $find); $find_sql = ""; // init foreach ($find_array as $temp) $find_sql .= "upper($field) LIKE '%".$temp."%' OR"; // note only need to do the substr once, the second time was removing the other %' $find_sql = substr($find_sql, 0, -3); // throw away last OR statement $sql = "SELECT * FROM motorhomes WHERE $find_sql"; $data = mysql_query($sql) OR DIE("SQL Was: " . $sql . "<br />ERROR: " . mysql_error()); $sql = mysql_query("SELECT * FROM motorhomes"); $num = mysql_num_rows($sql); if ($num > 0) { // There's a result } else { // No results found. }//And we display the results while($result = mysql_fetch_array( $data )) { echo "<b>Motorhome ID: </b>"; echo $result['MhID']; echo "<br>"; echo "<b>Make: </b>"; echo $result['Make']; echo "<br>"; echo "<b>Model: </b>"; echo $result['Model']; echo "<br>"; echo "<b>URL - Click here to view more details: </b>"; echo "<a href=\"$results[url]\">URL</a>"; echo "<br>"; echo "<hr>"; } //This counts the number or results - and if there wasn't any it gives them a little message explaining that $anymatches=mysql_num_rows($data); if ($anymatches == 0) { echo "Sorry, but we can not find an entry to match your query<br><br>"; } //And we remind them what they searched for echo "<b>Searched For:</b> " .$find; } ?> </p> </body> </html> Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.