mysql_fetch_array()

Guldstrand

Hi!

I can´t get my php script to work. The script is a "download script", and i get the same "error" all the time:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/guldst2/public_html/admin.php

The script is located at: http://www.guldstrands.net/admin.php, please go in and see if you can find the "error"!?

I really need all the help i can get regarding php scripts.

Moonglobe

you can't just go in and see, YOU have to post the code, as it doesn't show up in the source. could you post the mysql part?

Guldstrand

Here is ALL the code on my admin page!

<?
session_start();
session_register("user");
session_register("pass");

//Ändra till ditt lösenord här
include("variablar.php");
if ($user == 'admin') {
if ($pass == '002717') {
?>
<?
//Ändra inget under denna kommentar

if(isset($putin)) {
include("variablar.php");
$sql = "INSERT INTO avdelning (typ, förklaring) VALUES ('$namnet', '$förklaringet')";
$que = mysql_query($sql)or die("kunde inte");
header("location: admin.php");
}
?>
<?
if(isset($tabort)) {
include("variablar.php");
$sss = "DELETE FROM avdelning WHERE id = '$sid'";
$ooo = mysql_query($sss);
header("location:admin.php?uid=$sid");
}
?>
<?
if(isset($taborts)) {
include("variablar.php");
$ssss = "DELETE FROM nerladdning WHERE id = '$sids'";
$ooos = mysql_query($ssss);
header("location:admin.php?pid=$sids");
}
?>
<html>
<head>
<title>Admin Filscript version 2.0</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="svenskdns.css" type="text/css">
</head>

<body bgcolor="#FFFFFF" text="#000000">
<table width="600" border="0" cellspacing="0" cellpadding="0" class="ruta-ram" height="374">
<tr align="left" valign="top">
<td width="553">
<table width="602" border="0" cellspacing="0" cellpadding="0" class="ruta-ram-gråmörkare">
<tr>
<td width="22" height="13" align="center" valign="middle"><img src="nerladdning.gif" width="16" height="15"></td>
<td width="578" height="13" align="left" valign="middle">Fil nerladdning
Svensk-Design Scripts Version 2.0</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> </td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="ruta-ram-gul">
<tr>
<td align="left" valign="top" height="90">
<table width="600" border="0" cellspacing="0" cellpadding="0" class="ruta-ram-blå">
<tr align="left" valign="middle">
<td width="21" class="svensk-dns-tjock"> </td>
<td width="248" class="svensk-dns-tjock">Avdelning</td>
<td width="248" class="svensk-dns-tjock">Förklaring</td>
<td width="83" class="svensk-dns-tjock">Länk</td>
</tr>
</table>

Guldstrand

The script is most written in Swedish but the code is english. 😕

Moonglobe

first of all, the edit button at the bottom right of your posts is useful 🙂

second, yes, but i think anyone can figure it out if they look at it.

third, does it tell you what line number the error is on? if so, could you post the section of code that that line is in?

Guldstrand

In line 149 and 249:

include("variablar.php");
$sql = "SELECT * FROM nerladdning ORDER BY id";
$que = mysql_query($sql);
while ($rad = mysql_fetch_array($que)) {
$ids = $rad["id"];
$programs = $rad["program"];
$typs = $rad["typ"];
$storleks = $rad["storlek"];
$infos = $rad["info"];
$datums = $rad["datum"];

Moonglobe

well, i can't see anything wrong witht that, could you post a bit more of that section? and i don't see it in your first code.....😕

and your logic is strange in the code. right now, that while loop is going to reasign values till the last pass, esentially only taking from the last entry. is that what you wanted?

Guldstrand

I don´t know what i want because i´m not an expert in php and this script have i downloaded from someone else. It´s supposed to be a "download script", there you can see how many people who has downloaded this and that and so on!?

Guldstrand

here is a little bit more of the code:

<select name="type" class="svensk-input">
<?

include("variablar.php");
$sql = "SELECT * FROM avdelning ORDER BY id";
$que = mysql_query($sql);
while ($rad = mysql_fetch_array($que)) {
$id = $rad["id"];
$typ = $rad["typ"];
$förklaring = $rad["förklaring"];
$link = $rad["link"];

?>
<option><?=$typ?></option><? } ?>
</select>
</td>
</tr>
<tr align="left" valign="middle">
<td width="21%">Fil:</td>
<td width="79%">
<input type="file" name="fil" class="svensk-input">
</td>
</tr>
<tr align="left" valign="middle">
<td width="21%"> </td>
<td width="79%">* obs bara zip filer</td>
</tr>
<tr align="left" valign="middle">
<td width="21%"> </td>
<td width="79%">
<input type="submit" name="putin2" value="Skicka" class="svensk-input">
</td>
</tr>
</table>
</td>
</tr>
</table>
</form>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
<?
}}
else {
header("location: login.php?try=false");
}
?>