Explode, implode, join...

[The_Chancer]

I am trying to create something from a database as follows:

Database setup

Supplier = Me
Categories = This \n That \n The other

Supplier = Them
Categories = Who \n What \n Why

Tyring to get the following as a final result....

"Me","This","Me","That","Me","The Other","Them","Who","Them","What","Them","Why" to echo out.

SO far I have this....

$query=do_query("SELECT company,category FROM suppliers");
while(list($company,$category)=mysql_fetch_row($query))
{
	$category=explode("\n",$category);
	$array=implode("\"".$company."\",\"",$category);
}
echo $array;

Which produces this

This
"Me","That

"Me","The Other

I am now bemused and lost... any help ?

[The_Chancer]

Just an update - I can get the order out fine, but why the *&"^ does it have a new line at the end of each ???

Tried using str_replace("\n","",$string)

But no joy...

Aggghhhh.... HELP!

[The_Chancer]

As much as I hate bumping This is really starting to annoy me now... nothing I try works...

OK - lemmie have it... <opens arms for the bump criticism...>

[Hiccup]

This is just a suggestion, but I think your table set up is the enemy here. Why not have it look like this: have Supplier as one field name and Category as the other, then (use your imagination and imagine that the columns lined up correctly...)

Supplier Category
Me This
Me That
Me The Other
Them Who
Them What
Them Why

Then producing your desired results is simple using a while loop, mysql_fetch_array and the correct SELECT statement...

Just a thought

[The_Chancer]

I had thought about changing it, but that would mean an extra line in the database for each category per supplier... whereas I could just append the category to the cell in the database.

I have been thinking instead (sleep does wonderful things) of using a foreach instead, and then appending it to a normal string...

something like

<?
$query=do_query("SELECT ref,category FROM suppliers");
while(list($ref,$category)=mysql_fetch_row($query))
{

$category=explode("\n",$category);
if (strlen($ref)==1)
{
	$ref='0'.$ref;
}
foreach($category as $string)
{
	$string=trim($string);
	$array .="\"".$ref."\",\"".$string."\",\"".$string."\",";
}
$array=substr($array,0,-1);
}
echo $array;
?>

gives me what I require like so...

"01","Speakers","Speakers","01","Amps","Amps","01","Mixers","Mixers","01","Cameras","Cameras","01","Stereos","Stereos","01","Bob","Bob""02","fgsj","fgsj","02","sgkjafga","sgkjafga","02","adfgdf","adfgdf","02","gdfgdfga","gdfgdfga","02","asdfgdfggbs","asdfgdfggbs","02","searte","searte"

HOWEVER... now it is kicking up a javascript error... yet when I hard code it it works....

Any ideas on why that would happen ?

[The_Chancer]

How stoopid...

After the end of the 01 series, there are two "BOB"'s together, and because I put the
$array=substr($array,0,-1);

in the wrong place, it takes it off after the end of every supplier, not the very end...

it all works now 😃 YAY

[sirTemplar]

i don't know if i have the same problem. this is my code:

if (isset($row["E_MAIL"]) && strcasecmp($row["E_MAIL"],""))
if (strpos($row['E_MAIL']," ") !== FALSE) {
$E_MAILS = explode(" ",$row['E_MAIL']);
foreach ($E_MAILS as $E_MAIL) {

echo "<table bgcolor=#FFFEEF border=0 cellpadding=1 cellspacing=0 style=border-collapse: collapse bordercolor=#111111 width=100%>
<tr><td align=left width=80% valign=top>
<font face=Verdana size=2 color=#000000>
<a href='mailto:{$E_MAIL}'>{$E_MAIL}</a></td></table>";
}
}
else {
echo "<table bgcolor=#FFFEEF border=0 cellpadding=1 cellspacing=0 style=border-collapse: collapse bordercolor=#111111 width=100%>
<tr><td align=left width=80% valign=top>
<font face=Verdana size=2 color=#000000>
<a href='mailto:{$row['E_MAIL']}'>{$row['E_MAIL']}</a></td></table>";
}

this outputs the content of the e_mail field on my database. on my database field e_mail, the emails (if more than one are separated by a space). the above codes prints something like this:

siTemplar
[e-mail]
[e-mail]

what i want is to make it appear like this:

siTemplar
[e-mail] , [e-mail]

with the two emails next to each other and both active. thanks.