[RESOLVED] Search Hyperlink Results

key_uk

Before I start, I did search the forum for similar results, I found some but I didnt really understand them.

Ok I have a working search form, which searchs my database for cds, I use this code:

//Now we search for our search term, in the field the user specified
$data = mysql_query("SELECT * FROM cds WHERE upper($field) LIKE'%$find%'");

//And we display the results
while($result = mysql_fetch_array( $data ))
{
echo $result['cd_artist'];
echo " - ";
echo $result['cd_title'];
echo "<br>";
echo "<br>";
}

What I want to do is put my results into hyperlinks, then the user can click the "title" of one of the cd results, which will take them to another page with the CDs details (track list etc) How would I do this, and would I then need to create a page for each cd? or would it do it for me?

Thanks,

wilku

In your cds table there should be some id field or similar that would identify each cd uniquely. You'd need to echo this id in your link, example:

echo "<a href=\"cd_details.php?id=$result[cd_id]\">$result[cd_artist] - $result[cd_title]";

then in your cd_details.php script:

if (isset($_GET['id']))
{
 //use cd id to retrieve some more information about your cd
}
else
{
echo "No cd specified";
}

Useful links that should help you:
http://www.w3schools.com/php/php_get.asp - using GET variables
[man]mysql[/man] - using database
[man]mysql_real_escape_string[/man] (important)

key_uk

yea I have a cd id field which identifys each cd, so I have added this to the echo link in the searchresults php like so

while($result = mysql_fetch_array( $data ))
{
echo $result['cd_artist'];
echo " - ";
echo "<a href=http://www.indie-design.co.uk\"cdinformation.php?id=$result[cd_id]\">$result[cd_title] - $result['cd_title']";
echo "<br>";
echo "<br>";
}

but when I go and search for something now, it returns a blank page.

and for the cdinformation.php I have Im abit stuck, how would I echo each song? and is there anything else I need to add to this page?

<?
mysql_connect("****", "*", "*") or die(mysql_error());
mysql_select_db("****") or die(mysql_error());

if (isset($_GET['cd_id']))
{
echo $result['cd_song'];
}
else
{
echo "No cd specified";
}

wilku

key_uk wrote:
but when I go and search for something now, it returns a blank page.

Do you have error_reporting turned on in php.ini (or in the script)? Ask Google about error_reporting and display_errors. It should be turned on only on development machine - not the real server. Also, do you use "or die(mysql_error())" while running your query? If not, do it - [man]mysql_error[/man] (development as well).

key_uk wrote:
and for the cdinformation.php I have Im abit stuck, how would I echo each song? and is there anything else I need to add to this page?

It depends on how you store information on songs in a given cd.

 
<? 
mysql_connect("*******", "*******", "*******") or die(mysql_error()); 
mysql_select_db("*******") or die(mysql_error()); 


if (isset($_GET['cd_id'])) 
{
//definitely lacks mysql_query here
//and another while loop with mysql_fetch_array 
echo $result['cd_song'];
} 
else 
{ 
echo "No cd specified"; 
} 

?>

The query should look similar to

SELECT track_name, track_artist, track_number FROM tracks WHERE cd_id = 'id_from_get' ORDER BY track_number

In the above example only words in capital letter are SQL, other words are names of columns and tables (id_from_get must be replaced with data from GET processed by mysql_real_escape_string) which almost for sure are different in your database.

toxic_brain

think ur link generation code has some typos.

echo "<a href=http://www.indie-design.co.uk\"cdinformation.php?id=$result[cd_id]\">$result[cd_title] - $result['cd_title']";

echo "<a href=\"http://www.indie-design.co.uk\cdinformation.php?id=$result[cd_id]\">$result['cd_title']</a>" ;

if it deosn't work, pls paste the url of the second page ie, which shows the cd deatials here.