open close db

mikeuk · July 19th, 2004, 11:04 AM

When retreiving data from 2 or more tables, do you need to open and close each query with

Code:

mysql_close($connection);

??

I have a 3rd table that is unable to match the data from a correct SQL statement that I have tested on it own.

Michael.

Daniel Walker · July 19th, 2004, 11:26 AM

Nope.

In fact, you don't _need_ to call mysql_close() at all. PHP's garbage collector handles all that for you on finishing each page/script/whatever. Not using mysql_close() just seems like the RAM-equivalent of fly-tipping, though, so people tend to use it.

mikeuk · July 19th, 2004, 11:43 AM

:) Hi Daniel,

I thought so.
From the previous query that I posted, I am now trying to call the id from manufacturers using the prod_id, using this statement;

Code:

SELECT * FROM manufacturers WHERE manufacturers_id = '$prod_id'

This works in SQL command but for some reason when calling from the main PHP page it falls into my error catch and outputs saying that there is not data in the manufacturers table.

The entire PHP is working still but not this bit...

Michael.

Daniel Walker · July 19th, 2004, 11:58 AM

First thing to try, then, is echo the query out in the browser immediately before you try and execute it. Even if it's not immediately apparent what's afoot, you can then cut&paste the query into the DB directly and see what it says to you. You retrieve the value of $prod_id from the $_POST array before using it in the query with something along the lines of: "$prod_id = $_POST['prod_id']", do you?

Either way, you can bet your boots it's not doing what you expect it to because it's doing exactly what you're telling it to. All you really have to do is work out what you are asking it to do, and all will be clear.

Dan