[Resolved] slect * from table where field = array()

[[deleted]]

$advquery = "select sum(pc_count) from placecount where pc_place = array($_POST[chosenoption])" ;

The above is my feeble attempt at trying to select the sum total of the field pc_count where pc_place = to an array.

The array is my problem. Ive hunted high and low for 2 hours now and was hoping that someone here would know how to do what Im looking to achieve.

I know my problem lies here somewhere ... pc_place = array($_POST[chosenoption]) but Im at an absolute loss as to how to achieve it.

I did think of trying

 where pc_place = ( $_POST[chosenoption[0]] OR $_POST[chosenoption[1]] ) 

but as the $_POST vars are of variable quantity I thought better of it.

Am I on the right track even?

Any help much appreciated.

[devinemke]

$advquery = 'SELECT SUM(pc_count) FROM placecount WHERE pc_place IN(' . implode(',', $_POST['chosenoption']) . ')';

[[deleted]]

Thanks for that, but it doesn't pull the result.

Returns an empty result set, even though I know for 100% certain that the $_POST['chosenoption'] variables have matching equivalents in the database table.

I also tried replacing IN with = and == but that didn't work either.
🙁

[xblue]

I'd recommend to keep with devinemke's suggestion, looks far more promising than the others to me 😉

you could add a call to
print_r($_POST['chosenoption']);
for debugging, and post what it returns.

it may also be helpful to print the query before executing it.

[[deleted]]

xblue this what it outputs

Array ( [0] => Auvergne [1] => Basse Normandie [2] => Bourgogne [3] => Bretagne [4] => Champagne Ardennes [5] => Lorraine )

All the above vars exist in the db table I'm referencing

I'd recommend to keep with devinemke's suggestion, looks far more promising than the others to me 😉

And for the record, I really do appreciate the feedback, when something doesn't work its reasonable to tweak and play. Sometimes it does the job, you know? 🙂

[xblue]

sorry, didn't mean to be cocky or something.

So both the array values and database entries are strings, not numeric id's? Then you'd most likely need to add singlequotes, like

$advquery = "SELECT SUM(pc_count) FROM placecount WHERE pc_place IN('" . implode("','", $_POST['chosenoption']) . "')";

(if that was the case, I'd normally would have expected a mysql error rather than an empty recordset, though.) 😕

[[deleted]]

Hey xblue, no problem, I didn't take it as cocky 🙂

Yes they are strings, Im a little ignorant when it comes to mysql and php interactions. Ive usually got by on simple select * from tablename etc type things.

I tried your version and unfortunately that didn't work either.

On the actual mechanics of it, would that query compare just the $_POST value eg. Auvergne against a db value of the same, or will it compare the literal string "[0] => Auvergne" ?

If its the latter then it won't work as the place names are in the db fields as Auvergne etc etc.

Is there a way i could fake the above query in phpmyadmin to test do you think?

[xblue]

no the array values are "Auvergne" and so on, the "[0] =>" simply is structural information on the array that print_r() returns along with it.

I'd try to

echo $advquery;

take a close look at it, and execute it via phpmyadmin.

[[deleted]]

Ill give that a try later and report back.

Thanks again. 🙂

[[deleted]]

Ok, tested in phpmyadmin using xblue's suggestion and bingo it worked, yet it doesn't when ran through the php page itself :bemused:

$advquery = "SELECT SUM(pc_count) as amount FROM placecount WHERE pc_place IN('" . implode("','", $_POST['chosenoption']) . "')";

$advcresult=mysql_query($advquery);

  $adv = mysql_fetch_array($advcresult);

  echo" $adv[amount] ";

[xblue]

umm, you do not use reserved words (which could have been a cause for phpmyadmin acting different) - actually I'm afraid I ran out of ideas 🙁 hopefully there is someone else to take over.

[[deleted]]

Thanks all the same guys, its certainly an odd situation. Back to the drawing board.

[[deleted]]

<hangs head in virtual shame>

An update on this. The reason why it didn't output to the browser was because.... I'd forgot to put the db connection inside the starting if() condition 🙁

</hangs head in shame>

Thanks for all your help guys 🙂

[xblue]

Just mark the thread as resolved and cheer up again - I bet things like that happen to everyone around here every once in a while 🙂