Is it perhaps actually MAX and MIN?
SELECT MAX(profit) FROM schemes WHERE revenueexpenses
(not tested, confirmed etc :P)
HTH
Beau
// -Original Message-
// From: Jeff Oien [mailto:[EMAIL PROTECTED]]
// Sent: Tuesday, 12 March 2002 10:20 AM
// To: PHP-DB
// Subject: [PHP-DB] GREATEST,
andy, this should be pretty basic - just try something along the lines of
1. SELECT country/codes from DB [1]
2. loop thru those results [2]
a. check if a file called country code-map.gif exists[3], if it
does,
rename[4] it to matching country name-map.gif
b. if
could you perhaps do the select on the first page, then store the results in
a session (array) and just load different indexed portions of the resultset
each page?
only problem there is that you wouldn't get any refreshed results while
browsing those pages - but i don't know if this matters for
SELECT * FROM quotes ORDER BY RAND() LIMIT 1
something like that, take a quick look in the MySQL (or other) docs for the
RAND() function.
HTH
Beau
// -Original Message-
// From: Dan Swensen [mailto:[EMAIL PROTECTED]]
// Sent: Wednesday, 3 April 2002 1:45 PM
// To: [EMAIL PROTECTED]
//
Dave,
would it be possible (not ideal, but might work) to do something like this;
- user fills out form
- user clicks submit
- submit fires off 2 events, one submits to AFD server, the other opens a
new window, behind the current, submits certain values (the 3 new ones) and
saves them into
brandon,
you can only ever upload 1 file per file input box, but you can have more
than one of these input fields per form. you might have something like
input type=file name=file1
input type=file name=file2
input type=file name=file3
that way when you are processing (assuming PHP4+) you can
could you perhaps save the contents directly into a file, then read the file
into the database?
I know for a fact (http://www.dentedreality.com.au/webpad/) that you can use
a textarea to pump more info than that into a file, but haven't tried doing
it straight into a database.
HTH
Beau
//
basically it means that you have an invalid regular expression pattern in a
regex function.
i think it's something to do with the . * ? + symbols - but just take a good
look at your pattern and somewhere in there it is invalid :)
HTH
Beau
// -Original Message-
// From: Camelia Enderby
there might even be some cool SQL you can use tho, which would avoid having
to get the data out and then put it back in again.
I *think* (don't quote me on this) I remeber seeing something like
UPDATE myTable SET myField = CONCAT(myField + 'new string of stuff here')
WHERE myID='1'
HTH
beau
jen,
assuming you are currently looking at a page which is something like
php.php?record=3, then you should be able to just do
a href='php.php?record=?php echo ($record-1) ?'Previous record/aa
href='php.php?php echo ($record+1) ?'Next record/a
and then on the php.php page, you would obviously
3:14 PM
// To: [EMAIL PROTECTED]
// Subject: Re: [PHP-DB] Link for next db record
//
//
// This line sets $row[rv_space]
// echoTRTDSearch Record by Space Number
// /TDTDnbsp;INPUT size=4
// name=rv_space/TD/TR;
//
//
//
// Beau Lebens [EMAIL PROTECTED] wrote in message
// news:[EMAIL
Memory Leak?
check task manager periodically over that time to see how much memory IIS is
hogging (under Processes - you might have to add the column Mem Usage)
Other than that... my only suggestion would be to upgrade to Apache :)
(and yes, I intentionally use the phrasing - upgrade :)
Beau
Larry, take a look in the MySQL manual (or other SQL reference, but MySQL
has it there)
String Functions
http://www.mysql.com/doc/S/t/String_functions.html
Particularly, look at (no named anchors that I can see :)
LOCATE(substr,str,pos)
ie, you could use perhaps
LOCATE( , yourField, 95)
?
if it's only a one-off thing, you could use php to get all table names
(mysql_list_tables) and then go thru and create an array of the names that
match your criteria, then go thru that array and DROP each one progressivly.
HTH
Beau
// -Original Message-
// From: John Hughes
you have to change the Content-Type header or something (text/html) but the
easiest way is to use a pre-packed class (unless you really want to do it
yourself). Check out hotscripts or just do a google for php mail class or
similar :)
HTH
Beau
// -Original Message-
// From:
A cleaner option might be to do this before you get it to PHP at all, via
your SQL query.
Check out the string functions available, there are a number of
substring-style things available, string position etc.
HTH
Beau
// -Original Message-
// From: Ed Gorski [mailto:[EMAIL PROTECTED]]
chris, you'll need to do a little PHP manipulation, perhaps (pseudo)
if -word. (regular expression?)
for each -word
SQL .= NOT LIKE '%word% AND'
endforeach
endif
for each other word
SQL .= LIKE '%word%' AND
endforeach
strip trailing AND
clean up SQL as
htmlspecialchars()
Beau
// -Original Message-
// From: Larentium [mailto:[EMAIL PROTECTED]]
// Sent: Thursday, 30 May 2002 10:40 AM
// To: [EMAIL PROTECTED]
// Subject: [PHP-DB] Truncated Data
//
//
// Hello,
//
// I desperately need help... I've based my entire project on
// the
have you declared the variables as global int eh function?
eg
function foo($bar) {
global $this, $that, $theOther;
[...]
}
that way $this, $that and $theOther variables are available everywhere
HTH
Beau
// -Original Message-
// From: James Kupernik [mailto:[EMAIL
Keiran,
in your second page, you refer to $textfile as the thing that you want to
load into the database; this file doesn't exist on the server, so it is
inserting nothing I would imagine.
You need to use something like $_FILES['tmp_name'] to refer to the actual
file, once it has been
also, you might like to do some client-side validation before sending it to
the server, in which case you can use somehting like
http://www.dentedreality.com.au/jsvalidation/
HTH
Beau
// -Original Message-
// From: [EMAIL PROTECTED]
// [mailto:[EMAIL PROTECTED]]
// Sent: Friday, 21
make sure there are no # chars in there, unless you have commented lines
out (as below)
# commented line
in phpMyAdmin that is a comment, and the way it reads, if there's a # on a
line, it comments from there onwards (from memory)
HTH
Beau
// -Original Message-
// From: Chase
how about when u open the new window (using something like window.open(...))
you make it open a URL something like foobar.php?var1=foo and then on that
page (foobar.php) you can grab the value of $var1 as foo
HTH
Beau
// -Original Message-
// From: its me [mailto:[EMAIL PROTECTED]]
//
Keiran,
A couple possibilities for you;
1. Try referring to the field (in JavaScript) as something like; (might have
to play around with this)
document.existing[groupchoice[]].selectedIndex
2. Make it so that each selection on the select tag is mirrored into
another hidden input field
have you closed all browser windows?
eg. if you open your browser, then spawn a new window (ctrl-n or similar)
then do something with one of them which creates session vars, then close
that window, then open a new one again, the session has probably remained
active because the first window was
Also, as far as limitations go, the following are considerations;
1. You can't pass an array using the querystring
2. Multiline variables (ie. textarea contents) are bad
3. There is a limit of 255 or something characters to a URI (someone?)
4. Be careful with the $_GET[] array that Tony
/a';
then on link.php you'd have the array $array[] (with globals) or
$_GET['array'][]
cool
Beau
-Original Message-
From: Adam Royle [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 10 July 2002 9:05 PM
To: Beau Lebens; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] A Simple Question
Just
Jonathan,
most (all?) of the database query-related functions in PHP return a
Resource ID which contains the data resulting from your query. To access
that information, you need to pass the Resource ID thru a function like
(assuming u r using MySQL) mysql_fetch_array() or mysql_fetch_row()
Have
Chip, a couple ideas
1. why not display the select list something like this
select name=month
option value=00Please Select/option
option value=01January/option
option value=02February/option
...
/select
That way the user sees the names of the months, but your database gets sent
nice,
or alternatively just do something similar to what you did, using either the
in-built array handling, or your own string manipulation
ie.
http://url.com/page.php?var1=foo
http://url.com/page.php?var1=bar
could be either;
http://url.com/page.php?var[]=foovar[]=bar
($_GET[var] will be an array
Bo,
you have really answered your own question (question 1) all you need to do
is replace http://detination with http://localhost/index.php?id=1 (as per
your examples) and it should send them to the page which triggers the
deletion of the page (if they confirm the box)
as far as q2 goes, you
Ruth,
your reference to $_GET('var') is close, but as you have seen - no cigar :)
using the () after GET makes it refer to a function, but it is actually an
array which is automatically created, so you need to use
$_GET['var'] (note the square brackets
as for point 2 (register_globals) did you
monty,
i found that if you do the command
DELETE FROM table
(with no WHERE clause) it deletes everything, and resets
Beau
// -Original Message-
// From: Monty [mailto:[EMAIL PROTECTED]]
// Sent: Thursday, 25 July 2002 1:34 PM
// To: [EMAIL PROTECTED]
// Subject: [PHP-DB] Resetting
Meethoo
as it says in the PHP documentation, you can access a MySQL server whether
it's on the same machine as the PHP install or not.
ie. mysql_connect('localhost', $user, $pass)
OR mysql_connect('111.111.111.111', $user, $pass)
Beau
// -Original Message-
// From: Meethoo Salim
Scott, can you just do it by sorting your query, then limiting the results
to 10?
ie.
SELECT * FROM tables WHERE somthing='1' ORDER BY date DESC LIMIT 10
should sort highest - lowest date (ie most recent, backwards) and give you
the top 10 results. then if you have the option of flipping thru
try a little thought...
http://www.google.com/search?sourceid=navclientq=php+mysql+tutorial
// -Original Message-
// From: Bryan McLemore [mailto:[EMAIL PROTECTED]]
// Sent: Friday, 30 August 2002 2:52 PM
// To: PHP LIST
// Subject: [PHP-DB] MySQL/PHP
//
//
// Where can I find a
I'd use var inclusions like this;
VALUES (' . $_POST['Name'] . ',
that might help you
// -Original Message-
// From: Shoulder to Shoulder Farm [mailto:[EMAIL PROTECTED]]
// Sent: Monday, 2 September 2002 11:42 AM
// To: PHP Database List
// Subject: [PHP-DB] What's wrong with this
can't you just make the name of the file include a unique identifier of some
sort, or store each user's files in a different directory or something, to
make sure that they can't overwrite each other's (or their own) files?
Or would that not work in your app?
HTH
Beau
// -Original
try phpMyAdmin - nice and easy, although i'm pretty sure there is a direct
command line.
// -Original Message-
// From: Dr. Indera [mailto:[EMAIL PROTECTED]]
// Sent: Wednesday, 4 September 2002 12:21 PM
// To: [EMAIL PROTECTED]
// Subject: [PHP-DB] Upload csv file into mysql
//
//
//
i'm running php 4.2.2 and apache2 on my win2k laptop and it appears to be
running fine (stable etc) but obviously only as a dev platform, so not under
any sort of load or anything like that. also not running particularly
complex operations, so don't know about how it will handle that :)
but it
nope - an id is used for other things (like javascript, style sheets, DHTML
etc). They shouldn't affect your variable names.
HTH
Beau
// -Original Message-
// From: Michael Zornek [mailto:[EMAIL PROTECTED]]
// Sent: Wednesday, 18 September 2002 6:41 AM
// To: [EMAIL PROTECTED]
//
just use
?php
$filename = C:\\Documents and Settings\\roslyn\\My Documents\\note.txt; //
note double-slashes
$contents = join('', file($filename));
echo $contents;
?
should work. your parse error is probably because of the \ in your
filename, you need to escape them with another \.
HTH
Beau
\\note.txt, r);
// $contents = fread ($fp, filesize ($filename));
// echo $contents;
// fclose ($fp);
// ?
//
// regards,
// roslyn
// Beau Lebens wrote:just use
//
// $filename = C:\\Documents and Settings\\roslyn\\My
// Documents\\note.txt; //
// note double-slashes
// $contents = join('', file
\\My
// Documents\\note.txt;
// $fp = fopen (C:\\Documents and Settings\\roslyn\\My
// Documents\\note.txt, r);
// $contents = fread ($fp, filesize ($filename));
// echo $contents;
// fclose ($fp);
// ?
// /body
//
// /html
//
// regards,
//
// roslyn
//
// Beau Lebens wrote:what exact
If it's on MySQL, then the problem is that it doesn't support nested queries
:)
If it's on something else, i'm afraid i don't know :/
Back to MySQL, you can get around that by doing your select author_code
from authorxcat component query, then put the results into 'x', 'y', 'z'
format, then do
*** APOLOGIES FOR CROSS POSTING ***
I haven't done this directly, but I imagine the process would be similar to
working with images, and the same restrictions/rules of thumb would apply
regarding storing them in the db versus storing them on the filesystem, i.e.
store the flash files in the
you don't see them because they are interpreted as HTML tags, they are
unknown, so they are ignored.
options;
1. View - Source
2. Encode all as lt; (HTML version) and it will display it all
as text, then you can copy-paste it to somewhere else
3. Wrap it all in a pre tag, then follow 2.
you can do this as a part of your db query
check the string functions available for your rdbms.
mysql would use something like;
SELECT SUBSTRING(monthname(blah), 0, 3) AS monthAbbrev FROM tablename
from memory
HTH
beau
// -Original Message-
// From: John Coder
did you try echoing the value of $id after you have assigned it?
you may find it's because you aren't connected to your database or something
and also, i am assuming that you are using a recent install/verison of PHP,
because $_GET wasn't available until the last few releases.
beau
//
Not that there is actually a question in there...
I assume your question is How do I pass a value from a window which was
opened via JavaScript, back to the window which opened it
Short answer: window.opener -- read up in a javascript reference manual
about this object.
Longer answer
after
[php.ini]
register_globals=On
Beau
// -Original Message-
// From: Martin Allan Jensen [mailto:[EMAIL PROTECTED]]
// Sent: Wednesday, 20 November 2002 12:41 PM
// To: [EMAIL PROTECTED]
// Subject: [PHP-DB] standart variabels melfunction
//
//
// Hi all,
//
// I have a problem with my
implode accepts an *array* as input, not a string.
you would need to change your $sqlUpdate to be an array, and each statement
look something like;
if($textfield12 != '') { $sqlUpdate[] = textfield12='$textfield12'; }
of course it would probably be easier to just do something like this;
// Example:
$foo = BAR;
${'new' . $foo} = some string;
// this should do it i think, in this case creating a var called $newBAR
HTH
Beau
// -Original Message-
// From: Martin Allan Jensen [mailto:[EMAIL PROTECTED]]
// Sent: Monday, 2 December 2002 10:30 AM
// To: [EMAIL PROTECTED]
//
long story short - you can't
you can only call a function in javascript or some other client-side
scripting language like that, and you would use the onSubmit= attribute of
the form tag.
by the sounds of what you want to do - i would say you would do something
like;
1. load values from db and
Look at the section in the manual on how to upload files via HTTP (Under the
Features chapter from memory) for working with the images. a couple other
things to think about;
1. some sort of validation on the images to make sure they are images
(extension/mim-type?)
2. confirm that you can
This won't work, because the HOST needs to be able to access the files on
your machine, which is a gross security risk, and isn't possible in this
manner.
The only way I can think of that you would be able to do anything useful
like that would be to have an HTML page load an image using
img
of the 'city'
// symbols...
//
// So... what I gonna do to increase the speed ???
//
// --www.kapsul.org--
// DuFronte
//
// -Original Message-
// From: Beau Lebens [mailto:[EMAIL PROTECTED]]
// Sent: Tuesday, December 10, 2002 1:55 PM
// To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED
101 - 157 of 157 matches
Mail list logo