Row questions

TexasOutdoors

I have a script that I finally got to work that grabs a few fields from a table. I can't seem to get it to grab all the data though as it stops after the first entry in the table. Should it continue, or is there a 'loop' I have to use? I'm still new to this, so take it easy.

<?php
$dbhost = "localhost";
$dbuser = "root";
$dbpassword = "";
$dbname = "clientinfo";

$db = mysql_connect ($dbhost, $dbuser, $dbpassword);
mysql_select_db("$dbname") or die("Could not select database");

$result = mysql_query("SELECT firstname, lastname, email FROM users",$db);

if($result){
$row = mysql_fetch_row($result);

$firstname = $row['0'];

$lastname = $row['1'];

$email = $row['2'];
}
echo "<h3>TXO Unlimited Client Information</h3><table cellspacing=2 border=2 cellpadding=3>
<tr><td><b>First Name</b></td>
<td><b>Last Name</b></td>
<td><b>E-Mail Address</b></td>
</tr>";
echo "<tr height=30>
<td>$firstname</td>
<td>$lastname</td>
<td>$email</td>
</tr>";
echo "</table>";
?>

Also, is there a way to add checkboxes by each one, that will pass the email to an email form separated by ; ?

TIA

tuf-web_co_uk

I'm still new to this, so take it easy.

calm down, we're here to help not judge 😛

Page1

<?php 
$dbhost = "localhost"; 
$dbuser = "root"; 
$dbpassword = ""; 
$dbname = "clientinfo"; 

$db = mysql_connect ($dbhost, $dbuser, $dbpassword); 
mysql_select_db("$dbname") or die("Could not select database"); 

$result = mysql_query("SELECT firstname, lastname, email FROM users",$db); 

if($result){ 

echo "<h3>TXO Unlimited Client Information</h3><table cellspacing=2 border=2 cellpadding=3>";

echo "<form action=\"email_list.php\" method=\"post\">";

while ($row = mysql_fecth_array($result)) {

	$firstname = $row['firstname']; 
	$lastname = $row['lastname']; 
	$email = $row['email']; 

	echo "<tr><td><b>First Name</b></td> 
	<td><b>Last Name</b></td> 
	<td><b>E-Mail Address</b></td> 
	</tr>"; 
	echo "<tr height=30> 
	<td>$firstname</td> 
	<td>$lastname</td> 
	<td>$email <input type=\"checkbox\" name=\"email_list[]\" value=\"".$row['email']."\"></td> 
	</tr>";  

}

echo "</table>";

echo "<input type=\"submit\" value=\"submit\" name=\"submit\">";

echo "</form>";

}

?>

email_list.php

<?
if (!empty($_POST['submit'])) {

for ($i=0;$i<count($_POST['email_list']);$i++) {

	echo $_POST['email_list'][$i]." <br>\n";

}

}
?>

now as you can see email_list.php only displays the emails which have been selected, you can choose to do with them what you want. i didnt want to help you too much because like you said your learning.

for emailing people using php look up [man]mail()[/man]

hth

TexasOutdoors

Well, thanks for sparing me how to do this. lol. just joking. Thanks for the help. I now need to figure out how to move the emails into an email form. I have a form on my current site, so I may try to populate them there.

Thanks again, and now back to figure out how to join two tables together according to userid.

Is there an easy way to do that? lol