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

form variables from database help.
Hi all,

I would like to have a form that gives you options based on the results of an mysql q

. and .. appearing instead of pictures
First of all, thanks very much for providing this forum. It is very much appreciated!

My son

unexpected T_STRING
error log "[Sat Jan 09 18:27:58 2010] [error] [client 127.0.0.1] PHP Parse error: syntax error

DateTimeZone::listIdentifiers headache
http://php.net/manual/en/datetimezone.listidentifiers.php


So the documentation states tha

Php - mysql store data and use it later?
Hi, i' making a login page at the moment, however my username + password is stored many different pl

Help on query replacing the date
Hi Pals,

i want to replace the current date in a column to some value say C or D or any n

My XSRF Prevention code isn't working
First of all, thanks for the generous help you guys have given me in the past on this forum.
Seco

Linking with Foreign Keys
I have been getting an erro when I try and link:

create table Faculty_Specialty (I_Name v

Word Trimming
Hi Guys & Gals!!

Hope you are all ok....

I need some help with the following

HTML form problem
Ive made a form to that i want to send to my email via PHP. but when it send only the name's etc sen

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