[PHP-DB] merging a table from multiple servers

I'm trying to work on a project that gathers info from different servers, then combines them and displays it. Is it possble to merge the tables from the different servers into 1 table using php? My one solution to this was to have a php script on each server, then have my website call each php sc

[PHP-DB] Insterting date in an MySQL table

Hi everyone, I want to created a MYSQL table which will get the date in the form (-MM-DD) automatically. I have created the table below but it doesn’t get the form of date that I want. It has the form (MMDDHHMMSS) CREATE TABLE questions1 (ID INT NOT NULL AUTO_INCREMENT,name VARCHAR(30),da

[PHP-DB] Re: Insterting date in an MySQL table

"Charalambos Nicolaou" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi everyone, > > I want to created a MYSQL table which will get the date in the form > (-MM-DD) automatically. I have created the table below but it doesn’t > get the form of date that I want. It has the form (

Re: [PHP-DB] Insterting date in an MySQL table

From: "charalambos nicolaou" <[EMAIL PROTECTED]> > I want to created a MYSQL table which will get the date in the form > (-MM-DD) automatically. I have created the table below but it doesn't > get the form of date that I want. It has the form (MMDDHHMMSS) > > CREATE TABLE questions1 (ID IN

[PHP-DB] Re: Insterting date in an MySQL table

Maybe you can also use this syntax: select date_format(now(), '%Y.%m.%d') name_of_the_column Dalibor charalambos nicolaou napsal(a): Hi everyone, I want to created a MYSQL table which will get the date in the form (-MM-DD) automatically. I have created the table below but it doesn?t get the fo

Re: [PHP-DB] Image / file uploader

Try using the following: $_SERVER[PHP_SELF] Mainly, get rid of the quotes inside the brackets. Usually this error 'T_String' generally occurs when you have quotes (" or ') where they shouldn`t be. Give it a try if that thing still troubles you... Good luck Craig Hoffman wrote: > Sorry to be

[PHP-DB] looking for a variable

Hi, In a statement like: $result = mysql_query ("SELECT * FROM testdb WHERE Code_Name IN ('CLM', 'CAM', 'CSIM', 'cpl5', 'POP')",$connection) is there a php variable that holds the number of elements in the () after IN? Thanks, Robbie -- -*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* Robbie

Re: [PHP-DB] looking for a variable

Robbie Staufer wrote: Hi, In a statement like: $result = mysql_query ("SELECT * FROM testdb WHERE Code_Name IN ('CLM', 'CAM', 'CSIM', 'cpl5', 'POP')",$connection) is there a php variable that holds the number of elements in the () after IN? No :\ What did you want to do with that number? Ma

Re: [PHP-DB] Image / file uploader

I think you need the quotes: $_SERVER['PHP_SELF'] > Try using the following: > > $_SERVER[PHP_SELF] > > Mainly, get rid of the quotes inside the brackets. Usually this error > 'T_String' generally occurs when you have quotes (" or ') where they > shouldn`t be. > > Give it a try if that thing still

Re: [PHP-DB] looking for a variable

I'm formatting the display in a browser window. I need the second and consecutive elements to be indented below the first one. Something like this: echo "element 0" foreach additional element echo "tab","element" Thanks, Robbie Bruno Ferreira wrote: Robbie Staufer wrote: Hi, In a st

Re: [PHP-DB] looking for a variable

From: "Robbie Staufer" <[EMAIL PROTECTED]> >> $result = mysql_query ("SELECT * FROM testdb WHERE Code_Name IN ('CLM', >> 'CAM', 'CSIM', 'cpl5', 'POP')",$connection) >> is there a php variable that holds the number of elements in the () >> after IN? > > I'm formatting the display in a browser window

Re: [PHP-DB] looking for a variable

I supply those values. Data associated with them gets pulled out of the database and I need to format them so that the first one is displayed differently than the following ones. thanks, Robbie John W. Holmes wrote: From: "Robbie Staufer" <[EMAIL PROTECTED]> $result = mysql_query ("SELECT *

Re: [PHP-DB] looking for a variable

From: Robbie Staufer > I supply those values. Data associated with them > gets pulled out of the database and I need to format > them so that the first one is displayed differently than the > following ones. Oh... echo "CLM, CAM, CSIM, cpl5, POP"; ---John Holmes... -- PHP Database Mailin

Re: [PHP-DB] looking for a variable

Thanks, Robbie John W. Holmes wrote: From: Robbie Staufer I supply those values. Data associated with them gets pulled out of the database and I need to format them so that the first one is displayed differently than the following ones. Oh... echo "CLM, CAM, CSIM, cpl5, POP"; ---John

[PHP-DB] Re: Insterting date in an MySQL table

On 5/6/04 3:13 AM, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: Hi Charalambos, In MSSQL as in most DBMS's the format the date is inserted, the format it is stored and the format it is retrieved are quite independent. If inserting the date is working (you are saving the correct date) then all

[PHP-DB] MySQL Password() & PHP encryption?

Hi all, I've recently upgraded my mysql to v 4.1.1 (on win nt 4.0) and set the Passwords in the user table to the mysql Password() function. Now, this doesn't work anymore when call from a php web script (which is a good thing, cause it's plain text): mysql_connect ("localhost", "theID", "the

Re: [PHP-DB] MySQL Password() & PHP encryption?

Theisen, Gary wrote: I've recently upgraded my mysql to v 4.1.1 (on win nt 4.0) and set the Passwords in the user table to the mysql Password() function. Now, this doesn't work anymore when call from a php web script (which is a good thing, cause it's plain text): mysql_connect ("localhost", "t