Data not retrieving correctly from MySQL....

onlinegs

Hello,
I am loading the some settings for a script out of my MySQL database. When I try to pull the data out, it gives an error (actually the variable is just empty). I can't figure this out, and when I execute mysql_error();, nothing happens. I have posted the code in question below.

$MQuery = "SELECT * FROM NewsPref";
$result = mysql_query($MQuery);
$GMTos = mysql_result($result,0, "GMToffset");
if (!isset($GMTos)) {
                  @mysql_close($ifndb);
                  exit("ERROR TEXT OUTPUT");
}

It connects fine to MySQl, and selects that datbase properly. But, when I run the script it prints out the Error Text (thus indicating that the var GMTos is not set). I have also tried to print($GMTos); but it returns nothing as well.

If anyone could help me it would be greatly appreciated.
TIA, Bryce

onlinegs

bump
Sorry, but I want to make sure that if someone knows how to fix my problem, that they see this post.

hand

Add an or statement to get better informations

$MQuery = "SELECT * FROM NewsPref";
$result = mysql_query($MQuery)
   or print "&gt;&gt;&gt; MySQL-Error: ".mysql_errno()." -&gt; ".mysql_error()."<br>\n";

$GMTos = mysql_result($result,0, "GMToffset");
if (!isset($GMTos)) {
                  @mysql_close($ifndb);
                  exit("ERROR TEXT OUTPUT");
}

xblue

Hey, patience 🙂

I'd guess the way you call mysql_result most probable is wrong, unless you do have a column with the name "GMToffset".

The third argument should either be the column name (a string) or the field offset (a number).

Easiest may be to specify the column name in the select statement instead of selecting all column with *.
then you can skip the third agument of mysql_result alltogether.

Hope this helps!

onlinegs

The thing is, I do have a colume named 'GMToffset'. This same system also worked earlier with a different table in the same database.

I also removed the 0 from it, and it didn't error, but it didn't correctly return the value either.

So, does anyone know what else the problem could be?