Re: Help with Date in Where Clause

Thank you very much Jørn Blessed Be Phillip "Never ascribe to malice what can be explained by incompetence" -- Hanlon's Razor On Mon, Jan 31, 2011 at 1:18 PM, Jørn Dahl-Stamnes wrote: > Jørn

Help with Date in Where Clause

Greetings All, I am looking for a little help in setting a where clause. I have a dateAdded field that is a DATETIME field. I am looking to pull records from Midnight to midnight the previous day. I thought just passing the date (without time) would get it but I keep getting an empty record set. S

Re: Dev Environment

your > distro. > > - michael dykman > > On Thu, Oct 28, 2010 at 3:21 PM, Phillip Baker > wrote: > > Greetings All, > > > > I am in a new shop and we are redesigning the web site. > > For development I am setting up a > > Development/Staging/Productio

Dev Environment

Greetings All, I am in a new shop and we are redesigning the web site. For development I am setting up a Development/Staging/Production environment. I just realized yesterday that I have never been involved in setting that up from a database end, only the php coding end for webpages. What are my

Re: Query Help

Table 1 Product_id | Product_Name 1| Product A 2| Product B 3| Product C Table 2 Category_id | Category_Name 1 | Admin 2 | Marketing 3 | Support 4 | IT Table 3 Product_id

Query Help

Hello All, For the life of me I cannot remember how to make a query like this and what it is called. I know it is fairly basic though. Table 1 Product_id Product_Name Table 2 Category_id, Category_name Table 3 Product_id, Category_id Each product can have one or more categories. So I want a

Re: Help! (Transfer of table data gone wrong)

Hold the phone - I've just realised that those tables 'missing' .ISM files are actually supposed to be MyISAM - (I have complete MYD and MYI files) - not ISAM (ISM, ISD) - how do I tell MySQL this is the case? TIA (Again) /Phil On Sun, 02 Jun 2002 21:28:17 +0100 "Ph

Help! (Transfer of table data gone wrong)

Hi, In haste to change some server hardware I copied the /var/lib/mysql directory directly assuming this would suffice in order to carry the data over. I'm pretty certain I stopped mysqld, but regardless I now seem to be missing nearly all the respective .ISM files for my databases. Now, I'm