Jump to content

mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource


jigsawsoul

Recommended Posts

Warning:  mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/hr728/public_html/_uni/_admin/edit-staff.php on line 17

 

<?php

session_start();

include ("../_library/opendb.php");
include ("../_functions/f_login.php");

sessionAuthenticate ();

$login_id = $_GET['id'];

$result =	"SELECT * FROM web_login 
	LEFT JOIN web_staff ON web_login.login_id=web_staff.staff_id
	WHERE login_id = $login_id";

$result = mysql_query ($result);
$row = mysql_fetch_assoc ($result);

$current_firstname = $row['firstname'];
$current_lastname = $row['lastname'];
$current_email = $row['email'];
    
?>

 

I've used the code a number of times before and its worked fine, does anyone see anything wrong with the code?

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.