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
ddragas
Forum Contributor
Posts: 445 Joined: Sun Apr 18, 2004 4:01 pm
Post
by ddragas » Wed Feb 01, 2006 3:51 pm
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;
}
JayBird
Admin
Posts: 4524 Joined: Wed Aug 13, 2003 7:02 am
Location: York, UK
Contact:
Post
by JayBird » Thu Feb 02, 2006 3:39 am
ddragas wrote: Hope you'll understand what I'm asking for.
Nope
raghavan20
DevNet Resident
Posts: 1451 Joined: Sat Jun 11, 2005 6:57 am
Location: London, UK
Contact:
Post
by raghavan20 » Thu Feb 02, 2006 4:06 am
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...
ddragas
Forum Contributor
Posts: 445 Joined: Sun Apr 18, 2004 4:01 pm
Post
by ddragas » Thu Feb 02, 2006 7:59 am
yes what I ment was two dimensional arrays.
John Cartwright
Site Admin
Posts: 11470 Joined: Tue Dec 23, 2003 2:10 am
Location: Toronto
Contact:
Post
by John Cartwright » Thu Feb 02, 2006 9:37 am
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?
ddragas
Forum Contributor
Posts: 445 Joined: Sun Apr 18, 2004 4:01 pm
Post
by ddragas » Thu Feb 02, 2006 9:40 am
thank you
that's it