[RESOLVED] Supplied Argument not Valid Mysql Resource
I'm working on a script to grab data from a row in a database based on the id of the row (which automatically increments).
The script will grab a number from the URL (7 in www.site.com/page.php?id=7), and then find the row in a table with an id that matches that number. It will assign variables to data from that row, so the information can be placed in various places in the dynamic page.
However, something does not appear to be working: This script is on page.php. So when I type in the URL: www.site.com/page.php?id=7 , I receive the error output: "Save me!" and the text "Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home/dot/public_html/the_editor/page.php on line 19."
Following is the script:
$id = $_GET['id'];
mysql_connect(localhost,$username,$password) or die("Could not connect to MYSQL");
@mysql_select_db($database) or die(mysql_error());
$query="SELECT * FROM [table_name] WHERE id='$id'" or die(mysql_error());