Posted by Geoff Berrow on 04/06/06 10:43

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
}
--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/

• Next in forum: A Special Invitation to Join abcphp.com
• Prev in forum: Re: Problem with PHP Page
• Thread view: Re: Populating form from database, then passing results to next page

[Reply to this message]