note 35907 added to function.mysql-fetch-array
| From: | php-general at lists dot php dot net | Date: | Thu, 18 Sep 2003 19:12:36 +0000 |
| Subject: | note 35907 added to function.mysql-fetch-array | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-56722@lists.php.net to get a copy of this message | ||
Hello coders :)
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);
}
function add_phptag_before_html($phptag_before_html)
{
$this->template = str_replace("[php_content]", $phptag_before_html,
$this->template);
}
function add_title($title)
{
$this->template = str_replace("[title]", $title, $this->template);
}
function add_bodycontent($bodycontent)
{
$this->template = str_replace("[body]", $bodycontent, $this->template);
}
function getinfo()
{
}
function do_moduser()
{
$userid = $_GET[userid];
// echo $userid;
$username_session = $_SESSION['login_name'];
$user_identify = $_SESSION['login_stat'];
$link = mysql_connect("212.237.32.43", "kim",
"mohamedali") or die("1" . mysql_error());
mysql_select_db("ei", $link)or die("2" . mysql_error());
if ($user_identify == "user"){
$data = mysql_query("select * from slutbruger where brugernavn =
'$username_session'")or die("3" . mysql_error());
}
if ($userid == !NULL)
{
$data = mysql_query("select * from slutbruger where kundeid = $userid")or
die("4" . mysql_error());
}
if ($user_identify == "user")
{
echo "<a href='http://212.237.32.43/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")
{
//mysql_connect("212.237.32.43","kim", "mohamedali") or
die("Kan ikke forbinde til databasen: " . mysql_error() . "Vi beklager for fejlen, og
vi vil forsøge at rette fejlen hurtigst muligt.");
//mysql_select_db("ei") or die("kan ikke vaelge databasen: " .
mysql_error());
$delete_user_query = mysql_query("delete from slutbruger 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);*/
$userid_get = $rows["kundeid"];
$username = $rows["brugernavn"];
$password_check = $rows["kodeord"];
$firstname = $rows["fornavn"];
$lastname = $rows["efternavn"];
$tlfnr = $rows["tlfnr"];
$adress = $rows["adresse"];
$nr = $rows["nr"];
$emailadr = $rows["emailadr"];
$postnr = $rows["postnr"];
echo "<form method='POST'
I really epreciate any help. Sorry for my english, because I come from Denmark.
Best regards Brian
----
Manual Page -- http://www.php.net/manual/en/function.mysql-fetch-array.php
Edit Note -- http://master.php.net/manage/user-notes.php?action=edit+35907
Delete Note -- http://master.php.net/manage/user-notes.php?action=delete+35907&report=yes
Reject Note -- http://master.php.net/manage/user-notes.php?action=reject+35907&report=yes