snowboardr
Programmer
I am doing a nested loop using MySQL database, basicly I have
loop1
- city, state, city1, city2, city3, state1, state2, state3
loop2
- city, state
movenext loop2
movenext loop3
Lets say loop1 has a city= 'Riverside', state='CA'
on loop two I would like to show all matches to Riverside first or matches to the other cities first. Cities are more important than states but states do take a factor.
Right now its working but it throws the important matches in the middle of the 10 results, because CA is part of the display criteria.
Thanks in advanced.
Jason
Site San Diego www.sitesd.com
loop1
- city, state, city1, city2, city3, state1, state2, state3
loop2
- city, state
movenext loop2
movenext loop3
Lets say loop1 has a city= 'Riverside', state='CA'
on loop two I would like to show all matches to Riverside first or matches to the other cities first. Cities are more important than states but states do take a factor.
Right now its working but it throws the important matches in the middle of the 10 results, because CA is part of the display criteria.
Thanks in advanced.
Jason
Site San Diego www.sitesd.com