[mdhall]

Hopefully this is something simple I'm missing. When an insert query is done, I want an automatic email sent to members email addresses, which are stored in a different table than the insert table.

The table I'm inserting into is called "artist". After the insert query, I want to query a table named "maillist" to get the members email addresses. The "maillist" fields are named id, email_name, email. I keep getting a parse error on line 13. Heres the code i have.

php
include("dbinfo.inc.php");
$my_website=("www.mdhwebdesign.com");
$dbh=mysql_connect ("localhost", "$username", "$password") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db("$database");
$query="INSERT INTO artist VALUES ('','$fname','$email','$category','$artist_name',' $song_title','$lyrics','')";
$result=mysql_query($query);
$query2=("SELECT email_name,email FROM maillist");
$result2=$this->db->db_query($query2);
$row=$this->db->db_fetch_array($result2);
$emails=$row['email_name'];
while($row=$this->db->db_fetch_array($result2)) {
$emails=. "," . $row['email_name'];
}
$message = "$fname has just added the song '$song_title' by '$artist_name to our website.";
mail($emails,"A new song has been added.",$message,"From: $my_website\r\n");



echo "<meta http-equiv=\"refresh\" content=\"0; url=maillist.php\" />\n";
/php

Any thoughts?

[darkcarnival]

hmm,

A parse error if you dont know means a character is either missing or is added and not suppose to be there.Now after that echo place a } there and take the } b4 the $email. Doing this will allow the message to send.try that.

[mdhall]

Yes, I couldn't figure out what was in the wrong place. I tried moving the brackets and still getting parse errors. Can you show me how you'd write the code, because I'm probably misinterpreting the way you explained it.

[Snake Shift]

Not sure if this will help...

while($row=$this->db->db_fetch_array($result2)) {
$emails=. "," . $row['email_name'];
}


Try this instead...

$emails.= "," . $row['email_name'];


The string/arithmetic operators go before the assignment operator.

[jewellgr]

I noticed the same error that he had, this should fix the problem.

[mdhall]

Thnx for the response, but now I'm getting this...

Fatal error: Call to a member function on a non-object in /home/blahblahblah/php/songinsert.php on line 9

Also, I changed the second query to select only from the email field, and changed the leter references to match