 
Support Wrong Planet Awareness!
| View previous topic :: View next topic |
| Author |
Message |
aspergian_mutant
Learning to Walk
Joined: Oct 28, 2004
Posts: 1479
|
 Posted: Mon Apr 07, 2008 7:29 pm Post subject: |
 |
|
| LoL, yes I know, but if I made it more like actual code then most others would not understand it. |
|
| Back to top |
|
Tim_Tex
WP's Resident Simpsons and South Park Aficionado
Joined: Jul 03, 2004
Age: 28
Posts: 20883
Location: Central Texas
|
| Posted: Tue Apr 08, 2008 6:22 am Post subject: |
|
|
I like the idea regarding sorting by interests. Belief systems should come into consideration as well (but this is coming from a guy who bases liberal vs. conservative on whether or not someone believes in sex before marriage).
_________________
When you need something, that's a responsibility, that only an adult...of my maturity...Bunnies!!!
~Meatwad, Aqua Teen Hunger Force |
|
| Back to top |
|
0_equals_true
Quack!
Joined: Apr 06, 2007
Age: 26
Posts: 4725
Location: London
|
| Posted: Tue Apr 08, 2008 6:22 pm Post subject: |
|
|
| aspergian_mutant wrote: | | LoL, yes I know, but if I made it more like actual code then most others would not understand it. |
Sorry what I meant is you don't need that code, you don't filter the data once it has been retrieved. You just need to retrieve the users parameters either stored or through other inputs then retrieve the relevant data for that user.
Technically you can do it do it in a single SQL statement. However it so happens that the performance is better using two+.
That is the beauty of relational databases, there is little need for that logic that you put. Standard SQL does have operators but it works a bit differently from 'normal' code, although many versions of SQL are extended enabling it to behave in similar ways to 'normal' code. But in this case that is not necessary.
So the code that you need is database related and to make sure the parameters are transfered from the result of first statement (stored user parameters), plus any custom parameters to the next statement (data matching the parameters ), making sure it is valid and safe. Then to output the results in the desired format/template.
This is purely in relation to viewing matched personal ads. The entire application would be much more than that.
php is the scripting language. It is quite scrappy but it just about works. |
|
| Back to top |
|
aspergian_mutant
Learning to Walk
Joined: Oct 28, 2004
Posts: 1479
|
| Posted: Tue Apr 08, 2008 9:20 pm Post subject: |
|
|
Kewl, perhaps I should learn it
PHP, SQL, JAVA, HTML. |
|
| Back to top |
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
