hyperlinking PHP/SQL search results

[andrwleong]

Heyyyyy all

haha under the advice of the wise Monie I have switched to creating in php/SQL over ASP/Access and what wise move that was.

Okay heres my problem. I have produced an ecommerce website and have created catergory pages for my products. The list of products and thier attribuets are also displayed.

for example see this website. It shows all the products under 'Amino Acid' http://www.discount-supplements.co.u...pplements&t=lb

So far so good this is what I have achieved.

However, now I would like to make my results or at least the name of the product a link to thier own indavidual webpages. I have created the indavidual webpages so now it is just a case of making the results hyperlinkable.

[dab42pat]

All the categories seem to link ok in ff.

[andrwleong]

Originally Posted by dab42pat

All the categories seem to link ok in ff.

Hi Dab


that website is mine mate, i just used it as an exaple of all the products being displayed in the Amino Acid category and then the results being hyperlinked to thier indavidual pages.

The hyperlinking of data pulled from my SAL database is the part I dont know how to do

P.S your wifes site can be distracting hahaha

[dab42pat]

Are you using Mysql db. If so you may have to create a field in your products called hyper_link or something. Then make sure its referenced in your search results. eg.

PHP: Select all

<a href="<?php echo $row_Recordset1['hyper_link']; ?>"><span class="style2">£<?php echo $row_Recordset1['item_price']; ?></span></a>

[andrwleong]

Originally Posted by dab42pat

Are you using Mysql db. If so you may have to create a field in your products called hyper_link or something. Then make sure its referenced in your search results. eg.

PHP: Select all

<a href="<?php echo $row_Recordset1['hyper_link']; ?>"><span class="style2">£<?php echo $row_Recordset1['item_price']; ?></span></a>

Hi Dab thanks for your reply.

I think I understand what you mean. I am usuing MySQL in SQLyog and PHP.

So from what you mean I would make the lets say the data in 'Product_Name' hyperlinkable.

[dab42pat]

Say you have a products table and in that you have product_name, product_description etc. add a field hyper_link and insert the link in that field eg showitem.php?item_id=1. Then you can call it using something similar to the code I posted above.

I hope this makes sense,

Pat

[andrwleong]

Originally Posted by dab42pat

Say you have a products table and in that you have product_name, product_description etc. add a field hyper_link and insert the link in that field eg showitem.php?item_id=1. Then you can call it using something similar to the code I posted above.

I hope this makes sense,

Pat

Hey Pat

it does make sense. I am just trying to picture the output. So on the website next to all the products details there would be a 'http://www' link.

Example

Fiest : Ford : 2 seater : £15.000 : www.fordfiestapage.com

Although this would sove the problem I wouldnt like a full link on the end is there away i can disguise it into just a word say 'view details'

[dab42pat]

No, by using the code I posted or something similar the link would be attached to your product name, so when the user clicked your product name it would link to the hyper_link set in the database for that product.

A working example is on my wifes site, if you enter baby in the search field and look at the results I have hyperlinked the image using this process.

I'm not great at explaining things.

Pat

[andrwleong]

Originally Posted by dab42pat

No, by using the code I posted or something similar the link would be attached to your product name, so when the user clicked your product name it would link to the hyper_link set in the database for that product.

A working example is on my wifes site, if you enter baby in the search field and look at the results I have hyperlinked the image using this process.

I'm not great at explaining things.

Pat

I understand your a superstar.

[andrwleong]

Originally Posted by dab42pat

No, by using the code I posted or something similar the link would be attached to your product name, so when the user clicked your product name it would link to the hyper_link set in the database for that product.

A working example is on my wifes site, if you enter baby in the search field and look at the results I have hyperlinked the image using this process.

I'm not great at explaining things.

Pat

Pat you dont have a tutorial on how to make something hyperlinkable in your SQL database. Either am typing the wrong thing in google but I cant find any tutorials