in reply to Re: Re: Module Design Review -- DB mini language
in thread Module Design Review -- DB mini language
SELECT words.id, words.definition FROM words, stock, languages, stockmatch, types WHERE words.typeID = types.id AND stock.languageID = languages.id AND stockmatch.stockID = stock.id AND stockmatch.wordID = words.id AND stock.word = ? AND languages.name = ? AND types.name = ?
you just need some whitespace in your SQL =P that and sticking to plural/non-plural for your table names.
|
|---|