hi, I've currently been looking for a mysql news server where I could post
some questions on mysql database design (cause they shurely wouldn't fit
here) and I have yet to find one. Can anyone help?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
Mike wrote:
hi, I've currently been looking for a mysql news server where I could post
some questions on mysql database design (cause they shurely wouldn't fit
here) and I have yet to find one. Can anyone help?
http://lists.mysql.com/
--
PHP Database Mailing List (http://www.php.net/)
To
Hi all,
Anyone know how to access the optional COMMENT you can add to columns
during table creation?
eg.
create table x (fldx char(1) COMMENT 'some comment', fldy char (1) COMMENT
'another comment')
I want to 'get' the COMMENT field.
I know it should be in the manual, but I can't find it.
On Sun, 19 Sep 2004, David Orlovich wrote:
I think you're just missing some double quotes (which you have to
escape). How about something like this:
echo tda href=\mailto:;, $row['Email'], \, $row['Email'], /a/td;
Cheers, David.
Perfect!!! Many thanks.
Pete
--
PHP Database Mailing
Hello,
I am currently experiencing a problem with an INSERT statement in SQLite.
First of all an excerpt from the code:
$val = 127.0.0.1;
$query = INSERT INTO node (uri,name) VALUES (.$val.,'bla');
$db_name = mysqlite;
if($db_hdl = sqlite_open($db_name)){
$db_result =
$val = 127.0.0.1;
$query = INSERT INTO node (uri,name) VALUES ('.$val.','bla');
Try that?
-Original Message-
From: Stefan Reimers [mailto:[EMAIL PROTECTED]
Sent: Sunday, September 19, 2004 6:37 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] SQLite problem INSERTing string
Hello,
I am
$val=127.0.0.1;
$query=INSERT INTO node set uri=\$val\, name=\bla\;
Try this one... think is better n less confusing for u...
On Sun, 19 Sep 2004 19:13:48 +0200, Darryl [EMAIL PROTECTED] wrote:
$val = 127.0.0.1;
$query = INSERT INTO node (uri,name) VALUES ('.$val.','bla');
Try that?
Anyone for a list of php abstraction classes?
ADODB, PEAR::DB... any others? or better?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hi again,
first of all thanks for quick suggestions.
After some more testing, I can get more specific:
This might be a more general problem than the . in the error message.
Even when I use $val = hello I get an equivalent error message
sqlite_query(): near hello
As said, I have done all the
PHP knows at least three more:
dba - for databases built on Berkeley DB which can be used some
DB-configurations of MySQL
dbm - also very specific for dbm-format, which seems not to be a
relational one. Some apps seem to use that kind of DB internally.
dbx - supports about a dozen types of
Hello,
On 09/19/2004 02:32 PM, M Saleh Eg wrote:
Anyone for a list of php abstraction classes?
ADODB, PEAR::DB... any others? or better?
Metabase
http://www.phpclasses.org/metabase
PEAR::MDB
http://pear.php.net/package/MDB
Creole
http://creole.phpdb.org/
--
Regards,
Manuel Lemos
PHP Classes - Free
I'm still confused over one aspect of URL parameters.
As far as a form passing data back to the server, I
understand about get, post and replace.
Here is my problem.
I have an update form. User is logged in to the
system and needs to update whatever information.
Right now I'm including in the
Ugh, I should rest on the weekends :)
--- Stuart Felenstein [EMAIL PROTECTED] wrote:
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Turned out hiding the id wasn't necessary as the
awaiting update page can grab the session ID.
I wasn't thinking. Sorry
Stuart
--- John Holmes [EMAIL PROTECTED] wrote:
Stuart Felenstein wrote:
I'm still confused over one aspect of URL
parameters.
As far as a form passing data back to the
Greetings,
(That Iplanet word must have peaked your interest...riight...)
OS: Solaris 9
CC: GCC 3.2.2
APP: Sun ONE Web Server 6.2SP2
LDAP: Sun ONE Directory Server 5.2 (configured for SSL and confirmed with non-php apps)
Configured PHP 4.3.8/or 5.1 with openssl, openldap, libxml, zlib using GCC
I think I figured it out.
SQLLite doesnt take single quotes as the text or varchar datatype
values the strings passed to sqllite should match the data type of
the column ... so ur mistake was creating a data type mismatch at the
SQL lite end.
hmm... thanx for the info Stefan... I never knew
OK - just got a bit crazier!
That function works when running on the command line.
As the root user, as the webserver user and ANY user
who can run the php command (truss on php shows that it
IS reading the ldap.conf file from /usr/local/openldap/etc)
But why does it not work from the Web
On Sun, 19 Sep 2004 21:19, Ross Honniball wrote:
Hi all,
Anyone know how to access the optional COMMENT you can add to columns
during table creation?
eg.
create table x (fldx char(1) COMMENT 'some comment', fldy char (1) COMMENT
'another comment')
I want to 'get' the COMMENT field.
18 matches
Mail list logo