To answer your question, you should urlencode() the team name. However,
I would store the user in a cookie or session, and fetch the team name
on each page load. Otherwise, they can easily change which team they're
using.
Ian Fingold wrote:
Sorry I don't think I explained very well... heres
hi!
i think it would be better to make a second table because then you do not
need any of those scripts and just can use a JOIN. anyways it is better for
the database-management to make it as module as possible and saving those 4
values (which do not change?) in a enum-field - i do not know. If yo
What's the application? What are the issues with using ENUM verses
something else?
-Lisi
At 05:32 AM 6/2/03 -0400, Becoming Digital wrote:
Thanks to both Heilo and Lisi. These scripts should make things easier.
Is it safe to assume that we are in agreement about the use of an ENUM
field for
t
Thanks to both Heilo and Lisi. These scripts should make things easier.
Is it safe to assume that we are in agreement about the use of an ENUM field for
this application?
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "heilo" <[EMAIL PROTECTED]>
To: "
Hi!
there is a much shorter way to do this (which works with ENUM and SET):
$qry = 'SHOW COLUMNS FROM `gruzilla_content` LIKE "module"';
$res = mysql_query($qry);
if(mysql_num_rows($res)>0)
{
$row = mysql_fetch_row($res);
$pattern = "#(enum|set)\('(.+?)'\)#i";
$replace = '\\2';
$
I am forwarding this useful function someone once sent to the list that I
use often.
Hope this fits your needs.
-Lisi
-Original Message-
From: Russ [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 26, 2002 7:47 PM
To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Popula
I have a field in my database for which there are only four potential values
and, as such, I would like to use an ENUM field. However, I can't find an easy
way to load the "values" of this field into a select form element. Is there a
simple method for doing this or are the only solutions fairly c
Hi Ian
Comments inline...
On 01 Jun,2003 at 23:20 Ian Fingold wrote:
> link will look like this
> fant_stnd3.php?week=1&team=silly team
>
> but again, my problem is that it's cutting off the team value when there is
> a space in the string..
>
Don't allow spaces in the string ? Are we gett
Hi buttoz
Here's how I did it ...
function get_script($dbname) {
$cmd = "/usr/bin/mysqldump -u"._DBUSER." -p"._DBPASS." "._MDFLAGS." ".$dbname;
$script = `$cmd`;
return $script;
}
_MDFLAGS is a constant which holds the flags you want to pass to mysqldump ... I
commonly u
Hello,
On 06/02/2003 02:27 AM, Tony S . Wu wrote:
thanks.
but unfortunately, i still get errors:
Warning: Failed opening '/Library/WebServer/Documents/mime/test.php'
for inclusion (include_path='.:/usr/local/lib/php') in Unknown on line 0
the include path is somehow wrong...
I would need to see
thanks.
but unfortunately, i still get errors:
Warning: Failed opening '/Library/WebServer/Documents/mime/test.php'
for inclusion (include_path='.:/usr/local/lib/php') in Unknown on line 0
the include path is somehow wrong...
Tony S. Wu
[EMAIL PROTECTED]
"The world doesn't give us hope - it giv
On Sun, 2003-06-01 at 23:20, Ian Fingold wrote:
> Sorry I don't think I explained very well... heres my situation...
>
> I have a mysql database set up... I have a user table with 2
> fields..."team_name" and "fant_week".
>
> What I want to do is, depending on who is logged in, I want my link to
Check out http://www.php.net/manual/en/ref.url.php
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Ian Fingold" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, 01 June, 2003 23:20
Subject: Re: [PHP-DB] query string
Sorry I don't think I expl
Link is bad.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Jim" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, 01 June, 2003 23:24
Subject: [PHP-DB] remote commands thought www
Hey,
Where are some actual examples on url commands, ect
www
Hello,
On 06/02/2003 12:17 AM, Tony Wu wrote:
ok, i've installed a mail server on my machine (CommuniGate).
But it still doesn't work.
I've specified SMTP server in php.ini.
a frind of mine got it to work with the same configure (CommuniGate) and he said he
just put his SMTP in php.ini.
and now w
Hey,
Where are some actual examples on url commands, ect www.blah.com/modules.phpCOMMANDS.
Would really like to know the upload and download and run commands.
thanks
Sorry I don't think I explained very well... heres my situation...
I have a mysql database set up... I have a user table with 2
fields..."team_name" and "fant_week".
What I want to do is, depending on who is logged in, I want my link to
change the value of 'team' to the logged in members team nam
ok, i've installed a mail server on my machine (CommuniGate).
But it still doesn't work.
I've specified SMTP server in php.ini.
a frind of mine got it to work with the same configure (CommuniGate) and he said he
just put his SMTP in php.ini.
and now we both have tried to get it to work on two loca
Hello,
On 06/01/2003 11:55 PM, Tony Wu wrote:
thanks for the link, unfortunately, i have trouble getting it to work.
and i can't find anything document for it.
some instructions, please?
There is not big deal. Just include("smtp_mail.php") in your script and
replace your calls to mail() by smtp_m
Hi,
Does anyone know of there is a PDF version of the manual for PHP 4.3.1
available?
Thx
Tim Winters
Manager, Creative Development
Sampling Technologies Incorporated (STI)
[EMAIL PROTECTED]
[EMAIL PROTECTED]
W: 902 450 5500
C: 902 430 8498
--
PHP Database Mailing List (http://www.php.net/
On Sun, 2003-06-01 at 22:26, Ian Fingold wrote:
> I'm trying to build a query string for one of my links.. for example...
> fant_stnd3.php?week=1&team=fun%20team
>
> I need to be able to grab the values of 'week' and 'team' from an array, I
> can do that no problem, but when the code runs it cuts
thanks for the link, unfortunately, i have trouble getting it to work.
and i can't find anything document for it.
some instructions, please?
also, someone told me before that it's impossible to use mail() on OS X without
sendmail.
is it true?
On Sunday, June 01, 2003, at 07:05PM, Manuel Lemos
I'm trying to build a query string for one of my links.. for example...
fant_stnd3.php?week=1&team=fun%20team
I need to be able to grab the values of 'week' and 'team' from an array, I
can do that no problem, but when the code runs it cuts off the value if
there is a space in the string. so instea
Hello,
On 06/01/2003 10:37 PM, Tony S. Wu wrote:
hi all, i am trying to use mail() on Mac OS X 10.2 WITHOUT sendmail.
I have php.ini file in my usr/local/lib directory, with SMTP set to my
desire smtp server.
But it just doesn't work.
Does anyone here know how to use mail() on OS X?
No, the mail(
After Wracking my brain for too long on this I decided to give in and ask.
I have holes in an array that came from a database. I put the holes there with
unset some values so no prob. Now I need to fill the holes. Below is what I
have and what I need for further manipulations.
Array
(
[0] =>
Hi everyone
I changed the code a bit. Using the file tmp now.
Here's the code and the error (still error but less)
Thanks for the help
upload.php
-
error code
--
error. File: /tmp/phpObl8LE.
Warning: files
Rick,
Please give more information about your problem. Are you trying to
format a timestamp field in a MySQL table?
If yes, you can do something like,
SELECT DATE_FORMAT( columnname, '%m-%d-%y : %T-%i' );
Hope this helps...
Gurhan
On Sat, 2003-05-31 at 01:38, Rick Dahl wrote:
> I want to print
hi all, i am trying to use mail() on Mac OS X 10.2 WITHOUT sendmail.
I have php.ini file in my usr/local/lib directory, with SMTP set to my
desire smtp server.
But it just doesn't work.
Does anyone here know how to use mail() on OS X?
Thanks a lot.
Tony S. Wu
[EMAIL PROTECTED]
"The world doesn't
Hi,
Can you show the code? How r u running mysqldump in your php code? I
think phpmyadmin has such facility as well, you may want to check their
code and see how they did it ...
Gurhan
On Sat, 2003-05-31 at 06:51, buttoz wrote:
> hi,
>
> i want to backup mysql database.
> i use mysqldump command
29 matches
Mail list logo
