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 | | | |
------------------------------------------------------------------------
SQL query to search database and output in table format
Moderator: General Moderators
-
sanjushekar
- Forum Newbie
- Posts: 1
- Joined: Mon Oct 05, 2009 12:24 am
-
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
Start by looking at the examples in the PHP manual