SQL wont display results

[spike-spiegel]

Well, the page is not displaying the sql results, perhaps there is something wrong in this line, but I still dont know how to fix:

 

 

 

echo "<tr bgcolor=\"$col\"><td><a class=TN href=\"javascript:popUp('preview.php?uname=$a1[uname]&ename=$ename')\"> $a2[0] $a2[1]</a></td><td> $a1[clname] </td></tr>";

 

Is it the

 $a2[0] $a2[1]

part?

 

 

 

 

The code:

 

{

$q2 = "select fname, lname from job_seeker_info where uname = \"$a1[uname]\" ";

$r2 = mysql_query($q2) or die(mysql_error());

$a2 = mysql_fetch_array($r2);



 if($col == "cococo")

    { 

     $col = "dddddd"; 

    }

         	 else

	{ 

	$col = "cococo"; 

	} 



echo "<tr bgcolor=\"$col\"><td><a class=TN href=\"javascript:popUp('preview.php?uname=$a1[uname]&ename=$ename')\"> $a2[0] $a2[1]</a></td><td> $a1[clname] </td></tr>";

}

 

If you want the full code, let me know.

[ebruggema]

You can add print_r($a2) to your script (after the fetch) and you'll see what the content of $a2 is!