Posted by Jon on 01/12/06 17:24

To display it is going to be fairly easy with PHP and MySQL. Here's the
algorithm I'd use:

$sql = "SELECT * FROM table_name";
$result = mysql_query($sql);

while($row = mysql_fetch_array($result)){
echo your table structure along with each field you need displayed
}

That what you were looking for?


"manny" <manny@dontspamonme.net> wrote in message
news:lvhcs1hjrv6r4m39dnl05sbad1cf67728p@4ax.com...
>I wish I knew what this was called, and I could have made a more sensible
> subject. For that matter, I knew what it was called, I could have googled
> it!
>
> Anyway, let's I have a table with name, class, grade.
>
> joe bio a
> jill chem b
> john psych b
> john chem a
> jill pysch a
>
> and I want to display the results as
>
> name bio psych chem
> joe a - -
> jill - a b
> john - b a
>
> Is there a way to do this with sql? How about sql with php?
>
> Thanks much!
>
> Manny
> --
> manny@don't spam on me

[Back to original message]