Snoozee

Thanks this looks perfect so I'll give it a try. Thank you so much as it's greatly appreciated

Ok just to clarify :-) I have the PHP to connect to my database yet as in the above example I can only work out how to echo the entire database not echo a specific row in my html code. I somehow need to get the query to look at everything within the database & then from this have it return the value of a certain row and column ID within my line of html code - refer example in first post.

HI I'm creating my first e-commerce website and have come up against a problem that I can't work out on my own :-( I have my MySQL database created with the following headers product_name product_code price details In my HTML coding I want to be able to echo a particular row so that whatever "value" is in that row displays on the webpage e.g. so rather than having the code like this - <span class="product-price">$49.95</span> it would be something like this - <span class="product-price">echo #row 20 ('price')</span>. I'm aware that I would need to have the query run first, yet am having problems with this also :-( Any help would be greatly appreciated.