please help for beginner(php + ms access)

#1 July 17th, 2005, 01:30 PM

<html>
<head>
</head>

<body><pre>
<?php

$connection =
odbc_connect("test","root","passwd");

$query = odbc_exec($connection, "SELECT * FROM
People");

while ($row = odbc_fetch_row($result))
{
for ($i=0; $i<odbc_num_fields($result);$i++)
echo $row[$i] . " ";

echo "\n";
}

odbc_close($connection);
?>
</pre>
</body>
</html>
I got an error msg
Notice: Undefined variable: result in C:\Apache2\htdocs\test3.php on
line 14

Warning: odbc_fetch_row(): supplied argument is not a valid ODBC
result resource in C:\Apache2\htdocs\test3.php on line 14

thank in adv

#2 July 17th, 2005, 01:30 PM

that's because you never defined the variable $result that you are
sending to the odbc_fetch_row function. try changing it to this:

while ($row = odbc_fetch_row($query))

#3 July 17th, 2005, 01:30 PM

"mattvenables" <mattvenables@gmail.com> wrote in message
news:1118146126.870262.314520@g14g2000cwa.googlegr oups.com...[color=blue]
> that's because you never defined the variable $result that you are
> sending to the odbc_fetch_row function. try changing it to this:
>
> while ($row = odbc_fetch_row($query))
>[/color]

or:

$result = odbc_exec($connection, "SELECT * FROM
People");

since '$result' is used twice (it's also in the loop at "for ($i=0;
$i<odbc_num_fields($result);$i++)" )

please help for beginner(php + ms access)

Popular Articles

What is Bytes?