Hi everyone,
I got a problem with emailing in PHP. Any help is appreciated.
Here's the situation:
I have a webpage takes some information from user and submit it to
database, then it'll sent out an email. When clicking on the submit
button, it takes browser at least 10 seconds to fi
From: "Marie Osypian" <[EMAIL PROTECTED]>
> I don't want to use the limit on this query anymore. What I want is to
> display all that are dated within the last 3 months. What would be the
easy
> way to do that?
>
>
> SELECT federal_development_id, UNIX_TIMESTAMP(date) AS date, topic, body
>
Ok.. I echo'd out the queries AND the num_rows returned for each loop
and this is what I got:
Manufacturer Query is: SELECT DISTINCT manufacturer FROM kcs_threads
ORDER BY manufacturer
Manufacturer Rows Returned Are: 5
Left Join Query is: select t.type, t.newUrlType, g.threadType,
g.groupNam
Have you tried the MySQL EXPLAIN command to look at your statement?
That can provide some insight when nothing else works.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
If it is a unix timestamp, why not just select rows where the date is >= 7776000
(which is 90 days) or if you want to be specific about the months, use mktime()
to generate the timestamp for the date 3 months ago.
--
Adam Alkins
http://www.rasadam.com
Quoting Marie Osypian <[EMAIL PROTECTED]>:
I don't want to use the limit on this query anymore. What I want is to
display all that are dated within the last 3 months. What would be the easy
way to do that?
SELECT federal_development_id, UNIX_TIMESTAMP(date) AS date, topic, body
FROM federal_developments
Hi Guys,
I've tried several different things with the following 2 queries but
nothing seem to help. I've stared at the code and reworked it for hours
on end and frankly I am getting frustrated.
I'm only posting the queries themselves without the PHP code as the
entire section is quite long. If
Greeting,
I am trying to run a stored procedure on MS SQL server from my Linux box.
My Procedure accept variables and return values, everything went very well
"connecting, init. and binding" but when I run mssql_execute, I got the
following message (stored proceduer execution failed - changed data