php and mysql blues

nazdrowie · 12-13-2004, 05:07 AM

PHP does not want to cooperate! Co za kurwa jebana! Just kidding. I'm going through this tutorial on php/mysql:

http://dev.mysql.com/tech-resources/...s/ddws/26.html

and for some reason, the following chunk of code does not do what it's supposed to do:

Code:

    // Display the text of each joke in a paragraph
    // with a "Delete this Joke" link next to each.
    while ( $row = mysql_fetch_array($result) ) {
      $jokeid = $row["ID"];
      $joketext = $row["JokeText"];
      echo("<P>$joketext " .
           "<A HREF='$PHP_SELF?deletejoke=$jokeid'>" .
           "Delete this Joke</A></P>");
    }

The problem is that upon clicking the "Delete this joke" link, the url we're sent to looks like "http://foo.org/foo.php?deletejoke=" <-- Note the missing number/value after the equals sign. I did some digging around and it turns out that $jokeid does not get a value assigned from $row["ID"]. Why is that?

By the way, $joketext gets the right stuff assigned to it from $row["JokeText"] no problem, which is a string, and $row["ID"] is supposed to be an integer.

Cedrik · 12-13-2004, 07:44 AM

Are you sure in mysql table, the field is named 'ID', not 'id' ?

Hko · 12-13-2004, 11:19 AM

Did you select ID in your query?

djgerbavore · 12-13-2004, 01:57 PM

if you know the order of your columns numerical you can user fetch_arry($result, MYSQL_NUM),
this will return the number indexs of each columns, so $row[0] = row['id'], sometimes this is earier to remeber then names indexs.

nazdrowie · 12-13-2004, 04:00 PM

Thank you so much for the replies

Cedrik, I thought that SQL is case insensitive, so long as you're consistent within a query, say using only 'id' or only 'ID' throughout the whole query and not mixing.

Hko, you're right on the money. I hadn't copied and pasted the code from the link I gave, I had built it up from a previous version that was given in an earlier stage of the tutorial -- OOOPS. Good eye, Hko.

djgerbavore, thanks for the tip.

djgerbavore · 12-13-2004, 05:52 PM

another thing is after a mysql command that you are unsure you can put

Code:

$row =  mysql_fetch_array($result) or die mysql_error();

which will give you more insight on the problems you are having