Display data from database with phplib

[khristtianna]

Hi,

I 'm having problems with show the data from database (interbase) using phplib. I want to show the data with a table in html. But its not happend.

My code is:

(...)

$sql = "SELECT PEDIDO.PEDIDOID,RESULTADO.EXAMEID,EXAME.EXMEXAME,RESULTADO.RESDATARESULTADO
FROM RESULTADO
INNER JOIN PEDIDO ON (RESULTADO.PEDIDOID = PEDIDO.PEDIDOID)
INNER JOIN EXAME ON (RESULTADO.EXAMEID = EXAME.EXAMEID)
WHERE
(
(PEDIDO.PACIENTEID = '$prontuario')
and
(RESULTADO.RESDATARESULTADO BETWEEN '$data1' and '$data2')
)
ORDER BY RESULTADO.RESDATARESULTADO";

$db->query($sql);

if ($db->num_rows() == 0)
{
print("Prontuário não cadastrado");
}

else
{

while ( $db->next_record() )
    {

	//$var1 = implode("*",$result);

	echo "
  		<tr>
      		<td width = 6%><input type='radio' name='resultado' value='$var1'> </td>
      		<td width = 15% align=center>$db->p('PEDIDO.PEDIDOID')		   </td>
      		<td width = 19% align=center>$db->p('RESULTADO.EXAMEID')           </td>
      		<td width = 43%>$db->p('EXAME.EXMEXAME')                           </td>
      		<td width = 20% align=center>$db->p('RESULTADO.DATARESULTADO')     </td>	  
  		</tr>
 		";

 }

 }

If someone can help me, its urgently!!

bye,
Cristiana...

[joshsisk]

Well, you didn't give much detail about what your error is, but this is how I do it and it works for me:

$string="SELECT id,name FROM foo";

$db=new mydb;
$db->query("$string");

while($db->next_record()) {

$id=$db->f('id');
$name=$db->f('name');

print "<tr><td>$id</td><td>$name</td></tr>";

}

Note I use $db->f, not $db->p. using ->p inside Echo() might cause some problems.

[khristtianna]

Oh,

Thanks, the problem realy was that you said.

Bye.

Cristiana R Sousa
Brazil.