[RESOLVED] Turn a search result into a link?

[crazylegseddie]

I used a search tutorial to create my search function, which i have managed to link to my table and carry out correct searches. How do I edit the script to now turn the title of my search into a link to the product? all my products are linked like this: categories.php?c=0&p=70 ie 'p=70' being the product id.
The code that dispalys the data looks like.

while($row = mysql_fetch_object($result)) 
{ 
  echo '<strong>Title: '.stripslashes(htmlspecialchars($row->pd_name)).'</strong><br />'; 
  echo '<p>'.stripslashes(htmlspecialchars($row->pd_more)).'</p>';  
  echo '<p>'.stripslashes(htmlspecialchars($row->pd_more2)).'</p>'; 
  echo '<hr size="1" />'; 
} 

?> 

I need the title ie. $row->pd_name to be the link.

I tried:

echo "<a href='categories.php?c=0p=". $row['pd_id']. "'>".stripslashes(htmlspecialchars($row->pd_name)).'</a><br />';

but received this error:

Fatal error: Cannot use object of type stdClass as array in C:\Documents and Settings\ben\Desktop\Bens Briefcase\www\whitedisc\searchtemp\search.php on line 64

Any info regarding my query will be cool.

THX

[bradgrafelman]

You're trying to use $row as if it were an array... but it's not. It's an object.

If you want to use arrays, use something like [man]mysql_fetch_assoc/man. If you want to stick with [man]mysql_fetch_object/man, then you'll have to reference the pd_id column by treating $row as an object.

[crazylegseddie]

Im new to searches but using mysql_fetch_object() seems to be the only way that i retrieve search results. I dont quite understand what you mean by referencing the pd_id column by treating $row as an object? How do i go about doing that. Below is my full script if this helps?

<?php 
// Full-Text Search Example 
// Conect to the database. 
require_once 'config2.php';

// Create the search function: 

function searchForm() 
{ 

  // variable setup for the form. 
  $searchwords = (isset($_GET['words']) ? htmlspecialchars(stripslashes($_REQUEST['words'])) : ''); 

  echo '<form method="get" action="'.$_SERVER['PHP_SELF'].'">'; 
  echo '<input type="hidden" name="cmd" value="search" />'; 
  echo 'Search for: <input type="text" name="words" value="'.$searchwords.'" /> '; 
  echo '<input type="submit" value="Search" />'; 
  echo '</form>'; 
} 

// Create the navigation switch 
$cmd = (isset($_GET['cmd']) ? $_GET['cmd'] : ''); 

switch($cmd) 
{ 
  default: 
    echo '<h1>Search Database!</h1>'; 
    searchForm(); 

  break; 


  case "search": 
    searchForm(); 
    echo '<h3>Search Results:</h3><br />'; 

$searchstring = mysql_escape_string($_GET['words']); 

    $sql = "SELECT pd_id, pd_name, pd_more, pd_more2,  
           MATCH(pd_name, pd_more, pd_more2)  
           AGAINST ('$searchstring' IN BOOLEAN MODE) FROM tbl_product
           WHERE MATCH(pd_name, pd_more, pd_more2)  
           AGAINST ('$searchstring' IN BOOLEAN MODE) ORDER BY pd_name DESC"; 
 }    
// echo $sql; 

$result = mysql_query($sql) or die (mysql_error()); 

while($row = mysql_fetch_object($result)) 
{ 
  echo '<strong>'.stripslashes(htmlspecialchars($row->pd_name)).'</strong><br />'; 
  echo '<p>'.stripslashes(htmlspecialchars($row->pd_more)).'</p>';  
  echo '<p>'.stripslashes(htmlspecialchars($row->pd_more2)).'</p>'; 
 // echo '<hr size="1" />'; 
} 

?> 

[ClarkF1]

If you use mysql_fetch_assoc you just change the last bit to:

while($row = mysql_fetch_assoc($result))
    {
      echo '<strong>'.stripslashes(htmlspecialchars($row['pd_name'])).'</strong><br />';
      echo '<p>'.stripslashes(htmlspecialchars($row['pd_more'])).'</p>';  

      echo '<p>'.stripslashes(htmlspecialchars($row['pd_more2'])).'</p>'; 

You can then add the reference to $row['pd_id'] like you did before.

[crazylegseddie]

thx alot works fine now 🙂

[ClarkF1]

Glad I could help

Please mark the thread as resolved.

[crazylegseddie]

One more thing! the script retrieves results correctly but if none are found it just leaves a blank space. How do I add to the script to display 'No results found'? Ive tried a simple else statement with no luck 😐

[ClarkF1]

Place this after the line containing mysql_query

$num_of_rows = mysql_num_rows($result);

if ($num_of_rows > 0)
{
// put while loop and all output here
}
else
{
echo "No results found";
}

[crazylegseddie]

thx worked a treat, uve been a big help 🙂

[crazylegseddie]

eekkkk I just tested my script on the real server and just realised they use a version of sql that does not support boolean mode searches 🙁 is it possible to edit the script to not use boolean searches? If I remove the 'BOOLEAN MODE' from the script i receive the following message:

'Can't find FULLTEXT index matching the column list '

Any advise on this new problem will be great?

[ClarkF1]

I have no idea about that.

It'd probably be best to start a new thread for this problem as this one has been marked resolved so less people are likely to view it.