[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());
/*database output assigned variables below*/
$page_title=mysql_result($result,$i,"page_title") or die("Save me!");
I don't know half of you half as well as I should like; and I like less than half of you half as well as you deserve.
- Bilbo Baggins in The Fellowship of the Ring
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread