How can i display these results in a HTML table?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
donny
Forum Contributor
Posts: 179
Joined: Mon Aug 11, 2014 11:18 am

How can i display these results in a HTML table?

Post by donny »

hello,

i am trying to figure out how i can display results in a html table

when the customer types in their order number i want to show only certain fields of each row . there will be multiple rows with the same order number?

anybody can give me an idea of what my code should be looking like?

thank you
User avatar
Celauran
Moderator
Posts: 6427
Joined: Tue Nov 09, 2010 2:39 pm
Location: Montreal, Canada

Re: How can i display these results in a HTML table?

Post by Celauran »

Why are there multiple rows with the same order number? That doesn't sound right at all.
donny
Forum Contributor
Posts: 179
Joined: Mon Aug 11, 2014 11:18 am

Re: How can i display these results in a HTML table?

Post by donny »

i want to show a list of products they bought. i list each product bought in a database separately with the order number. I'm sure theres a better way to do it but this is a very simple site i am working on not going to be much traffic/orders
donny
Forum Contributor
Posts: 179
Joined: Mon Aug 11, 2014 11:18 am

Re: How can i display these results in a HTML table?

Post by donny »

bump...anybody?
User avatar
Celauran
Moderator
Posts: 6427
Joined: Tue Nov 09, 2010 2:39 pm
Location: Montreal, Canada

Re: How can i display these results in a HTML table?

Post by Celauran »

What have you tried? Where are you running into problems? You should be able to accomplish this with a simple query selecting the columns you want WHERE orderid = foo
Post Reply