I'm pretty new to this stuff myself but try this:

while ($row = $result->fetch_array())
 echo "<tr><td>$compname</td>";
 echo "<td>$conname</td></tr>";

Chris Carter wrote:
my code:



@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM phpbb_banlist";

if (!$result)
  {exit("Error in SQL");}
echo "<table><tr>";
echo "<th>Companyname</th>";
echo "<th>Contactname</th></tr>";
while (odbc_fetch_row($result))
  echo "<tr><td>$compname</td>";
  echo "<td>$conname</td></tr>";
echo "</table>";


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

chris smith-9 wrote:
Chris Carter wrote:

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
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

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to