All pastes #521940 Raw Edit

Unnamed

public text v1 · immutable
#521940 ·published 2007-05-30 09:36 UTC
rendered paste body
require_once ('mysql_connect.php');
		$query = "select * from users, tutorials WHERE users.username = tutorials.username and
		valid = 'Valid'";
		$result = @mysql_query ($query);

		
		echo "<br><table 
			width=\"950\"
			border=\"1\"
			cellpadding=\"3\" 
			bgcolor=\"#99ccff\" 
			align=\"center\">";
		
		echo "<th bgcolor=\"#ffffff\">Username</th>
			<th bgcolor=\"#ffffff\">Lesson</th>
			<th bgcolor=\"#ffffff\">Example Code</th>
			<th bgcolor=\"#ffffff\">Browser View</th></tr>";
			
		 if ($ROW = mysql_fetch_array($result))
		{	
			$ec = htmlspecialchars($ROW[exampleCode]);
				
			echo "<td> $ROW[username] </td>";
			echo "<td> $ROW[lesson] </td>";
			echo "<td> $ec </td>";
			echo "<td> $ROW[browserCode] </td></tr>";
		
		}
	
		else
			{
				echo "<p> No tutorials available at present </p>";
			}

		echo "</table>";