[Resolved] mysql_fetch_array problem

Tigress7

Am trying to fetch results from a table called personal but this code doesn't seem to produce any results. First i connect to mysql and select database as you can see above, this seems to be okay. Then i attempt to use while statements to list thru them. Any ideas why it doesn't work??

<?
include ("connect_to_mysql.php");
include ("select_employeedb.php");

connect_to_mysql();
select_employeedb();

$result=mysql_query("SELECT nameid FROM personal") or die (mysql_error());



echo "<table>";
while($row=mysql_fetch_array($result,MYSQl_ASSOC))
{
echo "<tr>";
while(list($key,$value)=each($row))
{
echo "</td>";
}
echo "</tr>";
}
echo "</table>";


?>

Any more info about script needed-just ask. Thx in advance.

stolzyboy

try this

<?
include ("connect_to_mysql.php");
include ("select_employeedb.php");

connect_to_mysql();
select_employeedb();

$result=mysql_query("SELECT nameid FROM personal") or die (mysql_error());

echo "<table>";
while ($row=mysql_fetch_array($result))
{ 
echo "<tr><td>";
echo $row['nameoffieldtodisplay'];
echo "</td></tr>";
}
echo "</table>";
?>

Tigress7

Excellent! Thanks! But is it possible to get what it's displaying here:

echo $row['nameoffieldtodisplay'];

out of the while loop, because i'd like to use the results obtained in some comparisons lower down the script. Right now I only seem to be able to manipulate them in the while loop's squiggly brackets of course.

stolzyboy

you can just set it equal to a variable

ie.

$variable = $row['nameoffieldtodisplay'];

Tigress7

But since it is passing it into arrays just making it a var like tat doesnt work. I'm not quite sure how to represent it. Any ideas? I tried $var(), which doesnt work...

Basically I need to get thisvariable out of the loop and use it someplace else which it doesn't let me do, am i spsoed to make it global?

laserlight

then you have to assign it to the array.

instead of
$variable = $row['nameoffieldtodisplay'];
use
$variable[] = $row['nameoffieldtodisplay'];

Tigress7

thanks for all your help guys, it's working fine now, the reason it didn't work before was because when i was using it in a comparison , i'd typed the variable to compare it to incorrectly!!:rolleyes: :o