How do I display SQL query results in a repeating table?

Hi all,

This is my first post here, but i've lurked for a while.

I'm working on a website but have come across a major stumbling block in the code:

I've managed to structure the search query but have 2 problems:

I dont know how to code the results into the table, and make the table repeat itself 5 times per page (and recognise it needs a new page)

And I cant test the search query because i cant get the results to display.

If any one could answer 1 or more of these problems and/or correct any error's i've made I'd jump for joy, as i feel i've been fumbling in the dark for the last week or so.

Here's my code so far:

Expand|Select|Wrap|Line Numbers

 
$connection = mysql_connect($hostname, $username, $password);

    if (!$connection) {

       die("A connection to the server could not be established");

    }

    //remember to select the database!

    mysql_select_db($database) or die("Database could not be selected!");
 
    //get the values from the form

    $MerchantType = $_POST["MerchantName"];

    $County = $_POST["County"];
 
    // rows to return

$limit=10; 
 
// Build SQL Query  

$query = "SELECT * FROM Testtable where County = '$county'  

  ORDER BY MerchantType"; // EDIT HERE and specify your table and field names for the SQL query
 
 $numresults=mysql_query($query);

 $numrows=mysql_num_rows($numresults);

?>
 
<?php

echo "

<html><body><table>

<table border="1" bordercolor="#FFCC00" style="background-color:#FFFFFF" width="800" cellpadding="3" cellspacing="3">

<tr>

<td width="200" align="left" rowspan=5>Image</td>

</tr>

<tr>

<td width="573" align="left">Name:</td>

</tr>

<tr>

<td height="27" align="left">Telephone:</td>

</tr>

<tr>

<td height="27" align="left">Website:</td>

</tr>

<tr>

<td height="54" align="left">Description:</td>

</tr>

</table>
 
</html></body></table>;

?>

Thanks,
Sam

Nov 25 '09 #1

Subscribe Post Reply

✓ answered by Alien

Why not do a while statement with mysql_fetch_array( ) ?

Expand|Select|Wrap|Line Numbers

 
$counter = 1;

$maxRows = 5;

$query1 = "# SELECT * FROM Testtable where County = '$county'  

#   ORDER BY MerchantType";

<table>

while($counter < $maxRows)

{

    $row_details = mysql_fetch_array($query1)
 
// each $row_details will have a row from the table, just output it onto a table.

     // $row_details['col1'] will output the which you need to put in <td></td>. 

}    

</table>

So you get first 5 rows this way. Do a bit of more programmiing using sessions to alter value of $counter and $maxRows to get your remaining tables.

4811

ak1dnar

1,584

Expert 1GB

Why don't you first have a look on the table pagination tutorials here.

Nov 26 '09 #2

Alien

Why not do a while statement with mysql_fetch_array( ) ?

Expand|Select|Wrap|Line Numbers

 
$counter = 1;

$maxRows = 5;

$query1 = "# SELECT * FROM Testtable where County = '$county'  

#   ORDER BY MerchantType";

<table>

while($counter < $maxRows)

{

    $row_details = mysql_fetch_array($query1)
 
// each $row_details will have a row from the table, just output it onto a table.

     // $row_details['col1'] will output the which you need to put in <td></td>. 

}    

</table>

So you get first 5 rows this way. Do a bit of more programmiing using sessions to alter value of $counter and $maxRows to get your remaining tables.

Nov 26 '09 #3

DigitalWallfare

Thank you both so, so much for your help. I apologise for asking such a basic question.

I went to bed dreading this morning and another day of coding, now i'm able hit it head on.

Thanks again,

Sam

Nov 26 '09 #4

Similar topics

Off-by-one error in display

by: erica | last post by:

Hi, I am currently writing PHP code for some polling software. When someone votes, it stores their IP address in the database. From then on, they cannot vote in that particular poll, they only...

PHP

Strange inconsistences when repeating a query more than twice in a row

by: Wescotte | last post by:

Here is a small sample program I wrote in PHP (running off Apache 1.3.31 w/ PHP 5.0.1) to help illustrates problem I'm having. The data base is using DB2 V5R3M0. The client is WinXP machine using...

PHP

Using results of query in a query

by: Stan | last post by:

Hello all, I'm looking for some hints as to how to use the results of a query in another query. I assume I'm 'thinking' wrong in how to solve this, so I'm hoping someone can clobber me and send...

Microsoft SQL Server

Use multiple queries to display information on a form

by: matthewemiclea | last post by:

I am trying to display information in Access on a form that takes information from many different queries and puts them together on a spreadsheet or chart. Some specific info: The information I...

Microsoft Access / VBA

help with a simple query

by: jim Bob | last post by:

Hi, Can someone help with a simple query? I have a table with the following. Firstname Lastname InterviewerID1 InterviewerID2 InterviewerID3 ...

Microsoft Access / VBA

SQL Query and Display Problem

by: PHPBABY3 | last post by:

Hi, 1. I have two SQL tables. I will call them employees and departments: EMP: LAST_NAME, FIRST_NAME, DEPTNM DEPT: NUM, NAME Input: text string FIND Output: the LAST_NAME, FIRST_NAME...

PHP

Crosstab Query to Display Zero

by: bruce24444 | last post by:

What I have is a database which tracks assigned files to a certain people which is generated by a form and then recorded into a table. Table are as follows “Staff” “Loss_Type” and...

Microsoft Access / VBA

Crosstab Query to display all possibilities, even if zero

by: bruce24444 | last post by:

First of all I'm new to the forum and am working on my first database. So far I think I've done not too bad but have hit a stumbling block for which I'm not sure how to get around. What I have is...

Microsoft Access / VBA

Display checkboxes in Query for boolean

by: Yitzak | last post by:

Have a query that is arregated into crosstab query, it is working correctly. select Yes as selected from tblname or select true as selected from tblname Produces -1 ( vba value of True) in...

Microsoft Access / VBA

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

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

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

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

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

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