[wdvltalk] Mysql Query help!

Hi all... I've not been here for AGES... but I hope many of you trusted clever people are still out there... I need help! ;-p I'm building a shop for a client. I've got 3 tables I'm trying to talk to. products stock categories - Each product can be flagged with any numebr of cateogories using

[wdvltalk] MySQK query takes 24 seconds!! help me! :-(

is there, as I add a few extra filters on when the user refines their search later.. Anyhoo, here's my query and table structure... I've been using MySQL for a few years now, but never anthing this 'complicated' any advise would help me learn alot!! Tris... SELECT distinct

Re: [wdvltalk] MySQK query takes 24 seconds!! help me! :-(

this is awesome.. I've always wanted to learn JOIN(s) I'll take a look cheers!!! On 20/10/06, r937 [EMAIL PROTECTED] wrote: three things: 1. your query is incomplete, some join conditions are missing 2. your tables are missing indexes on the join columns 3. LIMIT makes no sense without

Re: [wdvltalk] MySQK query takes 24 seconds!! help me! :-(

Sorry, I spotted it..!! never mind ;-p On 20/10/06, Tris [EMAIL PROTECTED] wrote: this is awesome.. I've always wanted to learn JOIN(s) I'll take a look cheers!!! On 20/10/06, r937 [EMAIL PROTECTED] wrote: three things: 1. your query is incomplete, some join conditions are missing 2

Re: [wdvltalk] MySQK query takes 24 seconds!! help me! :-(

LOL... I've missed you guys!!! I'm learnign...!!! ;-p On 20/10/06, David Precious [EMAIL PROTECTED] wrote: Hiya Tris, Hi there, I've built my first shooping basket.. yey me! Congrats! :) However the search results page takes ages. the query checks stock levels, and gender (mens, womens

[wdvltalk] MySQL query takes 24 seconds!! help me! :-(

Finally... How can I filter on products... (there's a 1/0 field in the products table, that flags if the product is ethically made.) how can I add a 'WHERE product.ethical = '1'? I tried just before the first inner join, but I got an error... Here's my query: SELECT distinct

Re: [wdvltalk] MySQL query takes 24 seconds!! help me! :-(

how can I add a 'WHERE product.ethical = '1'? by adding it after the FROM clause, just before the ORDER BY clause I tried that, but it caused an error... Here's my query: SELECT distinct products.id, try it without DISTINCT Cause duplicated galore! inner join categories as child

Re: [wdvltalk] MySQL query takes 24 seconds!! help me! :-(

I shoudl really learn myself.. let me paly, and if still can;'t get it, I'll be back on Monday.. with more info... Cheers for your help though!!! On 20/10/06, r937 [EMAIL PROTECTED] wrote: I tried that, but it caused an error... then you added it in the wrong place, and unfortunately my

Re: [wdvltalk] MySQK query takes 24 seconds!! help me! :-(

= products.brand order by products.id === On 20/10/06, Tris [EMAIL PROTECTED] wrote: this is awesome.. I've always wanted to learn JOIN(s) I'll take a look cheers!!! On 20/10/06, r937 [EMAIL PROTECTED] wrote: three things: 1. your query is incomplete, some join conditions

[wdvltalk] SQL query now taking 1 second...

this makes sense -- prodcatmatch is a many-to-many relationship table that joins products to categories My categories table has several 'types'. 2 = size 3 = Country 5 = category description (fashon tshirt, vneck etc) so I'm having to puick out category AND size so that's why I'm

Re: [wdvltalk] Web login system - best approach

Try this: http://www.freewebmasterhelp.com/tutorials/phpmysql A quick google will rpovide literally 100's of other tutorials... I leant from books myself, but the info is the same... Good luck, and once you get going and have specific questions... we're here for you...!!! Tris... On 06/11

Re: [wdvltalk] Web login system - best approach

Where are you based..? I've got a few books here, that I learnt from... One in perticular is VERY basic, but it sent me on the fast track to understanding what's what.. I'm in London and will happily sned it to you...? On 06/11/06, Ross Clutterbuck [EMAIL PROTECTED] wrote: Thanks Drew and Tris

Re: [wdvltalk] iPod question

I'd recommend going to watch the south park episode that touches on file shharing and piracy... Makes you think, but then it always does! Tris... :-) Riva Todd Richards wrote: Yeah, but she said brother-in-law, so technically it's family right??? ;-) As Ross stated, I'm sure that Apple

[wdvltalk] Prinitng multiple pages...

of data fom the databsae... I can simply open up all teh windows, and asign a pronty button to each of them.. but if there's 100+ orders per day, that's a pain in the arse... Anyhoo... any ideas? Tris... � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto

Re: [wdvltalk] Prinitng multiple pages...

css can force page brakes??? cool.. off to google for me... On 10/11/06, David Precious [EMAIL PROTECTED] wrote: On Fri, 10 Nov 2006, Tris wrote: all the order info is taken from the database, and I've got a template, but I don't know how to print rages of data fom the databsae... I can

Re: [wdvltalk] SQL - picking out data where duplicates exist...

No, it did work.. but my trest data didn't have what I'd described.. Company x only had 4 offices in one city.. so I've added a few fake offices and it filters! Phew!!! cheers... Final Query === SELECT company.company_id, company.company_name, company.website,

Re: [wdvltalk] Form box question

input type=text name=fieldName value=text to be removed onclick=javascript: document.formName.fieldName.value = ''; try that... On 15/11/06, Portman [EMAIL PROTECTED] wrote: Hi all, Does anyone know how you create a form so that some text appears in the box (for example Name) and when you

Re: [wdvltalk] Form box question - RESEND (first one didn't go through)

input type=text name=fieldName value=text to be removed onclick=javascript: document.formName.fieldName.value = ''; try that... On 15/11/06, Portman [EMAIL PROTECTED] wrote: Hi all, Does anyone know how you create a form so that some text appears in the box (for example Name) and when you

[wdvltalk] PHP date - get last month, and loop to last year..

I've got a date function using: Y-m eg: 2006-11 (for today) I want to get last month (2006-10) etc, and when I hit JAn, loop to 2005-12 .. Is this easy? (I'm displaying competition entries, and previous months entries.. but when I hit Jan, I want Dec to be in the list...) Any ideas? Tris

Re: [wdvltalk] Stupid vouchers...

, I'm gonna drastically change my naming convention.. Sigh,,, On 22/11/06, Matthew Macdonald-Wallace [EMAIL PROTECTED] wrote: Quoting Tris [EMAIL PROTECTED]: Hey all.. I've been asked to NOT charge delivery on a shopping cart I've built, if the product purchased is a gift voucher

[wdvltalk] FCKEditor...

tried to use stripslashes, but nothing.. Has anyone else seen, and resolved this issue with this editor? Tris... � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com

[wdvltalk] Getting corresponding fields from MySql, when using GROUP BY...

MySql, I love it... I'm building an asset management system.. I've got an asset table, with basse info, and a version table, where each susperceeded version of an asset sits. When I do a call to get a list of assets, and the latest version number, I'm having probs.. I can get the last version

Re: [wdvltalk] Getting corresponding fields from MySql, when using GROUP BY...

Cool.. I've in my head that group by is the same as distinct in the select part of the query.. When I only want results of one type... Is that right? On 23/11/06, r937 [EMAIL PROTECTED] wrote: Am i being a tool??? yes, for you have failed to grasp how GROUP BY works;o) the reason you

Re: [wdvltalk] Getting corresponding fields from MySql, when using GROUP BY...

Ooooh... SO is one better than the other, from a speed perpective...? On 23/11/06, r937 [EMAIL PROTECTED] wrote: I've in my head that group by is the same as distinct in the select part of the query.. When I only want results of one type... Is that right? yes, GROUP BY is the same as

[wdvltalk] CSS print.. putting an element at teh bottom of a page...

Um my title kinda says it all... I'm grabbing a bunch of info to put in an invoice, and my client wants to ahve the total and delivery at teh botoom of teh printed page... How can I force a div to the bottom of the page...? � The WDVL Discussion List from WDVL.COM � To Join wdvltalk,

Re: [wdvltalk] Stupid vouchers...

I've been told.. ;-p I will I will.. ;-p Sigh, soo tired, AND I just ran out of coffee!!! Fridays eh? On 24/11/06, David Precious [EMAIL PROTECTED] wrote: On Wed, 22 Nov 2006, Tris wrote: It did dawn on me that I've got Global varaibles ON.. If you mean register_globals, I'd *strongly

Re: [wdvltalk] Paper sizes

http://www.cl.cam.ac.uk/~mgk25/iso-paper.html Wuite useful.. and John, Awesome name, love your movies..! On 24/11/06, John Hughes [EMAIL PROTECTED] wrote: A4 is 210mm by 297mm if that's any help. J. -Original Message- From: Portman [mailto:[EMAIL PROTECTED] Sent: 24 November 2006

Re: [wdvltalk] Moral question

If that person signed a legally binding agreement to provide monies over time for an agreed sum of good and or services, then she's obliged to pay. BUT.. If the money in question is under a certain amount, many comapnies write it off.. saying that When I was 19 I signed up for one of those 'buy

[wdvltalk] Cookie warning...

.. off to google now.. Tris... � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription

[wdvltalk] [OT] remote connections?

is this possible? I've tried: \\123.123.123.123\myComputerName\shareName\ (I've got several PC's on my home IP) but it doesn't work...? Do I need to open up a specific port on my router at home, or is this just not possible..? It'd just make copying files to theoffice ALOT easier!! ;-p Thoughts? Tris

[wdvltalk] pulling one row where it matches in another table, many times... MySQL

I wanna holiday!!! I've an asset table: id name fileSize date and an options table: id name and finally a table to match them up assetPropertyOption: assetId optionId I want to pull all assets that appear in the match table, based on what options I ask for.. I can do it for ONE option, but

Re: [wdvltalk] pulling one row where it matches in another table, many times... MySQL

LOL... funny cause it's true.. he's pretty much saved my arse too any time sthis month.. MUST repay him soon!!! On 04/12/06, Drew Trusz [EMAIL PROTECTED] wrote: On 12/4/06, Tris [EMAIL PROTECTED] wrote: I wanna holiday!!! I've an asset table: id name fileSize date and an options

Re: [wdvltalk] pulling one row where it matches in another table, many times... MySQL

in the know to hand hold me :-( Cheers, I'll report back my progress shortly..!!! Tris... On 04/12/06, r937 [EMAIL PROTECTED] wrote: I need to say, optionId = 1 AND (4 or 6 or 6) etc... that's what the HAVING clause does ;o) I don't understand whats happening at teh bottom of the query

Re: [wdvltalk] pulling one row where it matches in another table, many times... MySQL

Ok, So when I put my WHERE clause, just before GROUP BY, it gets an error... What was SELECT 1 all about, I've never seen that before... Trying to tweak! Yoda man still! On 04/12/06, r937 [EMAIL PROTECTED] wrote: I tried to adda region filter, which is in a table jsut liek the option

Re: [wdvltalk] pulling one row where it matches in another table, many times... MySQL

And I've got it... (well, it'd be close to say you've got it, but you know ;-p ) I've learnt another little string to the sql bow, cheers again Rudy.. Now if I can just remember it!!! ;-p On 04/12/06, r937 [EMAIL PROTECTED] wrote: Ok, So when I put my WHERE clause, just before GROUP BY,

Re: [wdvltalk] [OT] remote connections?

Tris, On Thursday, November 30, 2006, 11:57:06 AM, you wrote: T I'm on site this week (I work at home normally) T and I'm using remote XP to connect to my home pc to pick up code T samples etc, FTPing them to my server, and then picking them up here, T in the office.. T bt... T I'd

[wdvltalk] html emails.. grrr..

...??? Tris... � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add

[wdvltalk] Creating zips in php...

created? At least tht way, the user will be given the download prompt early... Any other ideas are welcome...!!! Thoughts? Tris... � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e

Re: [wdvltalk] Link in plain text e-mail

Many clients interpret links that are full 'http://www.site.comn/link.html' etc So just ake sure all links are ful and correct.. you cannot use the A tag.. :-( On 11/12/06, Portman [EMAIL PROTECTED] wrote: Hi all, How does a person get a link into a plain text e-mail? I am assuming that it

[wdvltalk] Creating zip files in PHP that are HUGE!

if there was too much load? 3. Any other ideas for creating large zips on teh fly..?? Tris... (I'm currently trying to create them and email a link) � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e

[wdvltalk] Adding 15 mins to PHP time...

be easiy once I kno whow to knock off time from um, well, time :-p ) Thoughts? Tris... � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your

[wdvltalk] Fetching rows 5 above and 5 below a target row...

Monday morning hard... :-( Tris... � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change

Re: [wdvltalk] Fetching rows 5 above and 5 below a target row...

Wow.. i want to curl up and die.. That's insane! What's more scary is that you probably looksed it for 1 minute and knew what to do.. You're a clever clever man.. Tris... On 18/12/06, r937 [EMAIL PROTECTED] wrote: Is this easy no it is not select userName , score from resultsTable

Re: [wdvltalk] Fetching rows 5 above and 5 below a target row...

areas of data: Your current score the top 5 scorers your place relative to all users... it works great, with me and my 5 testers.. I wonder how it'll hold up to several 1000 users... eek! Tris... On 18/12/06, Cheryl D Wise [EMAIL PROTECTED] wrote: Yep, it is scary what someone who is really good

[wdvltalk] Flash not 'compiling' on FF...?

I know compiling is not the correct term, but bear with me ;-p I've discovered http://www.maani.us/ and am in love.. I'm using their cahrt generator, with some dynamically generated XML to create it. the flash file looks for an xml file (a php file in reality, but layed out as an SML to the

[wdvltalk] PHP ?

Another PHP developer near me, has jsut asked what the PHP function is where you can out put text 'like' this: = ABC My text will interpret $randomVariable into whatever it is set to ABC = I've nop idea, but he's convinced there's something like ths called escape

Re: [wdvltalk] PHP issue with creating new instance of a class

help, but I'll keep thinking... Tris... On 03/01/07, Matthew Macdonald-Wallace [EMAIL PROTECTED] wrote: Morning all, Has anyone ever come across an issue in PHP where all the pages except one can create a class properly? My site is sup as follows: class page contains all the information about

[wdvltalk] FF table padding?

http://w03-joshua.exalia.net/BrainPower/ On the above URL in FF, the display table has gaps.. but on IE.. it does not? Can anyone explain why? (I know I know, tables are bad.. though I've never really understood why...) Tris... -- When a person can no longer laugh at himself, it is time

Re: [wdvltalk] PHP issue with creating new instance of a class

Fatal error: Cannot instantiate non-existent class: newsroom in /usr/local/psa/home/vhosts/wepoweryour.net/httpdocs/includes/page.class.php on line 27 What IS on line 27, or 26? On 03/01/07, Matthew Macdonald-Wallace [EMAIL PROTECTED] wrote: Tris, Quoting Tris [EMAIL PROTECTED]: Hmmm... I

Re: [wdvltalk] PHP issue with creating new instance of a class

don't be so hard on yourself.. I had an afternoons work wasted cause I was calling an sql statment... named sal.. not sql... could not figure that one out for ages... :-( On 03/01/07, Matthew Macdonald-Wallace [EMAIL PROTECTED] wrote: Quoting Tris [EMAIL PROTECTED]: Fatal error: Cannot

[wdvltalk] FF flash... or xml..

, it just hangs and hangs til it times out.. the XML doc that feeds it is here: http://w03-joshua.exalia.net/BrainPower/sample.php Any brain storms as to why FF says 'I don't like it' (in my best northern UK accent)? Tris... -- When a person can no longer laugh at himself, it is time for others

Re: [wdvltalk] FF flash... or xml..

Oh yeah, bugger... I'd updated that page... http://w03-joshua.exalia.net/BrainPower/homeMaster.php login, then paste this URL... Sigh.. is it Friday yet?? On 04/01/07, Drew Trusz [EMAIL PROTECTED] wrote: On 1/4/07, Tris [EMAIL PROTECTED] wrote: Ello all.. I've got an XML fed flash chart

Re: [wdvltalk] FF flash... or xml..

Ok, go back to home, and there's a link in the main body (I've just added it..) That DEFFO goes to the flash file... REALLY sorry about this, I should've set up a test site else where whil I was working on this one.. Tris... On 04/01/07, Drew Trusz [EMAIL PROTECTED] wrote: On 1/4/07, Tris

[wdvltalk] PHP 3rd party sessions...

??? (this is keeping us in the office till we get it.. .on a FRIDAY :-( ) Tris.. -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web

[wdvltalk] PHP erros on..

I've just put a site I've built onto mybosses localhost... He ges LOADS of errors.. I don't.. sooo, how can I turn on all errors, so tat I can ensure I can clean all the code to be super good! I've looked at PHP.ini and i've got it on as far as I can see.. i think...? Tris... -- When a person

[wdvltalk] PHP and declaring variables...

the undeclared variables 'bug' without having a list of blank variales at the top of each page...? For now.. i'm off to browse the google... the wonderful goodle of web... (bad wizard of oz rip off, sorry) Tris... -- When a person can no longer laugh at himself, it is time for others to laugh at him

[wdvltalk] PHP, 8 digit string, to 8 item array..

? Tris... -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com

[wdvltalk] PHP: is_numeric... that's the question...

Hi all... I'm having probs with is_numeric... here's the body of a function I've written... the inout shoud be: 2 x letters 5 x numbers eg: fr23454 / kr5 / AP84754 Bt... these are coming up as valid too? F454354 / 4G64345 / L454345 it seems that if there's a single number in the

[wdvltalk] [OT] - Freelance/contractors Accounting software...

keeping? Any advise, suggestions on the whole process are welcome, and I'd liek to get started as soon as possible! Tris... -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk

[wdvltalk] [PHP] reformat date...

Simply put, I'm REALLY hungover, and want to die... However, before I go home.. I have to convert: (string)3/MAY/07 -- (date for MySQL)2007-05-03 google is confusing me... NEVER drinking again. Tris... -- When a person can no longer laugh at himself, it is time for others to laugh at him

Re: [wdvltalk] [PHP] reformat date...

sorry, it's for inclusion into a db.. so I need to convert the date before I create my MYSQL satement... On 25/01/07, r937 [EMAIL PROTECTED] wrote: (string)3/MAY/07 -- (date for MySQL)2007-05-03 select str_to_date('3/MAY/07','%e/%M/%y') from daTable... ;o) � The WDVL

[wdvltalk] onchange.. my aunt!

, Tris... -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com

Re: [wdvltalk] onchange.. my aunt!

was talking to that.. so I've renamed it to submitIt... and all is well in the universe again... Thanks for all the brain power though guys... you rock! On 30/01/07, David Precious [EMAIL PROTECTED] wrote: On Tue, 30 Jan 2007, Tris wrote: I've got a form.. (a form!) that s giving me grief.. I want

Re: [wdvltalk] verification emails

yes! i am... On 30/01/07, Linda Cole [EMAIL PROTECTED] wrote: Hi Gang, I've set Peter's account to get mail; is anyone getting the verification emails when you post to the list? Thanks, Linda -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.432 / Virus

[wdvltalk] [PHP] DEFINE Vs $variable..?

Hi all... I've a 'help me learn' type question.. I've got to do a site in 2 languages... My first thought was to simply set a session variable for each language, and then have an include page like this: if lang == english then $textWelome = Welcome; else if lang == chinese then $textWelome = Ni

[wdvltalk] PHP date month list...?

Why doesn't this 'function' output a list of months? for ($h = 1; $h = 12; $h++) { $monthNo = date(m, $h); $monthName = date(M, $h); $flightdateListMonth .= option value=\ . $monthNo . \ . $monthName . /option; } H... I know I'm missing something obvious... --

[wdvltalk] [MySQL] - REPLACE or INSERT IGNORE

(`emailAddress`, `signUpDate`) VALUES('[EMAIL PROTECTED]', '2007-01-14 11:42:24') and yet it's still duplicating the data Duplicates are unlikley, but I'd like to be safe... Anyone care to tell me what I'm doing wrong? Tris... -- When a person can no longer laugh at himself, it is time for others

Re: [wdvltalk] [MySQL] - REPLACE or INSERT IGNORE

And THAT... is why they pay Rudy the big bucks.. It was an index, not unique.. Cheers!!! On 27/02/07, r937 [EMAIL PROTECTED] wrote: Anyone care to tell me what I'm doing wrong? probably forgot to declare a primary or unique key rudy http://r937.com/ • The WDVL Discussion List from

[wdvltalk] Cannot delete csv... so let's edit it?

is fine by me... any idea? Back to google! Tris... -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http

[wdvltalk] PHP Sessions and Frames...

off client on a Mondya morning... i just LOVE them! ;-p Tris... -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web

[wdvltalk] [PHP] Hitting a URL from within a function, but NOT directing the browser there...

times, in the back end of my function. So, how can I hit a URL, without going there in teh browser? the mind boggles on this Monday morning..!!! Tris... -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from

[wdvltalk] Stupid ol..

Well, back to HTML basics for me today... http://www.tlc-rewards.com/5629JustinBridou/terms.html Has an ol tag and a few items... However, it's not showing a n ordered list... Did someone retire that tag and not tell me... I normally get all the memos... ideas? -- When a person can no longer

Re: [wdvltalk] Stupid ol..

Fixed now... Aren't you in Canada...? What you doing up at this hour!!! ;-p On 29/03/07, r937 [EMAIL PROTECTED] wrote: http://www.tlc-rewards.com/5629JustinBridou/terms.html Has an ol tag and a few items... However, it's not showing a n ordered list... looks fine in IE6 rudy • The

[wdvltalk] First Monday bug...

i'm trying to create a drop down tht contains the first Monday of each week, including the current week. From the function, I need to out put 2 bits of data: 1. the date in a happy DB compliant manner (-MM-DD) 2. the date in a user Friendly way (2nd April etc) Can a function even output 2

[wdvltalk] Joining tables... in MySQL

Hi Rudy.. I mean everyone ;-p i've two tables: JobType id (int) name (varChar) Jobs id (int) user (int) week (date) day (int) jobNo (int) jobType (int) hours (int) I want to list all job types, and IF there's any corresponding with the jobs table, I want to marry them up. I've used this:

Re:[wdvltalk] Joining tables... in MySQL

, 0, 0); INSERT INTO `jobs` VALUES (12, 0, '2007-02-19', 0, 0, 0, 0); On 04/04/07, Tris [EMAIL PROTECTED] wrote: Hi Rudy.. I mean everyone ;-p i've two tables: JobType id (int) name (varChar) Jobs id (int) user (int) week (date) day (int) jobNo (int) jobType (int) hours (int) I want to list all

Re: [wdvltalk] Joining tables... in MySQL

Rudy, I knew you'd be there somewhere ;-p it's odd... I'd tried that, and just got one row of results. Still do... It's going through the jobs table and only returning jobTypes that have been flagged in jobs.. not ALL job types... any other ideas? On 04/04/07, r937 [EMAIL PROTECTED] wrote:

Re: [wdvltalk] Joining tables... in MySQL

Ah, i'm on 4.1.11 that make a difference? On 04/04/07, r937 [EMAIL PROTECTED] wrote: It's going through the jobs table and only returning jobTypes that have been flagged in jobs.. not ALL job types... i tested the LEFT OUTER JOIN on the data you supplied and it works ~fabulously~ maybe

Re: [wdvltalk] Joining tables... in MySQL

:-( Here I go again... it really doesn't work... ? :-( SELECT jobType.name, jobs.user, jobs.jobNo, jobs.jobType, jobs.hours, jobs.day FROM jobType LEFT OUTER JOIN jobs ON jobs.jobType = jobType.id WHERE jobs.id IS NULL OR ( jobs.user = '4' AND jobs.week = '2007-03-19' AND ( jobs.day = '3' OR

Re: [wdvltalk] Joining tables... in MySQL

OHHH!!! Makes sence... Cheers Rudy... as ALWAYS!!! (I'd kiss you, but that'd be a bit too fruity for my taste... not that there's anything wrong with that!) On 04/04/07, r937 [EMAIL PROTECTED] wrote: Here I go again... it really doesn't work... ? :-( yes it does, but you have to be really

[wdvltalk] [OT] - I'm not a flash fan, bu tI've fallen in love with this...

http://www.gourmetoriental.com/ I'm probably the last to see this kinda thing, but I thought it was awesome... Love to see more of this kinda thing... Um, that's all, it tickled me... had to share... Tris... -- When a person can no longer laugh at himself, it is time for others to laugh

[wdvltalk] WAY [OT] - Google homepage...

Mines reverted back to 'factory settings' All my bookmarks and custom modules are gone... :-( Is it just me, or are there other people stuck? -- When a person can no longer laugh at himself, it is time for others to laugh at him. Thomas Szasz � The WDVL Discussion List from WDVL.COM �

Re: [wdvltalk] WAY [OT] - Google homepage...

rght ;-p On 26/04/07, r937 [EMAIL PROTECTED] wrote: All my bookmarks and custom modules are gone... :-( what happen someone set up us the bomb we get signal what! main screen turn on it's you !! how are you gentlemen !! ALL YOUR BOOKMARKS AND CUSTOM MODULES ARE BELONG TO US

Re: [wdvltalk] WAY [OT] - Google homepage...

party and just make my own homepage and calender setup...??? On 26/04/07, Linda [EMAIL PROTECTED] wrote: Mine has gone too :-( Linda -Original Message- From: Tris [mailto:[EMAIL PROTECTED] Sent: 26 April 2007 12:22 To: wdvltalk@lists.wdvl.com Subject: [wdvltalk] WAY [OT] - Google

Re: [wdvltalk] WAY [OT] - Google homepage...

, Linda [EMAIL PROTECTED] wrote: Mine has gone too :-( Linda-Original Message- From: Tris [mailto:[EMAIL PROTECTED] Sent: 26 April 2007 12:22 To: wdvltalk@lists.wdvl.com Subject: [wdvltalk] WAY [OT] - Google homepage... Mines reverted back to 'factory settings' All my bookmarks

[wdvltalk] Lazy PHPMyAdmin Question....

I've got a list of codes that I wanna import into a database (65k of them) can I import that list withough adding 'INSERT INTO `code`' etc... I've got a script that I can use, but I can't find it.. and i'm lazy... does PHPMyAdmin let you just dump a list? -- When a person can no longer laugh

[wdvltalk] A form in an HTML email?

si it possible to hav a form in an HMTL email? My current employer wants to send out a sutrvery to its staff. (I say survey, it's jsut a textarea box for comments) Can we have a box and submit button that talks to a web page? Clearly we'll have a link to a page with teh form on also, but this

[wdvltalk] FF Vs IE?

http://www.getpracticing.com/index2.php5 the flash blurb on this page is opaic? Any ideas why...? -- `We are what we pretend to be, so we must be careful what we pretend to be.` Kurt Vonnegut `When a person can no longer laugh at himself, it is time for others to laugh at him.` Thomas Szasz

Re:[wdvltalk] FF Vs IE?

Ignore EVERY thing I said.. I'm a tool, and need a coffee...!!! Sigh... On 06/06/07, Tris [EMAIL PROTECTED] wrote: http://www.getpracticing.com/index2.php5 the flash blurb on this page is opaic? Any ideas why...? -- `We are what we pretend to be, so we must be careful what we pretend

[wdvltalk] PHP5 hosts...

I'm about to sign up with these guys: http://www.a2hosting.com/reseller_hosting.php on an intermediate packge for a 2 year contract. does anyone know of any better deals out there, before I sign my life away? I need: PHP 5 MySQL 5 Control panel for adding new emails, sites etc... (I'm crap at

Re: [wdvltalk] i'm outta here !!!

have a BLAST!!! On 15/06/07, r937 [EMAIL PROTECTED] wrote: okay, that's it, i'm outta here !!! have a nice weekend folks, those of you not yet already having it see you back here monday morning!! ;o) oh, who am i kidding, i'll be back here tomorrow • The WDVL Discussion List

[wdvltalk] Fwd: [thelist] [fun] Now this is a really sick use of HTML tables

I just HAD to share with you guys... (many of you on thelist though, so sorry for the reposting...) -- Forwarded message -- From: Christian Heilmann [EMAIL PROTECTED] Date: 25-Jun-2007 11:18 Subject: [thelist] [fun] Now this is a really sick use of HTML tables To: [EMAIL

[wdvltalk] [OT] Tech break down needed...

am I missing? Tris... -- `We are what we pretend to be, so we must be careful what we pretend to be.` Kurt Vonnegut `When a person can no longer laugh at himself, it is time for others to laugh at him.` Thomas Szasz � The WDVL Discussion List from WDVL.COM � To Join wdvltalk, Send

Re: [wdvltalk] [OT] Tech break down needed...

for now Tris • The WDVL Discussion List from WDVL.COM • To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] or use the web interface http://e-newsletters.internet.com/discussionlists.html/ Send Your Posts To: wdvltalk@lists.wdvl.com To change subscription settings, add

[wdvltalk] Postcode checker...

a mile or 3 would be good) it's really clever.. if it works..! Feedback welcome! I'll share the code to anyone that wants it... (the source site is a little.. long winded, but good!) Tris... -- Give a man a fish and he'll feed himself for a day. Give a man a religion and he'll starve to death

Re: [wdvltalk] Postcode checker...

Hmmm, m2b... normally the first part of a postcode is letters, then No's.. not a mix... Where is m2b? Also, the root site is only viewable via our office.. Lng story.. ;-p On 01/08/07, r937 [EMAIL PROTECTED] wrote:

Re: [wdvltalk] Postcode checker...

Sorry, Rudy.. UK only.!!! my bad..! On 01/08/07, Dan Parry [EMAIL PROTECTED] wrote: Seems to work for me... distances are within the 3 mile allowance AFAICT (well, without getting a trundle wheel and walking 10 miles) Dan -Original Message- From: Tris [mailto:[EMAIL PROTECTED

Re: [wdvltalk] Postcode checker...

! On 01/08/07, David Precious [EMAIL PROTECTED] wrote: Tris wrote: Hi all... I've been asked to calculate how far postcode x is from post code y... No worries.. as I found this great page... http://www.easypeasy.com/guides/article.php?article=64 Taking his DB and sample maths, I've

Re: [wdvltalk] Postcode checker...

if the results are vaguely correct (we're not after rocket science, but within a mile or 3 would be good) it's really clever.. if it works..! Feedback welcome! I'll share the code to anyone that wants it... (the source site is a little.. long winded, but good!) Tris... -- Give

Re: [wdvltalk] Postcode checker...

share the code to anyone that wants it... (the source site is a little.. long winded, but good!) Tris... -- Give a man a fish and he'll feed himself for a day. Give a man a religion and he'll starve to death praying for a fish. Anon `We are what we pretend to be, so we must

  1   2   >