now its working,
i was wondering if we can do max(dateposted) on update?
mysql> update datafiles set status = '1' where max(dateposted);
ERROR : Invalid use of group function
hmm? seems, not to be working at all.
On Tue, 27 Jul 2004 14:43:58 +0800, Louie Miranda <[EMAIL PROT
ok, just removed the distinct syntax
On Mon, 26 Jul 2004 23:51:43 -0500, mos <[EMAIL PROTECTED]> wrote:
> At 10:45 PM 7/26/2004, you wrote:
> >if I understand you correctly, this should do it.
> >
> >select distinct office, max(dateposted)
> >from table
> >group by office
>
>
> Just one more thi
ah ic, thanks. it now works fine.
thanks also for the tip! :)
On Mon, 26 Jul 2004 23:29:06 -0700, Justin Patrin <[EMAIL PROTECTED]> wrote:
> On Tue, 27 Jul 2004 11:59:14 +0800, Louie Miranda <[EMAIL PROTECTED]> wrote:
> > This outputs a filename on $catchresult, and im working on redirecting
> >
Good day php people,
Hope somebody can help me out a bit.
I'm trying to compile 'apc' on my OpenBSd box.
The install file reads:
$ gunzip -c apc_x.y.tar.gz | tar xf -
$ cd apc_x.y
$ /usr/local/php/bin/phpize
But when i try to run phpize i get some errors:
/usr/local/bin/phpize
/usr/local/bin/ph
On Tue, 27 Jul 2004 11:59:14 +0800, Louie Miranda <[EMAIL PROTECTED]> wrote:
> This outputs a filename on $catchresult, and im working on redirecting
> it to that file via header. But when ever i run this the value of
> $catchresult is not being pass to the header() on php.
>
> $catchresult = $db_
On Mon, 26 Jul 2004 18:02:51 -0700, Ed Lazor <[EMAIL PROTECTED]> wrote:
> Any recommendations on books, links, tutorials, etc. for PHP 5's new DOM /
> XML stuff?
Answered some hours ago here on this list
See http://news.php.net/php.general/191907
(there's certainly more ;) )
chregu
--
christ
--- Louie Miranda <[EMAIL PROTECTED]> wrote:
> This outputs a filename on $catchresult, and im
> working on redirecting
> it to that file via header. But when ever i run this
> the value of
> $catchresult is not being pass to the header() on
> php.
>
> $catchresult = $db_view->getOne($getfile);
This outputs a filename on $catchresult, and im working on redirecting
it to that file via header. But when ever i run this the value of
$catchresult is not being pass to the header() on php.
$catchresult = $db_view->getOne($getfile);
header('Location: clients/FILES/$catchresult');
Hmm, it seems
It didn't work. Still the same problem.
Thanks
"Marek Kilimajer" <[EMAIL PROTECTED]> escribió en el mensaje
news:[EMAIL PROTECTED]
> Robert Winter wrote:
> > I have the following rewriterule:
> >
> > RewriteRule ^(([0-9]|[A-Z]|[a-z]|_)+)$ redirect.php?$1 [L]
> >
> > that transforms http://mysite.
Brian, pardon the typo, but maybe he's looking for a brain. *chuckles*. :)
--
Running 'ojtibi' on '127.0.0.1' (BATCH_OPTIMISTIC mode).
"Live free() or die()."
"Brian Dunning" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I'm a Brian, but you can't pick me unless you're a really
* Thus wrote EE:
> What is this? I got this message few times from php.net...
This isn't a message from php.net, it appears to be someone
attempting to harvest valid emails.
I would suggest to report this message including all the headers
but it doesn't appear they provide anyway to do such a thi
* Thus wrote Chris Martin:
> Justin Patrin wrote:
> >On Mon, 26 Jul 2004 11:27:32 +0300, EE <[EMAIL PROTECTED]> wrote:
> >
> >>What is this? I got this message few times from php.net...
> >>
> >
> >
> >Well, that's weirdI've never seen that one.
> >
>
> Apparently they're from an annoying spam
Justin Patrin wrote:
On Mon, 26 Jul 2004 11:27:32 +0300, EE <[EMAIL PROTECTED]> wrote:
What is this? I got this message few times from php.net...
Well, that's weirdI've never seen that one.
Apparently they're from an annoying spam service that someone on this
list has subscribed to and not ac
Any recommendations on books, links, tutorials, etc. for PHP 5's new DOM /
XML stuff?
Thanks,
Ed
Ed Lazor wrote:
Any comments or opinions on pros and cons, especially in terms of stability,
security, and future upgradability?
This is a a religious war topic. Horses for course but in this list of
PHP fanatics you should expect only one answer - PHP is better for web
applications - no conte
* Thus wrote Scott Taylor:
>
>$fp = fopen($file, 'rb');
>// send the right headers
>header("Content-Type: application/pdf");
>header("Content-Length: " . filesize($file));
>// dump the file and stop the script
>fpassthru($fp);
>
> ...
>
> The reason for this is that someh
It appears as though some readers (such as adobe acrobat) can read
this file fine yet others (such as the program gv in *NIX) cannot read
it.
The reason for this is that somehow a hex 0A is added before the
inital %PDF-1.2 which marks the start of the PDF file causing some
readers to not recog
Any comments or opinions on pros and cons, especially in terms of stability,
security, and future upgradability?
I know this is probably one of those religious war topics, but I'd still
like your feedback.
-Ed
I'm using this code to stream a PDF file:
$file = $_SERVER['DOCUMENT_ROOT'] . "/file.pdf";
simple_streamfile($file);
function simple_streamfile($file)
{
$fp = fopen($file, 'rb');
// send the right headers
header("Content-Type: application/pdf");
header("Content-Length: " . filesize(
Hi,
Tuesday, July 27, 2004, 7:40:25 AM, you wrote:
JP> Edit locally and FTP manually.
JP> Or get some kind of mounted FTP filesystemdoesn't Windows XP have
JP> something like this built in?
JP> --
JP> DB_DataObject_FormBuilder - The database at your fingertips
JP> http://pear.php.net/p
I'm a Brian, but you can't pick me unless you're a really hot chick.
- Brian
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
* Thus wrote Scott Fletcher:
> Hi, what is in your opinion is the best way to convert from JavaScript to
> PHP What I'm not entirely sure of is the
> "char_set.indexOf(input.charAt())". It look pretty tricky
>
Sometimes a whole complete approach can be done:
> --snip--
> var a
Hey, an alternative to your switch statement, is to have an
associative array with the full State names in it like this ...
$states = array('MI'=>'Michigan'); and so forth.
then just uses it in your html.. $states['$state'];
Jason
On Mon, 26 Jul 2004 15:28:11 -0400, Tom Ray [Lists]
<[EMAIL PROTE
It looks like you need to reset the $state variables each loop through
so that they are all empty, hence when you get to west virginia and
wisconsin they are but empties behind them
Heck, personally I'd just add another cell to the table and make it have
the full name in, then just use that column
On Mon, 26 Jul 2004 12:18:37 -0500 (CDT), Rodolfo Gonzalez Gonzalez
<[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm trying to use PEAR's DB class with the new PHP 5 MySQLi support on
> MySQL 4.1.3, using this example from the PEAR's docs (with my parameters
> of course). I'm getting "DB unknown error" me
> It's being copied somewhere. Maybe try this in the loadModule function:
> $this->module[$name] =& new $name($this);
>
> You don't need the & for $this as you've defined the function to send
> it by reference.
It doesn't work, either. But I think maybe the problem is somewhere else, it
seems that
On Mon, 26 Jul 2004 10:20:56 -0700, barophobia <[EMAIL PROTECTED]> wrote:
> On Sat, 24 Jul 2004 16:37:03 +0200, rush <[EMAIL PROTECTED]> wrote:
>
> > scite, from the scintilla fame. TemplateTamer would also work fine if you
> > just copy the whole directory
>
> wow. that's a pretty awesome editor
> --snip--
> $char_code = strpos($char_set,(substr($input,$loop,1)));
> --snip--
even a little shorter
$char_code = strpos($char_set,$input{$loop});
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I think maybe this will do the trick..
--snip--
$char_code = strpos($char_set,(substr($input,$loop,1)));
--snip--
FletchSOD
"Scott Fletcher" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi, what is in your opinion is the best way to convert from JavaScript to
> PHP What I'm
Michael and Curt,
Thank you very much with your time and promptness. You both have been very
helpful.
Kind regards,
Katie
- Original Message -
From: "Curt Zirzow" <[EMAIL PROTECTED]>
To: "php" <[EMAIL PROTECTED]>
Sent: Monday, July 26, 2004 1:12 PM
Subject: Re: [PHP] -> operator and ::
Hi, what is in your opinion is the best way to convert from JavaScript to
PHP What I'm not entirely sure of is the
"char_set.indexOf(input.charAt())". It look pretty tricky
--snip--
var algorithm = 8;
for (loop=0; loophttp://www.php.net/)
To unsubscribe, visit: http://www.
> I've run into a small bump in some code I'm writing for a membership
> database. The first thing that needs to be done is an index of all
> states in the US with members. The fun part is that the state
> information is stored as the abbreviation in the database (ie MI, WI)
> and the HTML pag
* Thus wrote Albert Padley:
> I have been struggling with a javascript regex validation for U.S.
> phone numbers all afternoon. This is part of Manuel Lemos' Formsgen
> class. This is limited to the 7 digit number sans 3 digit area code. To
> be complete, the regex should disallow a phone number
* Thus wrote Katie Marquez:
> Hi!
>
> I did a search of the PHP manual for these:
>
> -> and ::
>
as far as the :: is, its name (in php): The Paamayim Nekudotayim.
Paamayim Nekudotayim would, at first, seem a strange choice for a
double-colon. However, at the time of writing of Zend Engine 0.
> I need to kill that extra Texas and Virgina.here's how I'm doing this:
>
>
> $query=mysql_query("SELECT DISTINCT state FROM members WHERE
> country='US' ORDER BY state ASC");
> while($q=mysql_fetch_array($query)) {
> $q1=mysql_fetch_array($query);
> $q2=mysql_fetch_array($query);
> $q3=mys
Hey all-
I've run into a small bump in some code I'm writing for a membership
database. The first thing that needs to be done is an index of all
states in the US with members. The fun part is that the state
information is stored as the abbreviation in the database (ie MI, WI)
and the HTML page
On Mon, 26 Jul 2004 19:19:56 +0200, Erik Franzén <[EMAIL PROTECTED]> wrote:
> The docs for PHP5 and dom xml is not written yet,
yes they are: http://www.php.net/dom
> so I tried to find
> information about load and save methods on the w3c site, but I didn't
> find anything.
You didn't look good
* Thus wrote Robert Winter:
> I have the following rewriterule:
>
> RewriteRule ^(([0-9]|[A-Z]|[a-z]|_)+)$ redirect.php?$1 [L]
And why is this so more urgent than any other email? and what does
any of this have to any thing to do with PHP? perhaps you meant
'OT:'
>
> that transforms http://my
"Rodolfo Gonzalez Gonzalez" <[EMAIL PROTECTED]> wrote in
message news:[EMAIL PROTECTED]
> Hi,
>
> I'm trying to use PEAR's DB class with the new PHP 5 MySQLi support on
> MySQL 4.1.3, using this example from the PEAR's docs (with my parameters
> of course). I'm getting "DB unknown error" messages a
Katie Marquez wrote:
> Hi!
>
> I did a search of the PHP manual for these:
>
> -> and ::
>
> I know what they are used for, but what I don't know
> is what they are formally called. Can someone tell me
> what they are called (short of using the symbol in the
> name)?
I don't know what PHP's offic
as mentioned already, use a column in the table to order the query and
then use LIMIT to only to return one record. Best columns to use would
be an auto_increment or a datetime field type.
Jason
On Mon, 26 Jul 2004 18:27:25 +0100, Harlequin
<[EMAIL PROTECTED]> wrote:
>
>
> I would like to retr
The docs for PHP5 and dom xml is not written yet, so I tried to find
information about load and save methods on the w3c site, but I didn't
find anything.
What's is the PHP5 eqvivalent to domxml_open_mem in PHP4?
/Erik
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http:
I'm sure there are many ways to do this.
Perhaps use something like this as a query?
select * from login_table order by DATE_LAST_LOGGED_IN ASC limit 1
- Original Message -
From: Harlequin <[EMAIL PROTECTED]>
Date: Monday, July 26, 2004 1:27 pm
Subject: [PHP] Retrieve The Last Record in
[snip]
I would like to retrieve the last entry in a login table and present
that to
a user so they can verify the date we have when they last logged in.
Is this possible...?
[/snip]
yes,
http://catb.org/~esr/faqs/smart-questions.html
--
PHP General Mailing List (http://www.php.net/)
To unsubscri
I would like to retrieve the last entry in a login table and present that to
a user so they can verify the date we have when they last logged in.
Is this possible...?
--
-
Michael Mason
Arras People
www.arraspeople.co.uk
-
--
PHP Gen
On Sat, 24 Jul 2004 16:37:03 +0200, rush <[EMAIL PROTECTED]> wrote:
> scite, from the scintilla fame. TemplateTamer would also work fine if you
> just copy the whole directory
wow. that's a pretty awesome editor. too bad it can't connect to FTP
sites. all my files are remote!
anyone have a work
On Mon, 26 Jul 2004 11:27:32 +0300, EE <[EMAIL PROTECTED]> wrote:
> What is this? I got this message few times from php.net...
>
Well, that's weirdI've never seen that one.
--
DB_DataObject_FormBuilder - The database at your fingertips
http://pear.php.net/package/DB_DataObject_FormBuilder
On Sun, 25 Jul 2004 19:05:38 -0700 (PDT), Mark <[EMAIL PROTECTED]> wrote:
> --- Jason Wong <[EMAIL PROTECTED]> wrote:
> > On Sunday 25 July 2004 09:42, Mark wrote:
> > > Am I the only one who gets annoyed at these?
> >
> > No you're not. Look in the past week's archives.
> >
> > > [EMAIL PROTECTED
Hi,
I'm trying to use PEAR's DB class with the new PHP 5 MySQLi support on
MySQL 4.1.3, using this example from the PEAR's docs (with my parameters
of course). I'm getting "DB unknown error" messages after the query. The
same query from the mysql client works fine, there are no connection
problems
Hi!
I did a search of the PHP manual for these:
-> and ::
I know what they are used for, but what I don't know
is what they are formally called. Can someone tell me
what they are called (short of using the symbol in the
name)?
The PHP manual's search engine returns me (among
others)the "Chapte
05P$¯~í/R4{ßBPYe-ÅÎÓ²iºç¦#ðVÙWÀÊ £¬B^p½FâkhXI¼NrhNE&·-ùÚbçºQîOõmÑNÓ_ÞíìÌn
.ò1¼ñAÂâÔ_ð^®0rLháçRyýw®·®DKRÅ5¢Ü©mǾ·yÄMW:ø4Ï4ã>ÏÓ ~61öÀXsìøÒQÛ6yé
´ÇËËËGI)¬íê~
[UN&ýaÊSIÌåg
ùb
¤
P~ÈEV86>L|
ÔP%TðWÆV&wéÌ&á
ó¼¶u29kAæÓHB(ÖÜÀGëxd»µ^ê2ìô±?ê¬ÝE]V!lЫðæúW½¼uÌJèñ½éV
What version of PHP is this, in php 5, all classes are passed by
reference by default i beleive.
Jason
On Sun, 25 Jul 2004 20:00:18 +0200, Michael Ochs <[EMAIL PROTECTED]> wrote:
> I can call $myclass->module['mymodule']->variable; so I think the class is
> instantiate correctly. But the referenc
On Sun, 25 Jul 2004 20:00:18 +0200, Michael Ochs <[EMAIL PROTECTED]> wrote:
> I can call $myclass->module['mymodule']->variable; so I think the class is
> instantiate correctly. But the reference doesn't seem to work, cause the
> variable I get ist always the same:
>
> $myclass->nickname = "xyz";
On Mon, 26 Jul 2004 17:18:48 +0200, Andreas Goetz <[EMAIL PROTECTED]> wrote:
> Excellent, thank you. So I should read the document, the do a $doc->encoding
> = 'ISO-8859-1' before reading any nodedata values to obtain ISO characters?!
No, if you access the nodeData with for example ->nodeValue, it
Remember you can always use curly braces..
"SELECT * from MembersData WHERE UserID = '{$_SESSION['logname']}'"
works just fine
Jonathan Haddad
Afan Pasalic wrote:
I think he has to keep the single quotes and add double quotes with dots:
$MembersDataQry = "SELECT * FROM MembersData WHERE UserID='
"
Excellent, thank you. So I should read the document, the do a $doc->encoding
= 'ISO-8859-1' before reading any nodedata values to obtain ISO characters?!
As documentation hasn't caught up with $doc->encoding, how could I've found
out myself?
Thanks again for the quick help,
Andreas
"Christian St
The original message was received at Mon, 26 Jul 2004 08:58:34 -0600 from auburn.edu
[82.197.96.166]
- The following addresses had permanent fatal errors -
<[EMAIL PROTECTED]>
- Transcript of session follows -
... while talking to lists.php.net.:
>>> MAIL FROM:[EMAIL PROTECTED]
<
Hi
On Mon, 26 Jul 2004 16:31:38 +0200, Andreas Goetz <[EMAIL PROTECTED]> wrote:
> I'm confused and google couldn't answer :(
>
> I'm parsing XML files using domDocument and XPath in php5. Works like a
> charm. But- how do I know if I need to apply and utf8decode to the data
> returned from the do
I'm confused and google couldn't answer :(
I'm parsing XML files using domDocument and XPath in php5. Works like a
charm. But- how do I know if I need to apply and utf8decode to the data
returned from the domDocument? Unlike xml_parser_create the domDocument does
not seem to offer an parameter for
I think he has to keep the single quotes and add double quotes with dots:
$MembersDataQry = "SELECT * FROM MembersData WHERE UserID='
".$_SESSION['logname']'." ' ";
afan
At 09:24 AM 7/26/2004, Jason Davidson wrote:
hey, just take the single quotes around the word logname out and you
should be ok.
hey, just take the single quotes around the word logname out and you
should be ok.
Jason
On Mon, 26 Jul 2004 12:58:28 +0100, Harlequin
<[EMAIL PROTECTED]> wrote:
> Could someone please help me with my syntax here...?
>
> $MembersDataQry = "SELECT * FROM MembersData
> WHERE UserID='$_SESSION['log
Don't argue with machines, just give it what it wants.
Just put the session variable in it's own variable and
pass that to the sql statement.
$logon = $_SESSION['logname'];
$MembersDataQry = "SELECT * FROM MembersData
WHERE UserID='$logon'";
--- Daniel Kullik <[EMAIL PROTECTED]> wrote:
> Hello
Hello again, Michael!
You ought to read this:
http://de.php.net/manual/en/language.types.string.php#language.types.string.parsing
Daniel
Harlequin wrote:
Could someone please help me with my syntax here...?
$MembersDataQry = "SELECT * FROM MembersData
WHERE UserID='$_SESSION['logname']'";
I get an
===
Please feel free to add more points and send
to the list.
===
1. If you have any queries/problems about PHP
try http://www.php.net/manual/en first. You
can download a copy and use it offline also.
Please also try
htt
At 13:58 26-7-04, you wrote:
Could someone please help me with my syntax here...?
$MembersDataQry = "SELECT * FROM MembersData
WHERE UserID='$_SESSION['logname']'";
I get an error on line 2 but can't seem to figure out what I've missed.
1. You have errors with the ' quote: you use it to wrap the en
"Harlequin" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Could someone please help me with my syntax here...?
>
> $MembersDataQry = "SELECT * FROM MembersData
> WHERE UserID='$_SESSION['logname']'";
>
> I get an error on line 2 but can't seem to figure out what I've missed.
>
> The
Marek
thanks very much.
--
-
Michael Mason
Arras People
www.arraspeople.co.uk
-
"Marek Kilimajer" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Harlequin wrote:
> > Hello.
> >
> > I have a friend who knows less than me ab
Could someone please help me with my syntax here...?
$MembersDataQry = "SELECT * FROM MembersData
WHERE UserID='$_SESSION['logname']'";
I get an error on line 2 but can't seem to figure out what I've missed.
The variable echoes fine so I know there's a string in there.
--
-
Albert Padley wrote:
I have been struggling with a javascript regex validation for U.S. phone
This is a PHP list.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
"Skippy" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I just wanted to make things clear, because the way you said it above may
> lead to misinterpretations, such as believing that || makes all the
elements
> in a condition evaluate even if not necessary, which is not true.
>
> So
Since you're using cookies, are you remembering to destroy the cookie as well?
Check your web browser to see if the cookie is still there - then do your logout
script - and then immediately check to see if the cookie is still there.
Firefox makes this easy... just another reason why I love that
On 26 July 2004 01:13, Robert Frame wrote:
> OK, now I am bewildered again.
>
> Sample Code
>
>
> echo '';