-
From: 1LT John W. Holmes [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 05, 2002 3:26 PM
To: Ryan Jameson (USA); Art Chevalier; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MySQL Array
I think he meant that he is only pulling one column, i.e. field1
with each
mysql_fetch_array and he wants
nt(/trtr);
}
}
-Original Message-
From: 1LT John W. Holmes [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 05, 2002 3:26 PM
To: Ryan Jameson (USA); Art Chevalier; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MySQL Array
I think he meant that he is only pulling one column, i.e
Hi,
I want to insert the upper case of the strings written in the forn, so I put
on the php file called these lines
$NOME=strtoupper($nome);
mysql_query (INSERT INTO anagrafe (codice,nome, cognome, codicefiscale)
VALUES
Message -
From: Antonio Bernabei [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, December 06, 2002 7:12 PM
Subject: Re: [PHP-DB] MySQL Array
Hi,
I want to insert the upper case of the strings written in the forn, so I
put
on the php file called these lines
$NOME=strtoupper($nome
while ($ar = mysql_fetch_array($rs))
echo trtd. $ar['field1']./tdtd.$ar['field2']./td/tr;
Make sense?
-Original Message-
From: Art Chevalier [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 05, 2002 12:44 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL Array
Hello,
I am pulling
Yes that makes sense, but it is pretty much the same thing I was doing and
it's producing the same results. Its basically putting the first element in
all 4 table cells. The thing is...I am only selecting from one field. Im
trying to get the 4 elements of the column with each pass. So in
]
Subject: Re: [PHP-DB] MySQL Array
Yes that makes sense, but it is pretty much the same thing I was doing
and
it's producing the same results. Its basically putting the first
element in
all 4 table cells. The thing is...I am only selecting from one field.
Im
trying to get the 4 elements
and clean up the output, but
hopefully that gives you an idea.
---John Holmes...
- Original Message -
From: Ryan Jameson (USA) [EMAIL PROTECTED]
To: Art Chevalier [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, December 05, 2002 3:05 PM
Subject: RE: [PHP-DB] MySQL Array
while ($ar
DESCRIBE tbl_name col_name
Ignatius
- Original Message -
From: Bastian Vogt [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, December 02, 2002 1:41 PM
Subject: [PHP-DB] mysql - enum
Hi,
is it possible to get all possible values of
This is what I use:
SHOW COLUMNS FROM table LIKE field
I use the query result for a select field in HTML table.
Ruth
- Original Message -
From: Bastian Vogt [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, December 02, 2002 11:41 PM
Subject: [PHP-DB] mysql - enum
Hi,
is it
Hi
you need quotes around the values
mysql_query(insert into tblquotehits
(qoption,referer,browser,remoteaddr,dt) values
('$quotetype','$referer','$browser','$remoteaddress','$currentdtstring'),$d
b);
HTH
Peter
---
Excellence in internet and open
So what's the problem? The data doesn't appear in the table? Did you try
to see if mysql_error() had anything in it after your query?
---John Holmes...
-Original Message-
From: Bill Arbuckle, Jr. [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 28, 2002 5:56 PM
To: [EMAIL
Hi Jeremy,
Probably you don't have all of php installed; you can pick it up in
php.net and install the full php libs.
Or in your php ini file, the php lib path can be incorrect, well these
are just thoughts as I don't use red hat for some time (SuSE Forever).
Hope you figure it out,
Pedro
On Saturday 23 November 2002 02:34, Jeremy Wood wrote:
Hello all,
I'm new to PHP and would like to start using mySQL (or postgresql) but I
keep having one problem. In a php file i have a simple call to the function
mysql_connect()
but i constantly get the error
Fatal error: Call to
No, I was unable to find a new version of it. Is there a version for php 4.2
?
Jeremy
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Maybe I'm missing something - but the MySQL statement looks right ...
How are you displaying the results?
-Original Message-
From: Griffiths, Daniel [mailto:[EMAIL PROTECTED]]
Sent: 21 November 2002 16:37
To: PHP List
Subject: [PHP-DB] MySQL Problem
Hi,
I have a problem with an MySQL
: 21 November 2002 16:41
To: Griffiths, Daniel; PHP List
Subject: RE: [PHP-DB] MySQL Problem
Maybe I'm missing something - but the MySQL statement looks right ...
How are you displaying the results?
-Original Message-
From: Griffiths, Daniel [mailto:[EMAIL PROTECTED]]
Sent: 21 November
Still think we need to see the PHP code before determining that it is an SQL
problem.
Regards,
J
-Original Message-
From: Jason Wong [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 21, 2002 11:55 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MySQL Problem
On Friday 22 November
the month starts at 1, at the moment I'm just hard coding the month into the statment.
-Original Message-
From: Jason Wong [mailto:[EMAIL PROTECTED]]
Sent: 21 November 2002 16:55
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MySQL Problem
On Friday 22 November 2002 00:46, Griffiths
Hi,
Since i dont know any mysql group, i will try here - it is
anyway related to
php.
When i want to make php/mysql application i have mysql on the
server and i
connect to it with mysql_pconnect(localhost,root,) and it works.
I assume that any user or hacker could connect to mysql
how i do this in mysql.
If this is offtopic can someone point me to any mysql newsgroup.
I would say this is very offtopic, but this query should do the trick:
GRANT select, update, insert ON your_db_name.* TO
your_username@localhost IDENTIFIED BY 'your_password'
Take a look in the MySQL
$query = UPDATE tablename SET ;
foreach($_POST AS $key = $value)
$query .= $key = '$value',;
$query[strlen($query)-1] = ;
$query .= WHERE id = '$_GET[id]';
Or something?
On Tue, 2002-11-12 at 13:58, David Rice wrote:
Making an update query that adapts to the number of fields that
How about:
function do_query ($table, $fields, $where)
{
$sql = 'update ' . $table . ' Set ';
foreach ($fields as $k=$v)
$sql = $k . ' = \'' . $v . '\',';
return mysql_query ($sql);
}
Not sure if it adapts 100% to your case but you can probably fix it
Make the include file (or wherever your page with the pass is)
encrypted, see ioncube.com they charge by the amount of code you
incrypt, for a simple database include file, I think it would
be $1 or less.
On Wed, 2002-11-06 at 16:04, William Trappeniers wrote:
Hi all
I was wondering if it is
I was wondering if it is possible to protect my password to the
MySQL-server
from being in a PHP-script. Now I can't do that, so everybody who gets to
see my php-sourcecode also can see my (not protected/not encrypted)
password.
How can I change this?
You can't, unless you want to put it in
;charter.net]
Sent: Wednesday, November 06, 2002 4:16 PM
To: William Trappeniers; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MySQL password protection?
I was wondering if it is possible to protect my password to the
MySQL-server
from being in a PHP-script. Now I can't do that, so everybody who gets
You could put it anywhere. Stick it in a text file somewhere, fopen()
and read the file for the password. Or keep it in a php script outside
of the web root if that's the issue, then just include() it when you
need to.
Of course any file you put it in will have to be readable by whatever
user
John W. Holmes' [EMAIL PROTECTED]; William Trappeniers
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, November 06, 2002 5:30 PM
Subject: RE: [PHP-DB] MySQL password protection?
actually you can make a .php file with your connection info, include it in
your .php files at the top
in it.
-Original Message-
From: 1LT John W. Holmes [mailto:holmes072000;charter.net]
Sent: Wednesday, November 06, 2002 4:16 PM
To: William Trappeniers; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MySQL password protection?
I was wondering if it is possible to protect my password to the
MySQL
And make sure you make sure the webserver will not SERVE that file!!! You
see the source, see that you are fopening the file, I'll find it on your
system and get it from the web server and I have your password!
Make sure the file is NOT in the document root that the web server serves
from. You
The standard apache install filters anything named .ht*. on the web
tree.
-- Josh
-Original Message-
From: Peter Beckman [mailto:beckman;purplecow.com]
Sent: Wednesday, November 06, 2002 6:44 PM
To: Steve Cayford
Cc: [EMAIL PROTECTED]; William Trappeniers
Subject: Re: [PHP-DB] MySQL
PROTECTED]
Subject: Re: [PHP-DB] MySQL password protection?
Create a user nobody with no password and give that user select,
update,
delete and insert capabilities in your DB and can only connect from
localhost (or a certain host). This way they have to be on localhost in
order to gain access
One thing I do with Postgres that I'm not sure MySQL supports is
Kerberos5 authentication. This way, a user logs in (and they have a user
account on the DB) and I use their remote user name and their Kerberos
ticket to authenticate them to the DB. That works without having to
store a password
Given a datetime field in a MySql database, how can i list all the
records
that are dated back to yesterday or to 'N' days in the past?
SELECT * FROM your_table WHERE TO_DAYS(date_column) =
TO_DAYS(CURRENT_DATE) - N
Where N is how many days you want to go back.
---John Holmes...
--
PHP
On Monday 21 October 2002 22:07, lallous wrote:
TO_DAYS() applied on datetime field is returning different values on
different times but same date!
How can I pass to TO_DAYS() only the DATE part of my datetime field?
As far as I can tell, TO_DAYS() does only use the DATE part regardless
That's how you do it. Hopefully you've figured it out already.
---John Holmes.
-Original Message-
From: dwalker [mailto:dwalker;healthyproductsplus.com]
Sent: Saturday, October 19, 2002 7:51 PM
To: professional php; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL
.
-Original Message-
From: John W. Holmes [EMAIL PROTECTED]
To: 'dwalker' [EMAIL PROTECTED]; 'professional php'
[EMAIL PROTECTED]; [EMAIL PROTECTED] [EMAIL PROTECTED];
[EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Saturday, October 19, 2002 7:24 PM
Subject: RE: [PHP-DB] MySQL Insert Select statement
That's
]
10/19/2002 08:32 PM cc:
Please respond to Subject: Re: [PHP-DB] MySQL
Insert Select statement
i'm certainly no expert, but here are my thoughts:
the variable $tbn2 probabyl has no value inside of your function. so the
query is really just select name from. i'd suggest you pass the $tbn2
value to the function.
also, it is generally a bad idea to have a echo statements in function.
rather
Dave,
I'd agree with Rob especially about returning the results.
Plus it's always a good idea to add error checking to your SQL statement.
Try replacing your existing line of code with this to make sure you query is
actually returning valid results before trying to operate on them.
$gnlistres =
If you want to generalize the process to a n-set, a recursion method is
clearly required.
XSLT looks the best candidate to me to do this. I will tackle it when I find
some time.
Cheers
Ignatius
- Original Message -
From: Xepherys [EMAIL
Hi,
unfortunately i can't help you much, but listen
you can make your pattern more readable if you
delete [] there's no need for classes in your pattern
SELECT * FROM ospd WHERE word REGEXP
'^a?p?e?$|^a?e?p?$|^p?e?a?$|^p?a?e?$|^e?a?p?$|^e?p?a?$';
? = one or none but if you need each letter
New MySQL is out I noticed (4.0.4). Is there any way to make it work
correctly with PHP? I haven't seen any modules for download or
comments
about this issue.
I'm just wondering if there is some modifications I can make or if I'm
just
stuck with MySQL 3.x until something new is released
-Original Message-
From: Micah Stevens [mailto:[EMAIL PROTECTED]]
Sent: 23 September 2002 18:09
I've been running into a strange problem on my server with
scripts that
take form input and reformat it into SQL. It only happens
with statements
that insert or update data, the
Hi peoples,
The company I'm about to partner with for hosting my websites is using
postgresql for their database server. I currently use mysql for all of
mine.
What I'm trying to find out is peoples experiences using postgresql, any
plusses or minusses, is it worth using these guys or
At 11:59 -0500 9/11/02, Rob Day wrote:
Hi all,
I have a table in MySQL with the following field:
'time_date' timestamp(14) NOT NULL
When a record is inserted into the table, NULL is inserted into the
time_date field giving me a normal timestamp with the time of the INSERT.
That much is
Hi
you have to restart your mysqld server with
--default-character-set=greek option. You can either do this by
explicitly giving it in the command line when restarting your mysqld, or
you can add that line to your global my.cnf file.
See:
http://www.mysql.com/doc/en/Command-line_options.html
i am unfarmillar with InnoDB, i am currently using MyISAM i believe. just
the default one.
i am a complete noobie with InnoDB, do i have to convert my db?
cheers
Andrey Hristov [EMAIL PROTECTED] wrote in message
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
On Wednesday 28 August 2002 20:48, R Strang wrote:
i have a simple guest book script from a book by jay greenspan i think ,
when i run seems oikay i fill in the form and click submit, after
submitting iam getting this error ?
PHP Warning: Failed opening 'dbconnect.php' for inclusion
8:17 AM
Subject: Re: [PHP-DB] MySQL and BLOB
On Thursday 22 August 2002 13:57, Andy wrote:
Hi there,
I am storing via PHP pictures into BLOB fields. Worked fine so far for
over
200 images.
Now an error has occured with a particular picture. No error msg. Just
does
not work
On Thursday 22 August 2002 13:57, Andy wrote:
Hi there,
I am storing via PHP pictures into BLOB fields. Worked fine so far for over
200 images.
Now an error has occured with a particular picture. No error msg. Just does
not work. The wired thing is that the thumbnail does. So I guess the
Read about GRANT function in the MySQL manual.
-Joni-
--
// Joni Järvinen
// [EMAIL PROTECTED]
// http://www.reactorbox.org/~wandu
On Sunday 18 August 2002 09:54, Georgie Casey wrote:
rite,
i run a web server and sell space to workers. my admin setup apache,
mysql
and php with all the
As Joni said you need to read about the GRANT functions in the MySQL
manual. But basically here's what's happening.
Each person your hosting has a specific login/pass into the database.
When they login MySQL looks in the 'MySQL' database and checks the users
privileges. By default Ensim sets
On Sunday 18 August 2002 09:54, Georgie Casey wrote:
rite,
i run a web server and sell space to workers. my admin setup apache, mysql
and php with all the settings. each customers gets one sql db with a host
acc. the system runs ensim. but now i want one of my accounts do be able to
access
George,
It is likely that your win32 system did not care about case. If you are
using a *nix host it is case sensitive, and its installation of MySQL, by
extension, is as well.
Try echo'ing the select statement to see what you have.
Miles
At 10:42 PM 8/14/2002 +0100, Georgie Casey wrote:
I would suggest looking into MySQL's replication support. Split reads and
writes so they go to separate servers. That is, create a master server
where you send all database writes. And do all reads on the replicated
slave servers.
Have a look at this presentation I gave last week on this
desc is a key word. :-\
-Original Message-
From: Michael Zornek [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 10, 2002 10:50 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Mysql syntax error - phpMyAdmin ??
I was using phpMyAdmin to do an export from one machine to another and on
import
Try [desc]
-Original Message-
From: Ryan Jameson (USA)
Sent: Wednesday, July 10, 2002 10:51 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Mysql syntax error - phpMyAdmin ??
desc is a key word. :-\
-Original Message-
From: Michael Zornek [mailto:[EMAIL PROTECTED]]
Sent
I can't say for sure, but perhaps desc is a reserved word, short for
describe. What happens if you say something like description?
Chip
On Wed, 10 Jul 2002, Michael Zornek wrote:
I was using phpMyAdmin to do an export from one machine to another and on
import I got an error:
Error
DESC is a reserved word in SQL, standing for Descending Order. That is why you can't
use it as a table column name.
HTH
Martin
Michael Zornek [EMAIL PROTECTED] 07/10/02 12:49PM
I was using phpMyAdmin to do an export from one machine to another and on
import I got an error:
Error
Sorry, [desc] won't work either. :-(
-Original Message-
From: Chip Atkinson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 10, 2002 10:54 AM
To: Michael Zornek
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Mysql syntax error - phpMyAdmin ??
I can't say for sure, but perhaps desc
On Thursday 11 July 2002 01:00, Ryan Jameson (USA) wrote:
Sorry, [desc] won't work either. :-(
Try `desc`.
But it's best not to use 'desc' at all, it will save you confusion in the long
run.
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
Open Source Software Systems Integrators
*
Twas 7/10/02 12:55 PM, when Martin Clifford [EMAIL PROTECTED] said:
DESC is a reserved word in SQL, standing for Descending Order. That is why
you can't use it as a table column name.
Ok, that makes sence - thanks!
Although I find it a bit curious that building the DB in phpMyAdmin let me
:
http://www.mysql.com/doc/L/e/Legal_names.html
Gurhan
- Original Message -
From: Michael Zornek [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 10, 2002 1:30 PM
Subject: Re: [PHP-DB] Mysql syntax error - phpMyAdmin ??
Twas 7/10/02 12:55 PM, when Martin Clifford [EMAIL
Thanks, but I finally stumbled across the answer. Thankfully it was
simple enough even for me. In case anyone else had this question also, all
you have to do is browse for your dump file in the 'SQL' window of
phpMyAdmin and click 'Go'. That's it.
-Original Message-
From:
hi
If the database is not too much data you can export using phpMyAdmin and
select 'complete inserts' which generates complete queries.
you could also do
INSERT INTO db_2.tablename
SELECT *
FROM db_1.tablename
if both databases are on the same server.
There may be better answers, but these
I didn't get your attachements. Maybe paste them in a row into the email?
-Original Message-
From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 27, 2002 10:07 AM
To: '[EMAIL PROTECTED]'
Subject: [PHP-DB] MySQL Update failing...
In need of some help. I
Figured it out. Thanks to anyone who started looking at this. The
problem was not having my variables in the correct order in the $updateSQL.
Once I corrected this, the posting now works fine.
-Original Message-
From: NIPP, SCOTT V (SBCSI)
[mailto:[EMAIL PROTECTED]]
Sent:
hmm...
index it - and you will know
olinux
--- [EMAIL PROTECTED] wrote:
hi all
I want to know storage required for my database.
How i can determine size required for indexing a
column ?
(my column's type that indexed is varchar(15))
Thanks
--
PHP Database Mailing List
At 14:58 -0400 6/24/02, Page Works Web Solutions wrote:
Hi all,
I have a Cobalt Raq 4 running Linux. I've installed the .pkg file
RaQ3-RaQ4-MySQL-3.23.37-1.pkg I can telnet into the server and I type
mysql, now I see that I'm in MySql, but when I type
bin/mysqladmin -password and put a
neficial to check the event log. More clues may lie in
there. If the webserver has any type of error log check that as well.
Aaron Weiker
-Original Message-
From: Marco Lanini [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 22, 2002 1:10 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-D
Are you able to connect to the MySQL server using a client?
Aaron Weiker
-Original Message-
From: Marco Lanini [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 22, 2002 8:39 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MYSQL Socket error :\
PHP Warning: MySQL Connection Failed: Can't
, 2002 8:39 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MYSQL Socket error :\
PHP Warning: MySQL Connection Failed: Can't create TCP/IP socket
(10106)
in c:\flashinlabs\web\http\provamysql.php on line 3
this is the LOG error.
i'm into panic.
Aaron T. Weiker [EMAIL PROTECTED] ha scritto nel m
On Friday 21 June 2002 21:42, Charlie Grosvenor wrote:
Hi
I have a mysql table that has a field in it called 'DATETIMEADDED'
which has data type 'datetime' I want to display the contents of the field
on my page. I have tried usng the following code but the value in the
'DATETIMEADDED'
I'm no expert on XP, but you may want to check
the firewall settings, to make sure that windows XP
isn't preventing the connection.
For the $host, you may want to either use
'localhost' or 127.0.0.1
Cheers,
Dan
-Original Message-
From: Marco Lanini [mailto:[EMAIL PROTECTED]]
Thanks Dan, but i have already tested this solution...
i have build a very little test script, who generate this error.
?php
mysql_connect(127.0.0.1,root,admin) or die(mysql_error());
print(connected!!!);
?
i am in localhost and i use very simple root admin login
but the message is always
]
Subject: Re: [PHP-DB] MYSQL Socket error :\
Thanks Dan, but i have already tested this solution...
i have build a very little test script, who generate this error.
?php
mysql_connect(127.0.0.1,root,admin) or
die(mysql_error()); print(connected!!!);
?
i am in localhost and i use
Yes,it's called Replication in the MySQL documentation.
However, since the info in the manual is kind of sparse so I would hop
on google and do a search for specific instructions on how to do it when
your ready, but to answer your question, yes, MySQL does do
Redundancy/Failover. (Ofcourse you
://www.criticalcode.com
PO BOX 601
Manchester, NH 03105
-Original Message-
From: Adam Voigt [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 18, 2002 8:55 AM
To: [EMAIL PROTECTED]
Cc: Matt Babineau
Subject: Re: [PHP-DB] MySQL Clustering, redundancy
Yes,it's called Replication in the MySQL documentation
-Original Message-
From: Adam Voigt [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 18, 2002 8:55 AM
To: [EMAIL PROTECTED]
Cc: Matt Babineau
Subject: Re: [PHP-DB] MySQL Clustering, redundancy
Yes,it's called Replication in the MySQL documentation. However, since
the info in the manual
On 6/18/02 9:19 AM, Adam Voigt [EMAIL PROTECTED] pressed the keys
forming the message:
I have never actually tried to program against something which talks to
multiple DB's, the quickest way would be in your DB connection code to
have something that will either:
A. Try the first DB and
I had a similar issue where I wanted timestamps to be relative to the user. I didn't
find any better way then to create some profile data that contained their timezone and
allow them to save that data. Then anytime I displayed a timestamp I added the
timezone shift to the stamp. It would be
BTW... are you saying that you plan to move the MySQL server around to different time
zones? Why would you do that?
-Original Message-
From: Ryan Jameson (USA)
Sent: Thursday, June 13, 2002 9:44 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] MySQL timestamp field in different time zone
saying that you plan to move the MySQL server around to different
time zones? Why would you do that?
-Original Message-
From: Ryan Jameson (USA)
Sent: Thursday, June 13, 2002 9:44 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP-DB] MySQL timestamp field in different time zone
I had
the calculation either on the sql or upon displaying but
it has to happen on the client.
Ryan
-Original Message-
From: bill [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 13, 2002 2:03 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MySQL timestamp field in different time zone
No, it is similar
Woo-hoo! Fixing the extensions directory worked. I am now all set with MySQL
support ... Thanks for all the help!
--
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Saturday 08 June 2002 05:29, Garrett Nelson wrote:
I now downloaded php-mysql-4.1.2-1a.ppc.rpm from rpmfinder, and again I
get
rpm -ivh php-mysql*
Preparing...###
[100%]
package php-mysql-4.1.2-1a is already installed
(Same error
On Saturday 08 June 2002 23:20, Garrett Nelson wrote:
I have both the lines in httpd.conf. As I said, PHP is working fine, it's
just an issue with MySQL support I believe.
Sorry my mistake. Check in php.ini for this line:
extension=mysql.so
--
Jason Wong - Gremlins Associates -
On Sunday 09 June 2002 01:28, Garrett Nelson wrote:
Well, we're getting closer now, maybe. I added the line extension=mysql.so,
and I still get the same error when trying to run the web-based PHP apps,
but in the command line when I type php I get back,
PHP Warning: Unable to load dynamic
Edit your php.ini and log all errors to a file and then review the
filesalso you can turn on all errors and warnings to be displayed---this
has helped me many times...
Thank you,
RAY HUNTER
-Original Message-
From: Blaine Dinsmore [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 07,
Do you have SELECT permissions for your httpd user on the DB?
Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
Pay It Forward
mailto:[EMAIL PROTECTED]
http://accessingram.com
-Original Message-
From: Blaine Dinsmore [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 07,
On 6/6/02 4:48 PM, Jason Wong [EMAIL PROTECTED] wrote:
On Friday 07 June 2002 04:36, Garrett Nelson wrote:
I'm a relative newbie to the Linux/web server world, having worked with
Macs most of my life. I recently installed the Server install of Yellow Dog
Linux, with no window managers, CLI
Than you very much. I'm talking about dbase files so it must work...
- Original Message -
From: Viliam Frtala [EMAIL PROTECTED]
To: Achilleas Maroulis [EMAIL PROTECTED]
Sent: Wednesday, June 06, 2001 1:14 PM
Subject: RE: [PHP-DB] Mysql and DBF files
if it's like dbase DBF files
on 6/6/02 4:36 PM, Garrett Nelson at [EMAIL PROTECTED] appended the
following bits to my mbox:
What needs to be configured? I was under the impression that MySQL support
was built into PHP now and that it needs no extension. I downloaded the RPM
of PHP 4.1.2 (the latest PPC RPM available at
You need to parse the string and PHP and generate the appropriate query
based on that parsing...
ed
At 09:22 PM 5/29/2002 -0700, Chris Payne wrote:
Hi there everyone,
How can I do a search which excludes certain words if they put a - in the
search string? I can do a search easily, but if
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
That means PHP is not compiled with the MySQL support... Configure it with
mysql support, I bbelieve there were a lot of questions about this in the
list, so you may wanna search the archives..
Gurhan
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday,
At 1:01 PM +0100 5/3/02, CM wrote:
SELECT Periode.LibPeriode, PaysPeriode.RefPaysPeriode,
PaysPeriode.DateDebut,PaysPeriode.DateFin
FROM Periode, PaysPeriode, Pays
WHERE Pays.RefPays = PaysPeriode.Refpays
AND Periode.RefPeriode = PaysPeriode.RefPeriode
AND PaysPeriode.DateDebut 2002020700
I'm not sure what you're asking but the fields are set to varchar(40) which
will accommodate the information I have been insertinging...
/T
on 4/30/02 9:00 PM, Neil at [EMAIL PROTECTED] wrote:
Have you checked to see that id tidying is set to the amount equal to the
fields in your form.
601 - 700 of 916 matches
Mail list logo
