Non-Valid Supplied MySQL Result Resource

[The_Silent]

Well, I'm getting this error:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/ketsuka/public_html/dissonance/fetchit.php on line 14
Downloads)

If anyone knows how to help I'd really appreciate it...

<?php
/*************************************
* FetchIt v0.1                       *
* by Nite Phire                      *
* ================================== *
* [url]http://dissonance.ketsukaiten.net/[/url] *
* [email][e-mail][/email]          *
*************************************/

// Pulls in config file.
require ('fetchconfig.php');

$query = 'SELECT * FROM ' . $tableprefix . 'fetchit WHERE name="' . $name . '"';
$info = mysql_fetch_assoc ($query);
$downloads = $info['downloads'];

// Shows the nice number...
print $downloads;

?>

[laserlight]

1. Your script failed to connect to the database server, or
2. Your script failed to select a database, or
3. Your query failed, perhaps because your SQL statement was incorrect.

[The_Silent]

Oi. Wow. That was stupid of me. I completely forgot to connect to the database. That's what I get for coding up a five file script in all of 10 minutes or less. Thanks...

[The_Silent]

Hrmm ... well now I included that and I still get the error:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/ketsuka/public_html/dissonance/fetchit.php on line 20
Downloads)

<?php
/*************************************
* FetchIt v0.1                       *
* by Nite Phire                      *
* ================================== *
* [url]http://dissonance.ketsukaiten.net/[/url] *
* [email][e-mail][/email]          *
*************************************/

// Pulls in config file.
require ('fetchconfig.php');

// Connects to MySQL.
$connect = mysql_connect ($mysqlhost, $mysqluser, $mysqlpassword)
                         or die ('Could not connect to MySQL.');
mysql_select_db ($database)
                         or die ('Could not select database.');

$query = 'SELECT * FROM ' . $tableprefix . 'fetchit WHERE name="' . $name . '"';
$info = mysql_fetch_assoc ($query);
$downloads = $info['downloads'];

// Shows the nice number...
print $downloads;

// Closed connection.
mysql_close ($connect);

?>

[Drakla]

You're not actually doing the query, you're going straight to fetch_assoc without running it. Probably got code-blindness and need a cup of tea and a fag and you'll be right as rain.

[The_Silent]

Ah ... got that fixed ... now I just have one more ... hopefully only one more ... problem. I've never been quite sure on how to pull in a URL variable without having a pre-defined array. I'm having a problem getting it in, because my normal methods of $name=$_GET['name'] aren't working. Well, here's the script if you think you can help. $name is passed in through the url, and is used to find the filename via a MySQL database, with fields 'id', 'name', and 'file.'

<?php
/*************************************
* FetchIt v0.1                       *
* by Nite Phire                      *
* ================================== *
* [url]http://dissonance.ketsukaiten.net/[/url] *
* [email][e-mail][/email]          *
*************************************/

// Pulls in config file.
include ($_SERVER['DOCUMENT_ROOT'] . '/fetchconfig.php');

// Connects to MySQL.
$connect = mysql_connect ($mysqlhost, $mysqluser, $mysqlpassword)
              or die ("Wrong host, username, or password.");
mysql_select_db ($database)
              or die ("Could not select database.");

$name = $_GET['name'];
$query = mysql_query ('SELECT * FROM ' . $tableprefix . 'fetchit WHERE name="' . $name . '"');
$info = mysql_fetch_assoc ($query);
$file = $info['file'];
$downloads = ($info['downloads']+1);

mysql_query ('UPDATE ' . $tableprefix . 'fetchit SET downloads="' . $downloads . '"
                                     WHERE name="' . $name . '"')
                         or die ('Could not update download information.');

// Tells them its getting it and redirects them to the file.
print ('<head>
             <meta http-equiv="refresh" content="3; url=' . $file .'" />
       </head>

   <body>
   Retrieving file from server...<br />
   <br />
   If this is taking too long, click <a href="' . $file . '">here</a>
   </body>');

// Closed connection.
mysql_close ($connect);

?>