Oops,
Never mind, I found the problem.
I have succesfully done what you are describing in a project. If the old
value is submitted then the new value is not correctly set/changed. Do
alert(document.myform.myfield.value); after you change the value to check
if
it was really changed.
Regards,
msa wrote:
My date format is as aboveI am getting the following error message:
You have an error in your SQL syntax. Check the manual that corresponds to
your MySQL server version for the right syntax to use near 'Y') . ' AND
MONTH(date) = ' . date('m') . ' ORDER BY sort DESC'
I changed your
Msa [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
'SELECT * FROM table WHERE YEAR(date) = ' . date('Y') . ' AND
MONTH(date)
=
' . date('m') . ' ORDER BY SORT DESC'
What column type is your date column of? I know that the above statement
works with the MySQL date (-MM-DD)
Marek Kilimajer [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
date('m') was not parsed by php as it was in the string. Syntax
highlighting would help you see it. Try:
SELECT * FROM NewsArchive WHERE YEAR(date) = ' . date('Y') . ' AND
MONTH(date) =' . date('m') . ' ORDER BY sort
Marek Kilimajer [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
msa wrote:
My date format is as aboveI am getting the following error message:
You have an error in your SQL syntax. Check the manual that corresponds
to
your MySQL server version for the right syntax to use
Msa [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Marek Kilimajer [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
date('m') was not parsed by php as it was in the string. Syntax
highlighting would help you see it. Try:
SELECT * FROM NewsArchive WHERE YEAR(date) = '
Ryan Schefke wrote:
Can anyone help me with the code to pull out clientxxx from the below
string:
/tgwedding/users/client1/sites/testgrabid.php
I use $PHP_SELF to get the directory structure of the page and store that
string as a variable. Then, I want to pull out the string clientxx, where
xx
Daniel Clark [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Are you looping through the record set?
SELECT * FROM NewsArchive WHERE YEAR(date) = ' . date('Y') . ' AND
MONTH(date) =' . date('m') . ' ORDER BY sort DESC;
Well, still not working...but maybe closer? Not getting
Daniel Clark [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Are you looping through the record set?
i thought I was, but it isn't working!!
here is the code with all of the latest suggestions.
start code at top of document:
?php require_once('Connections/jpike.php'); ?
?php
Justin,
Very nice preg_match statement. I realized I need to make a minor tweek to
what I needed. I need to get the number after the client string in
/tgwedding/users/client1/sites/testgrabid.php
...so, in the string above I need to pull out the number 1.
Any help?
-Original
Msa [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Daniel Clark [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Are you looping through the record set?
i thought I was, but it isn't working!!
here is the code with all of the latest suggestions.
start code at top
Can anyone help me with the code to pull out clientxxx from the below
string:
/tgwedding/users/client1/sites/testgrabid.php
I use $PHP_SELF to get the directory structure of the page and store that
string as a variable. Then, I want to pull out the string clientxx, where
xx can be any given
John W. Holmes mailto:[EMAIL PROTECTED]
on Tuesday, May 04, 2004 1:30 PM said:
I don't follow what $_GET record count from initial query performed
above; is for, but that's the basic methodology.
well that just meant that after the initial count of records is found it
will be retrieved
Are you looping through the record set?
SELECT * FROM NewsArchive WHERE YEAR(date) = ' . date('Y') . ' AND
MONTH(date) =' . date('m') . ' ORDER BY sort DESC;
Well, still not working...but maybe closer? Not getting an error message,
just not returning any data.
--
PHP General Mailing
- Original Message - start code at top of document:
?php require_once('Connections/jpike.php'); ?
?php
mysql_select_db($database_jpike, $jpike);
$query_rsENews = 'SELECT * FROM NewsArchive WHERE YEAR(date) = ' .
date('Y')
. ' AND MONTH(date) = ' . date('m') . ' ORDER BY sort
Are you getting any output?
?php require_once('Connections/jpike.php'); ?
?php
mysql_select_db($database_jpike, $jpike);
$query_rsENews = 'SELECT * FROM NewsArchive WHERE YEAR(date) = ' .
date('Y')
. ' AND MONTH(date) = ' . date('m') . ' ORDER BY sort DESC';
$rsENews =
Heh, I got ahead of myself anyway. I should have just hard-coded client.
preg_match('!/client(\d+)/!', $_SERVER['PHP_SELF'], $matches);
$xxx = $matches[1];
Ryan Schefke wrote:
Justin,
Very nice preg_match statement. I realized I need to make a minor tweek to
what I needed. I need to get the
no.
- Original Message -
From: Daniel Clark [EMAIL PROTECTED]
Newsgroups: php.general
To: msa [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Tuesday, May 04, 2004 5:02 PM
Subject: Re: [PHP] Re: repeating data from one column until data from
another column changes
Are you getting any
Netscape browser?
In your browser have you checked View Source to see it table data is there?
no.
- Original Message -
From: Daniel Clark [EMAIL PROTECTED]
Are you getting any output?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit:
definitely
Daniel Clark [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Netscape browser?
In your browser have you checked View Source to see it table data is
there?
no.
- Original Message -
From: Daniel Clark [EMAIL PROTECTED]
Are you getting any output?
If you have no may articles then there will be no records returned.
Just change the . date('m') to the actualy month you want if not the
current month.
- Original Message -
From: msa [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, May 04, 2004 3:59 PM
Subject: Re: [PHP] Re:
Php [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
If you have no may articles then there will be no records returned.
Just change the . date('m') to the actualy month you want if not the
current month.
except if I have to specify the specific month I want, then every month I
Just for right now, go ahead a make the date change, or elimate the date
range to get SOMETHING to come out.
Just change the . date('m') to the actualy month you want if not the
current month.
except if I have to specify the specific month I want, then every month I
have to go in and
* Thus wrote msa ([EMAIL PROTECTED]):
Marek Kilimajer [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
date('m') was not parsed by php as it was in the string. Syntax
highlighting would help you see it. Try:
SELECT * FROM NewsArchive WHERE YEAR(date) = ' . date('Y') . ' AND
* Thus wrote msa ([EMAIL PROTECTED]):
I didn't hand write much of thisdreamweaver writes a lot of it behind
the scenes.i'm not much of a code writer, just get into small needs here
and there...REALLY appreciate all of you trying to help me!!!
dreamweaver writes buggy code, you'd be
* Thus wrote Ryan Schefke ([EMAIL PROTECTED]):
Can anyone help me with the code to pull out clientxxx from the below
string:
/tgwedding/users/client1/sites/testgrabid.php
$parts = explode('/', $path);
echo $parts[2]; // client1
Curt
--
I used to think I was indecisive, but now I'm not so
when i take out the WHERE clause, I get ALL 192 titles in the upper right
side and ALL 192 titles and descriptions in the main body..which is
almost what i want...minus about 180 titles and articles
Daniel Clark [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Just for right
Good :-)
You are narrowing the error down :-)
Sounds like it's in the date section then.
when i take out the WHERE clause, I get ALL 192 titles in the upper right
side and ALL 192 titles and descriptions in the main body..which is
almost what i want...minus about 180 titles and
Why not change the code back, then just add an article for the month of may
and see if it comes up?
when i take out the WHERE clause, I get ALL 192 titles in the upper right
side and ALL 192 titles and descriptions in the main body..which is
almost what i want...minus about 180 titles
Php [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Why not change the code back, then just add an article for the month of
may
and see if it comes up?
i am trying to automate this so I don't have to look at it againclient
updates the pages and I won't be getting paid beyond
the code again...
at top of document (with strange WHERE clause removed..
?php require_once('Connections/jpike.php'); ?
?php
mysql_select_db($database_jpike, $jpike);
$query_rsENews = SELECT * FROM NewsArchive ORDER BY date DESC;
$rsENews = mysql_query($query_rsENews, $jpike) or
Hey All:
Interesting problem that I haven't been able to solve using google. I want
to move a file from my system using php, and I want to SCP it to another
system. I setup the 2 keys and I can SCP files w/o using a password from the
command line with no problem. When I take the same string that
$query_rsENews = 'SELECT * FROM NewsArchive WHERE YEAR(datePublished) = ' .
YEAR('NOW'()) . ' AND MONTH(datePublished) = ' . MONTH('NOW'()) . ' ORDER BY
sortBy DESC';
this is supposed to return only the records that have the current month and
year in the datePublished record.
the above code got
Hello msa,
Wednesday, May 5, 2004, 2:18:57 AM, you wrote:
m $query_rsENews = 'SELECT * FROM NewsArchive WHERE YEAR(datePublished) = ' .
m YEAR('NOW'()) . ' AND MONTH(datePublished) = ' . MONTH('NOW'()) . ' ORDER BY
m sortBy DESC';
m the above code got a parse error
m any ideas, anyone?
Your
Matt,
Question: when you run it and it fails, are you running it with php from the
command line under your own userid or are you running it under a web server
by invoking the php file using a URL as userid (nobody)?
Warren Vail
-Original Message-
From: Matt Babineau [mailto:[EMAIL
* Thus wrote msa ([EMAIL PROTECTED]):
$query_rsENews = 'SELECT * FROM NewsArchive WHERE YEAR(datePublished) = ' .
YEAR(NOW()) . ' AND MONTH(datePublished) = ' . MONTH(NOW()) . ' ORDER BY
sortBy DESC';
got this error:
Fatal error: Call to undefined function: year()
any ideas, anyone?
May 4 at 4:25pm, Matt Babineau wrote:
When I take the same string that I jsut used to scp the file and run it
using exec, system, passthru it doesn't work!! I'm baffled and was
hoping someone had successfully done this before.
$address = www.url.com;
$value = foldername;
I assume this is
[EMAIL PROTECTED] (Kim Steinhaug) wrote in
news:[EMAIL PROTECTED]:
Hello,
Has anyone seen any resources on the net on OS independent sollutions.
Im aware of the Tidy software, but its not up for the job. Doesn't need
to be open source, but it needs to be OS independent.
All tips are
Justin Patrin wrote:
Richard Harb wrote:
Uh, I was wrong...
Foreach evaluates only once at initialisation... You can even unset
the array once into the loop and it still works perfectly well (not
that I recommend this as good practice or whatever, just did some
checking to be sure :)
Richard
That
John Doe wrote:
hello, does any know how to conver microsoft word document to pdf via on the
server using php language?? i try to implementing the feature that allow
user to upload microsoft word document to the web server, after the upload,
it automatic covert to pdf file ??? any one done that
germán m. rivera wrote:
Hi all!
Let's say I have a PHP script that needs the user to input some data
during its execution. At the point the data is needed the browser could
be redirected to a new page with a form where the user could enter the
data. But thus is necessary to save the script
Mike R wrote:
Is there a version of Apache 2+ that now works with PHP? Last I checked,
the were incompatible, but recently someone I ran into claimed that the bugs
have been for such a setup.
:)
Thanks,
-MIke
I've been using PHP + Apache 2 for a long time now.
http://www.php.net/install.apache2
Jason Barnett wrote:
John Doe wrote:
hello, does any know how to conver microsoft word document to pdf via
on the server using php language?? i try to implementing the feature
that allow user to upload microsoft word document to the web server,
after the upload, it automatic covert to pdf file
Is there a version of Apache 2+ that now works with PHP? Last I checked,
the were incompatible, but recently someone I ran into claimed that the bugs
have been for such a setup.
There is the warning not to use apache 2.0 and php in production. I am
sure that there are many that are using it
On Tue, 2004-05-04 at 19:18, msa wrote:
$query_rsENews = 'SELECT * FROM NewsArchive WHERE YEAR(datePublished) = ' .
YEAR('NOW'()) . ' AND MONTH(datePublished) = ' . MONTH('NOW'()) . ' ORDER BY
sortBy DESC';
this is supposed to return only the records that have the current month and
year
There's an input string like {str1,str2,...,strN}. I want to capture
all these strings and due to complexity of them I use a preg_match_all()
instead of simple split. A pattern for the matching strings is ready but
I cannot imagine how to specify that strings are separated by commas
and the last
Forgot about curly brackets. The above example is:
/^\{(?:(pattern),)*|(pattern)?\}$/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Wed, May 05, 2004 at 02:26:25PM +0900, Tumurbaatar S. wrote:
There's an input string like {str1,str2,...,strN}. I want to capture
all these strings and due to complexity of them I use a preg_match_all()
instead of simple split. A pattern for the matching strings is ready but
I cannot
48 matches
Mail list logo
