MySQL/PHP5 $_GET issue
am 09.08.2006 14:32:18 von mpar612Hi 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:
This works well and returns and opens a new window with the following
url: http://www.mikeparkermusic.com/delete_record.php?isbn=987654 321
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 "
$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 "
I can post all of my code if necessary. I appreciate any help you can
give. Thanks in advance!