STUMPED: Simple array vs. result from mysql query.

crazyjeremy

Hello, thanks to everyone who posts here as you have aided me many times when I'm stumped. A long time lurker, this is the first time I've needed to ask a question and hopefully this will help someone else along the way who needs the same answer.

I built a script which reads files in a directory and returns them into an array. All went well in my script and it spits out nice thumbnails for each file. Then, I upgraded the script, putting the same information into a table. 4 columns, one specifically for the filepath info. I am not having any trouble with sending or receiving anything from the database, it works perfectly. I simply do not know how to change the results to what I want.

Specifically,

$query  = "SELECT columnfilepath FROM table WHERE fileowner = '$currentusername'";
$result = mysql_query($query);
$rawphotolist = mysql_fetch_array($result);

The database result is not as simple of an array as I originally had. The mysql results for the file path in the $rawphotolist are buried a little more (behind column information?). $rawphotolist[0] is no longer what I need it to be. I'm not even to sure how to ask the question, but how do I make the array rawphotolist equal to only the data in columnfilepath? I should be able to

count($rawphotolist);
print_r ($rawphotolist);

and get the number of files then the list of each one of them. I'm thinking this might be a VERY easy fix, but I just can't figure it out.

PHP Version 4.3.9, Apache/1.3.33. Sorry if this is wordy, I'm usually an overexplainer.

Thank you all for your time,
crazyjeremy

devinemke

if you are expecting more than 1 record to be returned from your query then you need to do a [man]while[/man] loop to build the array:

$query = "SELECT columnfilepath FROM table WHERE fileowner = '$currentusername'";
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result))
{
	$rawphotolist[] = $row['columnfilepath'];
}
print_r($rawphotolist);

you will then have an array $rawphotolist with all of the columnfilepath's as the values.

crazyjeremy

THANK YOU! While I didn't get your exact code to work I got this one to work...

$cc=0;
while($row = mysql_fetch_row($result))
{
$rawphotolist[$cc] = $row[0];
$cc++;
}

Is your option better in some way? If so, let me know... I like to avoid using counters whenever possible. Sorry if you got a couple notifications from me before, I thought I had it working but I screwed up my data so I had to reimport it.

liquorvicar

have you tried your script without the counter and compared the results? you should find they're exactly the same with 2 less lines (hence a quicker script).
compare:

$cc=0;
while($row = mysql_fetch_row($result))
{
$rawphotolist[$cc] = $row[0];
$cc++;
}
echo('<pre>');
print_r($rawphotolist);
echo('</pre>');

with:

while($row = mysql_fetch_row($result))
{
$rawphotolist[] = $row[0];
}
echo('<pre>');
print_r($rawphotolist);
echo('</pre>');

crazyjeremy

Cool! It's working!

I can't keep track of all that PHP does. It's awesome.