[PHP-DB] VERY NEWBIE php_* mod_* --with-* question

Hello List for the first time, I am very new to php but impressed from what i've seen so far. I managed to configure php w/ mysql and db2 do some selects, inserts ... What I am inerested in is what are all those mod_php* and php_* on the distribution's CDs e.g. if they are installed how do i

[PHP-DB] MySQL 4.x and PHP

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 by the

[PHP-DB] Two sql queries

Hi there, Wonder if someone could help me, I have not touched PHP in a while now so a little rusty. What i have is a news page now the news story is disaplayed when someone clicks the item from the home page, which then loads a news page, but the problem I am having is when the news page

[PHP-DB] Two sql queries

Hi there, Wonder if someone could help me, I have not touched PHP in a while now so a little rusty. What i have is a news page now the news story is disaplayed when someone clicks the item from the home page, which then loads a news page, but the problem I am having is when the news page

[PHP-DB] Noob questions...

Ok, here's my scenario... My Web Host has all Root Admin control over MySQL and PHP configs (but they are setup well no complaints there)...I simply have access to 1 DB (already created) that I can do what I want with (create/delete/update tables). I'm VERY comfortable in Windows, C/C++,

RE: [PHP-DB] Noob questions...

Give phpMyAdmin a try... http://www.phpmyadmin.net/ -Original Message- From: Brett Lathrope [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 8:55 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Noob questions... Ok, here's my scenario... My Web Host has all Root Admin

Re: [PHP-DB] Noob questions...

search around for phpmyadmin on google Adam On Wed, 2 Oct 2002, Brett Lathrope wrote: Ok, here's my scenario... My Web Host has all Root Admin control over MySQL and PHP configs (but they are setup well no complaints there)...I simply have access to 1 DB (already

RE: [PHP-DB] Noob questions...

You should ask if your ISP has not already installed a phpMyAdmin that you can use - save you the bother. -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 9:57 AM To: 'Brett Lathrope'; [EMAIL PROTECTED] Subject: RE: [PHP-DB]

[PHP-DB] Query error

Hello guys Does anybody have a clue on what wrong with the following sentence? select author_code from author where author_code not in (select author_code from authorxcat); Thanks ***

Re: [PHP-DB] Query error

if you are using mysql, it doesn't support the sub-select. Wilmar Perez

[PHP-DB] Why would this query behave this way??

hi all this query: SELECT updates.MODELCODE, SETNO, FRPICNO, TOPICNO, CPOSTDATE, MODELNAME, ZIPFILENAME, TOTPICS FROM updates, models WHERE updates.MODELCODE = models.MODELCODE AND CPOSTDATE = CURDATE() AND CPOSTDATE = ( CURDATE() - 14 ) ORDER BY CPOSTDATE LIMIT 0, 30 worked perfectly until

[PHP-DB] problem selecting from mssql database

I have connected successfully to an MSSQL server, as can be seen by the following generated list of existing tables: http://webworks.ie/200210/ When I try to select from those tables, I get errors, as seen here: http://webworks.ie/200210/newhomes.php The source of the above is here:

[PHP-DB] problem selecting from mssql db

I have connected successfully to an MSSQL server, as can be seen by the following generated list of existing tables: http://webworks.ie/200210/ When I try to select from those tables, I get errors, as seen here: http://webworks.ie/200210/newhomes.php The source of the above is here:

[PHP-DB] I need Microsoft SQL Library: mssql70.so

I've installed Linux Red Hat 7.1 with php 4 and have the this libraries in /usr/lib/php4 pgsql.so ldap.so imap.so but I need Microsoft SQL Library: mssql70.so how can I install it? Leo

Re: [PHP-DB] I need Microsoft SQL Library: mssql70.so

You need the FreeTDS connection library (it works wonders for us): Goto www.freetds.org Download it Configure, make, make install it Edit your freetds config file to your needs Add the --with-sybase=/path/to/freetds to your PHP configure line yes, I know that says sybase, but trust me, it

Re: [PHP-DB] Get a single result

--- mysql_result($result_category_id, 0, $i); I think it is compaigning about the '$i' of course we don't know what that is set to, so cannot help much. I would say it might not like it when '$i' is equal to 0... :-) -Brad Hello guys. The scenery: I've got an array with some values

[PHP-DB] Difference in time

Hello all, I am fighting a time issue(don't we all). I have a online poll set up. I need a way to stop a person from submitting more than once an hour. As of now I have the time .. mktime( ) .. being stored in a database along with the users IP. I want to be able to say if 1 hour has passed

[PHP-DB] Retrieve auto_increment value after an insert with ODBC

Hi, I use php and db2 database. I wonder if there is a way to retrieve the value of an auto-increment id after an insert query. (Like mysql_insert_id on MySQL database.) The temporary solution is to select record with the same values than the insert. Any others solutions? -- PHP Database

RE: [PHP-DB] Retrieve auto_increment value after an insert with ODBC

You can select max(aifield) immediately after the insert. :-) Ryan -Original Message- From: Stéphane [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 11:57 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Retrieve auto_increment value after an insert with ODBC Hi, I use php

RE: [PHP-DB] Difference in time

for mySQL, the table would look like... CREATE TABLE polls( pollID INT NOT NULL AUTO_INCREMENT, ipAddress VARCHAR (50) NULL, insertTime DATETIME NULL, etc... PRIMARY KEY (pollID) ); === the code would look like... $statement =

Re: [PHP-DB] Noob questions...

Try this http://www.mydomain.com/phpmyadmin/ and be ready with your password. Russell Griechen You should ask if your ISP has not already installed a phpMyAdmin that you can use - save you the bother. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

RE: [PHP-DB] Difference in time

I am fighting a time issue(don't we all). I have a online poll set up. I need a way to stop a person from submitting more than once an hour. As of now I have the time .. mktime( ) .. being stored in a database along with the users IP. I want to be able to say if 1 hour has passed from the

RE: [PHP-DB] MySQL 4.x and PHP

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

[PHP-DB] postgres cursors

hi, i have a function that returns a cursor. how do i get at it in php? here's my function: create function test3 (INTEGER) RETURNS refcursor AS ' DECLARE cursor1 CURSOR FOR select description FROM t0040stock_item WHERE stock_number = $1; BEGIN open cursor1; return (cursor1); END; '

RE: [PHP-DB] Query error

If it's on MySQL, then the problem is that it doesn't support nested queries :) If it's on something else, i'm afraid i don't know :/ Back to MySQL, you can get around that by doing your select author_code from authorxcat component query, then put the results into 'x', 'y', 'z' format, then do

Re: [PHP-DB] Sending E-Mail

just put the variables from the form into the mail() function On Wed, 2002-10-02 at 23:11, Shoulder to Shoulder Farm wrote: Sorry all, this IS off topic, but I always receive faster answers from this group :-o! How can I send e-mail from PHP with the content of a submitted form. Thanks, Taj

[PHP-DB] VERY NEWBIE php_* mod_* --with- question

Hello List for the first time, I am very new to php but impressed from what i've seen so far. I managed to configure php w/ mysql and db2 do some selects, inserts ... What I am inerested in is what are all those mod_php* and php_* on the distribution's CDs e.g. if they are installed how do i