₦airaland Forum

oh yeah forgot to mention south america.

sometimes we forget where we are coming from and where we are going to. Yes in South East Asia there are countries as such like Nigeria with not only tirbal and religious diversity but race diversity and surely democracy is at its definition by the books of law.

terrorism 101. google it.

GenBuhari:
@dell_net
shame on you!

Ok Mr. General we all know no body likes the truth thats why you can't make it. And sorry he kicked your butt off the chair. For as far as I can remember IBB regime was gravy a lot of people got rich and you could still fill your tank up with N20. I want the best for Nigeria but we cant find it so what the heck we might as well turn loose. If you cant beat them join them.

I kinda like IBB I can't think of anybody better to rule Nigeria. It is just like father like son kind of a thing. The citizens are corrupt, the ruler is corrupt equals to perfect match.

two examples. one in the tag and the other in a function. all should work across browsers.

<div id="biglink1" onmousemove="this.style.backgroundColor='FFFF99'" onmouseout="testfunction(this)" style="position:absolute;">blah blah blah</div>

<script type="">
function testfunction(Obj)
    {
    Obj.style.backgroundColor = 'FFFFFF';
    }
</script>

I could develop a custom solution for you.

it is just a simple as reading the sms you sent and then sending back the recharge card to you. For example:

assuming the format of the sms message is MTN 1500 1 password. There will be an application at the other end to read this message and probably check against a database to verify your password and phone number and then reply back with recharge card details. I think MTN has quite a few applications for sending recharge cards which can be integrated into a system.

you can use vc++ 2008 express edition it is free. http://www.microsoft.com/express/downloads/#2008-Visual-CPP

it is ok now. the problem is from the telephone number if the telephone number is empty the script will not output and just continue with the while loop. As you can see in the table Romi's number is empty. I included a snippet at line 489 you can change the string "N/A" to an approtiate value.

I can see a space before Sheryl van der Hoef's table. email me the cp details let me take a look at it.

you need to check with the database if those field contain values. How about the last one I sent? it should echo the first 2 columns of each row. If you can create a temporary login for me to your mysql server I can check from here using the script.

zillonnair were you able to get the script to work?

wus:
how can i configure mysql to work with php script i need the procedure and code to create mysql database for creating form ain php script and linking it to mysql database using dreamweaver platform.i will be grateful

you configure php to work with mysql, by default mysql is enabled in php I think except for some windows version of php I can't remember which but should be 5 or so. for more info on dreamweaver and php visit http://www.adobe.com/devnet/dreamweaver/php.html

a fucking bot ai?

I think somewhere from line 449 the problem starts you might want to go through from there and check the variables being returned. Let me know how it works out. I will be on later.

I sent it to your box zillonnair.


@ moderators if you are the one blocking our post then you need to check your policy again. we are doing this for educational purpose so that the next person having such problem could easily find help. 9ja all the way.

ay it disappeared

I am sending it your box. damn

there we go

[php]
<?php

