<[EMAIL PROTECTED]>
.net.il> cc:
Subject: RE: [PHP-DB] Query problem
Assuming you run MySQL, why don't you just remove the " ' "?
SELECT * FROM MyTable WHERE MyField=NULL
Sincerely
berber
Visit http://www.weberdev.com/ Today!!!
To see where PHP might take you tomorrow.
Share your code : http://addexample.weberdev.com
-Original Message-
From: Ron All
How would the entire query look
select * from ticket where Type = 'Phone' and ???
"Dirk Kredler" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Am Dienstag, 22. Juli 2003 11:29 schrieb Ron Allen:
> > This is what I have
> > select * from ticket where Type = 'Line' and Closeddate
select * from ticket where Type = 'Line' and (Closeddate IS NULL OR
Closeddate ='')
or
select * from ticket where Type = 'Line' and Closeddate IS NULL
HTH
Peter
-Original Message-
From: Ron Allen [mailto:[EMAIL PROTECTED]
Sent: 22 July 2003 10:29
To: [EMAIL PROTECTED]
Subject: [PHP-DB]
Am Dienstag, 22. Juli 2003 11:29 schrieb Ron Allen:
> This is what I have
> select * from ticket where Type = 'Line' and Closeddate = ' empty space'
> and have tried the following
> select * from ticket where Type = 'Line' and Closeddate = 'Null'
> select * from ticket where Type = 'Line' and Close
On Tuesday 22 January 2002 13:18, Sommai Fongnamthip wrote:
> Hi,
> I have problem with these mysql's query:
>
> select * from holder, management where holder.id=management.id or
> (holder.name=management.name and holder.surname=management.surname) order
> by holder.no
>
> It ta
ok. try this.
ahven't tested it though ...
?".$months[$x-1]."\n";
}
echo ' ';
?>
then something like (pref before the dump of months)
will be
populated when the form refreshes and then isset() will say it has a value
and drop inside to create the query. that way you avoid an expe
> My PHP-embedded query is as follows:
>
> else if($sortBy == '01') {
> $sql = "SELECT * FROM $table_cal WHERE item_activity='$id' AND
>DATE_FORMAT('item_date','%m') LIKE '$sortBy'";
> $sortBy = "Month of January";
> }
>
> * '$sortBy' is equal to '01'.
> * MySQL isn't complainin
