Making text in field a hyperlink

AShain

I currently have the following table:

CREATE TABLE akileine_cooling (

id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
product_number TEXT,
product_title TEXT,
product_desc TEXT,
product_price FLOAT(8,2),
product_image VARCHAR(50),
FULLTEXT KEY product_title(product_title)
)TYPE=MyISAM;

I would like the "Product Title" text to show up in the table as a hyperlink. How do I do this, I am using PHP to display the table.

Here is a snippet of my script:

echo "<div style='margin-left: .lin'> 
<h2 align='center'><font color=#808080 face=Arial, Helvetica, sans-serif>Akileine Cooling and Soothing Foot Products</h2>     

<h4 align='center'>(Select product for additional information and to make purchase)</h4>\n";

echo "<form action='showitem.php' method='post'>\n";     

echo "<table cellpadding='3' border='1'>";     

$counter=1;     

function imageSize($width, $height, $percent) {     

if(($percent > $width) && ($percent > $height)){     

}else{     

if($width > $height){     

$ratio = $percent / $width;     

}elseif($height > $width){     

$ratio = $percent / $height;     

}elseif($width == $height){     

$ratio = $percent / $width;     

}     

$new_width = $width * $ratio;     

$new_height = $height * $ratio;     

return "width=\"$new_width\" height=\"$new_height\"";     

}     

}     

while ($row = mysql_fetch_array($result))      

{       

$image_url = "http://www.ppshealthcare.com/images/$row[product_image]";     

$picture = getimagesize("$image_url");     

$picture_size = imageSize($picture[0], $picture[1], 150);     

  echo "<tr><td valign='top' width='15%'>\n";      

  echo "<input type='radio' name='interest' 
       value='$row[product_number]'\n";      

  if ( $counter == 1 )      

  {      

       echo "checked";      

  }      

  echo "><font size='+1'><b>$row[product_number]</b></font> 
       </td> 
       <td>$row[product_title]</td> 
       <td>$row[product_desc]</td> 
       <td>$row[product_price]</td> 
       <td><img src=\"/images/$row[product_image]\" $picture_size></td> 
       </tr>";      

    $counter++;      

   }     

   echo "</table>";     

   echo "<p><input type='submit' value='Select Product'> 
       </form>\n";

Could someone PLEASE help me figure out what to change, I do not want to use the radio buttons.

Thanks!!
Allie

elementaluk

I dont know if I understand what you mean but going by: "I would like the "Product Title" text to show up in the table as a hyperlink."

I would probably go with
echo '<a href="somewhere.over">'.$row['product_title'].'</a>';

AShain

I tried adding that line, it didn't work.

To clarify... the Product information is displayed on the page within a table. One of the columns is the Product Title. I would like the title to appear within the column as a hyperlink when displayed, so that the viewer will "select to view" the item by clicking it, it will pop up a new window that will have a larger picture, quantity selected and add to cart.

Hope this helps you help me, ha.

Thanks!!
Allie

elementaluk

ok, yes that helps alot, I've now forgot my name, i'm that confused...

ok if you want the whole column to be a hyperlink try:
<td onClick="window.location='http://www.alink.com';" style="cursor: hand;">

what do you mean "it didn't work"? it didn't print something correctly? its not what you wanted?

AShain

Let's try this.

View the following page. I do NOT want the radio buttons to select an item, I want the Name of product displayed the same, but want it to be a hyperlink going to another page.

[URL=http://]http://www.ppshealthcare.com/products/akileinecooling2.php[/URL]

All the information displayed is from the table I posted earlier that's located within my MySQL database. I wasn't sure if it was something I would define within the table itself, or with the PHP script on the webpage.

I hope this helps!
Allie

drew010

yes, it is something you define in the php script. you can make a hyperlink just like you make the radio button.

you have
echo "<input type='radio' name='interest'
value='$row[product_number]'\n";

you can try something like
echo "<a href="otherpage.php?product_id={$row['product_number'}>{$row['product_number']}</a>'\n";

AShain

Thank you for trying to help me. That change didn't work either, the page came up blank. I think it's because there are 3 lines of script that affect the radio button.

At the top:

echo "<form action='showitem.php' method='post'>\n";

Towards the bottom, two more:

echo "<input type='radio' name='interest' 
       value='$row[product_number]'\n";      

  if ( $counter == 1 )      

  {      

       echo "checked";

and this one at the end:

echo "<p><input type='submit' value='Select Product'> 
       </form>\n";

I've tried deleting those just adding what you suggested, and that didn't work.

Thanks for any help!!
Allie

elementaluk

so you want information that would otherwise be sent in a form to be throw into a link right?

and when you do what drew suggested you get a blank page when you click it?

are you using $_POST in showitem.php?

zapa

HTML uses " not '
i.e A HREF="something.html"

not A HREF='something.html'

echo "<form action=\"showitem.php\" method=\"post\">\n";

Towards the bottom, two more:

echo "<input type=\"radio\" name=\"interest\" 
       value='".$row['product_number']."'\n";      

  if ( $counter == 1 )      

  {      

       echo "checked"; 
echo ">"; //close input tag

and then,....

echo "<p><input type=\"submit\" value=\"Select Product\"> 
       </form>\n";

Originally posted by AShain
Thank you for trying to help me. That change didn't work either, the page came up blank. I think it's because there are 3 lines of script that affect the radio button.

At the top:
echo "<form action='showitem.php' method='post'>\n"; 
Towards the bottom, two more:
echo "<input type='radio' name='interest' 
       value='$row[product_number]'\n";      

  if ( $counter == 1 )      

  {      

       echo "checked"; 
and this one at the end:
echo "<p><input type='submit' value='Select Product'> 
       </form>\n"; 
I've tried deleting those just adding what you suggested, and that didn't work.

Thanks for any help!!
Allie [/B]

elementaluk

...what? no, single quotes are valid in HTML. Same with no quotes.

TheDefender

The single and no quotes are not valid in the W3C XHTML/XML/XSL specifications though... Might as well code for the future, not the past.