php-general Digest 27 Jul 2004 09:00:24 -0000 Issue 2901
Topics (messages 191914 through 191949):
Re: -> operator and :: (formal names?) (RESOLVED)
191914 by: Mike Dichirico
Re: JavaScript conversion to PHP code...
191915 by: Scott Fletcher
191916 by: Matt M.
191922 by: Curt Zirzow
Re: PHP editor that doesn't require installation
191917 by: Justin Patrin
191924 by: Tom Rogers
Re: Refer a class
191918 by: Michael Ochs
Re: Problem with PEAR DB & MySQLi
191919 by: Justin Patrin
Re: Is there a brian I can pick?
191920 by: Robert Sossomon
191921 by: Jason Davidson
191923 by: Brian Dunning
191934 by: Oliver John V. Tibi
Extra byte added to PDF streaming file
191925 by: Scott Taylor
191927 by: Larry E. Ullman
191928 by: Curt Zirzow
PHP vs. Java
191926 by: Ed Lazor
191929 by: raditha dissanayake
php 5 DOM tutorials / examples?
191930 by: Ed Lazor
191938 by: Christian Stocker
Re: IMPORTANT: Please Verify Your Message]
191931 by: Chris Martin
191932 by: Curt Zirzow
191933 by: Curt Zirzow
Re: URGENT: Space char in rewriterule
191935 by: Robert Winter
issue a value on header, not working..
191936 by: Louie Miranda
191937 by: zareef ahmed
191939 by: Justin Patrin
191941 by: Louie Miranda
phpize missing files
191940 by: Thijs Lensselink
Re: select * on all current?
191942 by: Louie Miranda
191943 by: Louie Miranda
191944 by: Lester Caine
Mail System Error - Returned Mail
191945 by: nick.loman.net
totally new to PHP
191946 by: Paul Kain
191947 by: Jason Barnett
191948 by: Bruno Santos
Re: Retrieve The Last Record in a Table
191949 by: Harlequin
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
--- Begin Message ---
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 :: (formal names?)
> * 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.5
> (which powered PHP3), that is what Andi and Zeev decided to call
> it. It actually does mean double-colon - in Hebrew! As PHP has
> progressed with its development it has just never changed.
>
> php4:
> http://www.php.net/manual/en/keyword.paamayim-nekudotayim.php
>
> php5 (comming soon):
> http://www.php.net/manual/en/language.oop5.paamayim-nekudotayim.php
>
> Curt
> --
> First, let me assure you that this is not one of those shady pyramid
schemes
> you've been hearing about. No, sir. Our model is the trapezoid!
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--- End Message ---
--- Begin Message ---
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 not entirely sure of is the
> "char_set.indexOf(input.charAt())"..... It look pretty tricky....
>
> --snip--
> var algorithm = 8;
>
> for (loop=0; loop<input.length; loop++)
> {
> //search char_set string for character and set char_code
variable...
> char_code = char_set.indexOf(input.charAt(loop));
>
> //opposite of encrypt algorithm goes here
> if (char_code - algorithm < 0) {
> space = algorithm - char_code;
> char_code = char_set.length - space;
> } else {
> char_code -= algorithm;
> }
>
> //set output variable in accordance to char_set
> output += char_set.charAt(char_code);
> }
> --snip--
>
> Thanks,
> FletchSOD
--- End Message ---
--- Begin Message ---
> --snip--
> $char_code = strpos($char_set,(substr($input,$loop,1)));
> --snip--
even a little shorter
$char_code = strpos($char_set,$input{$loop});
--- End Message ---
--- Begin Message ---
* 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 algorithm = 8;
>
// shift the contents over and add the shifted to the end.
$trans = substr($char_set, $algorithm-1) .
substr($chars_set, 0, $algorithm);
$output = strtr($input, $trans_set, $trans);
If your $input string is of a significant length this will be more
efficient with the cost of some memory (strlen($trans_set)x2).
Curt
--
First, let me assure you that this is not one of those shady pyramid schemes
you've been hearing about. No, sir. Our model is the trapezoid!
--- End Message ---
--- Begin Message ---
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. too bad it can't connect to FTP
> sites. all my files are remote!
>
> anyone have a work around for this?
>
Edit locally and FTP manually.
Or get some kind of mounted FTP filesystem....doesn't Windows XP have
something like this built in....?
--
DB_DataObject_FormBuilder - The database at your fingertips
http://pear.php.net/package/DB_DataObject_FormBuilder
paperCrane --Justin Patrin--
--- End Message ---
--- Begin Message ---
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 filesystem....doesn'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/package/DB_DataObject_FormBuilder
JP> paperCrane --Justin Patrin--
I use a program called webdrive
(http://www.webdrive.com/index.php?pg=./products/webdrive/index)
that sets up the remote site as a
local drive which works really well.
--
regards,
Tom
--- End Message ---
--- Begin Message ---
> 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 this bug just appears when a user sees the first page after the
login, so I think this part works correct. Going to look on other lines! :)
Thanks for help, all of you! :)
--- End Message ---
--- Begin Message ---
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" messages after the query. The
> same query from the mysql client works fine, there are no connection
> problems... anyone has tried PEAR with mysqli?.
>
> <?php
> // Create a valid DB object named $db
> // at the beginning of your program...
> require_once 'DB.php';
>
> $db =& DB::connect('mysqli://prueba:[EMAIL PROTECTED]:3306/mibase');
> if (DB::isError($db)) {
> die($db->getMessage());
> }
>
> // Proceed with a query...
> $res =& $db->query('SELECT * FROM users');
>
> // Always check that result is not an error
> if (DB::isError($res)) {
> die($res->getMessage());
> }
> ?>
>
> result:
>
> DB Error: unknown error
>
Echo $res->getUserInfo() as well. It has the real error.
--
DB_DataObject_FormBuilder - The database at your fingertips
http://pear.php.net/package/DB_DataObject_FormBuilder
paperCrane --Justin Patrin--
--- End Message ---
--- Begin Message ---
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 of data to populate the
system, since you are calling everything anyways, why work more when
another column can be used and have multiple uses??
My $.02
Robert
--- End Message ---
--- Begin Message ---
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 PROTECTED]> wrote:
> 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 needs to display the full name of the State. I want to
> display the information in a four column table that kicks out as many
> rows as needed. Now in order to get the full name of the state, I'm
> running the state result through a switch statement. Actaully, it's
> working rather well expect for this little issue:
>
> Row 8: South Dakota Tennessee Texas Virgina
> Row 9: West Virgina Wisconsin Texas Virgina
>
> I need to kill that extra Texas and Virgina.....here's how I'm doing this:
>
> <table border=1>
> <?
> $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=mysql_fetch_array($query);
> $q4=mysql_fetch_array($query);
>
> (4 Switch statements here one for q1, q2, q3, q4)
> ?>
>
> <tr><td><?= $state1 ?></td><td><?= $state2 ?></td><td><?= $state3
> ?></td><td><?= $state4 ?></td></tr>
>
> <?
> }
> ?>
>
> Any thoughts, let me know if more information is needed.
>
> TIA.
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--- End Message ---
--- Begin Message ---
I'm a Brian, but you can't pick me unless you're a really hot chick.
- Brian
--- End Message ---
--- Begin Message ---
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 hot chick.
>
> - Brian
--- End Message ---
--- Begin Message ---
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($file));
// dump the file and stop the script
fpassthru($fp);
fclose($fp);
exit;
}
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 recognize it as a PDF file. Is there anything in this code which
could possibly (always) cause an extra byte (0A) to be added before the
real start of the file? And no, the file is not corrupted (I've
already tried that) - this only happens when it goes through this
script, and not loaded directly as example.com/file.pdf.
Scott
--- End Message ---
--- Begin Message ---
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 recognize it as a PDF file. Is there anything in this
code which could possibly (always) cause an extra byte (0A) to be
added before the real start of the file? And no, the file is not
corrupted (I've already tried that) - this only happens when it goes
through this script, and not loaded directly as example.com/file.pdf.
I've seen cases where extra buffer content gets added to the downloaded
file. The problem was fixed by deleting any existing buffer before
sending the file to the client. Not sure that will solve the problem
but it's worth a shot.
Larry
--- End Message ---
--- Begin Message ---
* 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 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 recognize it as a PDF file. Is there anything in this code which
> could possibly (always) cause an extra byte (0A) to be added before the
> real start of the file? And no, the file is not corrupted (I've
> already tried that) - this only happens when it goes through this
> script, and not loaded directly as example.com/file.pdf.
The reason this can happen is if you are including a file that
looks like this:
<?php
// content of includ file
?>
EOF
To find out where this is, turn error_reporting(E_ALL); and
ini_set('display_errors', true); you'll get a message telling you
that output was sent before the headers, and on what line the
output started on.
Curt
--
First, let me assure you that this is not one of those shady pyramid schemes
you've been hearing about. No, sir. Our model is the trapezoid!
--- End Message ---
--- Begin Message ---
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
--- End Message ---
--- Begin Message ---
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 contest when it comes to mobiles or desktop applications.
I know this is probably one of those religious war topics, but I'd still
like your feedback.
-Ed
--
Raditha Dissanayake.
------------------------------------------------------------------------
http://www.radinks.com/sftp/ | http://www.raditha.com/megaupload
Lean and mean Secure FTP applet with | Mega Upload - PHP file uploader
Graphical User Inteface. Just 128 KB | with progress bar.
--- End Message ---
--- Begin Message ---
Any recommendations on books, links, tutorials, etc. for PHP 5's new DOM /
XML stuff?
Thanks,
Ed
--- End Message ---
--- Begin Message ---
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
--
christian stocker | Bitflux GmbH | schoeneggstrasse 5 | ch-8004 zurich
phone +41 1 240 56 70 | mobile +41 76 561 88 60 | fax +41 1 240 56 71
http://www.bitflux.ch | [EMAIL PROTECTED] | gnupg-keyid 0x5CE1DECB
--- End Message ---
--- Begin Message ---
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 weird....I've never seen that one.
Apparently they're from an annoying spam service that someone on this
list has subscribed to and not actually from the list itself.
They seem to have caused quite a disturbance on a few lists recently.
Safe to ignore, setup a filter, and delete.
- Chris
--- End Message ---
--- Begin Message ---
* 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 weird....I've never seen that one.
> >
>
> Apparently they're from an annoying spam service that someone on this
> list has subscribed to and not actually from the list itself.
At closer look at the message, it isn't from someone subscribed to
the list using that service, it is someone injecting the messages
to the person posting to the list.
Note the email of whom is claiming to be using the service, it is
[EMAIL PROTECTED], php does not use that service!
Curt
--
First, let me assure you that this is not one of those shady pyramid schemes
you've been hearing about. No, sir. Our model is the trapezoid!
--- End Message ---
--- Begin Message ---
* 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 thing. Not
to mention they appear to be some sort of marketing scheme as well.
Curt
--
First, let me assure you that this is not one of those shady pyramid schemes
you've been hearing about. No, sir. Our model is the trapezoid!
--- End Message ---
--- Begin Message ---
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.com/XXX to
http://mysite.com/redirect.php?XXX
> >
> > and I need to also include to space char, for example
> >
> > that transforms http://mysite.com/AB XX to
http://mysite.com/redirect.php?AB
> > XX
> >
> >
> > I didn't find a way to write the " " characters. I tested with
RewriteRule
> > ^(([0-9]|[A-Z]|[a-z]|_| )+)$ redirect.php?$1 [L] but didn't work.
> >
> > Thanks!
> > Rob
> >
>
> Did you try
>
> RewriteRule ^([0-9A-Za-z_%]+)$ redirect.php?$1
>
> ?
--- End Message ---
--- Begin Message ---
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 simple but, its really not working..
--
Louie Miranda
http://www.axishift.com
--- End Message ---
--- Begin Message ---
--- 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);
> header('Location: clients/FILES/$catchresult');
>
> Hmm, it seems simple but, its really not working..
Yes it is simple just change your single quotes to
double quotes. i.e.
header("Location: clients/FILES/$catchresult");
zareef ahmed
>
> --
> Louie Miranda
> http://www.axishift.com
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
=====
Zareef Ahmed :: A PHP Developer in Delhi(India).
Homepage :: http://www.zasaifi.com
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail
--- End Message ---
--- Begin Message ---
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_view->getOne($getfile);
> header('Location: clients/FILES/$catchresult');
>
> Hmm, it seems simple but, its really not working..
>
When using single quotes, variables aren't replaced by their content.
Using double quotes would fix it, but consider this alternative:
header('Location: clients/FILES/'.$catchresult);
Cleaner, more obvious that you're using a variable, will be
highlighted correctly by syntax highlighters, and, most important,
it's faster. :-)
--
DB_DataObject_FormBuilder - The database at your fingertips
http://pear.php.net/package/DB_DataObject_FormBuilder
paperCrane --Justin Patrin--
--- End Message ---
--- Begin Message ---
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
> > 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 simple but, its really not working..
> >
>
> When using single quotes, variables aren't replaced by their content.
> Using double quotes would fix it, but consider this alternative:
>
> header('Location: clients/FILES/'.$catchresult);
>
> Cleaner, more obvious that you're using a variable, will be
> highlighted correctly by syntax highlighters, and, most important,
> it's faster. :-)
>
> --
> DB_DataObject_FormBuilder - The database at your fingertips
> http://pear.php.net/package/DB_DataObject_FormBuilder
>
> paperCrane --Justin Patrin--
>
--
Louie Miranda
http://www.axishift.com
--- End Message ---
--- Begin Message ---
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/phpize[48]: cd: /usr/local/lib/php/build - No such file or directory
/usr/local/bin/phpize[49]: cd: /usr/local/lib/php/build - No such file or directory
/usr/local/bin/phpize[53]: cannot open /usr/local/lib/php/build/phpize.m4: No such
file or directory
aclocal: `configure.ac' or `configure.in' is required
I checked to see if /usr/local/lib/php/build exists but it doesn't.
Looks to me php didn't install the devel files. I searched some news groups
and it looks like the are more people with this problem. But i havn't
seen any answer.
$ ./configure --enable-apc
$ make
$ make install
Thijs Lensselink
Web Developer
Factotum Media B.V.
Postbus 335, 1200 AH Hilversum
Oosterengweg 44, 1212 CN Hilversum
Telefoon: 035 688 11 82
Fax: 035 688 11 17
E-mail: [EMAIL PROTECTED]
www.factotummedia.nl
"certamen inter mammosas tunicis madefactis vestitas"
--- End Message ---
--- Begin Message ---
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 thing. You don't need "distinct" because you are already
> using "group by".
>
> Mike
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
Louie Miranda
http://www.axishift.com
--- End Message ---
--- Begin Message ---
now its working,
i was wondering if we can do max(dateposted) on update?
mysql> update datafiles set status = '1' where max(dateposted);
ERROR 1111: 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 PROTECTED]> wrote:
> 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 thing. You don't need "distinct" because you are already
> > using "group by".
> >
> > Mike
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
> >
> >
>
>
> --
> Louie Miranda
> http://www.axishift.com
>
--
Louie Miranda
http://www.axishift.com
--- End Message ---
--- Begin Message ---
Louie Miranda wrote:
now its working,
i was wondering if we can do max(dateposted) on update?
mysql> update datafiles set status = '1' where max(dateposted);
ERROR 1111: Invalid use of group function
WHERE dateposted = max(dateposted);
Perhaps ( works in Firebird :) )
--
Lester Caine
-----------------------------
L.S.Caine Electronic Services
--- End Message ---
--- Begin Message ---
The original message was included as attachment
--- End Message ---
--- Begin Message ---
I have never programmed anything
I know html and really want to know php
where is the best place to go for some really basic tutorials to start with ?
Thank in advance
--- End Message ---
--- Begin Message ---
phpfreaks.com and codewalkers.com
Or check the mailing list archives, others have been mentioned before.
--- End Message ---
--- Begin Message ---
Paul Kain wrote:
I have never programmed anything
I know html and really want to know php
where is the best place to go for some really basic tutorials to start with ?
Thank in advance
Hello.
There are a lots of tutorials around the net.
www.phpbuilder.com <--- Very nice site for developers
www.php.net <--- PHP official site. Look in the manual, every function
(or almost any) has a description and comments from people around the
globe with improvements and tips.
Since you never programmed before, i recomend you to buy some PHP
beginner books, cause always cover programing from the begining. but, if
you can affort it, buy some programing books, with no relation to any
programing language. It would be best for you to understande the basics
without knowing any programing language... almost of them starts with C
language, witch is very nice to start !
by the way, its nice for you to start programming with PHP. you will
love it !!
--
[EMAIL PROTECTED]
--
Divisao de Informatica
[EMAIL PROTECTED]
Tel: +351 272 000 155
Fax: +351 272 000 257
--
Hospital Amato Lusitano
Av. Pedro Alvares Cabral
6000-085 Castelo Branco
[EMAIL PROTECTED]
Tel: +351 272 000 272
Fax: +351 272 000 257
--- End Message ---
--- Begin Message ---
Thanks for that Jason
Any suggestions on how I would retrieve the next to last entry...? The last
time prior to this session that the user logged in...?
--
-----------------------------
Michael Mason
Arras People
www.arraspeople.co.uk
-----------------------------
"Jason Davidson" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> 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 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 General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
--- End Message ---
