Problem with database query

[Anon]

Hi all,

I'm having a real problem with a mysql query from a php script. It works absolutely perfectly from the mysql consol but I get crap when I try to do it from php.

$sQuery = "SELECT * FROM Document_Fields WHERE doc_type_id = '$iDocumentType'";

$oResult = mysql_query($sQuery)
or DIE("Couldn't query database in getFieldNames: ".mysql_error());

for($i=0; $aRow = mysql_fetch_array($oResult); $i++)
{
$aDocumentFieldNames[$i] = $aRow;
return $aDocumentFieldNames;
}

I get three rows returned from mysql consol but only the first one from the php script. Also, any comments on loading the result set into an array - I mean how efficient is that "for" loop?.

Thanks,
Billy

[Anon]

Probably what you should do for your code
is increment
$aRow++

OR
$oResult

instead of $i++

One of the 2 I'm not sure which

Or use what I use:

while($aRow = mysql_fetch_row($oResult))
{
echo $aRow[0].$aRow[1].$aRow[2]
}

Neville

[Anon]

Im not sure if the for loop actually works the way you use it, but the "I only get one record" problem is probably
due to the "return" in your loop statement.

An unconditional return inside a for loop?

[Anon]

hahaha :-)

Thanks, It's always so funny how you think at 2am. Do you know I was looking at the code for so long and I didn't even spot that? All I can say is this is rather embarresing.

Thanks :-)
Billy

[Anon]

Just more proof for my theory that programmers should never have to work more than 5 hours a day, with at least 30 minutes of rest between each hour, while a swedish blonde gives them a backrub....

Oops, getting slightly off-topic.. hehe... but what a topic!

:-)