Yes, but mySQL 4.0 is alpha Release and Apache 1.3.22 for Win32 is not as
stable as for Unix platforms
So, let's wit a bit more!
- Original Message -
From: "suraj" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 18, 2001 10:55 AM
Subject: [PHP-WIN] released
> Hel
http://206.47.217.53/pta/index.html
WARNING: Too Controversial for the public Web! Must be 18
or older to continue! We are not responsible for your
actions! SHOCKING CONTENT!
http://206.47.217.53/pta/index.html
C-ya inside sexy!
XoXoXoXoXoX
Tonya
Hey Sexy!
*** NEVER PA
Hi,
Every different page in a framset is loaded separatly so the only thing you
should be aware of is not to output anything before the session stuff.
Also you can use the output control functions lie ob_start - check the PHP
manual for more info.
HTH
Dobromir Velev
-Original Message-
Fr
Hello, I have a question.. But in french :)
while($colonne = mysql_fetch_array($result))
Jaimerai en fonction de la valeur de $colonne[live_type_evt] quil me
modifie la variable #couleur que je reprends apres dans un echo $couleur
pour la couleur d'un texte.
Jai ca. Mais seu
Il faut tu ecrire:
if ($colonne["LIV_TYPE_EVT"] == 21)
{
$couleur = "yellow";
}
else if ($colonne["LIV_TYPE_EVT"] == 1)
{
$couleur = "009933";
}
else
{
$couleur = "FF";
}
Georges Lioumis.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Super, les 2 versions marchent. Merci
David
-Message d'origine-
De : Bas Jobsen [mailto:[EMAIL PROTECTED]]
Envoyé : jeudi 18 octobre 2001 11:35
À : david1980; [EMAIL PROTECTED]
Objet : Re: [PHP-DB] Question In French.
--
PHP Database Mailing List (http://www.php.net/)
To uns
if i unput the values 10/10/2001 into mysql database, would mysql or php
recognize that as a date??
i am a bit confused. i inserted few dates in the above format and asked
mysql to list them by date and it does not seem to work.
any suggestions?? please :)
ax
--
PHP Database Mailing List
mysql date format is -MM-DD including the hyphens)
I usually use substr() to convert it from a user's entry to the format
reqd for the database
hth
Dave
-Original Message-
From: ax [mailto:[EMAIL PROTECTED]]
Sent: 18 October 2001 10:47
To: [EMAIL PROTECTED]
Subject: [PHP-DB] date
Hi
I am trying to set-up a type of anti-flood block on one of my forms, the way
I am doing this is that when the first submission is made I log various
details into a user_log table including IP no and a Timestamp (14) column
called log_time. Now if the button is clicked again the php script will
>(NOW()+0)
Not sure what the +0 achieves?? Try with just NOW().
Cheers.
Russ
On Thu, 18 Oct 2001 11:41:14 +0100 "p.whiter" <[EMAIL PROTECTED]> wrote:
> Hi
> I am trying to set-up a type of anti-flood block on one of my forms, the way
> I am doing this is that when the first submission is made I
Was thinking along these lines, but wouldn't it change the appearance of the keyword
in some case-situations?
eg "here is your KeyWord" would become "here is your keyword"
=dn
PS haven't coded it to see
> or you could do something like
> str_replace(strtolower($search_term), "$search_term",
> s
Hello:
I'm trying to setup a generic function to use to initialize all mysql
database access for a site.. Something like
function($tablename); How can I do this and preserve the connection outside
of that function?
?
Thanks--
dustin
--
PHP Database Mailing List (http://www.php.net/)
To uns
You could try the MyODBC driver. On the www.mysql.com website I think.
Then you won't need CSV or any other type of import file.
Tony
> -Original Message-
> From: Mikusch, Rita [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, October 17, 2001 5:05 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP
Check this out:
http://gertrude.anglia.ac.uk/webteam/tips/php_sql/odbc.htm
Step by step instructions on how to connect Access to MySQL (from PC/workstation to
remote server)
Cheers.
Russ
On Thu, 18 Oct 2001 13:44:15 +0100 Tony McCrory <[EMAIL PROTECTED]> wrote:
> You could try the MyODBC driv
Hello all,
Is there a way to use wildcards in search in a mySQL db?
e.g. I have a dbase of over 24000 records and i can only search exact
matches is there a way to search something like this : *admin* in mySQL? Or
i have to do it by hand in PHP?
Thanks
Sir Thomas "omega" Henning
--
PHP Datab
select from where like
'%searchword%'
RTFM!!!
-Original Message-
From: Thomas "omega" Henning [mailto:[EMAIL PROTECTED]]
Sent: 18 October 2001 14:58
To: [EMAIL PROTECTED]
Subject: [PHP-DB] wildcard in mysql search with php
Hello all,
Is there a way to use wildcards in search in
Thanks Tomy for the idia i could use the same code for my search programs
Sir Thomas "omega" Henning
"Chris Payne" <[EMAIL PROTECTED]> wrote in message
news:000c01c15736$49ea31e0$0200a8c0@chris...
Hi there everyone,
I'm becoming regular on here hehehe :-)
I have my search engine working great (
Hi
Thanks for your reply, I have tried this using NOW() and NOW()+0, there is
no difference, I think I have narrowed the problem down to the time part of
the timestamp being disregarded, as I have written the query below it is
making the calculation using days rather than seconds..
This shou
> From: Thomas "omega" Henning [mailto:[EMAIL PROTECTED]]
> Subject: [PHP-DB] wildcard in mysql search with php
>
> Is there a way to use wildcards in search in a mySQL db?
> e.g. I have a dbase of over 24000 records and i can only search exact
> matches is there a way to search something like thi
Thanks for all of the input. Here is the solution that I finally went:
DATE_FORMAT(v_date, '%b %e, %Y') AS v_date
v_date being the column name.
--
Jason L. West, Sr.
Web Architect
SalesTek Inc.
"Jason" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]...
> DATE_FORMAT is a MySQL fun
The % can be empty space or 'n' characthers. The LIKE command in mysql also
make the query very dynamic.
- trond
> -Opprinnelig melding-
> Fra: Dave Watkinson [mailto:[EMAIL PROTECTED]]
> Sendt: 18. oktober 2001 14:50
> Til: [EMAIL PROTECTED]
> Emne: RE: [PHP-DB] wildcard in mysql search
Sure use:
SELECT * FROM WHERE foo LIKE '%$bar%'
selects all records where 'bar' is found somewhere in the search string.
See also: http://www.mysql.com/doc/S/t/String_comparison_functions.html
HTH :-)
Russ
On Thu, 18 Oct 2001 15:57:56 +0200 "Thomas \"omega\" Henning" <[EMAIL PROTECTED]>
wro
thanks
"Dave Watkinson" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
select from where like
'%searchword%'
RTFM!!!
-Original Message-
From: Thomas "omega" Henning [mailto:[EMAIL PROTECTED]]
Sent: 18 October 2001 14:58
To: [EMAIL PROTECTED]
Subje
Take a good look at the manual page, it helped me out a bunch of times:
http://www.mysql.com/doc/D/a/Date_and_time_functions.html
Good luck.
Russ
On Thu, 18 Oct 2001 14:02:34 +0100 "p.whiter" <[EMAIL PROTECTED]> wrote:
> Hi
> Thanks for your reply, I have tried this using NOW() and NOW()+0, th
Using jsp I can create an array of multiple actions and pass them to an ldap
server as one request. Is there a way to do this using php.
Specifically I need to perform a delete action on "userPassword" where
value="oldPassword" and an add action passing "userPassword" and
value="newPassword". T
The manual says...
Remember that the header() function must be called before any actual
output
is sent, either by normal HTML tags blank lines in a file, or from PHP.
It is a
very common error to read code with include(), or require(), functions,
or another
file access function, and h
Buy a good book on PHP and MySQL.
Try ideveloping the application yourself.
If you then run into problems, post your question here.
-Original Message-
From: moi [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 17, 2001 11:54 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] PHP Code is Nee
[*NOTE* - I sent this yesterday. Since I didn't receive a copy
back from the listprocessor, I assumed that it was lost somewhere
along the way. --TGN ]
Hmm I'd first put a "or die" clause onto
the clause...
$updated = mysql_query
> I'm trying to setup a generic function to use to initialize all mysql
> database access for a site.. Something like
> function($tablename); How can I do this and preserve the connection outside
> of that function?
> ?
Hi Dustin,
Do you want something like: "Making arguments be passed by refer
$query = "SELECT sum(my_column) AS total FROM mytable WHERE some_condition";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
print "Sum of my_column is: ".$row['total']."\n";
-Original Message-
From: Mark Weber [mailto:[EMAIL PROTECTED]]
Sent: Thurs
On Thursday 18 October 2001 18:41 pm, p.whiter wrote:
> Hi
> I am trying to set-up a type of anti-flood block on one of my forms,
> the way I am doing this is that when the first submission is made I
> log various details into a user_log table including IP no and a
> Timestamp (14) column called l
Thanks for the reply, but the Timestamp(14) column (log_time) in my DB saves
the time as '20011018134612' this is the same format as the NOW()+0 I think?
I have tried various methods to get this to work. I've gone through the
manual and various books I have here but am having no joy at all.
I ha
On Thursday 18 October 2001 23:11 pm, p.whiter wrote:
> Thanks for the reply, but the Timestamp(14) column (log_time) in my
> DB saves the time as '20011018134612' this is the same format as the
> NOW()+0 I think?
>
> I have tried various methods to get this to work. I've gone through
> the manual
Hi all,
i'm really new in php (working on my first project9 and i got the following
situation:
i have a loop going through a result set of an odbc-query. each row of this
loop has to be checked if there is an entry in another table. so as the last
odbc-query is the same for each row except they k
I do not know if it suites your purposes, but I find INT UNSIGNED NOT NULL
does great at holding a UNIX_TIMESTAMP() value, and is easy to manipulate...
-Jason Garber
IonZoft.com
At 02:02 PM 10/18/2001 +0100, p.whiter wrote:
>Hi
>Thanks for your reply, I have tried this using NOW() and NOW()+0
Use this instead
SELECT user_ip FROM clinic_log WHERE user_ip = '$pw_userIP' AND
clinic_log.log_time + interval 300 second >= Now();
Sheridan Saint-Michel
Website Administrator
FoxJet, an ITW Company
www.foxjet.com
- Original Message -
From: "p.whiter" <[EMAIL PROTECTED]>
To: <[EMAIL
What is " fldFlight='?' "? Are you using ? as a wildcard or is it actually
the only character in the data field?
If you're trying to use a wildcard, then ? is not it. Use % or _
-Original Message-
From: Michael J. Eisner [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 18, 2001 11:31
Look this up on mysql.com:
TIME_TO_SEC(NOW())
It may be what you are after.
-Jason Garber
IonZoft.com
At 12:40 PM 10/18/2001 -0400, Jason G. wrote:
>I do not know if it suites your purposes, but I find INT UNSIGNED NOT NULL
>does great at holding a UNIX_TIMESTAMP() value, and is easy to ma
Hi there everyone,
I am happy, I have my search engine working almost perfectly (Touch wood :-) but there
is one problem. When I search - say for Backpacking in Australia it doesn't bring up
the results in that order as I have to order by country, city or whatever. What I
want to know is, ho
Hi,
There seems to be several ways to compare time. This is what I use
to log out visitors if they do nothing in 1000 seconds. This would be
easier to do with sessions, but when I made the site my ISP did not
have PHP 4.x available. logtime column type is DATETIME, and it
stores the date as
Hi there, I installed mySQL and php on my XP machine. I seem to be able to
connect to the sql server but I can't select a specific db.
I have configured my ODBC drivers and my php file resides in the same folder
as my db.
Any clue or any good resource to help?
Thanks.
K.
--
PHP Database M
Maybe I'm slow...
I'm trying to decipher what you're trying to do.
Show us your table layout
Show us your search criteria and code
Show us a dump of your table so we can see what the data look like
-Original Message-
From: Chris Payne [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October
Hi all,
sorry, there was a mistake:
> $sql="SELECT fldCaptain, fldCaptID, fldCaptStat, fldCaptTR, fldCaptDuty,
> fldFO, fldFOID, fldFOStat, fldFOTR, fldFODuty, fld_F_Reserved, fld_F_Flown
> FROM tblBookings WHERE fldFlight = '?' AND fldBookDate =#".$EngDatum."#";
should read
FROM tblBookings W
Thanks to everyone for your help!!
I have plenty to try here, I'll let you know how I get on with it
Regards
Paul
- Original Message -
From: "Jyrki Leppala" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "p.whiter" <[EMAIL PROTECTED]>
Sent: Thursday, October 18, 2001 6:21 PM
Subjec
Michael,
Have you generated an ODBC trace?
You can see what values are being passed into ODBC and where the error is
occurring.
Also, knowing what driver/database/platform would help :)
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Univ
Does fldFlight contain the character "?"
If it does, you must use: WHERE fldFlight='?'
Are you using ? as a wildcard?
-Original Message-
From: Michael J. Eisner [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 18, 2001 12:53 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Re: Newbie: odbc_
I also suppose that something is printed before Header() function.
Suppose, that you have code:
I such a case NO BLANK characters are allowed after closing "?>" in included "xxx"
file. Newline is enough to produce an error, you have received.
Premysl Dedic,
Need, a.s. (Quest Group, a.s.
I have several MS Access databases that I need to convert to MySQL.
Each table is indexed on an ID field. How do I find the last index
number in the existing table so that I can increment it for the next
record that is added?
Thanks,
Brad
--
PHP Database Mailing List (http://www.php.net/)
T
Once it's loaded into MySQL:
SELECT ID FROM mytable ORDER BY ID DESC LIMIT 1;
This will provide the highest ID index.
Set your new ID index in MySQL with the AUTO_INCREMENT attribute. This will
automatically increment ID when a new record is added.
-Original Message-
From: Brad Harrig
> > -Original Message-
> > From: TJayBelt <[EMAIL PROTECTED]>
> > To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
> > Date: Thursday, October 18, 2001 8:28 AM
> > Subject: [PHP-DB] Sessions and Frames
> >
> >
> > >I have a site that is successfully using sessions and
authentication.
> > >However
Hello,
How are you able to connect to MySQL - through PHP or through your (XP?)
user account? Does PHP connect to MySQL? If you can connect through PHP, then
who is privileged to use the database you're trying to use? Have you tried
connecting as the MySQL root user through a PHP script?
Chee
I just seems that the no existing user in MySQL can access the dbs I have.
My OS is XP so evrything is installed under it.
I seem to be able to connect through MySQL root since I can see all the
existing dbs.
I'll try to get more info on the user accounts.
Thx.
K.
"Daniel Barton" <[EMAIL PRO
Hi!
MySQL-3.23.44 and MySQL-4.0.0 support foreign keys
through transactional InnoDB type tables.
See http://www.innodb.com for more info.
Regards,
Heikki
Innobase Oy
Rita Mikusch wrote in message
<10C5C8152BD5D31181AC006008AD5F416886AD@NEWCA2>...
>Foreign Keys? No such luck! You need to check
Hi!
MySQL-3.23.44 -Max and MySQL-4.0.0 support foreign keys
through transactional InnoDB type tables.
Regards,
Heikki
http://www.innodb.com
Rick Emery wrote in message ...
>Quoting from the MySQL manual, section 6.5.3, CREATE TABLE Syntax:
>
>The FOREIGN KEY, CHECK, and REFERENCES clauses don'
Prior to version 4.0, INNODB was compiled in only the mysql-max binary, not
the standard binary. Most web-hosts, and virtual web-hosting companies, do
not run the -MAX version. Therefore, there was no access to innodb
databases.
As we stated in threads yesterday, version 4.0 is not ready for pr
Prior to version 4.0, INNODB was compiled in only the mysql-max binary, not
the standard binary. Most web-hosts, and virtual web-hosting companies, do
not run the -MAX version. Therefore, there was no access to innodb
databases.
As we stated in threads yesterday, version 4.0 is not ready for pr
Hi!
Rick Emery wrote in message ...
>Prior to version 4.0, INNODB was compiled in only the mysql-max binary, not
>the standard binary. Most web-hosts, and virtual web-hosting companies, do
>not run the -MAX version. Therefore, there was no access to innodb
>databases.
Well, many users downloa
No, I am not trying to delete with a select statement. That was just there
to show my tables, fields, etc.
So if I understand what you are saying I can not do a delete statement with
a join in it. I would have to query each individual row for the ID that need
to be deleted, delete the row in the
Below is the result of your feedback form. It was submitted by
([EMAIL PROTECTED]) on Thursday, October 18, 2001 at 21:20:11
---
message:
In addition to the information you selected, we thought you might be Interested in t
depends on how you are entering data...
if through a client, then you have to format it as MYSQL wants it.
if you're going through PHP (afterall, this is a PHP DB list... ;-)),
then accept it anyway you wanna, through a form on a web page, then your
script will handle the convertion on how MYSQ
61 matches
Mail list logo
