[PHP-DB] where can I post some mysql related questions?

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:

Re: [PHP-DB] where can I post some mysql related questions?

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

[PHP-DB] Finding the value of the COMMENT in a table column

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.

Re: [PHP-DB] HTML question

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

[PHP-DB] SQLite problem INSERTing string

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 =

RE: [PHP-DB] SQLite problem INSERTing string

$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

Re: [PHP-DB] SQLite problem INSERTing string

$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?

[PHP-DB] Abstraction Layer....

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

[PHP-DB] Re: SQLite problem INSERTing string

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-DB] Re: Abstraction Layer....

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

[PHP-DB] Re: Abstraction Layer....

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

[PHP-DB] Passing URL parameters, how to hide

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

Re: [PHP-DB] Passing URL parameters, how to hide-Nevermind

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

Re: [PHP-DB] Passing URL parameters, how to hide

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

[PHP-DB] PHP + SSL + LDAP + IPLANET

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

Re: [PHP-DB] Re: SQLite problem INSERTing string

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

RE: [PHP-DB] PHP + SSL + LDAP + IPLANET

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

[PHP-DB] Re: Finding the value of the COMMENT in a table column

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.