Page 1 of 1

help with array

Posted: Wed Feb 01, 2006 3:51 pm
by ddragas
Hi all

I want to retrive from db 2 informations from 4 recordset and insert them into array, and later print them out.

How to insert 2 informations into array

Hope you'll understand what I'm asking for.

Code: Select all

$sifre=array();
$slike=array();

include("../stranice/con_db.php");
					  
$result =  mysql_query ("SELECT * FROM apartmani 
						where datum_trajanja >= '$danas' 
						and slika1 <> ''
						order by RAND() LIMIT 4") 
						ordie (mysql_error());
while($row = mysql_fetch_array($result))
{
$sifre[] = $row["Sifra_apartmana"];
$slike[] = $row["slika1"];
}

foreach (($sifre as $key => $value) , ($slike as $key1 => $value1))
{

echo "Sifra: " . $value . " Slika: " . $value1;

}

Re: help with array

Posted: Thu Feb 02, 2006 3:39 am
by JayBird
ddragas wrote:Hope you'll understand what I'm asking for.
Nope :?

Posted: Thu Feb 02, 2006 4:06 am
by raghavan20
are you asking for something like two dimensional arrays...what do you mean by taking two information from four record sets...please explain with examples...

Posted: Thu Feb 02, 2006 7:59 am
by ddragas
yes what I ment was two dimensional arrays.

Posted: Thu Feb 02, 2006 9:37 am
by John Cartwright

Code: Select all

while($row = mysql_fetch_array($result))
{
   $data[] = array(
     $row['Sifra_apartmana'],
     $row['slika1']
   );
}

$rowCount = count($data);
for ($x = 0; $x < $rowCount; $x++) {
   echo 'Sifra: '. $data[$x]['apartmana'] .' -- Slika: '. $data[$x]['slika1'];
}
Perhaps?

Posted: Thu Feb 02, 2006 9:40 am
by ddragas
thank you

that's it