Organizational Research By

Surprising Reserch Topic

warning mysql result expects parameter 1 to be resource boolean given


warning mysql result expects parameter 1 to be resource boolean given  using -'php,mysql'


  Possible Duplicate:
  PHP: Warning: sort() expects parameter 1 to be array, resource given   




My PHP functions script was working fine last night, and now when I logged on to work on it some more today, I am getting

"Warning: mysql_result() expects parameter 1 to be resource, boolean given".

I have -no- idea why this isn't working. I've read the PHP manual online, and I've even seen examples where what I did is used and works. Can anyone please help me out with this? I've been fixing bug after bug (so many things stopped working when I logged on today) and I'm at my wits end here. If it helps, I'm using XAMPP on Windows 7 for my server.

Code: (also available via Pastebin)

<?php

function dbConnect() {
$dbserver="127.0.0.1";
$dbuser="Mike";
$dbpassword="mike";
$dbname="devsite";

$con = mysql_connect($dbserver, $dbuser, $dbpassword);
mysql_select_db($dbname, $con);
}

function getSiteTitle() {


$siteTitle = mysql_result(mysql_query("SELECT \`siteTitle\` FROM siteSettings"), 0);
return $siteTitle;
}

function getSiteHeader(){

$siteHeader = mysql_result(mysql_query("SELECT \`siteHeader\` FROM siteSettings"), 0);
return $siteHeader;
}

function getBodyContent() {


$bodyContent = mysql_result(mysql_query("SELECT \`bodyContent\` FROM siteSettings"), 0);
return $bodyContent;
}

?>

    
asked Oct 13, 2015 by kinnari
0 votes
15 views



Related Hot Questions



Government Jobs Opening


...