no result in php but mysql says otherwis

[Anon]

This query tells me that its not a valid mysql result on line blah blah etc.

echo"$dateone $datetwo $c_id";//output the form data so i know its there

//do the query
$query ="select * from egg_order where c_id = '$c_id' AND (eo_date BETWEEN
'$dateone' AND '$datetwo' ) order by eo_date desc";
$result = mysql_query($query);
//loop the results
while($row=mysql_fetch_array($result)){

echo"$row[eotrans_id]<br>";

}
ive ran the query through phpmyadmin and it outputs 12 results, like i expect it to.

can someone tell me why it doesnt in php or point me in the right direction.

thanks if you can help.

[flipis]

I'd rather use this:

$result = mysql_query($query);
$rows = mysql_num_rows($result);

echo "Rows --->".$rows;

for($i=0;$i<$rows;$i++){
$final = mysql_result($query,$i,"field_name");
echo "Value of field --->".$final;
}

Hope it helps

fLIPIS

[Anon]

thanks fLIPIS

I forgot to include my conn script >:-S

eg include("../os_conn.inc");

ive used your for loop too.

[flipis]

You're welcome, mate.

fLIPIS