[PHP-DB] ADOdb db abstraction library moving to sourceforge

2004-06-16 Thread John Lim
Hello, ADOdb is a popular database abstraction library for PHP. It supports a very large number of databases, including MySQL, PostgreSQL, Firebird, Interbase, SQLite, Oracle, Frontbase, DB2, SAP DB, Sybase, Informix, Netezza, Access, VFP, MS SQL, LDAP, ODBTP, ODBC, etc. Due to system outages

[PHP-DB] content managment systems

2004-06-16 Thread Lisi
I am looking for open source CMSs that: 1) use PHP/Mysql 2) are relatively easy to install, for someone familiar with both PHP and MySQL 3) also easily allow you to change the layout/template from the default For instance, if I want to hire a graphic designer to create a static page for me with a

[PHP-DB] Re: Erroneous date and time

2004-06-16 Thread franciccio
Have you tried with a insted of A for am/pm indication? Hope can help Bye Franciccio Philip Thompson [EMAIL PROTECTED] ha scritto nel messaggio news:[EMAIL PROTECTED] Hi all. Maybe there's something I'm doing incorrectly, but I cannot get the date() function to return the appropriate

RE: [PHP-DB] content managment systems

2004-06-16 Thread Kenny
Hi lisi, Have a look at www.opensourcecms.com They have all the popular CMS systems loaded on a server in one place so you can see them in action, once you find the one you like you can d/l it from there site as well Kenny -Original Message- From: Lisi [mailto:[EMAIL PROTECTED] Sent:

[PHP-DB] Re: content managment systems

2004-06-16 Thread pete M
I use www.tikiwiki.org love it pete Lisi wrote: I am looking for open source CMSs that: 1) use PHP/Mysql 2) are relatively easy to install, for someone familiar with both PHP and MySQL 3) also easily allow you to change the layout/template from the default For instance, if I want to hire a

RE: [PHP-DB] ADOdb db abstraction library moving to sourceforge

2004-06-16 Thread Galbreath, Mark A
Thanks, John - I, for one, would be lost without ADODB. Mark -Original Message- From: John Lim [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 16, 2004 2:04 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] ADOdb db abstraction library moving to sourceforge Hello, ADOdb is a popular database

Re: [PHP-DB] delete a record not working

2004-06-16 Thread Philip Thompson
Yeah, you should have a single apostrophe around the $id. So it should read: mysql_query(DELETE FROM open_trades WHERE id='$id'); That should do it. ~Philip On Jun 16, 2004, at 12:04 AM, Justin wrote: Hello, I have a simple script to retrieve and then delete a selected script, but it does not

Re: [PHP-DB] Re: Erroneous date and time

2004-06-16 Thread Philip Thompson
Have you tried with a insted of A for am/pm indication? Yes, I have tried both 'a' and 'A'. Still gives an incorrect time. ~Philip Hope can help Bye Franciccio Philip Thompson [EMAIL PROTECTED] ha scritto nel messaggio news:[EMAIL PROTECTED] Hi all. Maybe there's something I'm doing incorrectly,

[PHP-DB] Re: [PHP] update count

2004-06-16 Thread Bob Lockie
On 06/16/04 09:53 John Nichel spoke: Bob Lockie wrote: What is the best way to only do an update if it going to update only one row? I want to protect my code so that it won't accidentally update more than one row. I can do a select first but there must be an easier way. :-) UPDATE

Re: [PHP-DB] Erroneous date and time

2004-06-16 Thread Jason Wong
On Wednesday 16 June 2004 03:36, Philip Thompson wrote: Maybe there's something I'm doing incorrectly, but I cannot get the date() function to return the appropriate time. It's always 12 hours off. I've tried using 24-hour time and 12-hour time (with AM/PM), but they both give the wrong time.

RE: [PHP-DB] Re: [PHP] update count

2004-06-16 Thread Gary Every
If you aren't using a unique key, you can always use LIMIT 1 at the end of your query, but unless your ORDERing correctly to get the exact data row you want to update, this can have unexpected results. Gary Every Sr. UNIX Administrator Ingram Entertainment Inc. 2 Ingram Blvd, La Vergne, TN

[PHP-DB] Re: [PHP] update count

2004-06-16 Thread franciccio
I don't think you can have a relation (table) without a unique key. Either a single field or a unique relation between 2 or more fields is necessary for the table. Franciccio Bob Lockie [EMAIL PROTECTED] ha scritto nel messaggio news:[EMAIL PROTECTED] On 06/16/04 09:53 John Nichel spoke: Bob

[PHP-DB] Re: content managment systems

2004-06-16 Thread Justin Patrin
Pete M wrote: I use www.tikiwiki.org love it I just started using it and it's very nice. Here's a quick hint to those who are new, though. You can click the :: to expand the menu. If I'd only known this when I started pete Lisi wrote: I am looking for open source CMSs that: 1) use PHP/Mysql

[PHP-DB] Re: content managment systems

2004-06-16 Thread Lester Caine
Justin Patrin wrote: Pete M wrote: I use www.tikiwiki.org love it I just started using it and it's very nice. Here's a quick hint to those who are new, though. You can click the :: to expand the menu. If I'd only known this when I started Take a look at the tikipro version. You will be able

[PHP-DB] Fetch two mysql resource in while loop

2004-06-16 Thread sam
Hi all: i worte a piece of code like this $result1 = mysql_query(query1); $result2 = mysql_query(query2); while($row1=mysql_fetch_row($result1) $row2=mysql_fetch_row($result2)){ } only $row2 is initazlied. row1 is always empty. if i change it like this

[PHP-DB] mysql and indexes

2004-06-16 Thread Michael Gale
Hello, I know this question is more mysql related then PHP with mysql .. but If I do a SHOW INDEX from table_name I see what appears to be two index for the same column ? table_name 0 PRIMARY 1 columnname A NULLNULLNULL table_name 0 columnname