Two or more conditions in a where statement

[Asheeown]

I'm building a page for a customer to search every log from their ID.  When they login the ID is set to a session, However the customer may have two or more IDs so that sessions for example would be "000500,000501"  now what I want to do is search in the table "rated_cdrs" to match "000500" and "000501" to the column "Originating_TG" in that table, any idea on how to?

[effigy]

You can store the ids in an array, or use split to turn the string into one. After you have this, use indexes 0 and 1 in your SQL.

[Asheeown]

The ID's in the session are separated by a comma so I can explode that, but what do you mean by the 0th and 1st index in my SQL?

[effigy]

Use the pieces of the array (exploded string) in your SQL.

[Asheeown]

Well I'm trying to call the logs for the Id(s) in session so how would my where statement go if I were to have more than one Id to get logs for?

[effigy]

Since your ids are already separated by a comma, drop them in an [b]IN[/b]:

[code]
<pre>
<?php
$ids = array (
'1',
'1,2',
'1,2,3',
'111',
'111,222',
'111,222,333',
);
foreach ($ids as $id) {
echo "SELECT ... WHERE id IN ($id)<br>";
}
?>
</pre>
[/code]

Are the leading zeros important?

[Asheeown]

Yeah the leading zeros are part of the Id in both tables

[effigy]

[code]
<pre>
<?php
$ids = array (
'1',
'1,2',
'1,2,3',
'111',
'111,222',
'111,222,333',
'0005000',
);
foreach ($ids as $id) {
$id = preg_replace('/(\d+)/', '"\1"', $id);
echo "SELECT ... WHERE id IN ($id)<br>";
}
?>
</pre>

[/code]

[Asheeown]

I got it, thanks very much for your expertise