|
|
Posted by Steve on 02/15/07 02:08
"edward_sanders" <edward_sanders@bellsouth.net> wrote in message
news:mCMAh.9466$6a.142@bignews4.bellsouth.net...
| Hi,
| This is a newbie question. I am using a text for learning php/mysql.
| I am using PHP 5.2.x and mysql 5.
| The example is that of a mysql
| database of jokes. Before we get to joins there is a
| simple table with 3 fields, ID field (primary key, integer),
| JokeText, and JokeDate. In the program for some
| reason the code is not retrieving the ID for each
| row from the db. It gets the JokeText field just fine.
| Let me include the snippets below.
|
| This is where each row (each joke) is to be displayed.
| Note that the ID is used to give the option of deleting a
| joke from the db. The link tag is supposed to get that
| ID passed to the link but that isn't happening. Please help.
|
| // Display the text of each joke in the paragraph
| while ( $row = mysql_fetch_array($result)) {
| $jokeid = $row["ID"];
| echo ($row["ID"]);
| $deletejoke=$jokeid;
| $joketext = $row["JokeText"];
| $thispage = $_SERVER["PHP_SELF"];
| echo("<p>$joketext " .
| "<A HREF='$thispage?deletejoke=$jokeid'>" .
| "Delete this Joke</a></p>");
| }
|
| Then the code to delete the joke ( the row from the
| db) is as follows:
| // If a joke has been deleted,
| // remove it from the database
| if (isset($_GET['deletejoke'])) {
| $deletejoke=$_GET['deletejoke'];
| echo("<p>The joke to delete is number $deletejoke");
| $sql = "DELETE FROM jokes " .
| "WHERE ID=$deletejoke";
| if (mysql_query($sql)) {
| echo("<p>The joke has been deleted.</p>");
| } else {
| echo("<p>Error deleting joke: " .
| mysql_error() . "</p>");
| }
| }
dunno. in the middle of your while loop, insert:
echo '<pre>' . print_r($row, true) . '</pre>';
it could be something as simple as a capitalization problem with the key
being accessed in the $row variable, i.e. $row['id'] instead of $row['ID'].
spewing the variable to the browser will help pinpoint issues like that.
finally, if this code is straight out of a book...throw it away now! read
'code complete' and you'll understand how many 'bad' things are going on in
just that snippet - the rest must be equally dreadful. if you'd like (and
supply your joke db table structure), i'll give you more of a stardardized
and more manageable script to look at.
hth
Navigation:
[Reply to this message]
|