Hey,
Thanks again.
It should take me around an hour or two just to figure out what you
wrote...:-D
I guess i have to hit the manual quite a bit.
Thanks,
-Ryan
> > Hi,
> > Thanks for replying.
>
> no probs...
>
> >
> > I have not worked with arrays much other than simple arrays like the
$_get
> > or $_post and the database ones...can you give me a another emample on
how
> > to do this please?
> > like how to put my db into an array and then call each part....
> >
>
> sorry, i'm probably not the best person to give a full working example. my
> code works for me, but it's a little sloppy. check the php manual. look-up
> associative arrays.
>
> lets see if i can't give you a quick example tho...
>
> <?
>
> $n = 0;
> $result = mysql_query( "SELECT id, title, text, date FROM news ORDER BY
date
> DESC" );
> while ($rows = mysql_fetch_array($result)) {
> if( $rows == "" ){
> continue;
> }
> extract( $rows ); ///extract our result into variables named after our
> fields
> $content[id][$n] = $id;
> $content[title][$n] = $title;
> $content[text][$n] = $text;
> $content[date][$n] = $date;
> $n++; //increment our number for next time...
> }
>
> //this next bit is sloppy coz i'm just gonna make it up for an example
>
> print "<table>"
> for( $c=0; $c<4; $c++ ) //4 coz there's 4 key fields
> {
> //print the id's
> print "<tr>";
> print "<td>ID</td>";
> for( $i=0; $i<$n; $i++ )
> print "<td>".$content[id][$i]."</td>";
> print "</tr>";
> //print the titles
> print "<tr>";
> print "<td>TITLE</td>";
> for( $i=0; $i<$n; $i++ )
> print "<td>".$content[title][$i]."</td>";
> print "</tr>";
> //print the text
> print "<tr>";
> print "<td>TEXT</td>";
> for( $i=0; $i<$n; $i++ )
> print "<td>".$content[text][$i]."</td>";
> print "</tr>";
> //print the date
> print "<tr>";
> print "<td>DATE</td>";
> for( $i=0; $i<$n; $i++ )
> print "<td>".$content[date][$i]."</td>";
> print "</tr>";
> }
> print "</table>";
>
> ?>
>
> like i said, this isn't the most glamorous way of doing it, and you really
> should look this all up in the manual before trying it out. but if you run
> this code (and you have a db to back it up) you should get a table with
the
> format i think your after...
>
>
> >
> > Thanks,
> > -Ryan
> >
>
> no probs, hope my sloppy code helps you a little ;)
>
> -skate-
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
