not a valid MySQL result resource

[gx30uk]

I am trying to add a php app to my site called "wapuploader" that allows people to upload files to my "mysql" DB & then download to their phone. Unfortunately im getting an error message and the site that the software belongs to is not very forth coming with help. The error is....

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/gx30co58/public_html/Vault/index.php on line 156

Line 156 is

while($rs = mysql_fetch_array($result) ){

can someone please help with this error?

Many thanks in advance.

[LordShryku]

Usually a problem with your sql. echo your sql to the screen and run it directly against the database.

[gx30uk]

Hi LordShryku, Thanks for replying, but i must warn you im a novice & therefore unsure what you mean. Can you help me resolve this matter.
Thanks,

[TheDefender]

Also, post the part of the code with the line that looks something like this:

$result = mysql_query("Your query is here");

[gx30uk]

Originally posted by TheDefender
Also, post the part of the code with the line that looks something like this:

$result = mysql_query("Your query is here");

The full php code is...

<?php
/*
+---------------------------------------------------------------+
|	Wapuploader v1.0
|	/index.php
|
|	©Lars Drimer Faltz 2002-2004
|	[url]http://software.coolservice.dk[/url]
|	[email][e-mail][/email]
|
|	THIS IS COPYRIGHTED SOFTWARE
|   PLEASE READ THE LICENSE AGREEMENT
|   [url]http://software.coolservice.dk/wapupld_license.txt[/url]
+---------------------------------------------------------------+
*/
	include 'config.php';

$nu = time();


$sql = ("SELECT * FROM wapupld_upload");
$result = mysql_query($sql, $db);				
$enable = 0;

while($rs = mysql_fetch_array($result) ){ 
	$uptime = $rs["dato"];	
	$idnm = $rs["idnm"];					
	$filname = $rs["filname"];

	if(($nu-$uptime) >= $timeallowed) { // slet filen den er udløbet



			unlink("tmpfiles/$filname");
			$sql = ("DELETE FROM wapupld_upload WHERE idnm='$idnm'");
			mysql_query($sql, $db);



		}


}


?>

[TheDefender]

Just out of curiosity, where is the part of the script where you connect to the server and select the DB?

The part with the mysql_connect() and mysql_select_db()...

[gx30uk]

Hi, the app contains several files & was unsure what code from what files to add to here, and did nto want to overload you with code. I have found the code you seek in the config.php file...

This is taken from the original file...

<?php
/*
+---------------------------------------------------------------+
|	Wapuploader v1.0
|	/config.php
|
|	©Lars Drimer Faltz 2002-2004
|	[url]http://software.coolservice.dk[/url]
|	[email][e-mail][/email]
|
|	THIS IS COPYRIGHTED SOFTWARE
|   PLEASE READ THE LICENSE AGREEMENT
|   [url]http://software.coolservice.dk/wapupld_license.txt[/url]
+---------------------------------------------------------------+
*/
require_once("class.php");


//EDIT HERE START

$dbserver = "localhost";
$username = "root";
$password = "";
$database = "wapuploader";
$wapurl = "http://www.coolservice.dk/demo/wapuploader/wap.php";
$urltoindex = "http://www.coolservice.dk/demo/wapuploader"; 			//path where the script files reside in remember  NO trailing slash
$hostpage = "http://www.coolservice.dk/demo/wapuploader/tmpfiles/";    // directory on server where files are saved remember trailing slash
$timeallowed = 360; 		//seconds the file should remain on the server
$allowedsize = 512000; 		//allowed size in bytes
$license = ""; 				// enter license key here - if you have one

//EDIT HERE END


/////DO NOT EDIT BELOW


// Forbinder til MySQL-serveren
$db = mysql_connect($dbserver, $username, $password);

// Vælger databasen
mysql_select_db($database,$db);

?>

If you need anymore info just ask as if you could help me resolve this issue that would be great.

also the app's site is...
http://software.coolservice.dk/modules.php?name=Downloads&d_op=viewdownload&cid=1

once agin thanks for taking the time to assist.

[LordShryku]

Check what [man]mysql_error[/man] gives you.

# change 
$result = mysql_query($sql, $db);
# to
$result = mysql_query($sql, $db) or die(mysql_error());

[gx30uk]

Originally posted by LordShryku
Check what [man]mysql_error[/man] gives you.

# change 
$result = mysql_query($sql, $db);
# to
$result = mysql_query($sql, $db) or die(mysql_error());

[/B]

Thanks for replying and that got rid od that error, but now i get the message "No Database Selected" and the upload form is not displayed. Example..www.gx30.co.uk/tempindex.php

Cheers,

[TheDefender]

OK, does this stuff from your config.php match your running configuration?

$dbserver = "localhost";
$username = "root";
$password = "";
$database = "wapuploader";

If, so, it's a bad idea to connect to a database using a non-password protected root account. Also, did you use the same database name as the author?

[LordShryku]

The die statement tells it to stop processing completely, so once the errors are gone, everything will show up. It's good for debugging simply for this reason. If something is wrong with your mysql_connect statement, it will stop there. Without it, you get confusion like this, where it tells you that the problem was with mysql_fetch_array.

Now for the error, if it says no database selected, that would mean that it's not seeing your mysql_select_db call, which makes me wonder if it's including your config file at all. Try changing this:

# change
include 'config.php';
# to 
require_once('config.php');

[gx30uk]

Firstly thanks for your help & i hope you have the patience with me to see this problem resolved 🙂 now theres a challange.

Ok, i restored this bit of code

$result = mysql_query($sql, $db);

and also instead of just having

require_once('config.php');

i specified the full path to remove error...

require_once('http://gx30.co.uk/Vault/config.php');

, but now get the errors....

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/gx30co58/public_html/Vault/index.php on line 154

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/gx30co58/public_html/Vault/index.php on line 158

although the form is displayed. It must be something i have done, as otherwise the originating site would not be publishing it. Thanks for your continuing help.

Maybe i should start again?

[LordShryku]

Okay, so if it got there, it's either a problem with mysql_connect or mysql_select_db. Throw the or die(mysql_error()); on the end of those and see if it nets you an error...

[gx30uk]

Hi LordShryku & TheDefender, I have now got it working as a standalone page. Originally, i had it within a login form that if the user logged in, it would display the upload form. This page also had PHP coding in it, would this effect it, even though the 2 pieces of php coding were in their own <?php ?> tags? Also do you know if a form, can be within a form?

I am now going to attempt to start the process again with the login section, so i will keep you updated.

Thanks,