thecableguy2011

Hi, i have a marquee on my page that is getting its contents from mysql database. It gets all the information, put it in the marquee and it all scrolls, that works fine. The problem is that it take takes all the information and puts it as one line. That is it takes all the records and makes them as one. I want it to seperate them. I think the problem is with my loop. I have tried moving the loop and nothing seems to work. Please help, here is the code that im using <marquee behavior="scroll" direction="up" onmouseover="this.stop();" onmouseout="this.start();"> <h1> <?php require_once("connect.php"); $selectsqw = "SELECT name, quantity, price FROM inventory"; $resultqw = mysql_query($selectsqw); $countrowssaqw = mysql_num_rows($resultqw); if ($countrowssaqw > 1) { while ($resqw = mysql_fetch_array($resultqw)) { $resuqw[] = $resqw; } mysql_free_result($resultqw); foreach ($resuqw AS $rowqw) { ?> Latest Tenders: <?php echo "".$rowqw['name']." - ".$rowqw['quantity']." - ".$rowqw['price'].""; ?> <?php } } ?> </h1> </marquee>

Hi I am trying to store the results of a mysql query into a php array. Here is the code i am using $test = implode(",",$_GET['checkbox']); $query = mysql_query("SELECT categoryTitle FROM `category` where categoryid in ($test)"); $test2 = array(); while ($result = mysql_fetch_assoc($query)) { $test2[] = $result; } $test3 = implode(", ",$test2); print_r($test3); Everything works fine until implode the array. When i try to print after the implode the result is "Array, Array". if i remove the implode it prints "Array ( [0] => Array ( [categoryTitle] => Escalators & Lifts ) [1] => Array ( [categoryTitle] => Human Resource/Payroll/ Training ) )" The values here are ture. Im thinking that its storing an array inside another array so cannot implode. Is there something i can do to solve this