Adding further data to an array..

andrewmoir

<?php
$registerdates = array();
$resultcs = mysql_query("
    SELECT DISTINCT customer, site
    FROM PERMISSIONSCUSTSITE
    WHERE USERNAME = '".$usernam."'
    ORDER BY customer, customer desc
");
while($rowcs = mysql_fetch_array($resultcs)){
    $resultans = mysql_query("
        SELECT DISTINCT registerdate
        FROM sample
        WHERE customer='".$rowcs["customer"]."' AND site='".$rowcs["site"]."'
        ORDER BY registerdate DESC
    ");
    while($rowans = mysql_fetch_array($resultans)){
        $registerdates[] = $rowans['registerdate'];
    }
}
?>

as you can see - I am running through 2 seperate select statements and populating the result into an array:

while($rowans = mysql_fetch_array($resultans)){
        $registerdates[] = $rowans['registerdate'];

but say I wanted to also include more info in that registerdates array e.g. select registerdate and sampledate from sample. How do I then get the sampledate and registerdate into the registerdates[] array?

how would I pull both results out of the array?

arrays can be flippin hard

Regards

Installer

Something like this?

while ($rowans = mysql_fetch_array($resultans)) { 
    $registerdates[] = array($rowans['registerdate'], $rowans['sampledate']; 
}
foreach ($registerdates as $value) {
    echo $value['registerdate'] . ' / ' . $value['sampledate'] . '<br />';
}

Edit: To access, for example, the fourth value:

echo $registerdates[3]['registerdate'];

Addend.: "SELECT DISTINCT registerdate, sampledate etc." should get your data.

andrewmoir

 $registerdates[] = array($rowans['registerdate'], $rowans['sampledate'];

There appears to be one loose bracket, can't figure out where the closing bracket is mean't to be??

Thanks so much for your help so far...

Installer

I forgot the closing parenthesis:

$registerdates[] = array($rowans['registerdate'], $rowans['sampledate']);

andrewmoir

Doing some reading up on Arrays.

There seems to be a problem with this

while ($rowans = mysql_fetch_array($resultans)) { 
    $registerdates = array($rowans['registerdate'], $rowans['sampledate']; 
}

Note I removed the [] from$registerdates = .

first if doing the following, it only seems to do the action once, i.e. registerdates[0] has a value but nothing else does (e.g.registerdates[1]) (note I am trying with only the one value here (i.e. registerdate).)

while ($rowans = mysql_fetch_array($resultans)) { 
    $registerdates[] = array($rowans['registerdate']);

as opposed to

registerdates[] = $rowans['registerdate'];

So I do:

registerdates[] = $rowans['registerdate'];
registerdates[] =$rowans['sampledate'];

however this produces first all the registerdates And then only the sample dates - but the 2 are related i.e. sampledate[1] links to registerdate[1]. I need to be able to pull both out at a time. like in your

echo $value['registerdate'] . ' / ' . $value['sampledate'] . '<br />';

but I don't think its the correct type of array to do that???

Installer

From your original post:

How do I then get the sampledate and registerdate into the registerdates[] array?

The code I gave you will do that, assuming you alter your query to get "sampledate" also. If "$registerdates[0]" has values, but not "$registerdate[1]", then your query is returning only one row (as it probaby should for each loop, if there is only one record for each customer/site pair. But if you get one result on the inner loop for each iteration of the outer loop, the count for "[]registerdates" will equal the number of results for the outer loop. But then I don't know what your data set comprises).

how would I pull both results out of the array?

The values in the array become, for the first row, "$registerdates[0]['registerdate']" and "registerdates[0]['sampledate']". The values from the next row, if returned by the query, would become"$registerdates[1]['registerdate']" and "registerdates[1]['sampledate']", and so on.

After your "while" loop finishes, "$registerdates" will contain the values and can be echoed with the exact code I posted for that.

Here again is the code:

while ($rowans = mysql_fetch_array($resultans)) {  

    $registerdates[] = array($rowans['registerdate'], $rowans['sampledate'];  

} 
foreach ($registerdates as $value) { 
    echo $value['registerdate'] . ' / ' . $value['sampledate'] . '<br />'; 
}

andrewmoir

Whew finally got it to work

This seemed to work best: And I seemed to have to use: $rowans[registerdate] as opposed to: $rowans['registerdate'] (no ' ')

Thanks to Installer for the help and pointing me in the right direction.

while ($rowans = mysql_fetch_array($test)) {  

     $registerdates[] = array("regisdate" => $rowans[registerdate],"sampn" => $rowans[sampledate]);  

}

regards

Andrew

Installer

I'm very glad to help. But I see no reason to omit the quotes (i.e. why it "seemed" like you had to). In fact, if you do and you have error reporting turned on, as you should, then PHP will issue a warning.