code not working

232 100+

i hav 2 tables
1 town containing 338 data
2 address containing 500 data
i want to display town then related address
then again town then related address
and so on
but my code not working
kindly help

Expand|Select|Wrap|Line Numbers

 <?php

    session_start();   
 
?>

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

   <title></title>

   <meta name="generator" content="Microsoft FrontPage 5.0" />

   <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

   <meta name="description" content="" />

   <meta name="keywords" content="" />

   <meta name="author" content="" />

<link rel="stylesheet" href="../include/style.css" type="text/css" />

</head>

<body bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
 
<?php require("../include/header.php"); ?>

<?php require("../include/left.php"); ?>
 
 <div class="heading"> 

    welcome all

   </div>

     <div class="text"> 

    <?php

 $sql2 = mysql_query("select * from town");

 //echo  $sql2;

 //exit();
 
   if(!$sql2) { echo mysql_error();}
 
   while($rs = mysql_fetch_array($sql2))

   {

   $town=$rs[0];

   $q="select * from institute where address like '%".$town."%' ";

   //echo $town;

   //echo  $q;

   //exit();

   $sql3 = mysql_query($q);
 
   if(!$sql3) { echo mysql_error();}
 
   while($rs1 = mysql_fetch_array($sql3))

   {
 
   ?>
 
  <table width='93%' border='0' align='center' cellpadding="0" cellspacing="0" bordercolor="#000066" >
 
      <tr align="center"> 

        <td colspan="2" bgcolor="#CC3333" class="text1"><strong>Centre 

          Details</strong></td>

      </tr>

      <tr> 

        <td width="30%" valign="top" class="text1"><strong> Town</strong></td>
 
      <td width="70%" valign="top"><?php echo $town;?></td>

      </tr>
 
      <tr> 

        <td  valign="top" class="text1"><strong> state</strong></td>

        <td valign="top"> <?php echo $rs1[state];?> </td>

      </tr>

      <tr> 
 
        <td  valign="top" class="text1"><strong> Centre</strong></td>

        <td valign="top"> <?php echo $rs1[address];?> </td>

      </tr>

      </table>

    <?php  }

}  ?>
 
  <p align="center">&nbsp; </p>

</div>
 
<?php require("../include/right.php"); ?><?php require("../include/footer.php"); ?>
 
</body>

</html>

Dec 7 '09 #1

Subscribe Post Reply

1345

code green

1,726

Expert 1GB

Come on kkshansid.
You have made enough posts to know that "not working" is utterly meaningless.

Dec 7 '09 #2

kkshansid

232

100+

yes i know but i really cant find error

Dec 7 '09 #3

Similar topics

171

Code Behind vs not

by: tshad | last post by:

I am just trying to decide whether to split my code and uses code behind. I did it with one of my pages and found it was quite a bit of trouble. I know that most people (and books and articles)...

ASP.NET

Design flow for Code-behind

by: tshad | last post by:

Many (if not most) have said that code-behind is best if working in teams - which does seem logical. How do you deal with the flow of the work? I have someone who is good at designing, but...

ASP.NET

my code to prove working set larger than virtual bytes

by: George2 | last post by:

Hello everyone, From the definition of working set, it is a subset of virtual pages resident in physical memory -- from book Windows Internals. It means working set could not be larger than...

C / C++

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA