PHP help.

[Excellent]

Hey, I've just finished a little script I was creating. I submitted an entry to a database and on another file I displayed the contents of the database. I created a little file that deletes all entries from the database and it worked.. but now when I submit another entry to the database it doesn't display anything when I go to fetch the contents, just a white page.

This is the code I am using.

<?php
include 'database.php';
$fetch = mysql_query("SELECT * FROM database");
while ($display = mysql_fetch_array($fetch)) {
echo "
Blah: $display[blah]
";
}
?>

Obviously I've taked out the function names and such but does anybody know why it's not displaying anything? (It used to work before I deleted the entries)

[Calon]

Hey, I've just finished a little script I was creating. I submitted an entry to a database and on another file I displayed the contents of the database. I created a little file that deletes all entries from the database and it worked.. but now when I submit another entry to the database it doesn't display anything when I go to fetch the contents, just a white page.

This is the code I am using.

<?php
include 'database.php';
$fetch = mysql_query("SELECT * FROM database");
while ($display = mysql_fetch_array($fetch)) {
echo "
Blah: $display[blah]
";
}
?>

Obviously I've taked out the function names and such but does anybody know why it's not displaying anything? (It used to work before I deleted the entries)

<?php
include "database.php"; // Hate single quotes. :P
$result = mysql_query("SELECT * FROM `database`"); // prefer result.
while($row = mysql_fetch_array($result)) { 
echo "bla: ". $row[""] ."";
}
?>

[/php]

[Excellent]

Thanks but it still isn't displaying anything. Nothing can be wrong with my submit code due to it working before I deleted all entries.

[Calon]

Thanks but it still isn't displaying anything. Nothing can be wrong with my submit code due to it working before I deleted all entries.

Doubt it, paste all code but remove passwords etc.

[Robbie]

Are you 100% sure there is data in the table?

[Excellent]

Are you 100% sure there is data in the table?

Is there anyway I could check in PMA?

[Excellent]

*bump* still need help

[Johno]

To check for data in phpMyAdmin select the database, then the table and then click browse?

If there is data there then its not outputting correctly, if not then its not submitting it correctly.

[Excellent]

To check for data in phpMyAdmin select the database, then the table and then click browse?

If there is data there then its not outputting correctly, if not then its not submitting it correctly.

Just displays all my rows.

[iJoe]

when you see the rows, click browse should then show data (if any)