Rookie PHP/MySQL Question

"Scott Johnson" wrote in message

> Ian Rutgers wrote:
>> In querying a database
>>
>> ($result=query_db("SELECT photo_dir, photo_name FROM photograph_photo
>> WHERE photo_dir = '$dirToCheck'");
>>
>> is $result an array (where I could used a "in_array() function)?
>>
>> Thanks,
>>
>> Ian
> No the result is basicly a pointer to an external resource.
>
> You need to use an additional function to put that external resource into
> a usable value.
>
> The best way I find is to use (depending on the DB your using, there are
> different usages for each DB supported) is mysql_fetch_array($result)
>
> But with this you will need to step through the $result if more then one
> row is found.
>
> while($row = mysql_fetch_array($result)){
> foreach($row as $key => $vlaue){
> echo "Key: ".$key." (Value: ".$value.")";
> }
> }
>
> Hope this helps. If not post back.
> Scott

I thought I had this problem licked until I found I wasn't getting all the
values stored in my array ....
If I use:
while($row = mysql_fetch_array($result))
{
printf ($row["photo_name"]);
foreach($row as $key => $value)
{
$my_array[$key] = $value;
}
} //array now full of results from previous query
print_r($my_array);
$numArrayItems = count($my_array);
print("{$numArrayItems}\r");

I discover the numer of array items is only 2 (versus the 12 it should be).
If I use:
foreach($row as $value)
{
$my_array[] = $value;
}
I discover the number of array items is 24(double the number it should be).

What am doing wrong????

Thanks
 >> Stay informed about: Rookie PHP/MySQL Question 

"Ian Rutgers" wrote in message

>
> "Scott Johnson" wrote in message
>
>> Ian Rutgers wrote:
>>> In querying a database
>>>
>>> ($result=query_db("SELECT photo_dir, photo_name FROM photograph_photo
>>> WHERE photo_dir = '$dirToCheck'");
>>>
>>> is $result an array (where I could used a "in_array() function)?
>>>
>>> Thanks,
>>>
>>> Ian
>> No the result is basicly a pointer to an external resource.
>>
>> You need to use an additional function to put that external resource into
>> a usable value.
>>
>> The best way I find is to use (depending on the DB your using, there are
>> different usages for each DB supported) is mysql_fetch_array($result)
>>
>> But with this you will need to step through the $result if more then one
>> row is found.
>>
>> while($row = mysql_fetch_array($result)){
>> foreach($row as $key => $vlaue){
>> echo "Key: ".$key." (Value: ".$value.")";
>> }
>> }
>>
>> Hope this helps. If not post back.
>> Scott
>
> I thought I had this problem licked until I found I wasn't getting all the
> values stored in my array ....
> If I use:
> while($row = mysql_fetch_array($result))
> {
> printf ($row["photo_name"]);
> foreach($row as $key => $value)
> {
> $my_array[$key] = $value;
> }
> } //array now full of results from previous query
> print_r($my_array);
> $numArrayItems = count($my_array);
> print("{$numArrayItems}\r");
>
> I discover the numer of array items is only 2 (versus the 12 it should
> be).
> If I use:
> foreach($row as $value)
> {
> $my_array[] = $value;
> }
> I discover the number of array items is 24(double the number it should
> be).
>
> What am doing wrong????
>
> Thanks
>
Update ...With a Question ... I changed this:
while($row = mysql_fetch_array($result))
{
printf ($row["photo_name"]);
foreach($row as $key => $value)
{
$my_array[$key] = $value;
}
} //array now full of results from previous query

to this ....

while($row = mysql_fetch_array($result))
{
$my_array[] = $row["photo_name"];
}

and $my_array[] now stores the corrent number of image names!! Why does the
foreach(....) duplicate the entries?
 >> Stay informed about: Rookie PHP/MySQL Question 

Ian Rutgers wrote:
> and $my_array[] now stores the corrent number of image names!! Why
> does the foreach(....) duplicate the entries?

foreach isn't the problem.

mysql_fetch_array does this:

www.php.net:
mysql_fetch_array -- Fetch a result row as an associative array, a numeric
array, or _both_

So is returns both numeric and named arrayvalues.
(For example: [key] => value:
[0] => value1
[name1] =>value1
[1] => value2
[name2] => value2)

Use mysql_fetch_assoc, or mysql_fetch_array($bla, MYSQL_ASSOC) or
mysql_fetch_array($bla, MYSQL_NUM).

In the second example you're only checking for named values, so it returns
just the one set, in the first you're accessing all values, also the
numeric.

Grtz,

Rik
 >> Stay informed about: Rookie PHP/MySQL Question 

"Rik" wrote in message

> Ian Rutgers wrote:
>> and $my_array[] now stores the corrent number of image names!! Why
>> does the foreach(....) duplicate the entries?
>
> foreach isn't the problem.
>
> mysql_fetch_array does this:
>
> www.php.net:
> mysql_fetch_array -- Fetch a result row as an associative array, a numeric
> array, or _both_
>
> So is returns both numeric and named arrayvalues.
> (For example: [key] => value:
> [0] => value1
> [name1] =>value1
> [1] => value2
> [name2] => value2)
>
> Use mysql_fetch_assoc, or mysql_fetch_array($bla, MYSQL_ASSOC) or
> mysql_fetch_array($bla, MYSQL_NUM).
>
> In the second example you're only checking for named values, so it returns
> just the one set, in the first you're accessing all values, also the
> numeric.
>
> Grtz,
>
> Rik
>
>
Thanks for the education!
 >> Stay informed about: Rookie PHP/MySQL Question