473,396 Members | 1,996 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

phpmyadmin: missing rows from results

Hi,

I'm running PHP (version 4.3.1), MySqlAdmin 1.3 & PHPmyadmin 2.4.0 on
Apache HTTP Server 2.0.45. I'm having problems with phpmyadmin in
particular. I'm running several tables and querying them in a PHP
program.

The problem arises in one particular table which is proving to be very
temperamental. The most common error is the sql query missing the
first row from the returned results.

So for example, say I've got records 1-7 in my table; an SQL query
selecting everything from this table only returns records 2-7.

The row appears fine in phpmyadmin but doesn't appear in the php
program. I've also tried selecting where row number ='1' but this
still hasn't returned anything.

Can anyone help me out here, is this a bug or something I'm doing
wrong?

Any help greatly appreciated!

Thanks,

Chris
Jul 16 '05 #1
0 1912

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: RingTone | last post by:
SQL Server 2000/Access 2000 linked tables PK = FLOOR/DESK NO/TYPE A User has complained about seeing data below simply by scrolling through the attached table, the data is there when you look at...
2
by: Andrew | last post by:
Hey all, Have a strange one here, and being still fairly new to .NET isn't helping me understand it. I am having a problem where a DataReader doesn't return all the rows when I try to use a...
0
by: JC | last post by:
Hi, I have a stored Proc being called from a a c# class that is passing a resulting datareader back to a windows form , to build a drop down. The really odd thing is, only a handfull of the...
17
by: Justin Emlay | last post by:
I'm hopping someone can help me out on a payroll project I need to implement. To start we are dealing with payroll periods. So we are dealing with an exact 10 days (Monday - Friday, 2 weeks). ...
11
by: jimstruckster | last post by:
I have a table with 10 rows, I want all rows except for the first to be hidden when the page first opens up. If the user puts a value in a text box in the first row then I want the second row to...
2
by: Daron | last post by:
I have a listbox that will only show the header row and the first record regardless of how many records are returned. I can find no code or settings that account for this. Details: - The list...
2
by: danceli | last post by:
I have made trigger on table 'FER' that would be fired if data is inserted, updated to the table. And also, I made batch file using bcp to extract the newly updated / inserted records. But I got...
5
by: eBob.com | last post by:
I am so frustrated. I've been working all weekend on what I thought would be a simple script. I never find it easy to look at someone else's code, but if someone can help with this I would be...
42
by: dugong | last post by:
Here is my query. TRANSFORM Count(t_date.ftime) AS Sumftime SELECT t_date.gh FROM t_date GROUP BY t_date.gh PIVOT t_date.fdate; What i'm doing is count the number of clocking per points number....
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
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...
0
marktang
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,...
0
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...
0
Oralloy
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,...
0
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...
0
tracyyun
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...
0
agi2029
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,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.