Menu
Community /Pin to ProfileBookmark
@NogDogOct 17.2006 — #Here's a thought:
@NogDogOct 18.2006 — #It sounds like you get the gist of things. If the first query returned two rows with site values of "1" and "2", then the result of the implode() would be:
So, we're just popping that string into the where clause.
As far as the if question, you could use strpos():
Been a while…
…but I’m back with a headache maker.
[code=php]$recordset1 = mssql_query (“select distinct id from site where (name like ‘%$freetext%’) or (location like ‘%$freetext%’) or (state like ‘%$freetext%’)”, $handle);
while($arr1 = mssql_fetch_row($recordset1))
{
$recordset2 = mssql_query (“select * from object where site like ‘%$arr[0]%'”, $handle);
while($arr2 = mssql_fetch_row($recordset2))
{
echo “$arr2[0]”;
}
}
ok lets assume you have two “sites” US and Canada. So your first loop returns the id’s 1 and 2 (one for each site).
No you only have an object found both in US and Canada but because it’s embedded in the first loop it will display twice, but it should only display once.
If you want to check this code out, shoot me a pm and I’ll toss you the URL.
Let me know if you have questions, I’ll be happy to expand on anything that will you help me.
Sign in
to post a comment5 Comments(s) ↴
0
@NogDogOct 17.2006 — #Here's a thought:[code=php]
$recordset1 = mssql_query ("select distinct id from site where (name like '%$freetext%') or (location like '%$freetext%') or (state like '%$freetext%')", $handle);
$where = array();
while($arr1 = mssql_fetch_row($recordset1))
{
$where[] = "site like '%{$arr1[0]}%'";
}
if(count($where))
{
$whereClause = implode(' || ', $where);
$recordset2 = mssql_query ("select * from object where $whereClause", $handle);
while($arr2 = mssql_fetch_row($recordset2))
{
echo "$arr2[0]";
}
}
else
{
// handle error for no matches in first query
}
[/code]0
@NogDogOct 18.2006 — #It sounds like you get the gist of things. If the first query returned two rows with site values of "1" and "2", then the result of the implode() would be:<i>
</i>site like '%1%' || site like '%2%'
So, we're just popping that string into the where clause.
As far as the if question, you could use strpos():
[code=php]
if(strpos($totalrecords, $arr[0]) !== FALSE) // use !== not !=
{
[/code]