[Resolved] Updating Problems

ghjrbrasil

Whenever I delete an old record from my USER table and add a new user, my display code shows the idnumbers in the right order (for example: 1,2,5,6,10), but not with the corresponding username and password (it switches them around, the new user gets the id number from an old user, and the old user receives the new id).

The database has everything in the right order, but the following display code messes it up. This is a pain since my delete link deletes the entries from the idnumber.

Heres the main section of the idnumber field display. The other fields follow the same concept:

<?php

      $result = mysql_query("SELECT construtoraid FROM construtoras");

      while($query_data = mysql_fetch_row($result)) {



           echo "$query_data[0]" . "\r\n";
           echo "<font size=2>";
           echo "<a href=remover_construtora.php?id=$query_data[0]>Remover</a><br>";
           echo "</font size=2>";



      }

Any idea as to why it doesn't show up in the correct order?

ghjr

leatherback

Hi,

IF you do not output all data from the same query, the order may be different. To avoid this, add a specific order to the data:

To the query add: 'order by constutoraid':
SELECT construtoraid FROM construtoras order by constutoraid.

But you ar eprobably better of just using:

SELECT * FROM construtoras order by constutoraid

and outputting each field straight from that one query..

ghjrbrasil

Wow, that was fast!!

Thanks leatherback!! Your a lifesaver 🙂

ghjr

ksandom

Did that solve it?
If not, what is your SQL for deleting the row? What I'm getting at, is it deleting the whole row, or is it deleting just the id of the row?

leatherback

Ksandom.

The database has everything in the right order, but the following display code messes it up

So there is nothing wrong with the datase. Just the querying concept was wrong.

ghjrbrasil: Could you please mark this thread as resolved (See link at bottom of page) if your question is answered.

ksandom

sorry, you're quite right, my mistake.