[PHP-DB] Mac OS X 10.5 : odbc_connect( ) error code IM002 problem with MySQL

2009-05-26 Thread B. Aerts
Hello, I've already spent quite some time trying to solve ths one, hopefully some-one here can lend me a hand. I'm trying to set up a LAMP configuration, but on a Mac (so actually a MAMP ...). I have a MacBook Pro, Mac OS X 10.5.5, built-in Apache server and built-in PHP module ( phpinfo

[PHP-DB] Re: PHP Delete confirmation

2011-04-29 Thread B. Aerts
You could try to reload the same page, but with an added GET-parameter delete: I assume your snippet comes from a script called MAIN.PHP : ?php if ( $_GET[delete] == yes ) { $id = $_GET[id] ; echo DIV ARE YOU SURE ? A HREF=delete.php?id=$idyes/A/DIV ; } while($row = mysql_fetch_array(

Re: [PHP-DB] Storing multiple items in one MySQL field?

2012-01-10 Thread B. Aerts
On 08/01/12 23:35, Karl DeSaulniers wrote: On Jan 8, 2012, at 10:36 AM, Bastien wrote: On 2012-01-08, at 7:27 AM, Niel Archer n...@chance.now wrote: -- Niel Archer niel.archer (at) blueyonder.co.uk Hello phpers and sqlheads, If you have a moment, I have a question. INTRO: I am trying

Re: [PHP-DB] Storing multiple items in one MySQL field?

2012-01-11 Thread B. Aerts
Karl, I'm somewhat limited to reading posts, so I might have missed something, but can you explain why you wanted to avoid the 3rd table solution ? Because depending on that question, I can offer two other solutions, but they have their own limitations. Solution 1: the 2,5nd table. you

Re: [PHP-DB] Storing multiple items in one MySQL field?

2012-01-13 Thread B. Aerts
On 13/01/12 03:47, tamouse mailing lists wrote: On Thu, Jan 12, 2012 at 1:12 AM, B. Aertsba_ae...@yahoo.com wrote: Karl, I'm somewhat limited to reading posts, so I might have missed something, but can you explain why you wanted to avoid the 3rd table solution ? Because depending on that

[PHP-DB] Re: Database Problems

2012-06-25 Thread B. Aerts
On 17/06/12 21:06, Ethan Rosenberg wrote: Dear List - I have a database: +-+ | Tables_in_hospital2 | +-+ | Intake3 | | Visit3 | +-+ mysql describe Intake3; ++-+--+-+-+---+ | Field | Type | Null

[PHP-DB] Re: excec / query on Sqlite3

2013-05-20 Thread B. Aerts
On 20/05/13 14:35, Gilles wrote: Hello, I'm not sure if it's a bug : No, it's not - it's PHP code :-) $o_sqlite3=new SQLite3('test.sqlite'); $r=$o_sqlite3-exec(''); echo'pre';var_dump($r);echo'/pre'; // bool(true) $r=$o_sqlite3-query(''); echo'pre';var_dump($r);echo'/pre'; //

[PHP-DB] Re: Select on Group

2015-11-17 Thread B. Aerts
On 17/11/15 01:02, Karl DeSaulniers wrote: Hello All, Hoping someone can help me with this query. I want to select some custom fields from my database that are part of a group of custom fields. There are several of these groups. I want to (in one sql statement) grab these fields, all of them

Re: [PHP-DB] Any method to get primary key matching a given value ?

2016-09-02 Thread B. Aerts
Hi Ratin, working with sqlite, are you ? In that case, take a look at the default table : SELECT sql from sqlite_master where type= "table" and name = "" This query returns the creation query of the table concerned. By parsing it textually, you can find out the field name that was declared

[PHP-DB] Re: MySQL two tables and an uneven number of rows

2016-09-12 Thread B. Aerts
On 12/09/16 05:24, Karl DeSaulniers wrote: Hello All, Hoping you can help clear my head on this. I have two MySQL tables for custom fields data to be stored. custom_fields custom_fields_meta custom_fields is the info for the actual field displayed in the html and

Re: [PHP-DB] MySQL two tables and an uneven number of rows

2016-09-13 Thread B. Aerts
On 13/09/16 08:42, Karl DeSaulniers wrote: On Sep 12, 2016, at 2:53 PM, B. Aerts <ba_ae...@yahoo.com> wrote: On 12/09/16 05:24, Karl DeSaulniers wrote: Hello All, Hoping you can help clear my head on this. I have two MySQL tables for custom fields data to be stored. custom_

Re: [PHP-DB] Corn job anomaly

2016-09-20 Thread B. Aerts
On 20/09/16 10:06, Lester Caine wrote: On 20/09/16 06:16, Karl DeSaulniers wrote: Was probably a newb question, however, now it is saying that my database user is not allowed access. I have a mysql connection inside my script that reads the database to get user email addresses to send a

Re: [PHP-DB] Any method to get primary key matching a given value ?

2016-10-14 Thread B. Aerts
Hi Ratin, check out this FAQ : https://sqlite.org/faq.html#q7 SQlite has a read-only table that holds the creation query for each table. By doing a text analysis of this query, you can find out which field is declared as primary key. Regards, Bert On 11/10/16 02:12, Ratin wrote: Sorry