What does this mean?

[mastercjb]

I am trying to add something to my site however I keep getting this error:

 

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/blt3/public_html/race.php on line 16

 

I dont understand what this line of code is trying to do, can you help me. The code (line 16,17) is posted below.

 

$is=mysql_query("SELECT u.*,us.* FROM users u LEFT JOIN userstats us ON u.userid=us.userid WHERE u.userid=$userid",$c) or die(mysql_error());

$ir=mysql_fetch_array($is);

 

 

I dont get what (u.*,us.*) is. "users" is a table in MYSQL and "userstats" is another.

 

[Mchl]

FROM users u LEFT JOIN userstats us

is equal to

FROM users AS u LEFT JOIN userstats AS us

and this in turn is giving aliases to your tables (consider them shorter names, that are used within query)

 

So,

SELECT u.*,us.*

means

SELECT users.*,userstats.*

(which in this case is equal to

SELECT *

)

 

That should answer second part of your question. Getting back to first:

Is that the only error message you get? The code you have, should also display a MySQL error message if query fails.

 

 

[mastercjb]

Ok I get it, and yes that is the only error.

[Mchl]

Can you show us how you connect to the database?

[mastercjb]

Here is the first few lines of that page, it just includes my config to connect:

 

<?php

session_start();

require "global_func.php";

if($_SESSION['loggedin']==0) { header("Location: login.php");exit; }

$userid=$_SESSION['userid'];

require "header.php";

$h = new headers;

$h->startheaders();

include "config.php";

global $c;

$is=mysql_query("SELECT u.*,us.* FROM users u LEFT JOIN userstats us ON u.userid=us.userid WHERE u.userid=$userid",$c) or die(mysql_error());

$ir=mysql_fetch_array($is);

check_level();

$fm=money_formatter($ir['money']);

$cm=money_formatter($ir['crystals'],'');

$lv=date('F j, Y, g:i a',$ir['laston']);

$h->userdata($ir,$lv,$fm,$cm);

$h->menuarea();

[Mchl]

can you tell what var_dump($c); says?

[mastercjb]

I dont really have any idea. Its not on that page, but If I take $c out of that line it tells me it cant connect to the MYSQL using password NO. So do you think it could be connected to my config.php file some how?

[Mchl]

Please, just insert var_dump($c); somewhere before global $c; and also after it, and say what it displays.

[mastercjb]

I put it before and after and got this:

 

NULL NULL

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home/blt3/public_html/race.php on line 13

[Mchl]

Ok... so evidently $c is supposed to be a MySQL connection handle, but it is not. You should try to find if it is defined in your config.php, or perhaps headers.php.

 

Search for mysql_connect

[mastercjb]

I found this in my globals.php:

 

$db=new database;

$db->configure($_CONFIG['hostname'],

$_CONFIG['username'],

$_CONFIG['password'],

$_CONFIG['database'],

$_CONFIG['persistent']);

$db->connect();

$c=$db->connection_id;

[Mchl]

Ok..

 

Put var_dump($c); after $c=$db->connection_id; and tell what it says.

[mastercjb]

At the top of my globals.php I get this:

 

resource(5) of type (mysql link)

[Mchl]

That's good. Now we have to find out, why it is not visible in your race.php.

 

Is the line you have $c=$db->connection_id; inside a function?

[mastercjb]

Sorry I'm not good with terms, I just write. Here is my global.php file. Maybe you can see if it is in a function.

 

<?php
session_start();
ob_start();
if(get_magic_quotes_gpc() == 0)
{
  foreach($_POST as $k => $v)
  {
    $_POST[$k]=addslashes($v);
  }
  foreach($_GET as $k => $v)
  {
    $_GET[$k]=addslashes($v);
  }
}

require "global_func.php";
if($_SESSION['loggedin']==0) { header("Location: login.php");exit; }
$userid=$_SESSION['userid'];
require "header.php";

include "config.php";
global $_CONFIG;
define("MONO_ON", 1);
require "class/class_db_{$_CONFIG['driver']}.php";
$db=new database;
$db->configure($_CONFIG['hostname'],
$_CONFIG['username'],
$_CONFIG['password'],
$_CONFIG['database'],
$_CONFIG['persistent']);
$db->connect();
$c=$db->connection_id;
$set=array();
$settq=$db->query("SELECT * FROM settings");
while($r=$db->fetch_row($settq))
{
$set[$r['conf_name']]=$r['conf_value'];
}
$domain=$_SERVER['HTTP_HOST'];

global $jobquery, $housequery;
if($jobquery)
{
$is=$db->query("SELECT u.*,us.*,j.*,jr.* FROM users u LEFT JOIN userstats us ON u.userid=us.userid LEFT JOIN jobs j ON j.jID=u.job LEFT JOIN jobranks jr ON jr.jrID=u.jobrank WHERE u.userid=$userid");
}
else if($housequery)
{
$is=$db->query("SELECT u.*,us.*,h.* FROM users u LEFT JOIN userstats us ON u.userid=us.userid LEFT JOIN houses h ON h.hWILL=u.maxwill WHERE u.userid=$userid");
}
else
{
$is=$db->query("SELECT u.*,us.* FROM users u LEFT JOIN userstats us ON u.userid=us.userid WHERE u.userid=$userid");
}
$ir=$db->fetch_row($is);
if($ir['force_logout'])
{
$db->query("UPDATE users SET force_logout=0 WHERE userid=$userid");
session_unset();
session_destroy();
header("Location: login.php");
exit;
}
global $macropage;
if($macropage && !$ir['verified'] && $set['validate_on']==1)
{
header("Location: macro1.php?refer=$macropage");
exit;
} 
check_level();
$h = new headers;
$h->startheaders();
$fm=money_formatter($ir['money']);
$cm=money_formatter($ir['crystals'],'');
$lv=date('F j, Y, g:i a',$ir['laston']);
global $menuhide;
global $atkpage;
if($atkpage)
{
$h->userdata($ir,$lv,$fm,$cm,0);
}
else
{
$h->userdata($ir,$lv,$fm,$cm);
}
?>

[Mchl]

It seems like you should include this file into your script.

 

Try adding $require('config.php'); at top of your race.php

[mastercjb]

I put it in and got an error. Also I already have include "config.php"; in my race.php

[Mchl]

Sorry, I meant $require('global.php');

[mastercjb]

Its doubling my header so I took out a bunch of stuff however, it is putting my whole page inside the table on my race.php page. I think I might be able to take it from here. Thank you so much for the help.