Re: [PHP-DB] simple issue
by John Comerford other posts by this author
Nov 21 2006 9:55PM messages near this date
Re: [PHP-DB] simple issue
|
Re: [PHP-DB] simple issue
I'm pretty new to this stuff myself but try this:
while ($row = $result-> fetch_array())
{
$compname=$row["CompanyName"];
$conname=$row["ContactName"];
echo "<tr> <td>$compname</td>";
echo "<td> $conname</td></tr>";
}
Chris Carter wrote:
> 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
> >
> >
> >
> >
>
>
Thread:
Chris Carter
John Comerford
Ankur Dave
Chris
Chris Carter
Jeffrey
Chris Carter
Chris
John Comerford
Chris
|
