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
No comments posted yet
Your Answer:
Login to answer
131
54
Other forums
asp authentication problem
Hello all,
I want to use the asp authentication (from asp.net configuration) in my web site. there
unserialize help, getting errors
hi all ,
I got a form with 6 fields (2 input and 4 select box), when the page loads one block is
What do you call the "token" thing?
You know how some sites have links that run on tokens? Tokens are links that only stay alive for a c
How to add functionality to a simple php calender?
Hello everyone,
I have just finished creating a simple php calander. Can someone point
Help! refer to a friend script with captcha code
Hi guys, I am posting on here in desperate need for some help with an ongoing search I have been doi
Count Session and Trigger Events
I am New in PHP, seeking a method to count logged users by counting the sessions or any …, is
Multi language - seo links
Im trying to figure out the best method to have a multi language website that will function with seo
MII Trends - add data onto chart object
Hello,
Can anyone please provide some thoughts on my current requirement:
its pretty
Need help making a blockquote and line items conditional
I have some code I bought a few years ago that allows my clients to update content on their site usi
Generate PDF
Hi guys,
I would like to know if there is a way to generate pdf when clicking on a link. In f