Re: [PHP-DB] How to do error feedback when adding to indexed table?

Sorry if I was being vague. But naturally, about half an hour after I posted this, I found a simple and fool-proof way to do what I wanted: Simply just have MySQL lookup the ID after all the other error checking was done, like this: if (! isset($error)) { // DB check to ensure number is not

[PHP-DB] Comparing tables

I would like to compare 2 tables in a database to determine which records are different!!! Any clues out there. Thanks in advance! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Comparing 2 tables in the same database

I would like to compare 2 tables in the same database so that I can find out which records are different! Thanks in advance! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] joining two sql statements

Hello, I am having a problem on how to get products out of 2 diffenent mysql tables to display them on one php site. Goal is to display 10 listings each site which can contain data out of both tables. Problem though is, that I want to fill the same variable with values from both tables. Right no

[PHP-DB] How to insert date into date field

Hi I have a date that is formatted in the following way day(00-31)/Mon(Jan-Dec)/year(2003):hour(00-23):minute(00-59):sec(00-59) I want to load this into mysql table (date column) In oracle I can just use the to_date function but all I find about MYSQL seems to want the date in a specific format

[PHP-DB] Re: Oracle and PHP

Hi Roger, There is Oracle Commander , but it is not very good as phpMyAdmin. Try it: http://www.bitesser.de/downloads/download.php?filename=oraclecommander Oracle is similar to other databases used from PHP, only difference is calling stored procedures that return resultset. Dont use oracle funct

[PHP-DB] Fw: Mysql Query

Hi guys, I am resending the same query again because still stuck on it. I have been working in php/oracle for quite some time now but recently had to shift myself to mysql and I am struggling with a particular query here. Scenario is, certain researchers can submit their proposals and those pr

[PHP-DB] Reading File Contents

Hello. I have what should be a simple fix for the more advanced programmers out there. I'm having problems with the display format of a text file. I've been reading several resources, and I'm just not having much success with it. How would you be able to display the following file named test

RE: [PHP-DB] How to insert date into date field

> I have a date that is formatted in the following way > day(00-31)/Mon(Jan-Dec)/year(2003):hour(00-23):minute(00-59):sec(00-59) > > I want to load this into mysql table (date column) > > In oracle I can just use the to_date function but all I find about MYSQL > seems to want the date in a specific

Re: [PHP-DB] Fw: Mysql Query

Mohammad Saadullah wrote: Hi guys, I am resending the same query again because still stuck on it. I have been working in php/oracle for quite some time now but recently had to shift myself to mysql and I am struggling with a particular query here. what is the query you would write for oracle ?

[PHP-DB] PHP-DB Mailserver listed in spamcop?

http://spamcop.net/w3m?action=checkblock&ip=216.92.131.4 I just got a warning from PHP-DB mailserver that it cannot deliver to me because my server is blocking.. I checked and it looks like the list mailserver has been listed in spamcop by somebody? One of the list managers might want to take a

Re: [PHP-DB] Reading File Contents

On Mon, 25 Aug 2003, The Cossins Fam wrote: } I've tried the nl2br function, as well as adding "\n" to the end of each } line and using fgets to replace "\n" with "". However, nothing seems to } be working. I'm probably missing something very simple, but if someone } wouldn't mind helping a r