Hi,
I need some help. I have data in a table (cust) and one of the columns has multiple values in it (cat_id). I need to use those values to select data (cat_name) from a second table (cat) and display this with the data from the first table where (cat_id) are the same. The data is writen into (cust) in an area that is serialize then unserialize. Thanks in advance.
<table width="100%" border="0" align="center" cellpadding="4" cellspacing="4">
<tr>
<td bordercolor="#000000" bgcolor="#F4F4F4">
<?php
$i=0;
while ($i < $num) {
$f1=mysql_result($result,$i,"fname");
$f2=mysql_result($result,$i,"lname");
$f3=mysql_result($result,$i,"address");
$f4=mysql_result($result,$i,"city");
$f14=mysql_result($result,$i,"state");
$f5=mysql_result($result,$i,"zip");
$f6=mysql_result($result,$i,"phone");
$f7=mysql_result($result,$i,"fax");
$f8=mysql_result($result,$i,"email");
$f10=mysql_result($result,$i,"website");
$f11=mysql_result($result,$i,"comments");
$f12=mysql_result($result,$i,"cat_id");
$f12=unserialize($f12);
$f12 = implode(",",$f12);
$f13=mysql_result($result,$i,"cust_id");
$f15=mysql_result($result,$i,"area_id");
?>
<?php
$query2=" SELECT * FROM category WHERE cat_id IN ('$f12')";
$result2=mysql_query($query2) or die(mysql_error());;
$row = mysql_fetch_array($result2);
mysql_close();
$f16=mysql_result($result2,$i2,"cat_name");
?>
<?php
$query3=" SELECT * FROM area WHERE area_id=$f15";
$result3=mysql_query($query3) or die(mysql_error());;
$num3=mysql_numrows($result3);
mysql_close();
$f19=mysql_result($result3,$i3,"area_name");
?>
<div align="left"><font size="4"><strong><u><font size="3"> </font></u></strong></font><a href="directoryedit.php?cust_id=<?php echo $f13; ?>"><font size="4"><strong><u><font size="3">
</font></u></strong></font>Click to Edit </a><font size="3"><strong></strong></font><font size="3" face="Times New Roman, Times, serif"><strong>
<br>
</strong></font></div></td>
<td colspan="4" bordercolor="#000000" bgcolor="#F4F4F4"><div align="left">
</div>
<div align="center"><a href="directoryadd.php">Click to Add</a></div></td>
<td valign="top" bordercolor="#000000" bgcolor="#F4F4F4"><a href="directorydelete.php?id=<?php echo $f13; ?>">Click
to Delete</a> </td>
</tr>
<tr>
<td bordercolor="#000000" bgcolor="#F4F4F4"> <div align="left"><strong><font size="3" face="Times New Roman, Times, serif"><?php echo $f1; ?></font></strong></div></td>
<td colspan="3" bordercolor="#000000" bgcolor="#F4F4F4"><div align="left"><strong><font size="2" face="Times New Roman, Times, serif"><?php echo $f2; ?></font></strong></div></td>
<td bordercolor="#000000" bgcolor="#F4F4F4"><div align="left">Phone - <font size="2" face="Times New Roman, Times, serif"><?php echo $f6; ?></font></div></td>
<td bordercolor="#000000" bgcolor="#F4F4F4"><div align="left">Fax - <font size="2" face="Times New Roman, Times, serif"><?php echo $f7; ?></font></div></td>
</tr>
<tr>
<td colspan="4" bordercolor="#000000" bgcolor="#F4F4F4"><div align="left"><font size="2" face="Times New Roman, Times, serif"><?php echo $f3; ?></font></div>
<div align="left"></div></td>
<td bordercolor="#000000" bgcolor="#F4F4F4"><div align="left">Email - <font size="2" face="Times New Roman, Times, serif"><a href="mailto:<?php echo $f8; ?>"><?php echo $f8; ?></a></font></div></td>
<td bordercolor="#000000" bgcolor="#F4F4F4"><div align="left"><font size="2" face="Times New Roman, Times, serif">Website
- <a href="http://<?php echo $f10; ?>" target="_blank"><?php echo $f10; ?></a></font></div></td>
</tr>
<tr>
<td colspan="2" bordercolor="#000000" bgcolor="#F4F4F4"><div align="left"><font size="2" face="Times New Roman, Times, serif"><?php echo $f4; ?></font></div></td>
<td bordercolor="#000000" bgcolor="#F4F4F4"><div align="left"><font size="2" face="Times New Roman, Times, serif"><?php echo $f14; ?></font></div></td>
<td bordercolor="#000000" bgcolor="#F4F4F4"><div align="left"><font size="2" face="Times New Roman, Times, serif"><?php echo $f5; ?></font></div></td>
<td bordercolor="#000000" bgcolor="#F4F4F4"><font size="2" face="Times New Roman, Times, serif">Category
- <?php echo $f12;?> <?php echo $f16;?></font></td>
<td bordercolor="#000000" bgcolor="#F4F4F4"><font size="2" face="Times New Roman, Times, serif">Area
- <?php echo $f19 ; ?></font></td>
</tr>
<tr>
<td colspan="4" bordercolor="#000000" bgcolor="#F4F4F4"><font size="2" face="Times New Roman, Times, serif">Comments<br>
<br>
<?php echo $f11; ?></font></td>
<td bordercolor="#000000" bgcolor="#F4F4F4"><font size="2" face="Times New Roman, Times, serif"><?php echo $results2; ?></font></td>
<td bordercolor="#000000" bgcolor="#F4F4F4"> </td>
</tr>
<tr>
<td colspan="6" bordercolor="#000000" bgcolor="#333333"> </td>
</tr>
<tr>
<td bordercolor="#000000" bgcolor="#F4F4F4"><font size="2" face="Times New Roman, Times, serif">
<?php
$i++;
}
?>
</font></td>
<td colspan="3" bordercolor="#000000" bgcolor="#F4F4F4"> </td>
<td bordercolor="#000000" bgcolor="#F4F4F4"> </td>
<td bordercolor="#000000" bgcolor="#F4F4F4"> </td>
</tr>
</table>