eCommerce - Details.php

[a_bains]

Hello,

I would like to create a details.php page that displays all my products. I understand how to get the title, price, description etc from mySQL. But my problem is how do I get a list of data? For example say I want to display the features of a product in point form (list). What is the best way to do this? How do most common websites do this?

Thanks, in advance

Aaron

[sid]

i assume you use mysql?
one way would be [man]mysql_fetch_array/man - there are a bunch of code snippets posted too.

[a_bains]

OK, thats what I use already but thats going to give me the whole cell which includes lots of text. I want that text to be in a list.

[laserlight]

Could you elaborate further? Perhaps you could post your relevant database schema.

[a_bains]

OK, sorry if I am unclear.
Here is an example http://www.simplyfta.com/indvitem.php?item_id=10

That site uses PHP and mySQL, it has sections for SPECS and FEATURES. Description is easy you would just use the fetch array function and print it out. But if I want display my data as a list, how would i do that. I am supposing that SPECS and FEATURES are data in an mySQL table row. How do they input that data into mySQL table row to display it on a page using PHP in a list format.

[laserlight]

It depends on how your data is stored in the database. If it is properly normalised, you can run a loop to place the data from each row into an item in the list.

[a_bains]

Do you think this is how they did it? Is there an example of code how to do this?