Having problem with a bit of code. I am trying to fetch data from the database. I want to use this data for an IF statement later on. The IF statement isn’t there, because this code is catching somewhere 
In the code, I have put a comment (// Code kills here …) where the code is killing. I have identified the few lines of code that is killing the script.
You can see the page… The number 71 is what is supposed to be supplied by the query and array. This is the page as it is with the trouble code.
http://img28.imageshack.us/img28/4492/imagerest.jpg
[code]<?php
include (“db.php”);
$get_info = mysql_query (“SELECT * FROM registrations WHERE u_id=$uid AND appid=$appid” , $link2);
//Begin Trouble Code
while ($check = mysql_fetch_array($get_info))
{
echo $check[‘assign_id’];
}
//End Trouble Code
// Code kills here, for some reason… Proper assign_id displayed, but it kills script.
$count = mysql_num_rows($get_info);
if ($count >= 1)
{
$get_jos_info = mysql_query (“SELECT * FROM jos_users WHERE id=$appid” , $link);
$get_avatar = mysql_query (“SELECT * FROM jos_comprofiler WHERE user_id=$appid” , $link);
while ($avatar_link = mysql_fetch_array($get_avatar))
$avatarurl = $avatar_link[‘avatar’];
echo $avatar_link['avatar'];
echo “
”;
while ($rowteam = mysql_fetch_array($get_info))
{
while ($rowjos = mysql_fetch_array($get_jos_info))
{
$urlbegin = "<img src='http://versionxlegends.com/images/comprofiler/tn";
$urlend = "'>";
echo "<tr><td width=100% align=center colspan=2>".$urlbegin.$avatarurl.$urlend."</td></tr>";
echo $avatar;
echo "<tr><td width=40% align=right><strong>Registration #</strong></td><td width=60% align=center>$rowjos[id]</td></tr>";
echo "<tr><td width=40% align=right><strong>User's Username</strong></td><td width=60% align=center>$rowteam[username]</td></tr>";
echo "<tr><td width=40% align=right><strong>User's Name</strong></td><td width=60% align=center>$rowteam[name]</td></tr>";
echo "<tr><td width=40% align=right><strong>Provided Skype Username</strong></td><td width=60% align=center>$rowteam[skype]</td></tr>";
//Add script for lead only view Email Address. Team Member, field is hidden. Lead sees email and a YES/NO if email matches. If not, lead will email user to get email verification, to edit account before assignments occur.
echo "<tr><td width=40% align=right><strong>E-Mail Address</strong></td><td width=60% align=center>$rowteam[email]</td></tr>";
echo "<tr><td width=40% align=right><strong>Registration Date</strong></td><td width=60% align=center>$rowjos[registerDate]</td></tr>";
// Add script for lead only view age. Team Member, field is hidden. Lead sees birthdate and/or age and a YES/NO if age matches. If not, lead will email user with ID verification e-mail, to verify age before assignments occur.
echo "<tr><td width=40% align=right><strong>Age</strong></td><td width=60% align=center>$rowteam[age]</td></tr>";
}}
echo “
”;
}
else
{ echo “Invalid URL. Registration does not exist”;}
?>[/code]
Without the trouble code
[code]<?php
include (“db.php”);
$get_info = mysql_query (“SELECT * FROM registrations WHERE u_id=$uid AND appid=$appid” , $link2);
$count = mysql_num_rows($get_info);
if ($count >= 1)
{
$get_jos_info = mysql_query (“SELECT * FROM jos_users WHERE id=$appid” , $link);
$get_avatar = mysql_query (“SELECT * FROM jos_comprofiler WHERE user_id=$appid” , $link);
while ($avatar_link = mysql_fetch_array($get_avatar))
$avatarurl = $avatar_link[‘avatar’];
echo $avatar_link['avatar'];
echo “
”;
while ($rowteam = mysql_fetch_array($get_info))
{
while ($rowjos = mysql_fetch_array($get_jos_info))
{
$urlbegin = "<img src='http://versionxlegends.com/images/comprofiler/tn";
$urlend = "'>";
echo "<tr><td width=100% align=center colspan=2>".$urlbegin.$avatarurl.$urlend."</td></tr>";
echo $avatar;
echo "<tr><td width=40% align=right><strong>Registration #</strong></td><td width=60% align=center>$rowjos[id]</td></tr>";
echo "<tr><td width=40% align=right><strong>User's Username</strong></td><td width=60% align=center>$rowteam[username]</td></tr>";
echo "<tr><td width=40% align=right><strong>User's Name</strong></td><td width=60% align=center>$rowteam[name]</td></tr>";
echo "<tr><td width=40% align=right><strong>Provided Skype Username</strong></td><td width=60% align=center>$rowteam[skype]</td></tr>";
//Add script for lead only view Email Address. Team Member, field is hidden. Lead sees email and a YES/NO if email matches. If not, lead will email user to get email verification, to edit account before assignments occur.
echo "<tr><td width=40% align=right><strong>E-Mail Address</strong></td><td width=60% align=center>$rowteam[email]</td></tr>";
echo "<tr><td width=40% align=right><strong>Registration Date</strong></td><td width=60% align=center>$rowjos[registerDate]</td></tr>";
// Add script for lead only view age. Team Member, field is hidden. Lead sees birthdate and/or age and a YES/NO if age matches. If not, lead will email user with ID verification e-mail, to verify age before assignments occur.
echo "<tr><td width=40% align=right><strong>Age</strong></td><td width=60% align=center>$rowteam[age]</td></tr>";
}}
echo “
”;
}
else
{ echo “Invalid URL. Registration does not exist”;}
?>[/code]
The script goes to completion with no errors.
http://img221.imageshack.us/img221/2352/image2ocv.jpg
Any ideas??
Thanks for any help I receive in advance
