Solved

drop down menu showing old records from the database

Posted on 2014-01-24
4
341 Views
Last Modified: 2014-02-03
im doing this project, they is a page called insert a review, in my insert review page , before you can write a review you select the title of the book, i use a drop down menu for this, so the user writes a review on an existing book in my books database,

but now the issue is, my drop down menu is showing old records, book's title that i have deleted. and when i display my books table, the old records don't show, which is correct.

i just want to know why is my drop down menu showing old deleted records?

<?php
echo "<select name='title' >";
$res=mysql_query("SELECT *  FROM mbooks");

while($entry=mysql_fetch_array($res))
{
    echo "<option";

    if($entry['title'] ==fred)
    {
        echo " selected=selected";
     } 

    echo ">"  .$entry['title']. "</option>";
}
echo "</select>";
?>

Open in new window

Edited to put the code into the code snippet ~Ray
dropdownreviews.txt
0
Comment
Question by:JCWEBHOST
  • 2
4 Comments
 
LVL 42

Expert Comment

by:Chris Stanyon
Comment Utility
It absolutely impossible to tell from that.

Database records aren't cached, so you need to double check you're using the correct connection to the correct database, and using the correct table. Do you have the database on a development and a live server - make sure you select the right one.

Other than that, we're working blind here - nothing wrong with your code (apart from mySQL library being deprecated in PHP, but that won't affect the records!)
0
 
LVL 108

Expert Comment

by:Ray Paseur
Comment Utility
We would need to see your CREATE TABLE statements and your test data model.  We might need to see the other processes that led to the current state of the test data model.  In other words, it's not a question with any one answer.  It's a research project.

Maybe step back from this a little bit and try to get a foundation in how PHP works?  This article can lead you to good learning resources.
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/A_11769-And-by-the-way-I-am-new-to-PHP.html

And this article can help you avoid many of the bad things that happen to people who start copying code samples from the internet without any real understand of what they're doing.
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/A_12293-AntiPHPatterns-and-AntiPHPractices.html

Since you will have to convert the data base extension from MySQL to something else, you might as well learn the right way now, and never go back to MySQL.
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/PHP_Databases/A_11177-PHP-MySQL-Deprecated-as-of-PHP-5-5-0.html

Line 9 of the code snippet is almost certainly wrong, unless you have a defined constant somewhere else named "fred."  You might want to read this article, paying particular attention the part about time bombs.
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/A_12241-Quotation-Marks-in-PHP.html
0
 

Author Comment

by:JCWEBHOST
Comment Utility
what do you mean by  "deprecated in PHP" is they a new way to do a drop down menu?

my connect seems alright, because my other drop downs are working fine.
0
 
LVL 42

Accepted Solution

by:
Chris Stanyon earned 500 total points
Comment Utility
In PHP there are several libraries you can use to access your mySQL database - mysql, mysqli, and PDO - the mysql libraries are deprecated meaning that you will have to switch to using one of the other 2.

In your code you are using the mysql library (functions such as mysql_query() and mysql_fectch_array()). Read through Ray's article and it'll show you how to switch to using one of the other.

That said, it's not the cause of your problem, and switching to another library won't help you solve it (but it still needs to be done anyway)
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
This article discusses how to create an extensible mechanism for linked drop downs.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now