On Mon, Oct 17, 2011 at 12:58 PM, Jim Giner
wrote:
> I would do it this way:
>
> Where
> $sel_d = (the day # you want)
> $sel_m = (the month # you want)
>
> The "where" clause would be:
>
> Where (start_month => $sel_m and start_day => $sel_d) and
> (end_month =< $sel_m and end_day =< $sel_
Though the operators are >= and <=, not => and =<.
Toby
-Original Message-
From: Jim Giner [mailto:jim.gi...@albanyhandball.com]
Sent: Monday, October 17, 2011 1:58 PM
To: php-db@lists.php.net
Subject: [PHP-DB] Re: SELECT
I would do it this way:
Where
$sel_d = (the day # you want)
Do not forget to use TRIM function as well:
LENGTH(TRIM(fax))
in order to elliminate leading and trailing spaces.
Aurel
- Original Message -
From: "Geoffrey Pitman"
To:
Sent: Friday, March 11, 2011 7:59 PM
Subject: [PHP-DB] RE: SELECT WHERE length of content question
You should b
Bastien Koert wrote:
On Sun, Dec 21, 2008 at 7:56 PM, Ron Piggott
wrote:
One more thing ... Bible is stored by verses, t is the text of the verse
On Sun, 2008-12-21 at 19:52 -0500, Ron Piggott wrote:
I am working on a web based Bible searching query. So far I am able to
generate:
SELECT *
On Sun, Dec 21, 2008 at 7:56 PM, Ron Piggott wrote:
>
> One more thing ... Bible is stored by verses, t is the text of the verse
>
> On Sun, 2008-12-21 at 19:52 -0500, Ron Piggott wrote:
> > I am working on a web based Bible searching query. So far I am able to
> > generate:
> >
> > SELECT * FRO
--
Best Regards,
Shahmat Dahlan
Research and Development
SAINS
Mobile: +(60)16 882 6130
Office: +(60)82 426 733 ext 5512
--- Begin Message ---
(1)
i've been using this method for years now, maybe somebody else has a
better way to do this?
";
php codes
$i++;
}
?>
(2) check out the limit
Miguel Guirao wrote:
> You are right David, I have an auto_increment field!!
>
> What about this:
> $items2 = mysql_query("SELECT DISTINCT rev FROM rev ORDER BY rev", $link);
>
> where rev is a revision field for parts in my wharehouse!!!
> Does it will work in this case?
>
> Thanks
>
> -O
You are right David, I have an auto_increment field!!
What about this:
$items2 = mysql_query("SELECT DISTINCT rev FROM rev ORDER BY rev", $link);
where rev is a revision field for parts in my wharehouse!!!
Does it will work in this case?
Thanks
-Original Message-
From: David Robley [mai
Sorry, just say the message.
> Your code looks well. But is the variable $db the name of your database or
> your link-identifier. When it is the name of your database i'm not really
> surpised your code wouldn't work. mysql_query requires as second argument a
> link identifier.
Read what Rolf say
thanks, i think your probably right.
Another problem I have is trying to sum the totals of F1 over muliple tables, what I
would like is to be able to use the UNION statement but my site is hosted and they are
not using version 4x of MySQL.
Is there any work around for this using a single SQL sta
gyintl.com/ecommerce/
---
-Original Message-
From: Max Clark [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 03, 2003 3:35 PM
To: 'Matthew Moldvan'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Re: select date -MM mysql help
I ended up using:
Which solution did you end up using? Just curious, I wasn't sure if mine was
correct ...
Regards,
Matthew Moldvan
---
System Administrator
Trilogy International, Inc
http://www.trilogyintl.com/ecommerce/
---
-Orig
Perfect!
Thanks. I'm still trying to get a handle on the GROUP BY command. It's still a
little bit like magic to me. And in the manual, they don't really show how to
use it like the way I wanted to use it.
Thanks again,
russ
On Monday 12 August 2002 01:27 pm, Dan Koken wrote:
> SELECT *
> FROM
13 matches
Mail list logo