include ("include/db_connect.php";

include ("include/path.php";



$pk = $_GET['pk'];



$sql = "select * from listings_categories where pk = \"$pk\"";

$sql_result = mysql_query($sql, $connection) or die("Query 1 failed : " . mysql_error());

$row = mysql_fetch_array($sql_result, MYSQL_BOTH);

$title = $row["title"];

$title_uc = strtoupper($title);

$meta_title = $row["meta_title"];

$meta_description = $row["meta_description"];

$meta_keywords = $row["meta_keywords"];



$topad1 = $row["topad1"];

if ($topad1 == "" $topad1 = "bansplit.gif";



$topad1_url = $row["topad1_url"];



$topad2 = $row["topad2"];

if ($topad2 == "" $topad2 = "bansplit.gif";



$topad2_url = $row["topad2_url"];



$bottomad1 = $row["bottomad1"];

if ($bottomad1 == "" $bottomad1 = "bansplit.gif";



$bottomad1_url = $row["bottomad1_url"];



$bottomad2 = $row["bottomad2"];

if ($bottomad2 == "" $bottomad2 = "bansplit.gif";



$bottomad2_url = $row["bottomad2_url"];



$leftad1 = $row["leftad1"];

if ($leftad1 == "" $leftad1 = "advertc.gif";



$leftad1_url = $row["leftad1_url"];



$leftad2 = $row["leftad2"];

if ($leftad2 == "" $leftad2 = "bannerb.jpg";



$leftad2_url = $row["leftad2_url"];



$rightad1 = $row["rightad1"];

if ($rightad1 == "" $rightad1 = "advert.jpg";



$rightad1_url = $row["rightad1_url"];



$rightad2 = $row["rightad2"];

if ($rightad2 == "" $rightad2 = "advert.jpg";



$rightad2_url = $row["rightad2_url"];



$rightad3 = $row["rightad3"];

if ($rightad3 == "" $rightad3 = "advert.jpg";



$rightad3_url = $row["rightad3_url"];



$rightad4 = $row["rightad4"];

if ($rightad4 == "" $rightad4 = "advert.jpg";



$rightad4_url = $row["rightad4_url"];



$rightad5 = $row["rightad5"];

if ($rightad5 == "" $rightad5 = "advert.jpg";



$rightad5_url = $row["rightad5_url"];



$rightad6 = $row["rightad6"];

if ($rightad6 == "" $rightad6 = "advert.jpg";



$rightad6_url = $row["rightad6_url"];



$headerad1 = $row["headerad1"];

if ($headerad1 == "" $headerad1 = "advertpic.gif";



$headerad1_url = $row["headerad1_url"];

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<script type="text/javascript" src="menu.js"></script>

<LINK HREF="default.css" TYPE="text/css" REL="stylesheet">

<title><?php echo $meta_title?></title>

<META NAME="TITLE" CONTENT="<?php echo $meta_title?>">

<META NAME="DESCRIPTION" CONTENT="<?php echo $meta_description?>">

<META NAME="KEYWORDS" CONTENT="<?php echo $meta_keywords?>">

</head>



<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">

<table width="100%" border="0" cellpadding="0" cellspacing="-1" background="images/topbg1.jpg">

<tr>

<td height="134">&nbsp;</td>

<td width="559" valign="top" background="images/top2bg.jpg"><div align="right"><span class="logo"><img src="topimage.jpg" width="559" height="80" border="0" alt="" /></span></div>

<div align="right"></div></td>

</tr>

</table>

<table width="100%" border="0" cellspacing="0" cellpadding="-1">

<tr>

<td width="160" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="5">

<tr>

<td><div align="center">

<?php

if ($leftad1_url <> "" {

?>

<a href="<?php echo $leftad1_url?>">

<?php

}

?>

<img src="listings/<?php echo $leftad1?>" alt="" border="0" />

<?php

if ($leftad1_url <> "" {

?>

</a>

<?php

}

?>

</div></td>

</tr>

<tr>

<td>&nbsp;</td>

</tr>

<tr>

<td>

<?php

include ("menu.php";

?> </td>

</tr>

<tr>

<td>&nbsp;</td>

</tr>

<tr>

<td><div align="center">

<?php

if ($leftad2_url <> "" {

?>

<a href="<?php echo $leftad2_url?>">

<?php

}

?>

<img src="listings/<?php echo $leftad2?>" alt="" border="0" />

<?php

if ($leftad2_url <> "" {

?>

</a>

<?php

}

?>

</div></td>

</tr>

<tr>

<td>&nbsp;</td>

</tr>

</table></td>

<td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="5">

<tr>

<td><table width="300" border="0" align="center" cellpadding="5" cellspacing="0">

<tr>

<td><div align="center">

<?php

if ($topad1_url <> "" {

?>

<a href="<?php echo $topad1_url?>">

<?php

}

?>

<img src="listings/<?php echo $topad1?>" alt="" border="0" />

<?php

if ($topad1_url <> "" {

?>

</a>

<?php

}

?>

</div></td>

<td><div align="center">

<?php

if ($topad2_url <> "" {

?>

<a href="<?php echo $topad2_url?>">

<?php

}

?>

<img src="listings/<?php echo $topad2?>" alt="" border="0" />

<?php

if ($topad2_url <> "" {

?>

</a>

<?php

}

?>

</div></td>

</tr>

</table></td>

</tr>

<tr>

<td><table width="100%" border="0" cellspacing="0" cellpadding="-1">

<tr>

<td width="76%" valign="top"><h1><?php echo $title_uc?></h1></td>

<td width="24%"><div align="center">

<?php

if ($headerad1_url <> "" {

?>

<a href="<?php echo $headerad1_url?>">

<?php

}

?>

<img src="listings/<?php echo $headerad1?>" alt="" border="0" />

<?php

if ($headerad1_url <> "" {

?>

</a>

<?php

}

?>

</div></td>

</tr>

</table></td>

</tr>

<tr>

<td>

<?php

$sql = "select * from listings_areas";

$sql_result = mysql_query($sql, $connection) or die("Query 1 failed : " . mysql_error());

while ($row = mysql_fetch_array($sql_result, MYSQL_BOTH)) {

$area_id = $row["area_id"];

$area_name = $row["area_name"];

?>

<?php //body listings start here ?>

<h2><?php echo $area_name?></h2><br>

<?php

$sql1 = "select * from listings, listings_2_categories where listings.dr_area = \"$area_id\" and listings_2_categories.listing_id = listings.dr_id

and listings_2_categories.catid = \"$pk\" order by dr_name " ;

//echo "$sql1<br>";

$sql_result1 = mysql_query($sql1, $connection) or die("Query 1 failed : " . mysql_error());

while ($row1 = mysql_fetch_array($sql_result1, MYSQL_BOTH)) {

$dr_title = $row1["dr_title"];

$dr_name = $row1["dr_name"];

$dr_business = $row1["dr_business"];

$dr_address = nl2br(trim($row1["dr_address"]));

$dr_telnum = $row1["dr_telnum"];

$dr_faxnum = $row1["dr_faxnum"];

$dr_cellnum = $row1["dr_cellnum"];

$dr_ahnum = $row1["dr_ahnum"];

$dr_email = $row1["dr_email"];

$dr_website = $row1["dr_website"];

$dr_officehours = nl2br(rtrim($row1["dr_officehours"]));

$dr_notes = nl2br(trim($row1["dr_notes"]));

$dr_focus = nl2br(trim($row1["dr_focus"]));

$dr_logo = $row1["dr_logo"];

$dr_qualification = $row1["dr_qualification"];

?>
<?php if ($dr_telnum == ""{ ?>

<table width="90%" border="0" align="center" cellpadding="3" cellspacing="0" bordercolor="#000000">

<tr>

<td width="12%" bordercolor="#FFFFFF">&nbsp;</td>
<td width="88%" valign="top" bordercolor="#FFFFFF">

<?php

if ($dr_logo <> "" {

?>

<div align="center"><img src="listings/<?php echo $dr_logo?>" /></div>

<?php

}

?>

&nbsp;

</td>

</tr>

</table>

<?php } else { ?>

<table width="90%" border="1" align="center" cellpadding="3" cellspacing="0" bordercolor="#000000">

<tr>

<td width="80%" bordercolor="#FFFFFF"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">

<tr>

<td width="23%"><strong>Name:</strong></td>

<td width="77%"><strong><?php echo $dr_title?> <?php echo $dr_name?> <?php if ($dr_business <> "" echo " :: $dr_business";?>


<?php

if ($dr_qualification <> "" {

?>

<?php echo $dr_qualification?>

<?php

}

?>

</strong></td>

</tr>

<?php

if ($dr_address <> "" {

?>

<tr>

<td valign="top">Address:</td>

<td><?php echo $dr_address?></td>

</tr>

<?php

}

if ($dr_telnum <> "" {

?>

<tr>

<td>Telephone:</td>

<td><?php echo $dr_telnum?></td>

</tr>

<?php

}

if ($dr_faxnum <> "" {

?>

<tr>

<td>Fax:</td>

<td><?php echo $dr_faxnum?></td>

</tr>

<?php

}

if ($dr_cellnum <> "" {

?>

<tr>

<td>Cellphone:</td>

<td><?php echo $dr_cellnum?></td>

</tr>

<?php

}

if ($dr_ahnum <> "" {

?>

<tr>

<td>After Hours No:</td>

<td><?php echo $dr_ahnum?></td>

</tr>

<?php

}

if ($dr_email <> "" {

?>

<tr>

<td>E-mail:</td>

<td><a href="mailto:<?php echo $dr_email?>"><?php echo $dr_email?></a></td>

</tr>

<?php

}

if ($dr_website <> "" {

?>

<tr>

<td>Website:</td>

<td><?php echo $dr_website?></td>

</tr>

<?php

}

if ($dr_officehours <> "" {

?>

<tr>

<td valign="top">Office Hours:</td>

<td><?php echo $dr_officehours?></td>

</tr>

<?php

}

if ($dr_notes <> "" {

?>

<tr>

<td valign="top">Notes / Special Features:</td>

<td><?php echo $dr_notes?></td>

</tr>

<?php

}

if ($dr_focus <> "" {

?>

<tr>

<td valign="top">Focus Areas:</td>

<td><?php echo $dr_focus?></td>

</tr>

<?php

}

?>

</table></td>

<td width="20%" valign="top" bordercolor="#FFFFFF">

<?php

if ($dr_logo <> "" {

?>

<div align="center"><img src="listings/<?php echo $dr_logo?>" /></div>

<?php

}

?>

&nbsp;

</td>

</tr>

</table>







<?php } ?>

<?php //body listings ends here ?>

<br>

<?php

}

}



?> </td>

</tr>

<tr>

<td><table width="300" border="0" align="center" cellpadding="5" cellspacing="0">

<tr>

<td><div align="center">

<?php

if ($bottomad1_url <> "" {

?>

<a href="<?php echo $bottomad1_url?>">

<?php

}

?>

<img src="listings/<?php echo $bottomad1?>" alt="" border="0" />

<?php

if ($bottomad1_url <> "" {

?>

</a>

<?php

}

?>

</div></td>

<td><div align="center">

<?php

if ($bottomad2_url <> "" {

?>

<a href="<?php echo $bottomad2_url?>">

<?php

}

?>

<img src="listings/<?php echo $bottomad2?>" alt="" border="0" />

<?php

if ($bottomad2_url <> "" {

?>

</a>

<?php

}

?>

</div></td>

</tr>

</table></td>

</tr>

</table>

</td>

<td width="160" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="5">

<tr>

<td><div align="center">

<?php

if ($rightad1_url <> "" {

?>

<a href="<?php echo $rightad1_url?>">

<?php

}

?>

<img src="listings/<?php echo $rightad1?>" alt="" border="0" />

<?php

if ($rightad1_url <> "" {

?>

</a>

<?php

}

?>

</div></td>

</tr>

<tr>

<td>&nbsp;</td>

</tr>

<tr>

<td><div align="center">

<?php

if ($rightad2_url <> "" {

?>

<a href="<?php echo $rightad2_url?>">

<?php

}

?>

<img src="listings/<?php echo $rightad2?>" alt="" border="0" />

<?php

if ($rightad2_url <> "" {

?>

</a>

<?php

}

?>

</div></td>

</tr>

<tr>

<td>&nbsp;</td>

</tr>

<tr>

<td><div align="center">

<?php

if ($rightad3_url <> "" {

?>

<a href="<?php echo $rightad3_url?>">

<?php

}

?>

<img src="listings/<?php echo $rightad3?>" alt="" border="0" />

<?php

if ($rightad3_url <> "" {

?>

</a>

<?php

}

?>

</div></td>

</tr>

<tr>

<td>&nbsp;</td>

</tr>

<tr>

<td><div align="center">

<?php

if ($rightad4_url <> "" {

?>

<a href="<?php echo $rightad4_url?>">

<?php

}

?>

<img src="listings/<?php echo $rightad4?>" alt="" border="0" />

<?php

if ($rightad4_url <> "" {

?>

</a>

<?php

}

?>

</div></td>

</tr>

<tr>

<td>&nbsp;</td>

</tr>

<tr>

<td><div align="center">

<?php

if ($rightad5_url <> "" {

?>

<a href="<?php echo $rightad1_ur5?>">

<?php

}

?>

<img src="listings/<?php echo $rightad5?>" alt="" border="0" />

<?php

if ($rightad5_url <> "" {

?>

</a>

<?php

}

?>

</div></td>

</tr>

<tr>

<td>&nbsp;</td>

</tr>

<tr>

<td><div align="center">

<?php



?>

<a href="<?php echo $rightad6_url?>">

<?php



?>

<img src="listings/<?php echo $rightad6?>" alt="" border="0" />

<?php



?>

</a>

<?php



?>

</div></td>

</tr>

<tr>

<td>&nbsp;</td>

</tr>

</table></td>

</tr>

</table>

<table width="700" border="0" align="center" cellpadding="5" cellspacing="0">

<tr>

<td>

<div class="center">

<p class="foot">Note: Dear users, prescribing medications online or giving a diagnosis contradicts







medical ethics, which is why Doctors Online can only offer General information's and advise you on what medical professional to consult.</p>

</div>

</td>

</tr>

</table>

<?php

include("footertext.php";

?>

</body>

[/php]

I corrected some things I want to post back but I cant.

this is site need some serious tuning.

lets try this

<?php

include ("include/db_connect.php";

include ("include/path.php";



$pk = $_GET['pk'];



$sql = "select * from listings_categories where pk = \"$pk\"";

$sql_result = mysql_query($sql, $connection) or die("Query 1 failed : " . mysql_error());  

$row = mysql_fetch_array($sql_result, MYSQL_BOTH);

$title = $row["title"];

$title_uc = strtoupper($title);

$meta_title = $row["meta_title"];

$meta_description = $row["meta_description"];

$meta_keywords = $row["meta_keywords"];



$topad1 = $row["topad1"];

if ($topad1 == "" $topad1 = "bansplit.gif";



$topad1_url = $row["topad1_url"];



$topad2 = $row["topad2"];

if ($topad2 == "" $topad2 = "bansplit.gif";



$topad2_url = $row["topad2_url"];



$bottomad1 = $row["bottomad1"];

if ($bottomad1 == "" $bottomad1 = "bansplit.gif";



$bottomad1_url = $row["bottomad1_url"];



$bottomad2 = $row["bottomad2"];

if ($bottomad2 == "" $bottomad2 = "bansplit.gif";



$bottomad2_url = $row["bottomad2_url"];



$leftad1 = $row["leftad1"];

if ($leftad1 == "" $leftad1 = "advertc.gif";



$leftad1_url = $row["leftad1_url"];



$leftad2 = $row["leftad2"];

if ($leftad2 == "" $leftad2 = "bannerb.jpg";



$leftad2_url = $row["leftad2_url"];



$rightad1 = $row["rightad1"];

if ($rightad1 == "" $rightad1 = "advert.jpg";



$rightad1_url = $row["rightad1_url"];



$rightad2 = $row["rightad2"];

if ($rightad2 == "" $rightad2 = "advert.jpg";



$rightad2_url = $row["rightad2_url"];



$rightad3 = $row["rightad3"];

if ($rightad3 == "" $rightad3 = "advert.jpg";



$rightad3_url = $row["rightad3_url"];



$rightad4 = $row["rightad4"];

if ($rightad4 == "" $rightad4 = "advert.jpg";



$rightad4_url = $row["rightad4_url"];



$rightad5 = $row["rightad5"];

if ($rightad5 == "" $rightad5 = "advert.jpg";



$rightad5_url = $row["rightad5_url"];



$rightad6 = $row["rightad6"];

if ($rightad6 == "" $rightad6 = "advert.jpg";



$rightad6_url = $row["rightad6_url"];



$headerad1 = $row["headerad1"];

if ($headerad1 == "" $headerad1 = "advertpic.gif";



$headerad1_url = $row["headerad1_url"];

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<script type="text/javascript" src="menu.js"></script>

<LINK HREF="default.css" TYPE="text/css" REL="stylesheet">

<title><?php echo $meta_title?></title>

<META NAME="TITLE" CONTENT="<?php echo $meta_title?>">

<META NAME="DESCRIPTION" CONTENT="<?php echo $meta_description?>">

<META NAME="KEYWORDS" CONTENT="<?php echo $meta_keywords?>">

</head>



<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">

<table width="100%" border="0" cellpadding="0" cellspacing="-1" background="images/topbg1.jpg">

  <tr>

    <td height="134">&nbsp;</td>

    <td width="559" valign="top" background="images/top2bg.jpg"><div align="right"><span class="logo"><img src="topimage.jpg" width="559" height="80" border="0" alt="" /></span></div>

        <div align="right"></div></td>

  </tr>

</table>

<table width="100%" border="0" cellspacing="0" cellpadding="-1">

  <tr>

    <td width="160" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="5">

      <tr>

        <td><div align="center">

<?php

if ($leftad1_url <> "" {

?>        

        <a href="<?php echo $leftad1_url?>">

<?php

}

?>        

        <img src="listings/<?php echo $leftad1?>" alt="" border="0" />

<?php

if ($leftad1_url <> "" {

?>        

        </a>

<?php

}

?>        

        </div></td>

        </tr>

      <tr>

        <td>&nbsp;</td>

      </tr>

      <tr>

        <td>

<?php

include ("menu.php";

?>        </td>

      </tr>

      <tr>

        <td>&nbsp;</td>

      </tr>

      <tr>

        <td><div align="center">

<?php

if ($leftad2_url <> "" {

?>        

        <a href="<?php echo $leftad2_url?>">

<?php

}

?>        

        <img src="listings/<?php echo $leftad2?>" alt="" border="0" />

<?php

if ($leftad2_url <> "" {

?>        

        </a>

<?php

}

?>        

        </div></td>

      </tr>

      <tr>

        <td>&nbsp;</td>

      </tr>

    </table></td>

    <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="5">

      <tr>

        <td><table width="300" border="0" align="center" cellpadding="5" cellspacing="0">

          <tr>

            <td><div align="center">

                <?php

if ($topad1_url <> "" {

?>

                <a href="<?php echo $topad1_url?>">

                <?php

}

?>

                <img src="listings/<?php echo $topad1?>" alt="" border="0" />

                <?php

if ($topad1_url <> "" {

?>

                </a>

                <?php

}

?>

            </div></td>

            <td><div align="center">

                <?php

if ($topad2_url <> "" {

?>

                <a href="<?php echo $topad2_url?>">

                <?php

}

?>

                <img src="listings/<?php echo $topad2?>" alt="" border="0" />

                <?php

if ($topad2_url <> "" {

?>

                </a>

                <?php

}

?>

            </div></td>

          </tr>

        </table></td>

        </tr>

      <tr>

        <td><table width="100%" border="0" cellspacing="0" cellpadding="-1">

          <tr>

            <td width="76%" valign="top"><h1><?php echo $title_uc?></h1></td>

            <td width="24%"><div align="center">

<?php

if ($headerad1_url <> "" {

?>

              <a href="<?php echo $headerad1_url?>">

              <?php

}

?>

              <img src="listings/<?php echo $headerad1?>" alt="" border="0" />

              <?php

if ($headerad1_url <> "" {

?>

              </a>

              <?php

}

?>

            </div></td>

            </tr>

        </table></td>

      </tr>

      <tr>

        <td>

<?php

$sql = "select * from listings_areas";

$sql_result = mysql_query($sql, $connection) or die("Query 1 failed : " . mysql_error());  

while ($row = mysql_fetch_array($sql_result, MYSQL_BOTH)) {

  $area_id = $row["area_id"];

  $area_name = $row["area_name"];

?>        

<?php //body listings start here ?> 

        <h2><?php echo $area_name?></h2><br>

<?php

  $sql1 = "select * from listings, listings_2_categories where listings.dr_area = \"$area_id\" and listings_2_categories.listing_id = listings.dr_id 

    and listings_2_categories.catid = \"$pk\" order by dr_name " ;

  //echo "$sql1<br>"; 

  $sql_result1 = mysql_query($sql1, $connection) or die("Query 1 failed : " . mysql_error());  

  while ($row1 = mysql_fetch_array($sql_result1, MYSQL_BOTH)) {

    $dr_title = $row1["dr_title"];

    $dr_name = $row1["dr_name"];

    $dr_business = $row1["dr_business"];

    $dr_address = nl2br(trim($row1["dr_address"]));

    $dr_telnum = $row1["dr_telnum"];

    $dr_faxnum = $row1["dr_faxnum"];

    $dr_cellnum = $row1["dr_cellnum"];

    $dr_ahnum = $row1["dr_ahnum"];

    $dr_email = $row1["dr_email"];

    $dr_website = $row1["dr_website"];

    $dr_officehours = nl2br(rtrim($row1["dr_officehours"]));

    $dr_notes = nl2br(trim($row1["dr_notes"]));

    $dr_focus = nl2br(trim($row1["dr_focus"]));

    $dr_logo = $row1["dr_logo"];

    $dr_qualification = $row1["dr_qualification"];

?>
<?php if ($dr_telnum  == ""{  ?>

        <table width="90%" border="0" align="center" cellpadding="3" cellspacing="0" bordercolor="#000000">

          <tr>

            <td width="12%" bordercolor="#FFFFFF">&nbsp;</td>
            <td width="88%" valign="top" bordercolor="#FFFFFF">

<?php

if ($dr_logo <> "" {

?>            

            <div align="center"><img src="listings/<?php echo $dr_logo?>" /></div>

<?php

}

?>

            &nbsp;

            </td>

            </tr>

        </table>
		
		<?php }   else { ?>
		
		<table width="90%" border="1" align="center" cellpadding="3" cellspacing="0" bordercolor="#000000">

          <tr>

            <td width="80%" bordercolor="#FFFFFF"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">

              <tr>

                <td width="23%"><strong>Name:</strong></td>

                <td width="77%"><strong><?php echo $dr_title?> <?php echo $dr_name?> <?php if ($dr_business <> "" echo " :: $dr_business";?>


<?php

if ($dr_qualification <> "" {

?>                  

                  <?php echo $dr_qualification?>

<?php

}

?>

                  </strong></td>

              </tr>

<?php

if ($dr_address <> "" {

?>                  

              <tr>

                <td valign="top">Address:</td>

                <td><?php echo $dr_address?></td>

              </tr>

<?php

}

if ($dr_telnum <> "" {

?>

              <tr>

                <td>Telephone:</td>

                <td><?php echo $dr_telnum?></td>

              </tr>

<?php

}

if ($dr_faxnum <> "" {

?>

              <tr>

                <td>Fax:</td>

                <td><?php echo $dr_faxnum?></td>

              </tr>

<?php

}

if ($dr_cellnum <> "" {

?>

              <tr>

                <td>Cellphone:</td>

                <td><?php echo $dr_cellnum?></td>

              </tr>

<?php

}

if ($dr_ahnum <> "" {

?>

              <tr>

                <td>After Hours No:</td>

                <td><?php echo $dr_ahnum?></td>

              </tr>

<?php

}

if ($dr_email <> "" {

?>

              <tr>

                <td>E-mail:</td>

                <td><a href="mailto:<?php echo $dr_email?>"><?php echo $dr_email?></a></td>

              </tr>

<?php

}

if ($dr_website <> "" {

?>

              <tr>

                <td>Website:</td>

                <td><?php echo $dr_website?></td>

              </tr>

<?php

}

if ($dr_officehours <> "" {

?>

              <tr>

                <td valign="top">Office Hours:</td>

                <td><?php echo $dr_officehours?></td>

              </tr>

<?php

}

if ($dr_notes <> "" {

?>

              <tr>

                <td valign="top">Notes / Special Features:</td>

                <td><?php echo $dr_notes?></td>

              </tr>

<?php

}

if ($dr_focus <> "" {

?>

              <tr>

                <td valign="top">Focus Areas:</td>

                <td><?php echo $dr_focus?></td>

              </tr>

<?php

}

?>

            </table></td>

            <td width="20%" valign="top" bordercolor="#FFFFFF">

<?php

if ($dr_logo <> "" {

?>            

            <div align="center"><img src="listings/<?php echo $dr_logo?>" /></div>

<?php

}

?>

            &nbsp;

            </td>

            </tr>

        </table>
		
		
		
		
		
		
		
							<?php }  ?> 

		<?php //body listings ends here ?> 

        <br>

<?php

  }

}



?>        </td>

      </tr>

      <tr>

        <td><table width="300" border="0" align="center" cellpadding="5" cellspacing="0">

          <tr>

            <td><div align="center">

<?php

if ($bottomad1_url <> "" {

?>

                <a href="<?php echo $bottomad1_url?>">

<?php

}

?>

                <img src="listings/<?php echo $bottomad1?>" alt="" border="0" />

<?php

if ($bottomad1_url <> "" {

?>

                </a>

<?php

}

?>

            </div></td>

            <td><div align="center">

                <?php

if ($bottomad2_url <> "" {

?>

                <a href="<?php echo $bottomad2_url?>">

<?php

}

?>

                <img src="listings/<?php echo $bottomad2?>" alt="" border="0" />

                <?php

if ($bottomad2_url <> "" {

?>

                </a>

<?php

}

?>

            </div></td>

          </tr>

        </table></td>

      </tr>

    </table>

    </td>

    <td width="160" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="5">

      <tr>

        <td><div align="center">

<?php

if ($rightad1_url <> "" {

?>

        <a href="<?php echo $rightad1_url?>">

<?php

}

?>

        <img src="listings/<?php echo $rightad1?>" alt="" border="0" />

<?php

if ($rightad1_url <> "" {

?>

        </a>

<?php

}

?>

        </div></td>

        </tr>

      <tr>

        <td>&nbsp;</td>

      </tr>

      <tr>

        <td><div align="center">

<?php

if ($rightad2_url <> "" {

?>

        <a href="<?php echo $rightad2_url?>">

<?php

}

?>

        <img src="listings/<?php echo $rightad2?>" alt="" border="0" />

<?php

if ($rightad2_url <> "" {

?>

        </a>

<?php

}

?>

        </div></td>

      </tr>

      <tr>

        <td>&nbsp;</td>

      </tr>

      <tr>

        <td><div align="center">

<?php

if ($rightad3_url <> "" {

?>

        <a href="<?php echo $rightad3_url?>">

<?php

}

?>

        <img src="listings/<?php echo $rightad3?>" alt="" border="0" />

<?php

if ($rightad3_url <> "" {

?>

        </a>

<?php

}

?>

        </div></td>

      </tr>

      <tr>

        <td>&nbsp;</td>

      </tr>

      <tr>

        <td><div align="center">

<?php

if ($rightad4_url <> "" {

?>

        <a href="<?php echo $rightad4_url?>">

<?php

}

?>

        <img src="listings/<?php echo $rightad4?>" alt="" border="0" />

<?php

if ($rightad4_url <> "" {

?>

        </a>

<?php

}

?>

        </div></td>

      </tr>

      <tr>

        <td>&nbsp;</td>

      </tr>

      <tr>

        <td><div align="center">

<?php

if ($rightad5_url <> "" {

?>

        <a href="<?php echo $rightad1_ur5?>">

<?php

}

?>

        <img src="listings/<?php echo $rightad5?>" alt="" border="0" />

<?php

if ($rightad5_url <> "" {

?>

        </a>

<?php

}

?>

        </div></td>

      </tr>

      <tr>

        <td>&nbsp;</td>

      </tr>

      <tr>

        <td><div align="center">

<?php



?>

        <a href="<?php echo $rightad6_url?>">

<?php



?>

        <img src="listings/<?php echo $rightad6?>" alt="" border="0" />

<?php



?>

        </a>

<?php



?>

        </div></td>

      </tr>

      <tr>

        <td>&nbsp;</td>

      </tr>

    </table></td>

  </tr>

</table>

<table width="700" border="0" align="center" cellpadding="5" cellspacing="0">

  <tr>

    <td>

    <div class="center">

	<p class="foot">Note: Dear users, prescribing medications online or giving a diagnosis contradicts 







medical ethics, which is why Doctors Online can only offer General information's and advise you on what medical professional to consult.</p>

	</div>

    </td>

  </tr>

</table>

<?php

include("footertext.php";

?>

</body>

break it into chunks may 80 lines or less per post

all of it.

copy and paste the code here.

also you can put a closing tag before <.

< is refering to the opening tag that is the line containing <?

there should be no < at the line that does the connection.
A closing tag is ?>

check if connection is already open i.e. if $connection = mysql_connect, has already been called if so comment line 451. 451 lines of code thats huge. well not really but for a starter it is.

Here is the code of the form, the first other one list the records from the form to the website.

I am talking about the first one. Are the programs in a single file? you may use this medium to send the contents of the file(s) dont attach the file(s) just copy and paste the contents in the reply box. From the tools menu above the reply box click on the # button and insert the text in between the first code [] and last.

correction:
at line 9 take out one closing parenthesis.

if ($row = mysql_fetch_array($sql_result, MYSQL_ASSOC)) ) // this will fetch the first row only
change to
if ($row = mysql_fetch_array($sql_result, MYSQL_ASSOC)) // this will fetch the first row only

sorry fast fingers.

<?
//$connection = mysql_connect('localhost', 'user', 'password');


$sql = "select * from listings_areas";

$sql_result = mysql_query($sql, $connection) or die("Query 1 failed : " . mysql_error());  

if ($row = mysql_fetch_array($sql_result, MYSQL_ASSOC)) ) // this will fetch the first row only
{
$area_id = $row["area_id"];

$area_name = $row["area_name"];

echo 'this is area_name'.$area_name.'<br>';
mysql_free_result($sql_result);
}
else
{
echo 'unable to get area_id and area_name<br>';
mysql_free_result($sql_result);
exit();
}
$sql1 = "select * from listings, listings_2_categories where listings.dr_area = \"$area_id\" and listings_2_categories.listing_id = listings.dr_id 

    and listings_2_categories.catid = \"$pk\" order by dr_name " ;

  echo "$sql1<br>"; 

  $sql_result1 = mysql_query($sql1, $connection) or die("Query 1 failed : " . mysql_error());  

  while ($row1 = mysql_fetch_array($sql_result1, MYSQL_BOTH)) {
	echo $row[0]." ".$row[1]; //print first 2 columns in each row.
}

// release result and close connection to db.
mysql_free_result($sql_result1);
mysql_close($connection);
?>

ok try this. replace this code with the content of the.php file that sends output to the webbrowser make sure you make a copy before replacing.
uncomment //$connection = mysql_connect('localhost', 'user', 'password'); in the code and put valid values that is the server to connect to, username and password. Let us know if it works.