Php loop create array inside php code

Question

I need some help with the following code...

How do I create the array from a mysql db:

I have already created the connection set: I want to get the data for my domain from the db, this I can do - My problem is mainly how to create the loop...

<?php
// Each sponsor is an element of the $sponsors array:
$sponsors = array( 
    array('domain1.com','The biggest social network in the world.','http://domain1.com/'),
    array('domain2.com','Imaging and optical technology manufacturer.','http://domain2.com/'));
// Randomizing the order of sponsors:
shuffle($sponsors);
?>

I have tried to do it like this:

do {
array(''.$row_rs_domainrecord['g_sites_image'].'','The biggest social network in the world.',''.$row_rs_domainrecord['g_sites_url'].''),
} while ($row_rs_domainrecord = mysql_fetch_assoc($rs_domainrecord)););

but get an error here

But are not getting the results and get an error $sponsors = array(

What would be the easiest way to greate this loop?

Thanks

What's the exact error you're getting, and what exactly are you trying to do? Sorry, not clear on both counts from your question. — deceze
– deceze ♦, Commented May 19, 2011 at 3:35
Also, ''.$row[...].'' is nonsense, it's the same as $row[...]. — deceze
– deceze ♦, Commented May 19, 2011 at 3:36
Parse error: syntax error, unexpected T_DO, expecting ')' in C:\inetpub\wwwroot\domain\index.php on line 68 — Gerald Ferreira
– Gerald Ferreira, Commented May 19, 2011 at 3:38

deceze · Accepted Answer · 2011-05-19 03:43:00Z

2

I guess you're looking for this:

$sponsors = array();
while ($row = mysql_fetch_assoc($rs_domainrecord)) {
    $sponsors[] = array($row['g_sites_image'], 'The biggest social network in the world.', $row['g_sites_url']);
}

$array[] = appends to an existing array.

answered May 19, 2011 at 3:43

deceze♦

525k89 gold badges806 silver badges954 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Gerald Ferreira Over a year ago

Thanks Deceze - The solutions works perfectly - I envisage that I am going to do this frequently and this will help alot!

Gaurav · Accepted Answer · 2011-05-19 03:42:14Z

2

$sponser = array();
while ($row_rs_domainrecord = mysql_fetch_assoc($rs_domainrecord))
{
   $sponser[] = array($row_rs_domainrecord['g_sites_image'],'The biggest social network in the world.',$row_rs_domainrecord['g_sites_url']);
}

answered May 19, 2011 at 3:42

Gaurav

28.8k9 gold badges54 silver badges81 bronze badges

Collectives™ on Stack Overflow

Php loop create array inside php code

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related