Re: One more newbie question. About foreach..

On 23 Jun 2013 at 16:11, Karl-Arne Gjersøyen <karlarneg@gmail.com> wrote: > // Foreach get all given serialnumbers as I want it > foreach($serialnumber as $snr){ > > // I got the number of serialnumbers given in the array > $count = count($serialnumber); Why not do this *before* the foreach loop? > // I thought that a for loop would do the trick together with foreach > // And repeat the $sql = SELECT below but that did not happen. > for($i = 0; $i <= $count; $i++){ > > > // Connect and get only those records with given serialnumber > $sql = "SELECT * FROM explosive WHERE serialnumber = '$snr'"; > } // End of for loop > } // End of foreach loop All this for loop does is overwrite $sql each time. > $result = mysql_query($sql, $connect) or die(mysql_error()); > $count = mysql_num_rows($result); You need to have your mysql_query *inside* the for loop. Then, what are you doing with the results of the mysql_query? Nothing? Also, why do you need the for loop anyway? What is it supposed to do? -- Cheers -- Tim