displaying data from db onto webpage

[sarah]

Hi All,

I am new to MySQL, I have jus created my test database with one table and 5 rows of data using phpMyAdmin. Now I want to display this data on a webpage using php. Any ideas on how I can do this?

database name is "test"
table is called "users"

Thanks
Sarah

[raf]

I think the best thing you can do is search for a good tutorial on PHP and MySQL. There are plenty of thoose

Like
http://www.mysql.com/articles/ddws/index.html

[sir pannels]

Hi Sarah,
yeh find out what languages you can use on your server, id recommend php if you can.
and once you found out - come back and we will help you sort a few things out.
P:thumbsup:

[sarah]

Hey, thanx for the link - it helped me out heaps. I can now retrieve text from the database - what about images?

Currently in my test database I have 10 products, with their relevant id's, product names and product description. At the moment the images are stored in /images/products/thumbnails. Each image name corresponds with the id.

I.e

Product 1:
Id = 1
Name = Product 1
Desc = Blah blah
Image = 1.jpg

Product 2:
Id = 2
Name = Product 2
Desc = Blah blah
Image = 2.jpg

... and so on

Any ideas on how I can show the image with each product?

[Nightfire]

Just put the file path into the db, then print out the filepath from the table when you need it. Saves alot of resources than having to fetch an image from a db

[raf]

What Nightfire suggested + add another column to your db to store an alternative text in (+ even maybe a column to store the height and width of your image in, unless they all have the same size)