Page 1 of 1

SQL query to search database and output in table format

Posted: Mon Oct 05, 2009 1:14 am
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 | | | |
------------------------------------------------------------------------

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

Posted: Mon Oct 05, 2009 3:06 am
by Mark Baker
Start by looking at the examples in the PHP manual