Updating a mysql database help

Mr207

(note to all who helped me in my previous thread: Thanks alot. It turns out that there are two folders on my schools webserver we can upload to. One is php enabled, one is not. I was simply putting my php scripts in the wrong place.)

For a school project, I'm making something on an online movie database. Its got a "client" side where the users can browse the movies in the database, then it has an admin page where whoever has access can add movies, update them, delete them, etc. Anyway...in my update script, the name of the movie needs to be passed as a string. (ala update.php?title=The Godfather) The display script displays the movies in the database like so:

while ($row = @ mysql_fetch_array($result)){
$title = $row["title"];
echo "<tr><td><a href = 'update.php?title=$title'>{$row["title"]}</a></td>
<td>{$row["producer"]}</td>
<td>{$row["rating"]}</td>
<td>{$row["genre"]}</td>
<td>{$row["length"]}</td></tr>";
}

This is supposed to show the database in table form, with the title being a link to the update script. Now the problem I'm having is when it passes the title of the movie, it only passes the first word of it. So if the movie was "The Godfather" the link would be "update.php?title=The". I need to pass the entire title for the update script to work. How can I make $title = the entire title of the movie and not just the first word?

thorpe

Wrap it in [man]url_encode/man.

Mr207

Ok I tried that. The code now reads:

while ($row = @ mysql_fetch_array($result)){
$title = $row["title"];

   echo "<tr><td><a href="update.php?title=', urlencode($title), '">{$row[title]}</a></td>
   <td>{$row["producer"]}</td>
   <td>{$row["rating"]}</td>
   <td>{$row["genre"]}</td>
   <td>{$row["length"]}</td></tr>";
}

However now I keep getting this error: Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in /export/home/st1/v/t/y/vtyler1/COSCWWW/FinalProject/display_all_admin.php on line 49

I've tried fiddling around with the quotation marks, and I can';t seem to find the right combination. Probably because I'm a little tired atm, but maybe another set of eyes will see it?

knashash

try it this way:

while ($row = @ mysql_fetch_array($result)){
$title = urlencode($row["title"]);

echo "<tr><td><a href="update.php?title=$title">{$row[title]}</a></td>
<td>{$row["producer"]}</td>
<td>{$row["rating"]}</td>
<td>{$row["genre"]}</td>
<td>{$row["length"]}</td></tr>";
}

rayishu

Your Problem is right here

echo "<tr><td><a href = 'update.php?title=$title'>{$row["title"]}</a></td>

When the Single quote ' doesnt work when exporting out HTML u have to change it to

echo "<tr><td><a href = \"update.php?title=$title\">{$row["title"]}</a></td>