not sure why the hell this is happening all of a sudden, as it was working perfectly this morning at homeWarning: Supplied argument is not a valid MySQL result resource in /home/terrie/public_html/logged_in/My_Account/view_profiles.php on line 43
heres the code:
Code: Select all
<?php require_once('../../Connections/TDN_all.php'); ?>
<?php
$colname_showing_profile = "1";
if (isset($HTTP_SESSION_VARS['username'])) {
$colname_showing_profile = (get_magic_quotes_gpc()) ? $HTTP_SESSION_VARS['username'] : addslashes($HTTP_SESSION_VARS['username']);
}
mysql_select_db($database_TDN_all, $TDN_all);
$query_showing_profile = sprintf("SELECT show_profile FROM login WHERE username = '%s'", $colname_showing_profile);
$showing_profile = mysql_query($query_showing_profile, $TDN_all) or die(mysql_error());
$row_showing_profile = mysql_fetch_assoc($showing_profile);
$totalRows_showing_profile = mysql_num_rows($showing_profile);
mysql_select_db($database_TDN_all, $TDN_all);
$query_all_admins = "SELECT username, firstname, surname, gender, organisation, email, dob, comments, picture, show_profile, access_level FROM login WHERE show_profile = 'Yes' AND access_level = 'Admin'";
$all_admins = mysql_query($query_all_admins, $TDN_all) or die(mysql_error());
$row_all_admins = mysql_fetch_assoc($all_admins);
$totalRows_all_admins = mysql_num_rows($all_admins);
mysql_select_db($database_TDN_all, $TDN_all);
$query_all_members = "SELECT username, firstname, surname, gender, organisation, email, dob, comments, picture, show_profile, access_level FROM login WHERE show_profile = 'Yes' AND access_level = 'member' ORDER BY surname ASC";
$all_members = mysql_query($query_all_members, $TDN_all) or die(mysql_error());
$row_all_members = mysql_fetch_assoc($all_members);
$totalRows_all_members = mysql_num_rows($all_members);
// database variables for connections
$host = "localhost";
$user = "malcolmboston";
$password = "xxxxxxxx";
$DBname = "tees-drug-network";
$tablename = "login";
//connection variables completed
// establishing connections
$link = mysql_connect ($host, $user, $password);
//connection established
//the query defined
$query = "SELECT username, firstname, surname, gender, organisation, email, dob,
comments, picture, show_profile, password FROM login WHERE username = '".$_SESSION['username']."'";
// select the database
mysql_select_db($DBname);
// query the database
$result = mysql_query($query);
$data = mysql_fetch_array($result, MYSQL_ASSOC);
?>
<?php
//defining the date for later use
$theDate = time();
$date = date('j F Y',$theDate);
// use echo $date to show result
?>
<?php
//used to show the time
$thetime = time();
$time = date('g:ia',$thetime);
// use echo $time to show result
?>