Hyperlink in PHP to MySQL record

Posted on 16th Feb 2014 07:03 pm by admin

Hello,

I am having trouble as i am new to php. I have connected to the database and I have displayed the fields i want on my page. I need to access certain fields by links to each letter.

For example A will link to the products starting with A and so on.

I am using PHP ad MySQL. The database is however on a different server. I only have the .php file at the moment and want to display the data on a HTML page.

I am just unsure of how to make a link to the product field and the price field and display them within a table.
My code is this so far..

<?php
// Connect to the database server
mysql_connect("host", "username", "psssword") or die(mysql_error());

// Open to the database
mysql_select_db("telephon_cscartrestore") or die(mysql_error());

//select records from table
$result = mysql_query("SELECT cscart_product_descriptions.product, cscart_product_prices.price FROM cscart_product_descriptions, cscart_product_prices ORDER BY cscart_product_descriptions.product ASC") or die(mysql_error());

echo "<table border='1'>";
echo "<tr> <th>Product</th> <th>Price</th> </tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
// Print out the contents of each row into a table
echo "<tr><td>";
echo $row['product'];
echo "</td><td>";
echo $row['price'];
echo "</td></tr>";
}

echo "</table>";

?>
I want a link 'A' that opens all records starting in A and so on. Is this possible?

thanks

Your Answer:

Login to answer

Other forums

Beginner PHP code help
Hi I'm new to php but if someone could please read the question below and help it would be great.

Error when call dll from oracle
Hi all, please help me!

I have dll write C language, I want call it from oracle procedur

Login Functionality Working Different on IE
This is an odd one, I have a site which has an admin section. The admin pages unsurprisingly require

What am I missing here? Help!
Hello all!. I can't seem to get this working right. Well - it renders right, but something is goin

Business Health Check
Hello

I need to create an online business health check for a client it will be multiple choi

show the direct link into href
I want to display link on the page. i am fetching the data(URL) from database,actually before that i

Install page
How do I make it so when a user submits information on the Install page, it'll right it into the cor

ECC6 - Single sign-on
We are in the process of upgrading to ECC 6 which will support single sign on with user passwords al

strtotime issue
Hey all,

I'm playing around with some code, and basically the idea is:

Person changes

PHP form help required
Hi all! Apologies in advance for having to message the forum for help. I know you must get a lot of