StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POI'm going to be auto aupdating info from mysql. How do i get the past info to keep displaying along with the new info submitted into the database?
text
Body
copied!<p>I've figured out how to display info submitted into mysql, but I haven't figured out how to keep the past info there. It's going to show the current post on top and keep adding on top everytime new info is submitted but only display like 10 posts at a time. I hope I am explaining this well.</p> <p>How to go about doing this, I am completely lost. I've connected to the database and everything and now im to:</p> <pre><code>echo $hit, $amount, $category; </code></pre> <p>and stuck. that is displaying the info submitted, but when i submit new info, that info changes and the past info is gone. My question is, how would i get the past info to stay and get the new info to build on top of past info?</p> <p>Thanks.</p> <p>Edit: here's more of the code. also, ive been told about mysqli. i just havent changed it yet.</p> <pre><code>if(!$link){ die('Could not connect: ' . mysql_error()); } $db_selected = mysql_select_db(DB_NAME, $link); if(!$db_selected){ die('can not use' . DB_NAME . ': ' . mysql_error()); } $hit = $_POST['hit']; $amount = $_POST['amount']; $category = $_POST['category']; $sql = "INSERT into hit (hit, amount, category) VALUES ('$hit', '$amount', '$category')"; $result = mysql_query($sql); if(!mysql_query($sql)){ die('Error: ' . mysql_Error()); } echo $hit, $amount, $category; mysql_close(); ?> </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload