On Mon, Oct 17, 2011 at 12:58 PM, Jim Giner
jim.gi...@albanyhandball.com 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
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 geoffrey.pit...@gmail.com
To: php-db@lists.php.net
Sent: Friday, March 11, 2011 7:59 PM
Subject: [PHP-DB] RE: SELECT
On Sun, Dec 21, 2008 at 7:56 PM, Ron Piggott ron.pigg...@actsministries.org
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
Bastien Koert wrote:
On Sun, Dec 21, 2008 at 7:56 PM, Ron Piggott ron.pigg...@actsministries.org
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
--
Best Regards,
Shahmat Dahlan
Research and Development
SAINS
Mobile: +(60)16 882 6130
Office: +(60)82 426 733 ext 5512
---BeginMessage---
(1)
i've been using this method for years now, maybe somebody else has a
better way to do this?
?
sql query
$i = 0;
while (sql result fetches) {
if
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
-Original
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 says.
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
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/
---
/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:
SELECT * FROM table
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
12 matches
Mail list logo