Posted by Scott on 04/06/06 15:25

On Thu, 2006-04-06 at 08:43 +0100, Geoff Berrow wrote:
> Message-ID: <1144283421.2806.13.camel@localhost.localdomain> from Scott
> contained the following:
>
> >> $query = ("SELECT * FROM `table`");
> >> $result = mysql_query($query);
> >>
> >> print "<p>Data for Selections:";
> >> print "<table border=2><tr><th>You chose:";
> >>
> >
> >Try this instead (notice the quotes around array keys):
> >
> >while($row = mysql_fetch_array($result)) {
> > if(in_array(strval($row['ID']), $_POST['subm'])) {
>
> Alternatively, just get the rows you want from the database.
>
> $ids=implode(",",$_POST['subm']);
> $query = ("SELECT * FROM `table` WHERE `ID` IN ($ids)");
> $result = mysql_query($query);
> while($row = mysql_fetch_array($result)) {
> //print rows
> }

I like this way better.

[Back to original message]