Semi Colons:

[ChompGator]

I have a script here that lists email addresses I have stored in my database, what I want to do is separate them all with a semi colon, but Im unsure what to add to my script to get it to do that, anyone know? Heres the script: - Thanks!

 

<?php
$con = mysql_connect("***","****","****") or die('Could not connect: ' . mysql_error());
if (mysql_errno()) {
echo 'Connect error: ' . mysql_error();
}
mysql_select_db("login", $con);

$result = mysql_query("SELECT * FROM subscribe");
if (! mysql_errno()) {
while($row = mysql_fetch_assoc($result)){
echo $row['email'];
}
} else {
echo 'Query error: ' . mysql_error();
}
?>

[MikeL]

<?php
$myEmails = new array();
while( $row = mysql_fetch_assoc($result)){
  $myEmails[] = $row['email'];
}
echo implode(':', $myEmails);
?>

 

is that what you're trying to do?

 

[ChompGator]

Well Im trying to separate the email addresses with a semi-colon  ';'

 

[MikeL]

hahaha.... oops... well switch out the colon with the semicolon

 

hahahaha

 

http://us2.php.net/manual/en/function.implode.php

implode joins an array of strings by a specified delimiter and returns the joined string.

[ChompGator]

haha, Ok, I will Ill post here if I get any errors, 1 second.

[ChompGator]

Error is:

 

Parse error: parse error, unexpected T_ARRAY, expecting T_STRING or T_VARIABLE or '$' in d:\hosting\member\aiim\affiliates\email3.php on line 10

 

 

Here is what the new script looks like:

<?php
$con = mysql_connect("****","***","****") or die('Could not connect: ' . mysql_error());
if (mysql_errno()) {
echo 'Connect error: ' . mysql_error();
}
mysql_select_db("login", $con);

$result = mysql_query("SELECT * FROM subscribe");
if (! mysql_errno()) {
$myEmails = new array();
while( $row = mysql_fetch_assoc($result)){
  $myEmails[] = $row['email'];
}
echo implode(';', $myEmails);
?>

 

Any tips?

[MikeL]

oops haha.. get rid of the 'new' in the array sorry i didn't really test it.

[ChompGator]

 

Parse error: parse error, unexpected $end in d:\hosting\member\aiim\affiliates\email3.php on line 17

 

Problem is, there isn't 17 lines

[MikeL]

you need to close the if statement with }