[Resolved] weird: ERROR 1146

[phence]

I am getting this error when trying to query a table called ''listings".
Error 1146 : Table 'listings.listings' doesn't exist

this is my query statment:

$query = "SELECT * FROM listings WHERE (id) = ('$id')";

i don't under stand why it is looking for "listings.listings" ??
where is the extra " .listings " comming from?

thanks for any help!

[stolzyboy]

can we see more of your code, nothing looks wrong to me in that query

[phence]

here's the code concerning... Thank-you

<?php 
				// Initialize the session
    			session_start();    

			// Process the search parameters. 
			// If a searchValue is passed as a GET parameter, use it. 
			if (!empty($_GET['ID']))
				$catid = clean($_GET['ID'], 30);

			// Load offset
			if (!empty($_GET["offset"]))
				$offset = clean($_GET["offset"], 5);  
			else
				$offset = 0;

			// Register the search criteria if needed
			if (!session_is_registered("sessionCatID")){
				session_register("sessionCatID");
			}

			// Save the search criteria
			$_SESSION["sessionCatID"] = $catid;

			// collect db data
			require '/home/user/www/test/includes/lstdb.inc';

			// Open a connection to the DBMS
			if (!($connection = @ mysql_pconnect($hostName, $username, $password)))
    			showerror();

			if (!mysql_select_db($databaseName, $connection))
				showerror();

			// Build the query using the search criteria
			$query = "SELECT * FROM listings WHERE (cat_id) = ('$catid')";

			// This is used to encode the search parameters for embedding
			// in links to other pages of results
			$browseString = "$catid=" . urlencode($catid);
			$scriptName = "catman.php";

			// Listing Display 
			// Show the user the Listings Under Thier Choosen Category
			showListings($query, $connection, $offset, $scriptName, $browseString);
		 ?>

[stolzyboy]

what is the showListings thing doing at the very bottom?

[phence]

collects data from another database and displays it for the user.

[clandestine555]

hrm, i dont see where you mysql_select_db();

[stolzyboy]

try changing this

// Open a connection to the DBMS
                if (!($connection = @ mysql_pconnect($hostName, $username, $password)))
                    showerror();

            if (!mysql_select_db($databaseName, $connection))
                showerror();

to this

// Open a connection to the DBMS
$connection = @ mysql_pconnect($hostName, $username, $password) or die(mysql_error());
$db = mysql_select_db($databaseName, $connection) or die(mysql_error());

[phence]

nope, no change in error....

thanks for helping. any one have a solution or atleast a reason this is?

[matt_4013]

What's in $databasename? That's what it's looking at. It seems that you've selected the databasename as listings, which is why it's doing this.