|
|
Posted by mpar612 on 08/09/06 12:32
Hi everyone,
I am slowly making headway on my application. I am running into a
strange issue now.
I am inserted a "delete" link into every row returned from a database
query using the following link:
<tr><td><a
href=\"delete_record.php?isbn=$row[isbn]\">Delete</a></td><td>Update</td></tr>
This works well and returns and opens a new window with the following
url: http://www.mikeparkermusic.com/delete_record.php?isbn=987654321
Now I am trying to retrieve the "isbn=987654321" using $_GET and I'm
trying to make that a part of an SQL query using the following code and
I constantly get a "DB Error:
no such field." I could post more code if necessary, I was just trying
to save space:
$isbnget = $_GET['isbn'];
print "<table align=\"center\" border=\"1\" cellpadding=\"0\"
cellspacing=\"0\" bordercolor=\"#000000\">";
$rows = $db->getAll("SELECT isbn, artist_name, album_title,
date_format(release_date, \'%M %d, %Y\') as release_date,
date_format(add_date, \'%M %d, %Y\') as add_date, description, price
FROM lounge WHERE isbn=$isbnget");
foreach ($rows as $row) {
print "<tr><td>ISBN:</td><td>$row[isbn]</td></tr>
<tr><td>Artist Name:</td><td>$row[artist_name]</td></tr>
<tr><td>Album Title:</td><td>$row[album_title]</td></tr>
<tr><td>Release Date:</td><td>$row[release_date]</td></tr>
<tr><td>Add Date:</td><td>$row[add_date]</td></tr>
<tr><td>Description:</td><td>$row[description]</td></tr>
<tr><td>Price:</td><td>$row[price]</td></tr></tr>";
I can post all of my code if necessary. I appreciate any help you can
give. Thanks in advance!
Navigation:
[Reply to this message]
|