[Resolved] Help

[momal_1]

Hi,

I am tryin to use this query to see if a member has an item already:

$checkQuery = $db->Execute("SELECT * FROM cart WHERE username = '$userName' AND stock_id = $mediaID");	
echo $checkQuery;
if ($checkQuery->recordcount() <> 0) {	
echo '<p align="center">YOU CURRENTLY HAVE THIS ITEM IN YOUR CART!</p><br>'.  

'<p align="center">PLEASE PRESS THE BACK BUTTON ON YOUR BROWSER TO SELECT ANOTHER ITEM!'; 
exit();
}

This works first time when there is no data in the cart table, but when there is data, this error comes up:

Fatal error: Call to a member function on a non-object in C:\Program Files\Apache Group\Apache2\htdocs\cart.php on line 47

Line 47 is this:

if ($checkQuery->RecordCount() <> '0') {

Can anyone help me?

Thanks

[laserlight]

It depends on your database abstraction layer.

For example, are you using:
$db->Execute(" ... ");
correctly?
i.e. this should return an object.
This object should have the member function RecordCount(), which returns an integer, or numeric string.

[momal_1]

Here is my new code:

$checkQuery = "SELECT * FROM cart WHERE username = '$userName' AND stock_id = $mediaID";
$chkRecordSet = $db->Execute($checkQuery);		
if ($chkRecordSet->recordcount() > 0) {    

echo '<p align="center">YOU CURRENTLY HAVE THIS ITEM IN YOUR CART!</p><br>'.  

'<p align="center">PLEASE PRESS THE BACK BUTTON ON YOUR BROWSER TO SELECT ANOTHER ITEM!'; 
exit();
}

and im still gettin the same error on the same line:

 if ($chkRecordSet->recordcount() > 0) {  

Thanks for your help

[laserlight]

You simply have to debug this yourself.

If I knew what was the underlying database abstraction layer, I could check it out, but I dont.

My suggestion:
create a test script, and work with it.

e.g.

<?php
//File: test.php

//set error reporting for debugging
error_reporting(E_ALL);

//include required files

//connect to database server
//select database

//instantiate $db object

$query = "SELECT * FROM cart";
$result_obj = $db->Execute($query);
echo "Count: " . $result_obj->recordcount();

//close the database connection, if necessary (usually isnt)
?>

[momal_1]

I have tried everything now and here is as far as i have got:

//variables

$idQuery = "SELECT member_id FROM customer WHERE username = '$userName'";
$recordSet = $db->Execute($idQuery);
$userID = $recordSet->fields['0'];
$mediaID = $_GET["mediaid"];

$totalQuery = "SELECT * FROM cart WHERE stock_id = '$mediaID'"; 
$totalResults = $db->Execute($totalQuery); 
echo "Count 1: " . $totalResults->recordcount();
$checkQuery = "SELECT cart.member_id, cart.Res_date, cart.Stock_id FROM cart WHERE cart.member_id ='$userID' AND cart.Stock_id='$mediaID'";
$result_obj = $db->Execute($checkQuery);	
echo "Count 2: " . $result_obj->recordcount();

And this is the output:

Count 1: 1
Fatal error: Call to a member function on a non-object in C:\Program Files\Apache Group\Apache2\htdocs\cart.php on line 54

(line 54 is ------ echo "Count 2: " . $result_obj->recordcount()😉

The first count is right as it shows there is 1 item of a partiulcar item number in.

The only thing i can thinkof is that the query is not correct. I have tried every combination. Can someone tell me if it looks ok?

Thanks

[/b]