|
Posted by Rik on 02/15/07 01:35
On Thu, 15 Feb 2007 00:12:27 +0100, edward_sanders =
<edward_sanders@bellsouth.net> wrote:
> 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.
Is the 'ID' not in the query result, or doesn't it get passed?
> // Display the text of each joke in the paragraph
> while ( $row =3D mysql_fetch_array($result)) {
What is teh query you're fetching the result from?
What does a print_r($row) tell you?
> echo("<p>$joketext " .
> "<A HREF=3D'$thispage?deletejoke=3D$jokeid'>" .
> "Delete this Joke</a></p>");
What's the resulting link in the HTML source?
> $deletejoke=3D$_GET['deletejoke'];
Please use an intval() on the GET variable here. Consider what will happ=
en =
if someone was to use '1 OR 1=3D1' as the GET variable to your page...
-- =
Rik Wasmus
[Back to original message]
|