[PHP-DB] Can't Load Data into Mysql Using PHP

sfully load the data into Mysql database. Could someone pls tell me what mistake i had made? -- Thx a lot! Jack [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Question about Load Data to mysql through php

how to show the error message from mysql at php script!!). I had tried to use MyCC(a client program for Mysql) in client side to load the data into mysql, it works with no problem! Don't know what i had done wrong! Here is the php script at my page : -- Thx a lot! Jack [EMAIL PROTECTED

Re: [PHP-DB] Question about Load Data to mysql through php

Dear Jason Thx for the reply, but do you know where i should copy that file to in serverside? is it got to be the same directory of mysql? Thx a lot! Jack [EMAIL PROTECTED] - Original Message - From: "Jason Wong" <[EMAIL PROTECTED]> Newsgroups: php.db To: <[EMAIL PROTEC

[PHP-DB] Problem on Load Data into Specific Fields of a table?

into table hkd_deposit1 fields terminated by ',' " It said couldn't find the file! but if i put the file into the data directory of mysql, then it can find it! So what should i do if i want mysql will able to find that file from root directory? -- Thx a lot! Jack [EMAIL PROTEC

[PHP-DB] Have Problem on Checking condition before insert to Mysql Table

rd to understand what i want to do, so here is an example : Existing Records in Table: NameStaff CodeLeave_FromLeave_ToBackup_Staff JACK1232002-01-152002-01-17Someone User Input: NameStaff CodeLeave_FromLeave_ToBackup_Staff

[PHP-DB] How to Compare Date

do the comparsion? I had tried to use the following script but it doesn't work! It doesn't work since i use the < Operator! Does anyone know how i can perform this comparsion? -- Thx a lot! Jack [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsub

Re: [PHP-DB] How to Compare Date

could you tell me how i can covert it to UnixTimeStamp Format? Thx a lot Jack - Original Message - From: "Jason Wong" <[EMAIL PROTECTED]> Newsgroups: php.db To: <[EMAIL PROTECTED]> Sent: Thursday, May 30, 2002 8:32 PM Subject: Re: [PHP-DB] How to Compare Date >

[PHP-DB] How to convert Date to UnixTimeStamp

Dear all I had a table which store the date input by user, eg : 2001-12-31 How i can convert it back to Unix time Stamp? I got to do so for comparsion of date! Thx a lot! Jack -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Date Comparsion

ovide this operation? -- Thx a lot! Jack [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] How to Show my Own Error Message Instead of Mysql Error?

ation Form, it mean the Login Name is Duplicated! But i want to show my own message to the user for this error instead the Mysql Error! It is meanness to show User the Mysql Error, cause they won't understand it!!! Could Someone pls tell me how i can do this? -- Thx a lot! Jack [EMAIL PROTEC

[PHP-DB] How to Check Directory exist in Specific Folder

Dear all Does php have any script which can check if a directory exist in specific folder? Thx a lot Jack -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Date format in MSSQL

How I can format date in php query from MSSQL? Jack -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Multi-Task on PHP by submitting a form!

ess had finish, which will insert the data from the from to mysql_database. Thx Jack [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EM

[PHP-DB] How to get the content of a file into the value of a text column

Dear all Actually i'm trying to get the content of a file, and make it as a default value of a input text column. Is there anyway could do it? Thx jack [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional comman

[PHP-DB] appear in Text file

that txt file to the text box in (input box). Is there anyway that i can do to avoid grebing the from txt file to my input box's value? or anyway that i can delete the when the data is greb from input box to txt file?? Thanks a lot Jack [EMAIL PROTECTED] -- PHP Database Mailing

[PHP-DB] Could get all data from MYSQL using Mysql_fetch_array!!

(Showing below) : Pls help me!! Thx jack [EMAIL PROTECTED] [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Couldn't get all data using the "mysql_fetch_array" function, Pls Help!!!!

(Showing below) : Pls help me!! Thx jack [EMAIL PROTECTED] [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] Use the User Input Critia as part of Query! (Mysql)

quest where Staff_Number="" and authorized is null"; But said there is error on this line, which is what i expected!! So could anyone pls tell me how i can get the varaible into part of the Query of Mysql? Thx jack [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net

[PHP-DB] Username on NT Domain

Dear all Is there any function in php that can pass the username and password of NT domain to MYSQL interface?? I'm designning a database with interart with php for a web site, but i'm just concerning about the security of the user right!! Cheers Jack [EMAIL PROTECTED] -- PH

[PHP-DB] php and mysql security problem

ord. but i don't want other people can update his record. Is there also possible for php to grab the username and password from the window base which logged on to a Domain and pass it to MYSQL!! Thx Jack [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

[PHP-DB] Passing Logined in Name form One Form to other Page

need to select data from MYSQL, it will read the Username which passed from the Login Form and select the only Record to him! I heard about the Session, but how i can pass the Username to other page using Session?? Pls Help! Thx a lot ! jack [EMAIL PROTECTED] -- PHP Database Mailing List

[PHP-DB] Re: [PHP] RE: [PHP-DB] Login System with access levels

ww.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED]

[PHP-DB] Re: [PHP] How can this be done?

http://www.php.net/addslashes -jack Subodh Gupta wrote: > > Hi All, > > I created a table using the create command. > > create table trivia > ( > entry_id integer not null auto_increment, > trivia text null > ); > > Now I have a fle tvia.txt,

[PHP-DB] ODBC returns correct # of rows, but no data?

I have a MSSQL server running on WinNT, and I am trying to issue queries to it from my Linux 2.2.17 system using ODBC. I have installed unixODBC and the FreeTDS driver, and with this combination I am able to send queries from a command line client succesfully. In particular, when I execute

[PHP-DB] Will PHP work with IBM DB2 dbms?

Can anyone tell me if I can use PHP with a IBM DB2 database management system, running on a AIX Unix server? Thanks Jack Schroeder -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Adding MySQL support to PHP - libmysqlclient.so version problem

er of my other MySQL RPMs. But that contains /usr/lib/libmysqlclient.so.12, not the .10 version. How can I get mysql support in php? I'm hoping to avoid ripping out mysql and php and building everything from source. Jack Orenstein -- This is not a disclaimer -- -- PHP Database Mailing

Re: [PHP-DB] Adding MySQL support to PHP - libmysqlclient.so versionproblem

4.2.2-8.0.7 Jack Orenstein -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Problem with list#2

save your confirm and welcome e-mail from the list? That will tell you which one or if both of them are on the list. -- Jack Gates http://www.jlgates.com/ http://www.myenergyproducts.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Configuring PHP 5.2.0 with Postgres 8.1.3 (no source)

ths in the configure file suggest that it might not. 2) How can I get PHP configured to support postgres? Jack Orenstein -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MySQLi not closing connections

yone can assist, I'd appreciate it. Any info you need, let me know. -- Jon L. I'm not sure why the connections are staying open, but I would suggest using mysqli_real_connect with the flag to timout connections. http://www.php.net/manual/en/mysqli.real-connect.php If this is wa

[PHP-DB] Date formatting question

I need to reformat the output of the 'dates' field from '2009-04-08' to 'Wed. Apr. 8th'. Any help would be appreciated. Thanks. --- for ($counter = 0; $counter < mysql_num_rows($resultID); $counter++); while ($row = mysql_fetch_object($resultID)) { print ""; print "" . $row->dates . "

RE: [PHP-DB] Re: send email

Hi my example earlier does not show the email address in the source of the displayed web page. It is in the source code, but you can change that to be put in a config file and include this file in the script. Jack -Original Message- From: howard gramer [mailto:[EMAIL PROTECTED] Sent

[PHP-DB] unsuscribe

[PHP-DB] unsuscribe __ Do you Yahoo!? Yahoo! Mail - now with 250MB free storage. Learn more. http://info.mail.yahoo.com/mail_250 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] MYSQL 4.1 derived tables and PHP

php script must be correct). Does PHP do syntax checking before sending the query to mysql? Any other solution? I have tried PHP 4.3.2/4.3.3 & 5.0 TIA Jack -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

format beforehand. Any help?? TIA JAck -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

just make sure that just before midnight every day I load the data. I'll look at my PHP insert script one day to see if I can easily change this to pre format the date field . Jack -Original Message- From: Jennifer Goodie [mailto:[EMAIL PROTECTED] Sent: dinsdag 26 augustus 2003 1:1

RE: [PHP-DB] Connect to Oracle DB

Hi I don't know how this shared library works, but to the best of my knowledge you'll always need oracle client software (SQL*Net) installed on the php server to connect to an oracle database . Please correct me if I'm wrong and point me to the docs. Tia Jack -Original Me

RE: [PHP-DB] Selecting data from multiple tables

tbl2.user_id=tbl3.user_id (not neccessary but sometimes better performance) and tbl2.age=30 and tbl3.country='UNITED KINGDOM' Jack -Original Message- From: Awlad Hussain [mailto:[EMAIL PROTECTED] Sent: zaterdag 27 september 2003 15:58 To: [EMAIL PROTECTED] Subject: [PHP-DB]

RE: [PHP-DB] PHP 5 and MySQL

Active Persistent Links 0 Active Links 0 Client API version 4.1.0-alpha MYSQL_MODULE_TYPE external MYSQL_SOCKET /tmp/mysql.sock MYSQL_INCLUDE -I/usr/local/mysql/include MYSQL_LIBS -L/usr/local/mysql/lib -lmysqlclient Jack -Original Message

RE: [PHP-DB] PHP Issue

install PHP or name your file .PHP (if type added is .php or start your script with "" Jack -Original Message- From: Michael Cupp, Jr. [mailto:[EMAIL PROTECTED] Sent: vrijdag 3 oktober 2003 23:29 To: [EMAIL PROTECTED] Subject: [PHP-DB] PHP Issue I'm trying to '

[PHP-DB] Test connection to database

Hi I have written a little program that cycles through a list of databases and checks conectivity. it writes the status of this to a table now to check all 143 databases it takes about 50 seconds and I was wondering if this sounds about right to you guys. Connect(false, $ola_usr, $ola_pwd, $ol

Re: [PHP-DB] Test connection to database

Jack On 27/08/2008, Chris <[EMAIL PROTECTED]> wrote: > > Jack van Zanen wrote: > >> Hi >> >> >> I have written a little program that cycles through a list of databases >> and >> checks conectivity. it writes the status of this to a table >

[PHP-DB] OCI8 , PHP and APACHE issue

k this out. Anybody with some more experience in configuring this combo can shed some light on this?? Brgds Jack

Re: [PHP-DB] OCI8 , PHP and APACHE issue

at home now, will log on maybe later and get these Thanks so far 2008/9/1 Evert Lammerts <[EMAIL PROTECTED]> > Can you send your and the output of phpinfo when run from the command > line and when run from the browser? > > On Mon, Sep 1, 2008 at 6:35 AM, Jack van Zanen <[EM

Re: [PHP-DB] OCI8 , PHP and APACHE issue

10.2.0.4 client apache 2.2 php 5.2.6 Thanks On 01/09/2008, Evert Lammerts <[EMAIL PROTECTED]> wrote: > > Can you send your and the output of phpinfo when run from the command > line and when run from the browser? > > On Mon, Sep 1, 2008 at 6:35 AM, Jack van Zanen <[EMAIL PROTEC

Re: [PHP-DB] OCI8 , PHP and APACHE issue

I have the phpinidir directive set in apache so it loads the exact same php.ini as the cli Jack 2008/9/1 Evert Lammerts <[EMAIL PROTECTED]> > I see that in both cases c:\PHP\php.ini is loaded. Are you sure that > after trying the command line you didn't cut - paste the fil

RE: [PHP-DB] OCI8 , PHP and APACHE issue

it worked ok I really need to understand more about windows I guess Jack -Original Message- From: Evert Lammerts [mailto:[EMAIL PROTECTED] Sent: Monday, September 01, 2008 10:32 PM To: Jack van Zanen Cc: php-db@lists.php.net Subject: Re: [PHP-DB] OCI8 , PHP and APACHE issue No

RE: [PHP-DB] CMS-Blog system

I agree it depends on the architecture, however... 100 is not that many records. I personally like to keep my data together that could/should be used together. Jack -Original Message- From: Evert Lammerts [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2008 7:15 AM To

RE: [PHP-DB] display values from to_char() function.

Try to_char(task_start-(+480/1440),'mm/dd/yy-hh24:mi') as task_start),to_char(task_end-(+480/1440),'mm/dd/yy-hh24:mi') as task_end ,task_owner,label_phase,to_char(task_actual_start-(+480/1440),'mm/dd/yy-hh24 :mi') as task_actual_start Jack -Original Me

Re: [PHP-DB] How to retrieve the position of a row inside a table with garbage data in all cloumns?

way it is ordered in the table. Jack 2008/9/23 Trullo <[EMAIL PROTECTED]> > En/na Chris ha escrit: > > Trullo wrote: > >> hello_world(); > >> > >> in fact.. how to goTo next/previous row of a table without using > >> incremental ids AND w

Re: [PHP-DB] query optimization

come back from the main query What is the current execution plan? Jack 2008/9/26 YVES SUCAET <[EMAIL PROTECTED]> > How could I rewrite the following query so it runs faster: > > select distinct location from blockunit where blockid in ( > select bu.blockid from block

Re: [PHP-DB] query optimization

If you can answer the other questions that would help as well you can try rewriting using "exist" instead of "in" But without the basic information like number of records expected and explain plan it is very hard to come up with a better solution. Brgds Jack 200

Re: [PHP-DB] Performance (lots of tables / databases...)

If it were Oracle I'd go with one database and separate schema for each blog. For Mysql I think I'd go for a database each blog. Jack 2008/9/28 Martin Zvarík <[EMAIL PROTECTED]> > Hi, > I am working on a blog system and I am currently thinking of what would be > the bes

Re: [PHP-DB] Foreign Key Versus Table Index

I am not up to scratch with innodb, but in oracle you would have a Primary key on both the id fields in the Car and person table and a Foreign key on PersonId linking it to Id in the Person table. IN your select an index on PersonId would be beneficial if the tables get large. Jack 2008/10/2 J

Re: [PHP-DB] MySQL Query Timeout program in PHP

Just put the time out in your PHP.INI file max_execution_time = 30 ; Maximum execution time of each script, in seconds 2008/10/16 Piyush Kumar <[EMAIL PROTECTED]> > I'm using http://myclient.polarlava.com/ as web query interface for mysql > server > > Now I want to add "Query Timeout" functi

Re: [PHP-DB] SimpleXML broke while I was sleeping.

did they change the source at WoWhead? 2008/12/11 Nicholas Mercier <[EMAIL PROTECTED]> > So I had a code project that took the name of a piece of equipment in World > of Warcraft - pulled the XML from WoWhead and pulled the database item > number from the XML file. It worked for a long while a

Re: [PHP-DB] SimpleXML broke while I was sleeping.

I'll pass we all have a senior moment every now and than :-) Jack 2008/12/11 Nicholas Mercier <[EMAIL PROTECTED]> > Jack wins the right to call me an idiot for a long time. WoWhead changed > their configuration slightly I think, that is what messed it up. I believe &g

Re: [PHP-DB] Re: New Table Creation with PHP Variables

That looks like it should work, just execute the select query and see what is the output Jack 2008/12/29 Keith Spiller > Another option that would work if I can figure out the correct syntax is to > just NULL certain values if a given condition exists. If > product_type='cou

Re: [PHP-DB] Bounty for PHP DB project

the download Brgds Jack 2009/3/23 B B > > Hi Guys, > > > > I am new to PHP but have Linux and MySql experience. I have a requirement > which I would like to outsource for few hundred dollars if anyone is will to > take the job. The requirement is as follows: > >

Re: [PHP-DB] Get ID of ROW when using aggregate functions

s a person with highest sallary (17000) when > obviously Jane has sallary of 10 000? > > Thanks for any help. > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- Jack van Zanen -

Re: [PHP-DB] MySQLand a prepared statement problem

check into stripslashes ,addslashes and mysqli_real_escape_string functions. Jack 2009/7/17 Jason Carson > > Hello everyone, > > > > I have a problem. When I insert http://example.com>Example > > into my database with the following code... > > > &

Re: [PHP-DB] finder

and also represents poor/lazy programming (in my opinion) leaving you open to all sorts of trouble if columns get added or deleted. I always advise to querry exactly what you require. Sorry for this comment but op seems to be fairly novice on SQL and could benefit from this post. Brgds Jack

Re: [PHP-DB] finder (I AM REALLY SORRY)

EDA .= "AND cochera LIKE > '%$f_cochera%' "; } > > if ($f_ubicacion > 0) { $sql_BUSQUEDA .= "AND ubicacion LIKE > '%$f_ubicacion%' "; } > > if ($f_apto > 0) { $sql_BUSQUEDA .= "AND apto LIKE '%$f_apto%' "; } > > $sql

Re: [PHP-DB] newbie: how to return one iteration *per unique date (DAY!)* in a timestamp column?

so my advise may be completely flawed. Jack 2009/8/3 Govinda > Oops, forgot to mention that with the alias you can change the ORDER BY >> clause to use the aliased column data: >> ORDER BY solarLandingDate DESC >> this will only use the returned data instead of the entire column.

RE: [PHP-DB] newbie: how to return one iteration *per unique date (DAY!)* in a timestamp column?

case this might not happen if you do not get that much data, but again we do not know. Just something to keep in mind before deploying. Jack -Original Message- From: Govinda [mailto:govinda.webdnat...@gmail.com] Sent: Tuesday, August 04, 2009 12:34 AM To: php-db@lists.php.net Subject: Re

Re: [PHP-DB] Re: Need help-Send email

o not think so Most likely culprit is number 2. Jack van Zanen - This e-mail and any attachments may contain confidential material for the sole use of the intended recipient. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or u

Re: [PHP-DB] Re: Need help-Send email

I thought he said he was using the gmail smtp server? Jack van Zanen - This e-mail and any attachments may contain confidential material for the sole use of the intended recipient. If you are not the intended recipient, please be aware that any disclosure, copying

Re: [PHP-DB] Search

the joining should be on the ID field that is present in all three tables, but the ID may not be the same meaning for the tables. Jack 2009/10/16 Emiliano Boragina > Hello > I’m using this code to a search: > > $sql = "SELECT empresas.id, empresas.nombre, rubros.

Re: [PHP-DB] Hello

that is on your result page in phpmysql and see what it returns. Jack 2009/12/14 Karl DeSaulniers > Hi I am new to this list. > I am in need of some help or direction. > I am new to php and databases, so forgive me if my request seems too > simple. > > I am making a databas

Re: [PHP-DB] Working with large datasets

quick. Jack van Zanen - This e-mail and any attachments may contain confidential material for the sole use of the intended recipient. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of this e-mail or any attachme

Re: [PHP-DB] SELECT syntax

, should not be too hard to come up with a couple of lines of code to display only 1 variable based on the value of variable 5. Overhead should be pretty minimal as well You'll be writing something to display a value anyway Jack van Zanen - This e-mail and any attachment