reign webserver as credentials during the HTTP GET? Anyone done
something similar?
-P
Peter Westergaard
ICQ#: 10294457
[EMAIL PROTECTED]
http://www.westergaard.ca
http://courtly.livejournal.com
---TECHNOLOGY---
Human history becomes more and more a race between education and catastrophe.
that I'm aware of, how would
you best handle this dangerous potentiality? Suggestions? A humble
request: Responses which begin with: "Don't use MySQL", please include
a good affordable alternative?
-P
Peter Westergaard
[EMAIL PROTECTED] ### ICQ#: 10294457
http://www.
w close the table.
echo "";
// and we're done!
note, I didn't test this code. But it should do what you want.
--
Peter Westergaard
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Lars,
One idea that occurs to me, and it's a tradeoff from Torsten's idea (which
is to read the whole database, and parse out the unique rows), is to first
execute your "SELECT DISTINCT distinct_col FROM table", and then walk
through that, and for each one issue a "SELECT * FROM table WHERE
distin
I think you want:
"SELECT * FROM routes, users WHERE area='$area' AND style='$style'
AND rating BETWEEN '[$rating1]' AND '[$rating2]' GROUP BY route
ORDER BY rating ASC ";
>From http://dev.mysql.com/doc/mysql/en/Comparison_Operators.html
"expr BETWEEN min AND max
If expr is greater than or equal
Oh, and I assume you left out the part of the query where you bound tables
routes and users?
-P
"Craig Hoffman" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> "SELECT * FROM routes, users WHERE area='$area' AND style='$style'
> BETWEEN rating='[$rating1]' AND rating='[$rating2]' GRO
"Rosen" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I have an orders with one main record in table1 ( client, date, e.t.c. )
and
> detail description in table2 ( all materials with quant, price, e.t.c. )
> and I save data in table1 for positions (range of id - autoinc field of
I've done exactly this for a really cheap-and-dirty instance where two
people were doing bulk data entry into two different instances of a mysql
table which would eventually be stitched together. by giving one a higher
range, the data migration afterwords was very easy.
Other than that, can't ima
I'm developing a site where I anticipate the need to make several updates to
several forms, and I'll want to "commit" them all at once (i.e. if there's a
failure with any of the transactions, I'd like to be able to back out to
before I started).
Is there a decent way to do this with PHP and Mysql?
... or, am I barking up the wrong tree with Mysql, and should I change
database platforms? (You'll never convince me to give up PHP though.
muahaha. Except for sql-level stored procedures where necessary, that is).
-P
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: htt
> I was about to suggest the same, the latest builds of MySQL have theese
> functions from what I knew... I think youll find what you need there.
Thanks, Kim.
Any stable and fairly affordable hosts out there using these latest builds?
Mine is back a few, no transactional functionality that I can
"Damien Babilon" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> the mssql_connect function work right, but php give me back this message
when I try mssql_init:
> Fatal error: Call to undefined function: mssql_init() in
/var/www/eurogsmtest/test.php on line XX
Shouldn't you use mssql
Could I get a plain-language explanation of the process of a 'hold'? I'm
not entirely clear what is happening, and what an 'expiry' means in the
context of the hold and what a '#1 position' would represent for a student.
-P
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visi
I guess I'm still not grasping...
Who creates the temporary "I'm-trying-to-place-you" link between
coordinator and student? The system automatically, or the coordinator
manually?
What is a "#1 position"? How does a student get there? Who or what
places them there? How do they leave that posit
Ah, now I think I understand. Thank you.
> 2. A Coordinator can only hold a student while in the #1 position for a
> certain amount of time. (I don't have a problem with calculating the
> time.The problems are:
> A. What do I do with the record once there hold has expired?
> B. Also what do I do
> In the example of Bob, Mary and Barbara that I gave in my last post. If
> Bob cancels his hold and I reset date_held for mary to the current date,
> so that she has adiquite time to place her student. If I do that this
> will put Barbara into the #1 position because she has now put a hold
> bef
"Lisi" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I am running a script (called through a browser) that checks entries in a
> table one at a time. As the table has grown, the script takes longer to
run
> than is allowed - 30 seconds.
Of course, I have to ask... is there absolut
> In other words, how do we prevent two users from using the same password
to access the same account at the same time?
There are a few strategies I'd consider... each has plusses and minuses.
1) Lock to one IP. Keep a table with the most recent IP address, and the
most recent access time. Any
"Steve Butzel" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> It appears that Apache/PHP still thinks the session.save_path is /tmp,
even
> though I changed this in php.ini-recommended and php.ini-dist. **What am I
> doing wrong?**
Have you changed it in the version of php.ini which
esn't make me happy, but it
would be 'easier' to build, if not to maintain. (And, as you can appreciate, since
I'm not the one maintaining it, I'm like THAT CLOSE from just going that way and
saying 'screw em'!)
Hopefully,
-Peter Westergaard
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi,
I'm attempting to pull about 300 rows from a mysql database, (all rows in
the table).
I can pull the first 10, the first 20, the first 30, no problem. (using
LIMIT (start), (10|20|30)... in the SQL statement)
But if I attempt to pull all of them (no LIMIT clause), or even the first
(x) w
Assuming that c.province is the province name, and c.province_id is the
province code, and U.province_id is the province code from the User table,
I don't see where in your statement you have filtered the search down to
just the province_id for the CURRENT USER.
I think you need something like
Barry,
Since you're posting to an HTML page, you need and/or to produce
formatting.
I'm guessing that if you look at the SOURCE for the web page you've
produced, you'll see all the formatting.
So, you can either fetch the lyrics and replace all line-ends with , or
else use the tags or some
Miles, you wrote:
>Is your table indexed on the field your query is based on? That will
>greatly speed up the query.
>
>Miles Thompson
I'm afraid in my case, the query needs to be pretty much a complete table dump.
Even if I filter a subset the data, my relational DB experience (not deep,
ad
Thanks to Miles!
The problem, for anyone who is going through this themselves lay (in my
case) with my php.ini file - evidently my fat fingers copied the
'recommended' php.ini file, instead of the 'distro' php.ini file.
The 'Recommended' file contains a few optimizations and security patches,
Thanks to Miles!
The problem, for anyone who is going through this themselves lay
(in my case) with my php.ini file - evidently my fat fingers copied
the 'recommended' php.ini file, instead of the 'distro' php.ini file.
The 'Recommended' file contains a few optimizations and security
patches
George,
When you use:
$prd
Why not use the Product ID in the VALUE tag, and use the Product
NAME between the OPTION /OPTION tags?
That way, the VALUE is what is selected, and you can then use an
SQL INSERT or UPDATE command to push that into the destination table.
One less check aga
It seems like what you're looking for is first to do a "SELECT DISTINCT
.." to find all the unique topic names in the system.
This, in your case, would present you with Billie, Bill, Bret, ... etc.
Then, in a loop as you traverse this result, create a query for the
count of each of these spe
At 08:03 AM 1/9/2002 -0800, Max wrote:
>Just curious, but which version of PHP are you using, the ISAPI or CGI.
>I've tried the isapi version before and had problems like this. PHP
>would crash and leave orphaned instances of php. If your using the
>isapi version try the cgi and see if it work
>hallo guys!
>
>i'm a newbie in php..I've installed phpMyAdmin on my pc, together with MySQL
>and Apache with PHP 4 on Win98.
>
>the index.php page is blank! any ideas/suggestions from u ppl?
>
>gracias!
Can you post some of the code from your index.php?
Have you installed it all correctly, ie p
>I'm trying to use PHP and MySQL to query a table and write the contents to a
>new file. When run the command to outfile it tells me I don't have
>permissions. This is on a Unix machine.
I haven't run this on Unix myself, but I think this answer might be
useful. Someone please correct me if I'
>but presumably if i'm doing a SELECT count(*) FROM Designs WHERE Keywords
>LIKE "%sport%"
>followed by a SELECT * FROM Designs WHERE Keywords LIKE "%sport%" LIMIT 0,20
>
>it's still using nearly as much processing time as just returning all the
>designs and just using a get_num_rows and then onl
At 07:34 AM 12/11/2002 +, you wrote:
I understand that the column name does not normally need quotes, but
without quotes on the column name I get a mysql error message about no
column named 'id'. Unfortunately, I cannot even get the UPDATE statement
working outside of PHP through an
p! :)
I've also uploaded the source at http://www.westergaard.ca/dierolling.
phpsrc
The webserver at westergaard.ca is Linux, but I've also tested this
on a Win2000 IIS webserver, and have the exact same results.
If anyone has any clue what is going on, I'd really ap
I guess the .phpsrc is being interpreted as PHP anyhow, so let me
just include the body of the page, below:
---
$value) print ("$key
=> $value ");
# (DEBUG) -- foreach ($HTTP_SERVER_VARS as $key => $value) print
("$key => $value ");
# (DEBUG) -- foreach ($HTTP_ENV_VARS as
uot;)
--- returns Ian, Jill
--- outputs Ian
--- calls function_name("Ian")
- returns nothing
--- outputs Jill
--- calls function_name("Jill")
- returns nothing
- outputs Danielle
- calls function_name ("Danielle")
--- returns nothing
- outputs Edward
- calls f
Sorry for what is probably going to be a late reply. I'm waiting to pick
someone up at the airport, and the plane was delayed, so I wanted to try my
hand at answering your question.
First I had to figure out what method you used to pick those dates in the
first place. It seems to be...
Today
needs aren't very complicated.
Anyone have any practical experience to share?
Apologies if this has been rehearsed a thousand times before, I see
discussions pop up in the archive but they never seem to come to a
concensus so I'm going to risk asking again...
-P
--
Peter @ westergaard .
Ben, I would say that the only reason
$select_sql_two = mysql_query($select_sql);
if($select_sql_two) {
would refuse to execute is if $select_sql represents an invalid SQL
statement. Whether it has records or not, you should (if I'm not very
much mistaken) get a resource returned in sele
Miguel -
MD5() is a "hash" function, not an encryption function. A hash function
cannot be reversed.
One of the reasons some sites use MD5() for passwords is so that the
passwords are never even stored on the server, only the hash. So even
the site's database admin can't figure out the pas
Bastien,
I think it would help if you described what result you were expecting,
what version of SQL you're using, and where your error is occurring.
I'm going to assume you're looking for a list of tours (including event
start and end dates, event name, and result) for a specific angler (in
Your line :
Should probably be:
So that each field's name isn't the string "field_id", but rather is
each field's unique ID.
Hi,
How can I send multiple values from a form to be stored in a database, as
name of the fields is the same?
For example:
";
}
elseif ($dataty
Oops, I'm sorry, recovering from a 102 fever the other day. :)
You don't want duplicate field IDs anywhere, really. The hidden fields
are probably completely unnecessary; what do you use them for?
It's the latter section you really need to correct, however, where each
data field's name is b
Rick Taylor wrote:
I'm new to PHP and having issues. We have seperate servers for them.
We can use ODBC to test the connection and it works fine. However, when
we try to run the site we get a message of *** Error: Unable to Connect
to Database. Please Try Again Later. ***
We are using a cu
I'm not sure this has to do with Variable Scope. (Scope has to do with
when you can or can't reference a variable ... for example, that you may
have defined in a different function than the currently-running code).
I don't actually understand your question that well, either. Can you
elaborat
45 matches
Mail list logo
