Page 1 of 1

[56K WARN] Echo a table from MySQL

Posted: Fri Dec 29, 2006 5:17 pm
by oskare100
feyd | Please use

Code: Select all

,

Code: Select all

and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read:  [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]


Hello,
I've my sales in a table. I want to be able to echo them in a "google search type design" (as shown in the attached picture) where each row is like a separate table. The screen shot of a script is of the RW download script and how they show the categories in that script. Is that possible and if, what would the php code look like?

This is how my second "draft" table (the one which shows three rows and is one table) looks like in HTML (with one blank line at the bottom if it).

[syntax="html"]<table border="0" width="419" height="86" bgcolor="#C0C0C0" style="border-collapse: collapse">
	<tr>
		<td height="13" width="308" colspan="2">$item_name</td>
		<td height="13" width="107">$item_number</td>
	</tr>
	<tr>
		<td height="21" width="97">Purchase date: </td>
		<td height="21" width="209">$item_date</td>
		<td height="55" width="107" rowspan="3">
		<p align="center"><a href="http://downloads">Download</a></td>
	</tr>
	<tr>
		<td height="14" width="97">Price:</td>
		<td height="14" width="209">$item_price</td>
	</tr>
	<tr>
		<td height="12" width="97">Downloads</td>
		<td height="12" width="209">$item_downloads</td>
	</tr>
	<tr>
		<td height="6" width="413" colspan="3" bgcolor="#FFFFFF">&nbsp;</td>
	</tr>
</table>
I've searched but I couldn't find any information about how to create a such table in any of the guides I'm using.. If you have one that shows how to do this, feel free to post a link to it.... (if it isn't agains the forum rules).

/Oskar

Image[/img]


feyd | Please use[/syntax]

Code: Select all

,

Code: Select all

and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read:  [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]

Posted: Sun Dec 31, 2006 9:29 pm
by Li0rE
not sure what you mean? Are you having a problem displaying information from your database or just having problems with the html?