I have a form that contains about 3 SQL calls to different tables with them all displaying the results. My last select statement which looks like:

$prod_id is taken from another table once the selected record has been chosen. (I have tried this select statement directly into MySQL and it works like a treat but it does not seem to work on the form). Am I missing something?

This code does not seem to be working in extracting any data. I get the error message saying that there is no data in the manufacturers table. But there is data in there, all 40 rows.

I've been round this problem all yesterday and today and still no joy.
Is there a limit as to how many queries you can make on one PHP page?

Michael.

__________________
Michael.

What happened when you echoed your SELECT on screen before executing it? i.e.
$query = "SELECT * FROM manufacturers WHERE manufacturers_id = '$prod_id'";
echo $query;
$result=mysql_query($query);

?

How are you retrieving $prod_id? Are you sure you're not asking to retrieve SELECT * FROM manufacturers WHERE manufacturers_id = ''?

I only ask, because, no: there's no limit to the number of queries per page.

Dan

When I echo the entire SELECT statement I get the following message:

Resource id #8

 
What do you mean by this, an empty single character?

Michael.

I am retrieving $prod_id from the following SQL statement;

$prod_id is one of the fields in the newsitems_options table holding the manufacturers_id number.

Well $result (or your equivalent of it) should be a Resource, but the querystring itself should be just a string of text. What I mean is, are you sure that $prod_id has a value, because if it hasn't PHP will swap-in '' (empty string) and you'll be searching for "manufacturers_id = ''".

By echoing the _actual_ string you are trying to execute, you'lll see if that's the case.

dan

hi Dave,

I have outputted the results before and after the SQL statement and there is data in the $prod_id but its the actual SQL that doesnt seem to be extracting the results as required.
I dont understand!

What do you mean by a Resource?

Michael.

A resource is a non-simple data type that PHP is using to reference something. A resultset is a resource, for instance, because you can navigate around in it and pull data from it. The SQL statement should have just been a simple type (a string), if you echo'ed you $query (or whatever variable name you are using to store your query) and got:

Resource id #8

Then something is definitely wrong.
Dan

hmmm.. ic.


Michael.