[wdvltalk] SQL query - one for Rudy :D (Joining same table twice)

2007-08-17 Thread David Precious
Morning all (and especially Rudy, the God of SQL :D), I'm struggling to figure out a way to join a table with itself to return a certain set of rows. First, the table: mysql describe servicedata; +---+---+--+-+-+---+ | Field | Type

Re: [wdvltalk] Missing image, then it's back...?

2007-08-17 Thread David Precious
David Precious wrote: Tris wrote: http://www.tlc-rewards.com/4462Dubli/ load this page, hit F5, and again... When I do that, I loose the top image... then it's back... I've tried a pragma-no-refresh meta thingy.. it does nothing... Hmm, any thoughts? Which image? If it's any help,

Re: [wdvltalk] SQL query - one for Rudy :D (Joining same table twice)

2007-08-17 Thread r937
I could do a join on this easily enough if was just comparing the value of the other row, but I'm struggling to see how to do what I'm after. if there are only these two conditions, then the easiest solution is a LEFT OUTER JOIN select yay.domain from servicedata as yay left outer

Re: [wdvltalk] SQL query - one for Rudy :D (Joining same table twice)

2007-08-17 Thread David Precious
r937 wrote: I could do a join on this easily enough if was just comparing the value of the other row, but I'm struggling to see how to do what I'm after. if there are only these two conditions, then the easiest solution is a LEFT OUTER JOIN select yay.domain from servicedata

RE: [wdvltalk] Missing image, then it's back...?

2007-08-17 Thread Cheryl D Wise
Any ad blockers on your system? Cheryl D Wise MS MVP FrontPage Foundation of Microsoft Expression Web http://by-expression.com -Original Message- Tris wrote: http://www.tlc-rewards.com/4462Dubli/ load this page, hit F5, and again... When I do that, I loose the top image... then

Re: [wdvltalk] Missing image, then it's back...?

2007-08-17 Thread r937
I tried to design my homepage... this is as far as I got... http://www.net-tastic.com what are you talking about? that design is fine! i would change the sequence of nav links, though, from portfolio contact about code home to home code portfolio about contact rudy � The

Re: [wdvltalk] Missing image, then it's back...?

2007-08-17 Thread Tris
Rudy you smoothy..! i was aiming for a left -- right nav style, which I was gonna reflect in the design... but I guess that might jsut confuse and annoy a propspective employer... Dont' wanna loose work for being funky! On 17/08/07, r937 [EMAIL PROTECTED] wrote: I tried to design my

Re: [wdvltalk] Missing image, then it's back...?

2007-08-17 Thread Tris
Hmm, just me then... that's good, hopefully the client will not see it! Design, LOL.. I'm rubbish at all that... in the Co I'm at, we have 3 teams.. the arty types, who photoshop a layout and make it all pretty etc.. the CSS whizes, who webify the photoshop files and me and our lot who make it

Re: [wdvltalk] Missing image, then it's back...?

2007-08-17 Thread PBC Web Design
At 05:38 AM 8/17/2007, you wrote: http://www.tlc-rewards.com/4462Dubli/ load this page, hit F5, and again... When I do that, I loose the top image... then it's back... I tried it several times in both FF and IE6. No loss of image for me. Did you create that great design? Very cool! I love

Re: [wdvltalk] Missing image, then it's back...?

2007-08-17 Thread David Precious
r937 wrote: I tried to design my homepage... this is as far as I got... http://www.net-tastic.com what are you talking about? that design is fine! Yup, clean and simple. If you're a developer, your site doesn't need to be all image-heavy pretty stuff, it can just be a nice, clean simple