help with array

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
ddragas
Forum Contributor
Posts: 445
Joined: Sun Apr 18, 2004 4:01 pm

help with array

Post 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;

}
User avatar
JayBird
Admin
Posts: 4524
Joined: Wed Aug 13, 2003 7:02 am
Location: York, UK
Contact:

Re: help with array

Post by JayBird »

ddragas wrote:Hope you'll understand what I'm asking for.
Nope :?
User avatar
raghavan20
DevNet Resident
Posts: 1451
Joined: Sat Jun 11, 2005 6:57 am
Location: London, UK
Contact:

Post 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...
User avatar
ddragas
Forum Contributor
Posts: 445
Joined: Sun Apr 18, 2004 4:01 pm

Post by ddragas »

yes what I ment was two dimensional arrays.
User avatar
John Cartwright
Site Admin
Posts: 11470
Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:

Post 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?
User avatar
ddragas
Forum Contributor
Posts: 445
Joined: Sun Apr 18, 2004 4:01 pm

Post by ddragas »

thank you

that's it
Post Reply