# Query with array

**URL:** https://forum.kirupa.com/t/query-with-array/230902
**Category:** Uncategorized
**Created:** [June 29, 2007, 8:29pm UTC](https://forum.kirupa.com/t/query-with-array/230902 "2007-06-29T20:29:54Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![rschoenbach](https://avatars.discourse-cdn.com/v4/letter/r/7cd45c/32.png) [@rschoenbach](https://forum.kirupa.com/u/rschoenbach)
#### Post date: [June 29, 2007, 8:29pm UTC](https://forum.kirupa.com/t/query-with-array/230902/1 "2007-06-29T20:29:54Z")

</div>

Below is the code for this problem i have.

I am running a few queries to do a few things.

First query creates column headers.

Second query shows users available.

Third quest displays users information.

What I need to do is take the returned value $result\_machines and based on what column they are in from $machine\_array either put \<input type=checkbox checked\> or \<input type=checkbox\>.

Any help

```php
echo '<table><tr>';
echo '<td>Name</td>';
//echo "<td>Alert</td>";

$query_column = "SELECT uid, machinename from machineinfo";
$result_column = mysql_query($query_column);

$i = 0;
$machine_array = array();
while ($i < mysql_num_rows($result_column)) {
    $uid = mysql_result($result_column, $i, "uid");
    $column = mysql_result($result_column, $i, "machinename");
    echo "<td class=vertical>$column</td>";
    array_push($machine_array,$uid);
    $i++;
}
echo "</tr>";

$query_row = "SELECT uid, name, alertnumber FROM wkusers";
$result_row = mysql_query($query_row);

$j = 0;
while ($j < mysql_num_rows($result_row)) {
    echo "<tr>";
    $uid = mysql_result($result_row, $j, "uid");
    $name = mysql_result($result_row, $j, "name");
    $alert = mysql_result($result_row, $j, "alertnumber");
    
    
    echo '<td nowrap>'.$name.'</td>';
    //echo "<td nowrap>$alert</td>
";
    
    $query_machines = "SELECT machine from usermachineassociation where user = $uid";
    $result_machines = mysql_query($query_machines);
    
/**
     * Help is needed here
     */

    foreach ($machine_array as $val) {
        if (in_array($row,$val) {
echo "<td></td>";
    }
    
    
    echo "</tr>
";
    $j++;
}
echo "</table>";
?>

```