SQL&PHP table merge?

[ABM2007]

The problem is real simple,

I have a database with products which i search through. Some products however look the same, but have different dimensions... I want the products that look the same to be output into 1 table. For example:

Scissor
-------4inch
-------5inch
-------6inch

Instead of what i have now all products seperately output:
Scissor
-------4inch

Scissor
-------5inch

Here is a bit of code i have... the url-small is the link to the image of the product ( match to this ) and article are the products.
So my database has numerous articles that share the same image. and i want those acticles to be displayed WITH just 1 image.

Here is what i have so far:

$data = mysql_query("SELECT * FROM temp_26_01_2007_22_00_25 WHERE $field LIKE'%$find%'");

$find = strtoupper($find); 
$find = strip_tags($find); 
$find = trim ($find);

while($result = @mysql_fetch_array( $data )) 
{

echo "<a href=".$result['url-big']."><img src=".$result['url-small']."></a>";  

echo $result['Article:']; 
echo " "; 
echo "<br>"; 
echo $result['zoek1']; 
echo "<br>"; 
echo $result['zoek3'];
echo "<br>"; 
} 

I hope i'm making myself clear enough, english is not my first language. And i'd be very thankfull if anyone could help me with the problem.

[ABM2007]

I brushed my teeth right? hehe nobody knows?

All i want is to have multiple products shown next to 1 picture...
Can anyone help me please because my knowledge of this ends here... 🙁

Anne.

[Piranha]

This is untested, but you should at least get the idea:

$data = mysql_query("SELECT * FROM temp_26_01_2007_22_00_25 WHERE $field LIKE'%$find%'");

$find = strtoupper($find);
$find = strip_tags($find);
$find = trim ($find);

$oldarticle = "";

while($result = @mysql_fetch_array( $data ))
{

echo "<a href=".$result['url-big']."><img src=".$result['url-small']."></a>";  

if ($oldarticle == $result['Article']) // If it is the same article
{
    // Do nothing
}
else // If it is a new article
{
    echo $result['Article:'];
    $oldarticle = $result['Article'];
}
echo " ";
echo "<br>";
echo $result['zoek1'];
echo "<br>";
echo $result['zoek3'];
echo "<br>";
}

[ABM2007]

xxx
Anne

[ABM2007]

Solved!

Thank you so much! here is the end code...

$oldarticle = ""; 

while($result = @mysql_fetch_array( $data )) 
{ 


if ($oldarticle == $result['url-klein']) // If it is the same article 
{

echo $result['Artikel']; 
// Do nothing 
} 
else // If it is a new article 
{ 
echo "<a href=".$result['url-groot']."><img src=".$result['url-klein']."></a><br>";  

	    echo $result['Artikel']; 
    $oldarticle = $result['url-klein']; 
} 
echo "<br>"; 
echo "<br>"; 
} 

This will show 1 picture and several results. 😃 thanks again

[ABM2007]

Hi there 🙂 I'm back, the code works perfect. only one problem and this time it is a design issue.

Allow me to explain... I have the following code which is the table i would like to show my products in:

<table border="0" width="100%" cellspacing="0" cellpadding="0" id="table1">
	<tr>
		<td>
		<table border="0" width="100%" cellspacing="0" cellpadding="0" id="table2">
			<tr>
				<td width="26" height="21"></td>
				<td width="155" height="21"></td>
				<td height="21"></td>
				<td width="18" height="21" valign="bottom"></td>
			</tr>
			<tr>
				<td width="26"></td>
				<td width="155" valign="top">
				<p align="center">Main picture</td>
				<td valign="top">
				<table border="0" width="100%" cellspacing="0" cellpadding="0" id="table3">
					<tr>
						<td><font face="Verdana" size="1">Article</font></td>
						<td width="83">info button</td>
					</tr>
				</table>
				</td>
				<td width="18"></td>
			</tr>
			<tr>
				<td width="26"></td>
				<td width="155">
				<p align="center"><b><font face="Verdana" size="1">category</font></b></td>
				<td></td>
				<td width="18"></td>
			</tr>
		</table>
		</td>
	</tr>
</table>

As you can see it has what i spoke of when i asked the first question, the picture of an article is to the left, and the articles are on the right.

The problem is that i cannot under any circomstance get it to work with the code 🙁
The layout will alway's either messup, or the articles that share the same picture will be shown under the table.

The code is still the same, i just need them to work together...

$data = mysql_query("SELECT * FROM temp_26_01_2007_22_00_25 WHERE $field LIKE'%$find%'"); 

$find = strtoupper($find); 
$find = strip_tags($find); 
$find = trim ($find); 

$oldarticle = ""; 

while($result = @mysql_fetch_array( $data )) 
{ 

echo "<a href=".$result['url-big']."><img src=".$result['url-small']."></a>";   

if ($oldarticle == $result['Article']) // If it is the same article 
{ 
    // Do nothing 
} 
else // If it is a new article 
{ 
    echo $result['Article:']; 
    $oldarticle = $result['Article']; 
} 
echo " "; 
echo "<br>"; 
echo $result['zoek1']; 
echo "<br>"; 
echo $result['zoek3']; 
echo "<br>"; 
} 

I wouldn't be asking these questions if i had the time to really look into it, the fact however is that i am creating this for an ill friend of mine who wanted to make a site where he could make categories of his life... and per category post some topics where he then will make a poem or a message...

Anyway, it is really important to me to get this fixed and i am even willing to compensate the person that solves my issue if that is allowed here at phpbuilder.

I hope someone can help me, at least thanks for reading through the issue at hand.

Sincerely,
Anne

[ABM2007]

Hmmm, anyone? 🙁

[Weedpacket]

Since this is a different problem, it might be better to ask a separate question (otherwise it could get confusing for anyone else with either problem who does a search).

Since it's a design problem (the code is working fine, but the output needs to look different) - first, check that the HTML you're generating is correct (suggestion: make up a page with dummy data, make sure that's looking right, and then write code to generate it - it's often easier than going in the other direction (writing code and then worrying about how it looks)), and consider posting the issue in the client-side forum.

Third, if you consult the FAQ you'd see that offering payment for services (or any sort of advertising) is not allowed at PHPBuilder.

Fourth; content-free posts like

Hmmm, anyone?

that exist just to bump your post back to the top are an irritant.

(Other guidelines can be found here).

[ABM2007]

I'm sorry 🙁

The problem isn't the design though... the table works fine, but it's not possible to output it in the way i wan't the script isn't complicated enough i think.

Because when it hits the article output, it should build a small list with all article's that belong to that corresponding picture...

i've tried everything however, from extra while's to another if statement. and everything i do comes up with the same thing.

A messed up table...