When printing SQL query, only the first result is not displayed

2 New Member

Hey. I am new to php and am trying to learn. What I'm doing is querying(did I spell this right?) a mySQL database and putting the results into a table on a webpage. I have worked for hours on this and I finally got the answer I was looking for...almost. The problem is that the first result is not displayed.

For example, my table in the database looks like:
Item Number <-- Column Names
Him 5
Fim 20
Kim 8
Lim 12

The results that are printed in the table are:
Fim 20
Kim 8
Lim 12

The number of rows that the SQL returns is 4 so I don't understand why I cannot display all 4 rows in the table. Line 64 is where the while loop starts where I think something is wrong.

What am I doing wrong? PS. There are a lot of commented lines that I couldn't get to work but are there for my reference, I apologize for not taking them out. I may have left something out that I missed.

Edit: No errors. Just the first row in the mysql table is not showing up in the table on the webpage.

Expand|Select|Wrap|Line Numbers

 <?php

$dbname = $_POST["dbname"];

$quantity = $_POST["quantity"];

$itemnumber = $_POST["itemnumber"];
 
include "include/z_db.php";

$sql = sprintf("SELECT * FROM `distributor` WHERE 1", mysql_real_escape_string($itemnumber));

endif;

?>
 
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html><head>

    <style type="text/css"> .tbl1 { background: url('back.jpg'); background-repeat: no-repeat;} </style>

<title>Search</title>

</head> 

<body style="background-color: rgb(255, 255, 255);" link="#cc0000" vlink="#660033">

    <table class="tbl1" border="0" cellpadding="0" cellspacing="0" width="647">

        <tbody>

            <tr>

                <td colspan="4"><img src="single_pixel.gif" border="0" height="1" width="740"/></td>

            </tr>

            <tr valign="top">

                <td height="91" width="60%"><img src="single_pixel.gif" height="200" width="1"/></td>

                <td colspan="3" align="center" height="91" valign="top" width="40%"> </td>

            </tr>

            <tr>

                <td colspan="3"> </td>

            </tr>

            <tr>

                <td colspan="4" valign="top">

        <table border="0" cellspacing="15" width="100%">

            <tbody>

                <tr>

                    <td valign="top" width="8%"><img src="single_pixel.gif" height="1" width="180"/><br />

                        <b>Menu</b>

                        <br />

                        <a href="userare.php">User Area</a><br/>

                        <a href="contact.html">Contact</a><br/>

                        <a href="logout.asp">Logout</a><br/>

                    </td>

                    <td width="92%">

                        <b>Search Results</b><br />

                        <?php

$result = mysql_query($sql) or die(mysql_error());  

$re = mysql_fetch_array($result);
 
$num = mysql_num_rows($result);

echo "$num rows<br />";

if (mysql_num_rows($result) < 1):

    $error[] = "The search term provided {$itemnumber} yielded no results.";

else:

    $results = array(); // the result array

    $i = 1;

    while($row = mysql_fetch_array($result)):
 
//echo $row['itemnumber']. " = " .$row['quantity']. "<br>";
 
// echo "{$i}";

//echo "Column 1 is {$row['itemnumber']} {$row['quantity']}<br>\n";
 
//endif; if change while to if uncomment this line

        $results[] = "<tr><td>{$row['itemnumber']} </td><td>{$row['quantity']}</td></tr>";

        $i++;
 
//$row = mysql_fetch_array( $result , MYSQL_ASSOC )

    endwhile;

echo "<center><table border=1 bgcolor=><tr><td>Item Number</td><td>Quantity</td></tr>";

foreach($results as $v){

        echo "{$v}";

}

echo "</table></center>";

endif;   

                        ?>
 
                    </td>

                </tr>

            </tbody>        </table>                        <h2>&nbsp;</h2>                    </td>                </tr>        </tbody>    </table></body>

</html>

Oct 30 '09 #1

Subscribe Reply

3113

Atli

5,058

Recognized Expert Expert

Hey.

Line #45.
You fetch the first row into the $re variable on that line, so when you start your loop on line #55, the first row in the result is already gone.

If you comment line #45 out this particular problem should be fixed.

Although, on line #8 you have a random "endif;" which doesn't seem to belong anywhere. That should cause a parse error.

Oct 30 '09 #2

Atli

5,058

Recognized Expert Expert

Also, just to throw it out there...

I would recommend avoiding the alternate control-structure syntax, and use the C-Like syntax instead. PHP is a C-Like language and should ideally be used as such.

By this I mean, instead of doing:

Expand|Select|Wrap|Line Numbers

 <?php

if ($something == "something"):

  echo "Something!";

else:

  echo "Not something";

endif;

?>

It is generally better to do:

Expand|Select|Wrap|Line Numbers

 <?php

if ($something == "something") {

  echo "Something!";

}

else {

  echo "Not something";

}

?>

May seem irrelevant, but mixing syntax types can get very confusing.

Oct 30 '09 #3

jmooney5115

New Member

Thanks Atli. I knew it was simple.

I used the control-structure syntax because that's how I first saw if else statements and while loops. I like using brackets because I'm use to them so I'll go back and change it.

Oct 30 '09 #4

Similar topics

1842

Improper result when number table is used to substitute the "IN" clause in oracle

by: sarith sutha | last post by:

Hi Guys Need a help i am facing a sporadic issue when executing the query using nested table of numbers Here are the things which i did 1. I created a type as CREATE TYPE NUMBERTABLE AS...

Oracle Database

63306

Selecting Only the First Row in a Query.

by: Marcus | last post by:

Say a number of people have 2 or 3 addresses each in a query result. How do I select only the first address displayed for each person. For example: John Taylor 33 Dundas Ave. John Taylor 55...

Microsoft Access / VBA

2819

Multiple tables not displayed when binding to a Repeater

by: Jim French | last post by:

I have a page that takes a comma delimited string and needs to bind to a Repeater control. The string is split into an Array, and each value is put into a DataBase query via a For Each loop. The...

ASP.NET

3509

MySQLdb - Query/fetch don't return result when it *theorically* should

by: Bernard Lebel | last post by:

Hello, I'm stumbled at a serious problem, and quite frankly getting desparate. This is a rather long-winded one so I'll try to get straight to the point. I have this Python program, that...

Python

3893

Printing mysql_fetch_array results in multicolumn table

by: JackM | last post by:

I'm not sure if this qualifies as a mysql or a php question so I'm asking in both groups. I am pulling the results of a mysql query from my database and want to print the results into a two...

PHP

2042

Blank Row added to database when existing row found

by: DavidPr | last post by:

I'm creating (trying to create) a picture gallery for my website. The script is not working. I've been working on it now for about 80 hours with no success. My php skills aren't very good. This...

PHP

1578

Unable to see full result of mysql query in php

by: Terry | last post by:

Hi folks. I am just starting to dabble in php. I am trying to do some simple pagination in php/mysql. For whatever reason I am only getting the first digit of my result. For example: ...

PHP

1345

Printing complex XML from DB

by: launchpad67a | last post by:

Hello, I'm retrieving database info and turning it into an xml file. The xml file has to be structured exactly like this example below: Here is what I need: <xml> <listitem name="Video 1"...

XML

2631

Help with displaying MySQL query results

by: Lloyd Harold | last post by:

I'm very new to PHP and attempting to put together a simple script for retrieving MySQL data of personal records. The MySQL table I'm using consists of: 0: id 1: name 2: location (an integer...

PHP

7224

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

7118

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

7323

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

7379

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

7038

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

4706

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

3180

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1550

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

763

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP