knerdi
9:21
so i'm doing this
9:21
tell me if I'm doing it right
9:26
1. make sure the categories that were GETted are valid
2. SELECT * FROM categories WHERE category=$validcategory[0] and category=$validcategory[1]...
3. explode each $result[x] to get the picture_ids without the commas
4. combine all of these arrays using array_merge to get just the picture_ids in one array
5. get rid of duplicates
6. from here I can take these picture ids and grab the file name, width, height, and affiliate_id and then go over to the author db to get the descriptions and urls and titles
tallshaffer
9:26
yup
9:26
exactly
9:27
sounds right to me
knerdi
9:27
okay, now i'm having a problem
9:27
it is rtight
9:27
i drew it out
tallshaffer
9:27
i was going to do a join, but that works
knerdi
9:27
but i dont quite know how to combine all the arrays
9:27
first i have to write a loop to get all the category=$validcategory[0] and category=$validcategory[1]...
9:27
and the whole "and" part
9:27
thats a pain
tallshaffer
9:27
&& ?
knerdi
9:28
?
tallshaffer
9:28
ohhhh
9:28
okay
9:28
why can't you just do a regular for loop there
knerdi
9:28
to get the syntax of the sql_query?
9:28
the way I did it before seemed weird, but it worked.
tallshaffer
9:29
for($i.....etc){sql(select from blah where cat=category[$i])}
knerdi
9:29
oh yes
9:29
that'd work better i think
9:29
umm
9:29
let me think
tallshaffer
9:29
k
knerdi
9:30
so i'd be doing a ton of queries
tallshaffer
9:30
yup
9:30
that's why fast servers are good to have
9:31
let's hope hostgator can handle it
knerdi
9:31
and how could i get all the results out of it in an array?
9:31
what I need is $result[0] to give me 1,2,5,8,9 or whatever
9:32
how do i get the array made while in a for loop?
tallshaffer
9:35
make the array before the loop
9:35
like $jews = new array();
9:35
and then just do $jews[] = $sqlresult;
9:35
each time, it'll automatically put it in the right place
9:35
or $jews[$i] = $gaschamber
knerdi
9:35
ok
9:35
new array();
9:35
is that the right syntax?
tallshaffer
9:35
i think so
9:35
should be
knerdi
9:36
ive got it somewhere i can find it
tallshaffer
9:36
if not just array();
9:36
ok
knerdi
9:36
its just array();
9:36
okay, we will test this out
9:36
one i get this done the site is ready
9:36
and then i just need content
9:37
well, i've also goto to write a privacy policy and contact form, and then do something with the breadcrumbs
9:37
but other than that, thats it
9:37
i'm going to try to get it all done tonight
9:37
after i poop first.
9:37
brb