Re: [PHP-WIN] Nulls in database

2001-02-01 Thread Larry Forrister
Try: [Start Construction Date] is null or:[Start Construction Date] is not null ~~LF "Conover, Ryan" wrote: > I am trying to write a query to bring back rows that have null values set in > them. I cannot figure out how to do this. I can bring back all rows that do > not have nulls with the

Re: [PHP-WIN] Random Code

2001-01-26 Thread Larry Forrister
36.36 > > > is 33696, which is much higher than the intended number of > > > users on the > > > system (we invisage no more than a few hundred - by the time > > > the userbase > > > gets to 33000, I'll be a millionairre and this can be someone > > > e

Re: [PHP-WIN] Random Code

2001-01-26 Thread Larry Forrister
red - by the time > > the userbase > > gets to 33000, I'll be a millionairre and this can be someone > > else's job > > hehe) > > > > 2. the two remaining characters could be a day/year thing. > > perhaps the days > > since the start of the y

Re: [PHP-WIN] Random Code

2001-01-23 Thread Larry Forrister
Do you mean W3E4-22ER would be valid? If so there would be 36^8 (2,821,109,907,456) possible values. A truly random generator algorithm cannot guarantee uniqueness. I'm guessing what you want is to generate each possible value once in a pseudo-random order. Would just apparent randomness suf

Re: [PHP-WIN] createing a php script with reloadable modules.

2001-01-23 Thread Larry Forrister
Is this running under a web server? How is it running 24/7? ~~LF kill-9 wrote: > yes but. when does it cashe the file. at the beginning right when the > script first starts running. isn't there a way to make it hmm refresh the > cashed file reload its self to pick up the changes? what if I a

Re: [PHP-WIN] Inner Joins

2001-01-12 Thread Larry Forrister
The INNER JOIN condition is not allowed in mySQL prior to version 3.23.16. Just put the test "tbl_cip.FormID = tbl_formid.FormID" in the WHERE clause. ~~LF "samsom, debra" wrote: > I am writing some PHP code with calls to Mysql. I am trying to do a > Inner > join and I am not getting any resul