Hello all,
Does anyone know how I might determine the start date and end date of the
previous calendar quarter based on today's date. For example, today is
2002-03-19, so the previous quarter start date would return 2001-10-01 and
the previous quarter end date would return 2001-12-31. I am trying
Hi, I'm working on a website for a local tennis group, and we are raising
money to offset website costs through sponsorships. I have created some 15
and 30 second GIF's for the sponsors, and would like to create a function
that loads the files in random order when the page is opened. I am creati
Hello Tom,
First of all, since you are keeping the filepaths and filenames you don't
need to worry about any of the filesystem functions.. You just need to
replace variables in the right places in your output HTML code.
As for how to implement what you need, I will give you a different tip.
Wr
Hello All,
I am trying to return the largest id for a table and then print the value to
a page. My query works fine in MySQL, the problem is getting the value to
show in a web page with php. This is what I am trying to process.
TABLEID | VALUE
1 | Test
2 | Test 2
3
Ok, lets say I have some code here:
$result = array();
$ch = curl_init ("https://www.myverificationplace.com/verify.asp";);
curl_setopt ($ch, CURLOPT_POST, 1);
curl_setopt ($ch, CURLOPT_POSTFIELDS, $args);
curl_setopt ($ch, CURLOPT_TIMEOUT, 120); // Set the timeout, in seconds.
curl_setopt ($ch
first, it helps if you show us your REAL code. The query statement you
showed below would obviously not work (it's missing the "mysql_query" part.
Second, when executing mysql_query() ALWAYS include the "or
die(mysql_error())" part to aid diagnostics.
Third, your query could not possibly work at
Hi,
Did you copy and paste your code?IF yes, I have noticed a problem on the
code you posted.. Y
The line:
$run_query = ($maxid,$db_connect);
will fail as you didn't put the function name in. Rewrite it as:
$run_query = mysql_query($maxid,$db_connect);
Gurhan
-Original Message-
Fro
Gurhan:
> I was wondering if you'd wanna use temporary tables to accomplish it..
Actually, another person on this list came up with the following:
SELECT s1.site_id
FROM site_category AS s1
JOIN site_category AS s2
WHERE s1.category_id=10
AND s2.category_id=12
AND
Hi there everyone,
Say I do a simple search as follows:
$query = "SELECT * FROM search WHERE
(description LIKE '%$test%' OR state LIKE '%$test%' OR city LIKE '%$test%' OR fname
LIKE '%$test%') AND (category = '$category' AND country = '$country' AND type =
'$type') ORDER BY city ASC LIMIT $of
You could select these results into a temporary table
and then query that table. Look at the mysql.com docs
and check out the CREATE TEMPORARY TABLE. You can
select data right into the table and the table is
erased when the connection closes.
But first it looks like cleaning up your query would
Hi there,
Thanks for your help on this it's appreciated, i'll look into temporary
tables tomorrow and see what I can do. Just curious, why is the method you
have shown below better than the method I used previously? Is it a speed
thing or is it more logical? I am learning different methods of
Found out why it was so slow.
> $e = OCIExecute($stmt);
The above commits every insert. It should be changed to
> $e = OCIExecute($stmt,OCT_DEFAULT);
Then I got the expected results. Using bind vars is nearly twice as fast.
"John Lim" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]"
There's a great article at phpbuilder on making your
dynamic site indexable.
http://phpbuilder.com/columns/tim2526.php3
Unfortunately I only found solutions that work with
apache. Does anyone have a solution that allows urls
to be constructed in "Search Engine Friendly" format.
thanks much
I know that there is a PEAR library
[http://pear.php.net] that allows this. I don't know
if it requires CURL or not. I ran into the same
problem and haven't had time to check out PEAR yet.
perhaps someone can enlighten us.
olinux
--- mailing list <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I am tr
I use a method I'd like to share:
For building queries with many conditions you first create an array like so
$select = "SELECT *";
if (isset($cond)) unset($cond);
if ($desc) $cond[] = desc LIKE '$desc%';
if ($state) $cond[] = state LIKE '$state%';
if ($city) $cond[] = city LIKE '$city%';
if (
15 matches
Mail list logo
