SQL query to search database and output in table format
Posted: Mon Oct 05, 2009 1:14 am
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 | | | |
------------------------------------------------------------------------
| 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 | | | |
------------------------------------------------------------------------