I can't seem to get this right. I've been searching here and other sites for an example similar to what I need to do, but no luck... unless I just didn't recognize it.
Anyhow, I would be greatful for an example for my scenario
Tables:
images:
imgid __ userid __ path
1 _____ 1 ______ ...
2 _____ 1 ______ ...
3 _____ 1 ______ ...
4 _____ 2 ______ ...
image_order:
imgid __ ordernum
2 _____ 1
3 _____ 2
1 _____ 3
I need something like this:
select all from images where userid=$var and select all from image_order where imgid and then order images by image_order.ordernum
I think it's probably simple enough...
Thank you in advance for your help.