[RESOLVED] MySQL Table showing old records which are already deleted!

[xeirus]

Hi!
I'm using MySQL5 and PHP5
I'm facing a really weird problem.
I deleted an entire table and recreated it, with the same table name.
The inserted rows are not the same as the previous ones but when I do an output of that table, it still shows me the contents of the old table!

This is really strange and I can't even imagine how this would be possible?

Please help!

My pathetic hosting company (APlus) has just asked me to bugger off so I'm really stuck.

• Xeirus

[bradgrafelman]

How do you "do an output of that table" ?

[xeirus]

with a php file with this kinda code:

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM table1";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

echo "<b><center>Database Output</center></b><br><br>";

$i=0;
while ($i < $num) {

$field1=mysql_result($result,$i,"field1");
$field2=mysql_result($result,$i,"field2");
$field3=mysql_result($result,$i,"field3");
$field4=mysql_result($result,$i,"field4");
$field5=mysql_result($result,$i,"field5");

echo "$field1 <br> $field2 <br> $field3 <br> $field4 <br> $field5 <br><br>";

$i++;
}

[bradgrafelman]

Try doing a TRUNCATE TABLE and viewing that script again. Does it show no rows? Then try adding one or two new rows and seeing if the output is correct.

EDIT: Also, have you tried executing the SELECT query directly against MySQL (e.g. via the CLI, or perhaps through a GUI such as phpMyAdmin) and viewing the contents of the table?

[xeirus]

Not specifically shows the number of rows but I can count it throws out 10 records, all of them are the old records and the ELEVEN new ones, none to be seen !

I don't really know how to truncate a table. Can you help? Or guide be somewhere where I can find an explanation on how to do it.

Question, will I lose the new records if I do a truncate table?

[bradgrafelman]

xeirus;10991165 wrote:

Not specifically shows the number of rows but I can count it throws out 10 records, all of them are the old records and the ELEVEN new ones, none to be seen !

Either you didn't delete the old table, or the page you're viewing is cached in your browser and isn't actually showing a new execution of the script.

xeirus;10991165 wrote:

I don't really know how to truncate a table. Can you help? Or guide be somewhere where I can find an explanation on how to do it.

http://dev.mysql.com/doc/refman/5.0/en/truncate-table.html

xeirus;10991165 wrote:

Question, will I lose the new records if I do a truncate table?

Well, yes, you'll lose all rows... that's the whole point of truncating a table.

[xeirus]

I'm afraid, I've already tried those tests.
In phpmyadmin it shows 11 rows perfectly.
My cache gets deleted everytime I close my browser AND I've already done manual deletion to be on the safe side.
I've renamed the table to something else and did the query from front end, then it shows the 11 records perfectly.
I then renamed it back to the original name, and it again goes back to 10 records only and the information of the 10 records is incorrect (old) as well.

[cretaceous]

are you certain you are checking the correct database?
could you have a local db and another on an external server and you are mixing up where you select from?

[xeirus]

Ok, the culprit is the pathetic APlus Hosting service.
They moved DBs from one server to another and didn't inform us.
Oh yes, the servernames are different, just by ONE alphabet!
But then that's APlus, one of the most lame hosting companies I've every been with, no courtesy to inform the customers and dream on if you're looking for an apology!

Anyway, "thank you" to everyone who tried to help and sorry for the trouble!