Query problems

SquirrelJ

I am having trouble with the following query the error I am getting is

Warning: sqlite_query() expects at least 2 parameters, 1 given in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\swiftdist\website\database\loginsuccess.php on line 19

This is my query that is causing the problem

$sql = "SELECT u.name, u.username, u.currency, u.company, u.salescontact, c.company, c.orders2006, c.orders2007, c.sales2006, c.sales2007 FROM tblusers AS u, tblcompany AS c WHERE u.username = '$_SESSION[username]' AND c.company = '$_SESSION[company]'";
echo($sql);
$result = sqlite_query($sql);

Could someone please explain to me what the problem is??? And how I fix it???

Cheers

NogDog

As suggested by the error message and indicated by the [man]sqlite_query/man documentation, that function requires at least two parameters: the query string and the "dbhandle" which is returned by [man]sqlite_open/man.

SquirrelJ

[Changed [ code ] tags to [ php ] tags. -- NogDog]

Cheers I have now fixed that error by changing my query, but unfortunately it doesn't work

$result = sqlite_query($db, "SELECT u.name, u.username, u.currency, u.company, u.salescontact, c.company, c.orders2006, c.orders2007, c.sales2006, c.sales2007 FROM tblusers AS u, tblcompany AS c WHERE u.username = '$_SESSION[username]' AND c.company = '$_SESSION[company]'");

//check that at least one row was returned
$rowCheck = sqlite_num_rows($result);
if($rowCheck > 0){
while($row = sqlite_fetch_array($result)){

$logintext = <<<LOGINTEXT
<ul class="ulmembersdetails">
<li>Name: $row[name]</li>
<li>Company: $row[company]</li>
<li>Your last login was: {$_SESSION['timestamp']}</li>
<li>Your local sales contact is: <a href="mailto:$row[salescontact]"  class="centerlink">$row[salescontact]</a></li>
</ul>
LOGINTEXT;

The page works but it doesn't output any of my results to the page (so doesn't work really)

Where am i going wrong???

Cheers

NogDog

Try this pattern to make sure the query is valid:

$query = "SELECT u.name, u.username, u.currency, u.company, u.salescontact, c.company, c.orders2006, c.orders2007, c.sales2006, c.sales2007 FROM tblusers AS u, tblcompany AS c WHERE u.username = '$_SESSION[username]' AND c.company = '$_SESSION[company]'";
$result = sqlite_query($db, $query);
if(!$result)
{
   $error = sqlite_last_error($db);
   die(sqlite_error_string($error) . "<br />\n$query");
}

SquirrelJ

Yeah I have tried that code and it just prints out the same empty screen I deliberately changed a column name so that it was wrong and it brought up an error so the code as worked.

Is there a way now to put an else statement into the code and output what value as been received for each column name???

Something along these lines

$query = "SELECT u.name, u.username, u.currency, u.company, u.salescontact, c.company, c.orders2006, c.orders2007, c.sales2006, c.sales2007 FROM tblusers AS u, tblcompany AS c WHERE u.username = '$_SESSION[username]' AND c.company = '$_SESSION[company]'";
$result = sqlite_query($db, $query);
if(!$result)
{
   $error = sqlite_last_error($db);
   die(sqlite_error_string($error) . "<br />\n$query");
}
else{echo "$row{name}";}
exit;

Cheers for the help