Database info not displaying correctly

WebNinja · #1 (**permalink**) May 23rd, 2008, 17:38

I am having a problem with a PHP&MySQL quote of the day script I'm using. The script works. I downloaded one called "The World's simplest PHP Message/Quote of the Day Script". It can be found here: http://www.interaction-design.org/ma...te_of_the_day/

The problem is this: I can enter more quotes via phpMyAdmin and they display, but when I submit new quotes via PHP form to the database, it won't display in the final page. The quote & author information is in the database, but it does not show in the end page. As the script cycles through the database, some days it will display the quote and author correctly, then the next few are blank.

Is there a problem with the code?

To enter first quote & author

HTML: Select all

<html>
<body>
<form method="post" action="add_quote.php">
Quote: <input type="text" name="quote" /><br />
Author: <input type="text" name="author" /><br />
<input type="submit" value="Add 1st Quote">
</form>

</body>
</html>

To send quote & author to database...
...then to add another quote & author

PHP: Select all


<?php
$con = mysql_connect("localhost","USERNAME","PASSWORD");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("DATABASE", $con);

$sql="INSERT INTO quotes (Quote, Author)
VALUES
('$_POST[quote]','$_POST[author]')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "The quote was added.";

mysql_close($con)
?>

<html>
<body>
<form method="post" action="add_quote.php">
Quote: <input type="text" name="quote" /><br />
Author: <input type="text" name="author" /><br />
<input type="submit" value="Add Next Quote" />
</form>

</body>
</html>

Or maybe its just a setting in phpMyAdmin I can adjust. Anyone have any ideas?

Thanks.

longstand · #2 (**permalink**) May 24th, 2008, 20:39

There appears to be no problem with your code but i am a bit confused as what you are trying achieve. Here is what i have gathered so far:

You have a working database & you are trying to send post data from the form from these to fields here 'quote' & 'author' into the database using the 'add_quote.php' to handle the transfer from form to database right???

So how and were are you displaying the the data from the database or do you mean it wont display or show up in the database once posted??

If its the database check you or someone else have not set a option in the database to only display the entrys by date or time ie: and

PHP: Select all


 
and DATE_ADD( created_at, INTERVAL 30 DAY ) > NOW()

if you need help displaying the database rows on a web page the use the following code below:

PHP: Select all


<?php
 
$connection = mysql_connect('localhost','username','password');
 
mysql_select_db('DATABASE');
 
$sql = "SELECT * FROM quotes order by quotesid";
 
$result = mysql_query($sql);
 
$row = mysql_fetch_array($result);
 
// Then simpley echo out the rows using the the echo statement below:
 
<?php  echo $row['qoutes'[; ?>  <br />
 
<?php echo $row['author']; ?> 
?>

Hope this helps you out mate

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
[SOLVED] Use info from Database in a script ???	WebNinja	PHP Forum	2	May 3rd, 2008 00:59
Images not displaying correctly	leighhobson89	Web Page Design	2	Nov 29th, 2007 16:33
Displaying diff info on the same page	waheeddin	Web Page Design	1	Feb 23rd, 2007 19:56
Displaying correctly in every browser except IE	promod	Web Page Design	15	Feb 16th, 2007 16:28
displaying data from my database	franknu	PHP Forum	20	Jun 16th, 2006 09:43

		Webforumz.com > Main Forums > Program Your Website > PHP Forum
Database info not displaying correctly