[Resolved] Please help!!PHP Problem!!

obrienkev

Hi all,

Please could you help me out here...I have created a database with a list of people and emails. However when I use php to display the list I do not get the list. Why???

Here is my code...It connects ok to the db.

mysql_select_db('cartest');
$query = "select * from candidate";
$result = mysql_query($query);

	$num_results = mysql_num_rows($result);

	echo "<font size = 4>Select people to contact</font><pre></pre>";

	for ($i=0; $i<$num_results; $i++)
	{
		$row = mysql_fetch_array($result);
		echo $row['name'].'
		<input type="checkbox" name="rep[]" value='.$row['email'].' title="Select email recepient">';
	}

TheDefender

Change your FOR loop to a WHILE to see what it does. (I am really just curious to see if this works, to know where to ebgin trying to help.

You say you don't get the list... What do you get instead?

WHILE($row = mysql_fetch_array($result)){ 
echo $row['name']." 
<input type=\"checkbox\" name=\"rep[]\" value=".$row['email']." title=\"Select email recepient\">"; 
}

obrienkev

no that doesnt work. it doesnt seem to be able to read the database for some reason. i tested another db and it worked fine.

my database has 2tables..name and email.both are varchar 100

laserlight

Test for this database:

<?php
mysql_select_db('cartest')
	OR die(mysql_error()); //for debugging

$query = "SELECT * FROM candidate";
$result = mysql_query($query)
	OR die(mysql_error()); //for debugging

while ($row = mysql_fetch_array($result)
{
	echo $row['name']
		. '<input type="checkbox" name="rep[]" value="'
		. $row['email'] . '" title="Select email recepient">';
}
?>

obrienkev

thanks for the error checking tips. the problem was that the priviliges werent set properly.

barrin

Privileges cause so many problems :p