PHP assistance with Key Checking system?

Question

Right, so here's the issue.

I'm making a script which checks the key a user inputs into the database, and returns the value of the "active" setting in the database, this will either be "YES" or "NO" in the database.

Here's the error.

mysql_fetch_array(): supplied argument is not a valid MySQL result resource on line 17
This should return the value of 1: (There is supposed to be a php variable here which is not displaying for some reason)
That key was not found in our database

And here is the code.

http://pastebin.com/7F35Lvkh

Thanks to all in advance. Your assistance is greatly appreciated.

Jeff P · Accepted Answer

Echo out your SQL statement to see what it says. Is the data for $key showing up?

echo $sql = "SELECT * FROM database_removed.table_removed WHERE keycode = '$key'";

You didn't post your form code--are you sure you're using the post method in your form?

Chris D · Answer

Line 12 in your pastebin refers to what I assume is a string parameter, but you aren't quoting it.

Given
$sql = "SELECT * FROM database_removed.table_removed WHERE keycode = $key ";

Should be
$sql = "SELECT * FROM database_removed.table_removed WHERE keycode = '$key' ";

Trending News

PHP assistance with Key Checking system?

2 Answers