SQL query to search database and output in table format

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
sanjushekar
Forum Newbie
Posts: 1
Joined: Mon Oct 05, 2009 12:24 am

SQL query to search database and output in table format

Post by sanjushekar »

I have a table setup on phpmyadmin as below

| id | img | prt_no | descrp | price | str_lnk | spec_lnk | man_lnk |
| 1 | URL link | XX-123-23 | blah..blah..blha | 234 | URL link | URL link | URL link|
| 2 | URL link | XX-356-34 | blah..blah..blha | 567 | URL link | URL link | URL link|
| 3 | URL link | XX-895-23 | blah..blah..blha | 789 | URL link | URL link | URL link|

need a SQL query and output in the below format...request anybody to help me with the script......this is urgent!!

------------------------------------------------------------------------
| shows img | part no. XX-123-23 | Price | spec_link | man_link |
| |descrp: blah...blah..blah | | | |
| |store: URL link | | | |
------------------------------------------------------------------------
| shows img | part no. XX-123-23 | Price | spec_link | man_link |
| |descrp: blah...blah..blah | | | |
| |store: URL link | | | |
------------------------------------------------------------------------
Mark Baker
Forum Regular
Posts: 710
Joined: Thu Oct 30, 2008 6:24 pm

Re: SQL query to search database and output in table format

Post by Mark Baker »

Start by looking at the examples in the PHP manual
Post Reply