Problem with arrays.

[poleposters]

Hi, I'm having a problem with arrays. I'm only quite new to PHP. Can anyone show me what I'm doing wrong in the following code.

 

I seem to be retrieving the same record for each array $row[slide][0],$row[slide][1],etc.

 

 

$query = "SELECT slide FROM slideshow WHERE business_id=1";
$result = mysql_query ($query);
$numlinks=mysql_num_rows($result);
if($numlinks >0){

$row = mysql_fetch_assoc($result);


$string = "<indexes>" . PHP_EOL;
$string .= "<page" .PHP_EOL;
$string .= "src=\"$row[slide][0]\">" . PHP_EOL;
$string .= "</page>" . PHP_EOL;

$string .= "<page" .PHP_EOL;
$string .= "src=\"$row[slide][1]\">" . PHP_EOL;
$string .= "</page>" . PHP_EOL;

$string .= "<page" .PHP_EOL;
$string .= "src=\"$row[slide][2]\">" . PHP_EOL;
$string .= "</page>" . PHP_EOL;

$string .= "</indexes>". PHP_EOL;

}

$open = fopen("file.xml", "w");
fwrite ($open, $string);
fclose($open);

[miracle_potential]

Not quite sure, but I didnt notice you were missing a full stop before your first = on "$string ="

 

 

$string .= $row[0] ..etc

[Fadion]

Shouldnt those in-string arrays be like?:

 

$string .= "src=\"$row['slide'][0]\">"

[chigley]

<?php

$query = "SELECT slide FROM slideshow WHERE business_id=1";
$result = mysql_query ($query);
$numlinks=mysql_num_rows($result);
if($numlinks >0){

$row = mysql_fetch_assoc($result);

print_r($row);

$string = "<indexes>" . PHP_EOL;
$string .= "<page" .PHP_EOL;
$string .= "src=\"$row[slide][0]\">" . PHP_EOL;
$string .= "</page>" . PHP_EOL;

$string .= "<page" .PHP_EOL;
$string .= "src=\"$row[slide][1]\">" . PHP_EOL;
$string .= "</page>" . PHP_EOL;

$string .= "<page" .PHP_EOL;
$string .= "src=\"$row[slide][2]\">" . PHP_EOL;
$string .= "</page>" . PHP_EOL;

$string .= "</indexes>". PHP_EOL;

}

$open = fopen("file.xml", "w");
fwrite ($open, $string);
fclose($open);

?>

 

Let us know the output of that.

[Barand]

try

<?php
$query = "SELECT slide FROM slideshow WHERE business_id=1";
$result = mysql_query ($query);
$numlinks=mysql_num_rows($result);
if($numlinks >0){

    $string = "<indexes>" . PHP_EOL;
    while ($row = mysql_fetch_assoc($result)) {        // loop through returned rows
        
        $string .= "<page" .PHP_EOL;
        $string .= "src=\"$row['slide']\">" . PHP_EOL;
        $string .= "</page>" . PHP_EOL;
    
    }
    $string .= "</indexes>". PHP_EOL;
}

$open = fopen("file.xml", "w");
fwrite ($open, $string);
fclose($open);

?>

[poleposters]

Thank you. I solved it in the meantime. But both your suggestions are far more elgant than what I came up with.

 

Still trying to get my head around arrays. Thank you for the insight.