my code:
<html>
<body>
<?
$username="chris";
$password="carter";
$database="chris_phpb1";
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM phpbb_banlist";
$result=mysql_query($query);
if (!$result)
{exit("Error in SQL");}
echo "<table><tr>";
echo "<th>Companyname</th>";
echo "<th>Contactname</th></tr>";
while (odbc_fetch_row($result))
{
$compname=odbc_result($result,"CompanyName");
$conname=odbc_result($result,"ContactName");
echo "<tr><td>$compname</td>";
echo "<td>$conname</td></tr>";
}
odbc_close($conn);
echo "</table>";
?>
</body>
</html>
My error:
Fatal error: Call to undefined function: odbc_fetch_row() in
/home/chandan/public_html/deb.php on line 19
Companyname Contactname
Also .. I am trying this live on cPanel compiler coz I could not install the
PHP thing on my localhost. I have apache-tomcat-5.5.17 which works perfectly
with jsp files but I do not understand what does it take to run a php using
apache.
chris smith-9 wrote:
>
> Chris Carter wrote:
>> Hi,
>>
>> I am new to PHP, just trying a peace of code to access mySQL database to
>> fetch and show result on web page. But getting errors. Can you help me
>> with
>> this code please. Or if you have a very basic code where in I can do some
>> insertion in the database.
>
> There are hundreds of mysql + php tutorials on the 'net - do a search in
> your preferred search engine.
>
> If you *still* can't work it out post a sample of the code you're trying
> to use and the errors you get.
>
> --
> Postgresql & php tutorials
> http://www.designmagick.com/
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
--
View this message in context: http://www.nabble.com/simple-issue-tf2683559.html#a7485434
Sent from the Php - Database mailing list archive at Nabble.com.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
