Query with Access
| From: | Fernando Buitrago | Date: | Sun, 01 Apr 2001 08:21:35 +0000 |
| Subject: | Query with Access | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-8086@lists.php.net to get a copy of this message | ||
Well, this is my code, but it dosen't work, please, help me, this table has
5 records, and the result of the query is -1.
Code
<html>
<head>
<title>Lista Datos</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<?
$conn = odbc_connect("pruebas_php", "", "");
$resultado1 = odbc_exec($conn,"SELECT Nombre, Apellido1, Apellido2 FROM
Personas");
echo odbc_num_rows($resultado1);
$cantidad_articulos = 0;
for
($cantidad_articulos=1;$cantidad_articulos<=odbc_num_rows($resultado1);$cant
idad_articulos++) {
echo odbc_result($resultado1,2);
echo odbc_result($resultado1,3);
echo odbc_result($resultado1,4);
}
?>
</body>
</html>
Regards