Arrays

[sandy1028]

Hi,

The below code is fetch the data from table.
The problem is for each id
execw is 4 to 5 rows.
But only one value is fetched.

How to push all the rows into array $records.

 $result = mysql_query("select id,state,subtime from table1 where id="23" order by subtime desc");
                     $no_of_rows = mysql_num_rows($result);

         while($r = mysql_fetch_array($result)){
            $exec = '';
            $res = mysql_query("select execw from table2 where id='".$r[0]."'");
            while($row = mysql_fetch_array($res)){
               $exec = $row[0];
            }

                      array_push($records, "$r[0]#$r[1]#$r[2]#$r[3]#$r[4]#$exec");
         }

[bradgrafelman]

I think it would be much easier (and more efficient) if you did this all in one query, something like:

SELECT t1.id, t1.state, t1.subtime, t2.execw
FROM table1 t1
INNER JOIN table2 t2
ON t1.id = t2.id
WHERE t1.id = 23
ORDER BY t1.subtime DESC
LIMIT 1 # If you're expecting more than 1 record, remove this line

Then you can simply loop through the result set.

[sandy1028]

But still only one row of execw is displayed in a table in front end.

select execw from table2 where id="1456";
+----------+
| execw |
+----------+
| tfg82/0 |
| tfg82/0 |
| tfg82/0 |
| tfg82/0 |
+----------+
4 rows in set (0.86 sec)

id EXECW
1456 tfg82/0

But all the 4 rows should be displayed

[Weedpacket]

Dunno what your code looks like now, but in the original:

 while($row = mysql_fetch_array($res)){
                   $exec = $row[0];
                }

You're never doing anything with each $exec you retrieve before you replace it with the next. Afterwards you're left with just the last one.

Maybe you're making the same mistake now.