Coding Help Please

[darkdesire]

this has been stressing me for days lol could anyone please tell me what i've done wrong? i'm trying to get a page to pm all members, the code im using follows...

<?php 
header("Cache-Control: no-cache, must-revalidate");
	include("config.inc.php");
header("Pragma: no-cache");
header("Content-type: text/vnd.wap.wml"); 
echo "<?xml version=\"1.0\"?>"; 
echo "<!DOCTYPE wml PUBLIC \"-//WAPFORUM//DTD WML 1.1//EN\" \"http://www.wapforum.org/DTD/wml_1.1.xml\">"; 
echo "<wml>"; 
$sqlthing = mysql_query("SELECT * FROM members WHERE username='$username'");
   $owner=(mysql_result($sqlthing,0,"owner"));
   $pmname=(mysql_result($sqlthing,0,"pmname"));
   $buddyname=(mysql_result($sqlthing,0,"buddyname"));

echo "<card id=\"card1\" title=\"$pmname Sent\">"; 
echo "<p align=\"center\">";

$Connect = mysql_connect("$server","$user","$pass");
mysql_select_db("$dbname");
$result=mysql_query("select * from members where username='$username' and session='$session'");
$number_of_rows = mysql_num_rows($result);
if ($number_of_rows>0)
{
	include("check.inc.php");
}
if ($ok>0)
{
	include("online.inc.php");


$date_sent = date('Y-m-d H:i:s');

	$from_username=$username;
	$has_it_been_read = "no";
    $pos=1;

$gbvalues="$pm_message";
	include("smilies.inc.php");

$max_results = 3000; 
$result9 = mysql_query("SELECT * FROM members ORDER by id asc LIMIT 0, $max_results"); 
 $username9=(mysql_result($result9,0,"username"));




$date_sent = date('Y-m-d H:i:s');
	$sql = "INSERT INTO privatemessage3 (to_username, from_username, date_sent, has_it_been_read, pm_message, spamfree) VALUES ('$username9','$from_username','$date_sent','no','$pm_message','$pos')";
$result = mysql_query($sql);









echo " PM Sent to All Staff<br/>";
echo "<a title=\"Enter\" href=\"pm.php?username=$username&amp;session=$session\">Continue</a>";



        
        
        }
echo "</p>";
echo "</card>";
echo "</wml>";
?>

My problem is it only sends to one person and i cant work out how to get it to select every member, any help would be appreciated

Many thanks
Jamie

[subzero]

'$username9'


You need to array this as this only will lookup 1 per send.

[darkdesire]

thanks sub but thats the bit i dont see how to do, i dont understand why its only returning one name

[subzero]

$result = mysql_query("SELECT * FROM members ORDER by id"); 

if(mysql_num_rows($result) > 0) 
{ 
$username9 = 0; 
while ($row = mysql_fetch_array ($result, mysql_ASSOC)) 
{
$username9 = $row['to_username'] . ', ';
$date_sent = date('Y-m-d H:i:s');
	$sql = "INSERT INTO privatemessage3 (to_username, from_username, date_sent, has_it_been_read, pm_message, spamfree) VALUES ('$username9','$from_username','$date_sent','no','$pm_message','$pos')";
$result = mysql_query($sql);
}

[darkdesire]

that just gives me a white page sub mate

[subzero]

. ', ';

take out

then place ; only

My error lol

[darkdesire]

still the same mate, white page, validation says - end of document in prolog

[subzero]

$result = mysql_query("SELECT * FROM members ORDER by id"); 
if(mysql_num_rows($result) > 0) 
{ 
$username9 = 0; 
while ($row = mysql_fetch_array ($result, mysql_ASSOC)) 
{
$username9 = $row['to_username'] . ', ';
$date_sent = date('Y-m-d H:i:s');
	$sql = "INSERT INTO privatemessage3 (to_username, from_username, date_sent, has_it_been_read, pm_message, spamfree) VALUES ('$username9','$from_username','$date_sent','no','$pm_message','$pos')";
$count++; 
} 
echo "myResult=$count Emails Sent. Done."; 
}else{ 
echo "myResult=Email Submissions Failed."; 
}

Or

$result = mysql_query("SELECT * FROM members ORDER by id"); 
if(mysql_num_rows($result) > 0) 
{ 
$count = 0;
while ($row = mysql_fetch_array ($result, mysql_ASSOC)) 
{
$username9 = $row['to_username'] . ', ';
$date_sent = date('Y-m-d H:i:s');
	$sql = "INSERT INTO privatemessage3 (to_username, from_username, date_sent, has_it_been_read, pm_message, spamfree) VALUES ('$username9','$from_username','$date_sent','no','$pm_message','$pos')";
$count++; 
} 
echo "myResult=$count Emails Sent. Done."; 
}else{ 
echo "myResult=Email Submissions Failed."; 
}

[darkdesire]

myResult=0 Emails Sent. Done. PM Sent to All Staff
Continue

but nothing sent to anyone now mate

the coding youre trying mate looks more like php5, its a php4 scotspaul script im editing

[subzero]

oh ok i will think of a good plan then

[darkdesire]

cheers sub mate

[subzero]

Give this a shot

$query="SELECT * FROM members ORDER by id";
$result=mysql_query($query);
$num=mysql_num_rows($result);

 $i=0;
        while ($i < $num) 
        {
$username9=mysql_result($result,$i,"to_username");

$date_sent = date('Y-m-d H:i:s');
$sql = "INSERT INTO privatemessage3 (to_username, from_username, date_sent, has_it_been_read, pm_message, spamfree) VALUES ('$username9','$from_username','$date_sent','no','$pm_message','$pos')";
$result = mysql_query($sql);

$i++;
                                
        }
}

[darkdesire]

Sorted it thanks sub, Cheers for the help. the following works fine

$result9 = mysql_query("SELECT * FROM members ORDER by id asc"); 
if(mysql_num_rows($result9) > 0) 
{ 
$count = 0;
while ($row = mysql_fetch_array ($result9)) 
{
$username9 = $row['username'];
$date_sent = date('Y-m-d H:i:s');
	$sql = "INSERT INTO privatemessage3 (to_username, from_username, date_sent, has_it_been_read, pm_message, spamfree) VALUES ('$username9','$from_username','$date_sent','no','$pm_message','$pos')";
$result = mysql_query($sql);



}}

[subzero]

Always glad to help.

[darkdesire]

youre a star mate, its the array bit i missed, cheers dude