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 Like 54 Dislike
Previous forums Next forums
Other forums

Preserving user-entered linebreaks
Hi, I'm building a web 2.0 thingy from scratch and I wanna display text which users input. It's all

Weird MySQL error, why am I recieving this?
PHP Code:


<?php require "global_settings.php"; ?>
<titl

Generate multilayered array from string.
ok so i have a string that looks like this:
Code: blog:edit_all,delete_all|users:edit_all,delete_

php is not recognized as an internal or external command
Hello,

I am trying to bake the code in CakePHP through my console.
I have changed my Path

How to disable direct access to a file
Suppose I've 2 Files. 1.php & 2.php

I don't want anybody to access 2.php directly fr

License Issue - service type user
Hi,

I would like to understand the following issue regarding sap license.
I wish to

Hardcopy printing is to wide
I want to make a hardcopy at runtime of my active form like this

Data type mismatch
Hi,
I am migrating data from algol to c.I mapped real datatype in algol to double datatype in

C problem struct and string
Hi guys,

This is my first post and I'm hoping the experts here can help me solve my problem.<

j1inmis Ouput layout changes
Hi,

Can anybody tell how can j1inmis output layout can be changed so that vendor names ge

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash