Forum Moderators: coopster
I really need your help. The code beneath, get the follewing error:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/html/classes/moduser.class on line 66
I really need your help, because this is a finishing project. The last one, then I'm finish with my education. So please help me. :)
The error is marked as a comment in line 66. "Error is here."
<?php
session_start();
class moduser
{
var $template;
var $data;
function moduser($template_filename)
{
$filename = "templates/".$template_filename;
$handle = fopen ($filename, "r");
$this->template = fread ($handle, filesize ($filename));
fclose ($handle);
}
// snipped code here - jatar_k
function do_moduser()
{
$userid = $_GET[userid];
$username_session = $_SESSION['login_name'];
$user_identify = $_SESSION['login_stat'];
$link = mysql_connect("111.111.111.111", "something", "somethingelse") or die("1" . mysql_error());
mysql_select_db("ei", $link)or die("2" . mysql_error());
if ($user_identify == "user"){
$data =mysql_query("select * from ****bruger where brugernavn = '$username_session'")or die("3" . mysql_error());
}
if ($userid ==!NULL)
{
$data =mysql_query("select * from ****bruger where kundeid = $userid")or die("4" . mysql_error());
}
if ($user_identify == "user")
{
echo "<a href='http://111.111.111.111/moduser.php?userid_delete=$userid_get delete=yes'>Slet mig</a><br>";
$delete_user = $_GET[userid_delete];
$delete_verf = $_GET[delete];
}
if($delete_verf == "yes")
{
// snipped code here - jatar_k
$delete_user_query = mysql_query("delete from ****bruger where kundeid= $delete_user")
or die("Connection to skal ikke køre" . mysql_error());
}
/*-------------------------------------------------------------------------------------Line 65
The error is here.$rows = mysql_fetch_array($data);-------------------------------------------------------------------------------------*/
// snipped code here - jatar_k
?>
I really epreciate any help. Sorry for my english, because I come from Denmark.
Best regards Brian
[edited by: jatar_k at 7:44 pm (utc) on Sep. 18, 2003]
[edit reason] removed specifics and clipped massive code dump [/edit]
