[PHP-DB] Help displaying Column Names

2006-09-14 Thread Grant Griffith
Hello All, I am fairly new to PHP but have coded in asp and asp.net for years. I am trying to find the code that will allow me to display the name of the column's from the table I am using. Below is the code where I am writing all the data out in a comma delimited fashion, but I want to make

[PHP-DB] Help building oci8 module on Solaris-10 x86 with PHP

2006-09-10 Thread Robert Sturrock
Hello. I've been trying to build the PHP oci8 with PHP 4.4.2 on a Solaris 10 x86 based machine, and I'm having problems getting a working module. What I have built segfaults and dumps core everytime I try to use it. If anyone has been able to get the module working with this configuration I'd be

Re: [PHP-DB] help in sql - postgresql

2006-05-02 Thread suad
Hi, Thanks a lot, That exactly wat I need :) Suad Chris wrote: suad wrote: Hi, I need some help in sql - postgresql: Yay a postgres question! :D hee hee *The question is* : how can I force that the result of the col payed to be zerro "0" insted of nothing (NULL) and the order will

Re: [PHP-DB] help in sql - postgresql

2006-05-02 Thread Chris
suad wrote: Hi, I need some help in sql - postgresql: Yay a postgres question! :D hee hee *The question is* : how can I force that the result of the col payed to be zerro "0" insted of nothing (NULL) and the order will be in way that the zerro's values comes first. and the result will be:

[PHP-DB] help in sql - postgresql

2006-05-01 Thread suad
Hi, I need some help in sql - postgresql: I create this 4 tables: CREATE TABLE a ( a_id SERIAL PRIMARY KEY, a_name text ); CREATE TABLE b ( b_id SERIAL PRIMARY KEY, b_price INT2 ); CREATE TABLE c ( c_id SERIAL PRIMARY KEY, a_id INT4 REFERENCES a ON UPDATE CASCADE ON DELETE CASCADE, b_id INT4

[PHP-DB] help width sql

2006-05-01 Thread suad
hi I have a problem whith inforcing the result of a selekect query, here is my tables and the query: I create this 4 tables: CREATE TABLE a ( a_id SERIAL PRIMARY KEY, a_name text ); CREATE TABLE b ( b_id SERIAL PRIMARY KEY, b_price INT2 ); CREATE TABLE c ( c_id SERIAL PRIMARY KEY, a_id INT4

Re: [PHP-DB] Help: Two dimensional array from table

2006-04-07 Thread Mark Fellowes
now Im not sure how to call the individual fields. I've tried $usrreg['date']; but that doesn't seem to work. Do I need to use keys and values ? TIA Mark -Original Message- From: [EMAIL PROTECTED] Sent: Friday, April 7, 2006 4:14 PM -07:00 To: Mark Fel

[PHP-DB] Help: Two dimensional array from table

2006-04-07 Thread Mark Fellowes
I created an array to pull data out of one column in database. However I now need a second column from the table and think a two dimensional array is the right way to go. Having a problem though in defining. Most of the examples I found don't seem to apply to pulling the values from a

RE: [PHP-DB] help with file downloads from MySQL

2006-03-28 Thread Mickey Martin
from the queries and it put a newline at the end of the output data. Thanks everyone for the help with this. -Original Message- From: Oskar [mailto:[EMAIL PROTECTED] Sent: Friday, March 24, 2006 1:59 AM To: Mickey Martin; PHP db Subject: Re: [PHP-DB] help with file downloads from MySQL

RE: [PHP-DB] help with file downloads from MySQL

2006-03-24 Thread David Robley
ot;, $data; > > When the file is saved, it begins with 0a followed by TEST TEXT and then > the start of the file without another instance of 0a. > > Mickey > > > -Original Message- > From: Oskar [mailto:[EMAIL PROTECTED] > Sent: Friday, March 24, 2006 1:5

RE: [PHP-DB] help with file downloads from MySQL

2006-03-24 Thread Mickey Martin
ith 0a followed by TEST TEXT and then the start of the file without another instance of 0a. Mickey -Original Message- From: Oskar [mailto:[EMAIL PROTECTED] Sent: Friday, March 24, 2006 1:59 AM To: Mickey Martin; PHP db Subject: Re: [PHP-DB] help with file downloads from MySQL Mick

RE: [PHP-DB] help with file downloads from MySQL

2006-03-22 Thread Mickey Martin
it is configured today. Thanks, Mickey -Original Message- From: Giff Hammar [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 21, 2006 3:50 PM To: 'Mickey Martin'; 'Bastien Koert'; php-db@lists.php.net Subject: RE: [PHP-DB] help with file downloads from MySQL Can you use somet

RE: [PHP-DB] help with file downloads from MySQL

2006-03-21 Thread Giff Hammar
f -Original Message- From: Mickey Martin [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 21, 2006 4:05 PM To: 'Bastien Koert'; php-db@lists.php.net Subject: RE: [PHP-DB] help with file downloads from MySQL I tried purposely corrupting the file by adding blank spaces at the beginning of

RE: [PHP-DB] help with file downloads from MySQL

2006-03-21 Thread Mickey Martin
t: Tuesday, March 21, 2006 2:07 PM To: [EMAIL PROTECTED]; php-db@lists.php.net Subject: RE: [PHP-DB] help with file downloads from MySQL If you load the data into the field with addslashes, have you tried stripslashes on the way out? Bastien >From: "Mickey Martin" <[EMAIL PROTECTED]&

RE: [PHP-DB] help with file downloads from MySQL

2006-03-21 Thread Mickey Martin
Here's the code I'm using to upload if it helps: "; echo "Continue"; } mysql_close(); } else { ?> -Original Message- From: Bastien Koert [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 21, 2006 2:07 PM To: [EMAIL PROTECTED]; php-db@lists.php.ne

RE: [PHP-DB] help with file downloads from MySQL

2006-03-21 Thread Mickey Martin
hp-db@lists.php.net Subject: RE: [PHP-DB] help with file downloads from MySQL If you load the data into the field with addslashes, have you tried stripslashes on the way out? Bastien >From: "Mickey Martin" <[EMAIL PROTECTED]> >To: php-db@lists.php.net >Subject: [PHP-DB] help

RE: [PHP-DB] help with file downloads from MySQL

2006-03-21 Thread Bastien Koert
If you load the data into the field with addslashes, have you tried stripslashes on the way out? Bastien From: "Mickey Martin" <[EMAIL PROTECTED]> To: php-db@lists.php.net Subject: [PHP-DB] help with file downloads from MySQL Date: Tue, 21 Mar 2006 12:55:56 -0600 Eve

[PHP-DB] help with file downloads from MySQL

2006-03-21 Thread Mickey Martin
Every time I try to download a file from MySQL it cannot be opened. Using HexEdit, I noticed that all of the files are getting 0a added to the beginning of them (happens with all browsers). I can look at the files with MySQL Query Browser and they don't have the 0a. Using php 4.3.11, Solaris 8, Ap

RE: [PHP-DB] Help needed creating a social network

2006-03-07 Thread Miles Thompson
: You know bob who knows john who knows carrol who knows Sam. Sam <- carrol <- john <- bob <- you Etc. > -Original Message- > From: Micah Stevens [mailto:[EMAIL PROTECTED] > Sent: Monday, March 06, 2006 10:28 PM > To: php-db@lists.php.net > Subject: Re: [PHP-DB

RE: [PHP-DB] Help needed creating a social network

2006-03-07 Thread Daevid Vincent
t;- carrol <- john <- bob <- you Etc. > -Original Message- > From: Micah Stevens [mailto:[EMAIL PROTECTED] > Sent: Monday, March 06, 2006 10:28 PM > To: php-db@lists.php.net > Subject: Re: [PHP-DB] Help needed creating a social network > > > CREATE TA

Re: [PHP-DB] Help needed creating a social network

2006-03-06 Thread Micah Stevens
CREATE TABLE `users` (userID int(11) not null auto_increment, primary key(userID), name tinytext not null, email tinytext not null); CREATE TABLE `links` (userID int(11), key (userID), friendID int(11), key(friendID)); You have friends!!"; while ($f = mysql_fetch_assoc($friends)) { echo "{$f['

[PHP-DB] Help needed creating a social network

2006-03-06 Thread Daevid Vincent
Anyone have some pointers at a HowTo on creating a social network? Basically I need to show people in your immediate network, and also friends of your friends, etc... Like the whole 'six degrees of separation' thing. Ala: myspace, friendster, etc. ad nauseum. I prefer mySQL and PHP, but I could p

Re: [PHP-DB] Help Needed with malfunctioning query

2006-02-25 Thread Murray @ PlanetThoughtful
On 26/02/2006 3:03 PM, Chris Payne wrote: Hi there everyone, This line of code USED TO WORK but now it gives me a Coudln't Execute Query error: $query2 = "SELECT word,def,photo MATCH(word,def) AGAINST ('$txtsearchword' IN BOOLEAN MODE) AS m FROM dictionary WHERE MATCH(word,def) AGAINST ('$t

RE: [PHP-DB] Help Needed with malfunctioning query

2006-02-25 Thread Chris Payne
Hi there, I'm using asd just to test the search, here's the output from the statement echoed to the screen: SELECT word,def,photo, if(locate('asd',word),1,2) as meFirst ,MATCH(word,def) AGAINST ('asd' IN BOOLEAN MODE) AS m FROM dictionary WHERE MATCH(word,def) AGAINST ('asd' IN BOOLEAN MODE) ORDE

[PHP-DB] Help Needed with malfunctioning query

2006-02-25 Thread Chris Payne
Hi there everyone, This line of code USED TO WORK but now it gives me a Coudln't Execute Query error: $query2 = "SELECT word,def,photo MATCH(word,def) AGAINST ('$txtsearchword' IN BOOLEAN MODE) AS m FROM dictionary WHERE MATCH(word,def) AGAINST ('$txtsearchword' IN BOOLEAN MODE) LIMIT $offset,

Re: [PHP-DB] Help with Variable Variables in Array

2006-02-20 Thread Andrew Darby
e simpler, something like: > $tmp_fldname = $type . "_title'; > $right_row = $myrow[$tmp_fldname]; > > This should work, I haven't tested it. > > Naintara > > -Original Message- > From: Andrew Darby [mailto:[EMAIL PROTECTED] > Sent: Monday, February

RE: [PHP-DB] Help with Variable Variables in Array

2006-02-20 Thread Naintara
ailto:[EMAIL PROTECTED] Sent: Monday, February 20, 2006 10:19 PM To: php-db@lists.php.net Subject: [PHP-DB] Help with Variable Variables in Array Hi, all. I can't quite figure out how to call the contents of a variable variable in a mysql_fetch_array result and was hoping someone could help .

[PHP-DB] Help with Variable Variables in Array

2006-02-20 Thread Andrew Darby
Hi, all. I can't quite figure out how to call the contents of a variable variable in a mysql_fetch_array result and was hoping someone could help . . . inside the "fetch all rows" while loop, i have the following: $right_row = "$" . myrow . "['" . $type . "_title']"; ($type is assigned elsewher

Re: Re: [PHP-DB] Help getting php up and running

2006-02-11 Thread bungo
Is the file you are trying to save parsed php? If it is parsed, I have no Idea what your problem is, but its probably not apache-php. otherwise, Its possible, you need to add handlers in your apache conf to instruct apache to run .php files as php something like AddType application/x-httpd-ph

Re: [PHP-DB] Help getting php up and running

2006-02-11 Thread CasperLinux
Anyone have any input? I am googling till my fingers hurt and everything I find says it should be running. Whenever I try to open a test.php file all I get is the web browswer trying to save the file instead of serving up the php content. On Friday 10 February 2006 21:28, CasperLinux wrote: >

[PHP-DB] Help getting php up and running

2006-02-10 Thread CasperLinux
I run a Debian unstable system with apache 1.3 installed. I had PHP installed and running then tried to install Acid/Base for Snort. That installation did not work properly so I attempted to remove the components but then I lost php support. I removed all the PHP files and reattemtped to ins

Re: [PHP-DB] Help need please?

2006-01-24 Thread JeRRy
Hi, Thanks for this, got a few reposnses regarding this. This seems a more professional approach, I will try this and let you know about it when I do it. Thanks for your time. Jerry Ross Honniball <[EMAIL PROTECTED]> wrote: Get rid of both your onload= statements and rep

Re: [PHP-DB] Help need please?

2006-01-23 Thread Ross Honniball
Get rid of both your onload= statements and replace with... window.onload=doboth Then include the function below... function doboth() { changetext(); changead(); } Not sure what you were getting at regarding the " thing, but I think the browser must just over-ride the previous onload s

[PHP-DB] Help need please?

2006-01-22 Thread JeRRy
Hi, I know this is not PHP/MySQl related but every other board I have posted on I have not got a response, so I'll try here also. I'm missing something basic, surely here so that is another reason I am posting here.. Here goes... I have two lots of code here, one is for a refre

[PHP-DB] Help with MySQL configuration

2005-09-20 Thread Joakim Ling
Hi, I'm running MySQL 5 on a Win2K3 machine (2x3.2Ghz 4Gb RAM) Lately I experience some heavy login problems, "Can't connect to MySQL server on 'localhost' (10048)" and Service error "ERROR: 10060 - A connection attempt failed because the connected party did not properly respond after a period

Re: [PHP-DB] Help with

2005-09-02 Thread Fen Lu
Martin is right... carefully~ @ $db = new mysqli('localhost', 'root', 'password', 'database_table'); On 8/30/05, Richard Hart <[EMAIL PROTECTED]> wrote: > > Hi > > I'm new to PHP/MySQL and wondered if anyone on this list would be kind > enough to help me solve > this problem. I'm trying to autom

RE: [PHP-DB] Help with

2005-08-31 Thread Norland, Martin
e- From: Richard Hart [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 30, 2005 12:06 PM To: Bastien Koert; php-db@lists.php.net Subject: RE: [PHP-DB] Help with. . Thanks for your help Bastien. I have changed the authentication procedure but have come up against another problem. This time I

RE: [PHP-DB] Help with

2005-08-30 Thread Richard Hart
ully logged on.'; } else { echo "Your username and/or password have not been accepted. Please go back and try again."; } Thanks Richard -Original Message----- From: Bastien Koert [mailto:[EMAIL PROTECTED] Sent: 30 August 2005 00:59 To: [EMAIL PROTECTED]; php-db@lists.ph

RE: [PHP-DB] Help with

2005-08-29 Thread Bastien Koert
ccess only bastien From: "Richard Hart" <[EMAIL PROTECTED]> To: Subject: [PHP-DB] Help with Date: Mon, 29 Aug 2005 23:27:46 +0100 Hi I'm new to PHP/MySQL and wondered if anyone on this list would be kind enough to help me solve this problem. I'm trying to automati

[PHP-DB] Help with

2005-08-29 Thread Richard Hart
Hi I'm new to PHP/MySQL and wondered if anyone on this list would be kind enough to help me solve this problem. I'm trying to automatically set up a users privileges on a MySQL table using the username and password selected by them in an html form. I get the error message: "Warning: mysql_query()

RE: [PHP-DB] Help Needed

2005-07-29 Thread ReClMaples
You ROCK!!! Thanks so much, this worked perfectly!!! Thanks -Rich -Original Message- From: Alain Rivest [mailto:[EMAIL PROTECTED] Sent: Friday, July 29, 2005 10:10 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] Help Needed ReClMaples a écrit : >Sorry, the data under '

Re: [PHP-DB] Help Needed

2005-07-29 Thread Alain Rivest
ReClMaples a écrit : Sorry, the data under 'Looking something like this' should be in a table format with 3 columns and 4 rows. -Original Message- From: ReClMaples [mailto:[EMAIL PROTECTED] Sent: Friday, July 29, 2005 8:46 PM To: PHP Subject: [PHP-DB] Help Needed All, I

RE: [PHP-DB] Help Needed

2005-07-29 Thread ReClMaples
Sorry, the data under 'Looking something like this' should be in a table format with 3 columns and 4 rows. -Original Message- From: ReClMaples [mailto:[EMAIL PROTECTED] Sent: Friday, July 29, 2005 8:46 PM To: PHP Subject: [PHP-DB] Help Needed All, I know this is the wrong

[PHP-DB] Help Needed

2005-07-29 Thread ReClMaples
All, I know this is the wrong distro to be sending this request for help to but I don’t know which one to send this to. If you could either point me in the direction that I should go or help me, I would greatly appreciate it. Here is my issue. I have a set of date that I want returned in 3

Re: [PHP-DB] Help. I am losing the plot.. .

2005-07-05 Thread Bastien Koert
zend is excellent, i use editpad at work, have engisite for php (also good) phpedit, context all depends on how much you want to spend and what features you want bastien From: Ross Honniball <[EMAIL PROTECTED]> To: php-db@lists.php.net Subject: Re: [PHP-DB] Help. I am losing th

Re: [PHP-DB] Help. I am losing the plot.. (NOW good code editor)

2005-07-05 Thread Philip Hallstrom
Um. Anyone know of a good code editor? I normally use vim, but on my windows box sometimes use http://www.pnotepad.org/ when looking at log files and what not... (yes, I know there's a windows version of vim) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://ww

Re: [PHP-DB] Help. I am losing the plot.. .

2005-07-05 Thread Ross Honniball
use? Bastien From: Martin Norland <[EMAIL PROTECTED]> Reply-To: php-db@lists.php.net To: php-db@lists.php.net Subject: Re: [PHP-DB] Help. I am losing the plot... Date: Tue, 05 Jul 2005 09:41:55 -0500 Ross Honniball wrote: script1.php: echo 'script 1 before'; require_once(&

Re: [PHP-DB] Help. I am losing the plot.. .

2005-07-05 Thread Bastien Koert
Perhaps there is an encoding issue in the file(s) that the server is not recoginizing? Could you post the code you actually use? Bastien From: Martin Norland <[EMAIL PROTECTED]> Reply-To: php-db@lists.php.net To: php-db@lists.php.net Subject: Re: [PHP-DB] Help. I am losing th

Re: [PHP-DB] Help. I am losing the plot.. .

2005-07-05 Thread Martin Norland
Ross Honniball wrote: script1.php: echo 'script 1 before'; require_once('script2.php'); echo 'script 1 after'; script2.php: echo 'hello from script 2'; which in IE visually produces: script 1 beforehello from script 2script 1 after However if I view the source in IE, I get: script 1 before

[PHP-DB] Help. I am losing the plot.

2005-07-05 Thread Ross Honniball
script1.php: echo 'script 1 before'; require_once('script2.php'); echo 'script 1 after'; script2.php: echo 'hello from script 2'; which in IE visually produces: script 1 beforehello from script 2script 1 after However if I view the source in IE, I get: script 1 before?hello from script 2scr

RE: [PHP-DB] Help!!!

2005-05-19 Thread Juffermans, Jos
In the second loop you do an array_shift($entry) which should be array_shift($all). Perhaps a foreach loop would be easier: Jos -Original Message- From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED] Sent: 18 May 2005 22:47 To: php-db@lists.php.net Subject: [PHP-DB] Help

RE: [PHP-DB] Help with PHP

2005-04-25 Thread ReClMaples
I apologize but I figured out my mistake. Thanks -Rich -Original Message- From: ReClMaples [mailto:[EMAIL PROTECTED] Sent: Monday, April 25, 2005 10:05 PM To: PHP Subject: [PHP-DB] Help with PHP I'm not sure if this is the correct distro to be sending this question to, if it&

[PHP-DB] Help with PHP

2005-04-25 Thread ReClMaples
I'm not sure if this is the correct distro to be sending this question to, if it's not, let me know which one I should send it to. I am having an issue where a variable in on php file won't go to the next php file: Here is the code I am using: get colors $get_colors = "select Cat_Name from l

[PHP-DB] help wanted for install php with mysql support on windows

2005-04-23 Thread zheng
I use Apache1.3,php5.0(they work fine) and mysql 4.1(it also can work separately) . But when I interact with MySql using php,it says " Fatal error: Call to undefined function mysql_connect() ", I have uncommented php_mysql.dll inside php.ini and add D:\php to the system variable path, the libmy

RE: [PHP-DB] help wanted for install php with mysql support on windows

2005-04-22 Thread Bastien Koert
uncomment the mysqli library functions in the ini file and use those functions instead... bastien From: "zheng" <[EMAIL PROTECTED]> Reply-To: "zheng" <[EMAIL PROTECTED]> To: php-db@lists.php.net Subject: [PHP-DB] help wanted for install php with mysql support on w

[PHP-DB] Help wanted, writing to a LPT port with PHP.

2005-04-21 Thread CNFPC
Hello, I want to write a switch board in PHP. So that it is possible to write data 1 or 0 to the D0 - D7. So that It is possible to switch a relais wich I connected to the LPT port of my webserver. I could not find any examples or documentation on this theme. Could somebody help me with this proble

[PHP-DB] Help wanted, Writing to the LPT Port.

2005-04-21 Thread JB
Hello, I want to write a switch board in PHP. So that it is possible to write data 1 or 0 to the D0 - D7. So that It is possible to switch a relais wich I connected to the LPT port of my webserver. I could not find any examples or documentation on this theme. Could somebody help me with this p

Re: [PHP-DB] help query is so slow

2005-01-24 Thread Samar
Hello Ron, I guess it would really help all of us helping you in giving any real help if you post some code here. :) Regards, Samar M. = Warning: Dates in Calendar are closer than they appear. On Mon, 24 Jan 2005 23:18:33 +0800, ron <[EMAIL PROTECTED]> wrote: > > Hi All, > > What seems to be

[PHP-DB] help query is so slow

2005-01-24 Thread ron
Hi All, What seems to be the problem why my query to mysql is so slow. I'm using it for accounting, wherein I need to get the start time they login and the time they logout then compute it. to get the start time I did select * from table where blah blah and blah blah and blah; to retrieve th

Re: [PHP-DB] Help in learning PHP and MySQL

2004-12-31 Thread Novice Learner
Janet and Peter, Thank you for your help. It worked and I was able to populate the database through the next script that was in the book. I am on my way to learning PHP and MySQL. I hope it also works on my web hosting servers in a few days time. Thank you again. My New Year is starting in a

RE: [PHP-DB] Help in learning PHP and MySQL

2004-12-31 Thread Peter Lovatt
enable it, edit php.ini - find the reference to php_mysql.dll and remove the ; which comments it out ) Peter > -Original Message- > From: Novice Learner [mailto:[EMAIL PROTECTED] > Sent: 31 December 2004 03:35 > To: php-db@lists.php.net > Subject: [PHP-DB] Help in learnin

Re: [PHP-DB] Help in learning PHP and MySQL

2004-12-30 Thread Janet Valade
Novice Learner wrote: I apologize if this is a very basic question. I just started learing PHP and MySQL, I am reading "PHP and MySQL" by Larry Ullman, I also have access to PHP 5 by Julie Meloni. I reached Chapter 6 of Ullman's book and got stuck. I have the following code: //to MYSQL and s

[PHP-DB] Help in learning PHP and MySQL

2004-12-30 Thread Novice Learner
I apologize if this is a very basic question. I just started learing PHP and MySQL, I am reading "PHP and MySQL" by Larry Ullman, I also have access to PHP 5 by Julie Meloni. I reached Chapter 6 of Ullman's book and got stuck. I have the following code: I have a normal MySQL user as "mas

Re: [PHP-DB] help newbies :)

2004-12-23 Thread Jochem Maas
Nayyar Ahmed wrote: Hello All, I am developing attendence mangement system, its my first application in PHP, I want to compaire the input text box value with table records the follwing is the code _index.htm___ .. User

RE: [PHP-DB] help newbies :)

2004-12-23 Thread Bastien Koert
you have a mysql account with that particular user identification? bastien From: Nayyar Ahmed <[EMAIL PROTECTED]> Reply-To: Nayyar Ahmed <[EMAIL PROTECTED]> To: php-db@lists.php.net Subject: [PHP-DB] help newbies :) Date: Thu, 23 Dec 2004 20:54:23 +0500 Hello All, I am developin

Re: [PHP-DB] help newbies :)

2004-12-23 Thread Nayyar Ahmed
ECTED]> > >Reply-To: Nayyar Ahmed <[EMAIL PROTECTED]> > >To: php-db@lists.php.net > >Subject: [PHP-DB] help newbies :) > >Date: Thu, 23 Dec 2004 20:54:23 +0500 > > > >Hello All, > > > >I am developing attendence mangement system, its my

[PHP-DB] help newbies :)

2004-12-23 Thread Nayyar Ahmed
Hello All, I am developing attendence mangement system, its my first application in PHP, I want to compaire the input text box value with table records the follwing is the code _index.htm___ .. User Name:

Re: [PHP-DB] Help me please

2004-11-08 Thread Petrus Ali Saputra
Bastien Koert wrote: have you created a dsn for this connection? Bastien From: Petrus Ali Saputra <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: [PHP-DB] Help me please Date: Mon, 08 Nov 2004 10:55:45 +0700 Can anyone here help me how to connect to an ODBC data? Here is my code:

Re: [PHP-DB] Help me please

2004-11-08 Thread Petrus Ali Saputra
Arné klopper wrote: Have you set up a ODBC connection ? You must set up a ODBC connection in the ODBC Sources that is usually in you Control Panel or Administrator Tools. You must put it as a System DNS and set up the connection, so your local system know where to find the database. I already

RE: [PHP-DB] Help me please

2004-11-08 Thread Bastien Koert
have you created a dsn for this connection? Bastien From: Petrus Ali Saputra <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: [PHP-DB] Help me please Date: Mon, 08 Nov 2004 10:55:45 +0700 Can anyone here help me how to connect to an ODBC data? Here is my code: $odbc = odbc_connect(&q

Re: [PHP-DB] Help me please

2004-11-08 Thread Arné Klopper
Have you set up a ODBC connection ? You must set up a ODBC connection in the ODBC Sources that is usually in you Control Panel or Administrator Tools. You must put it as a System DNS and set up the connection, so your local system know where to find the database. Kind Regards Arné K

[PHP-DB] Help me please

2004-11-07 Thread Petrus Ali Saputra
Can anyone here help me how to connect to an ODBC data? Here is my code: $odbc = odbc_connect("Ta Fara","",""); And this is the result: Warning: odbc_connect(): SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in

Re: [PHP-DB] Help: Transactions working but question / issue

2004-10-15 Thread Stuart Felenstein
Here is my situation , not sure how I should handle it. I have this multi page form, at the end I use mysql transaction to get the data into all the tables. All the tables are innodb with the exception of one. The last page has one field which takes a copy/paste of a document, so it's a text area

Re: [PHP-DB] Help: Transactions not working

2004-10-15 Thread Stuart Felenstein
John, Big thank you! for your help. I had been trying out the mysql_insert_id and was not having luck. It's working great (with just a few more bumps to get over). --- John Holmes <[EMAIL PROTECTED]> wrote: > Stuart Felenstein wrote: > > > But - I want to confirm, am I still using > transacti

Re: [PHP-DB] Help: Transactions not working

2004-10-15 Thread Stuart Felenstein
That made a world of difference! :) Thank you. But - I want to confirm, am I still using transactions even though I'm issuing individual query calls for each insert. And, if I can ask another question to the list : In this line (from the second insert) VALUES (null, LAST_INSERT_ID(), ..)";

Re: [PHP-DB] Help: Transactions not working

2004-10-15 Thread John Holmes
Stuart Felenstein wrote: If you see the code I have the begin , then the $query follows. With both statements present, only the second one does the insert. If I // or remove the second, the first one takes. Am I missing something here ? Yep... you're missing a mysql_query() call for each query.

[PHP-DB] Help: Transactions not working

2004-10-15 Thread Stuart Felenstein
If you see the code I have the begin , then the $query follows. With both statements present, only the second one does the insert. If I // or remove the second, the first one takes. Am I missing something here ? Stuart Code: function begin() { mysql_query("BEGIN"); } function commit() { mysq

Re: [PHP-DB] Help: Transactions not working

2004-10-15 Thread John Holmes
Stuart Felenstein wrote: But - I want to confirm, am I still using transactions even though I'm issuing individual query calls for each insert. Yes, that's the idea. Everthing between BEGIN and COMMIT/ROLLBACK is the transaction. In this line (from the second insert) VALUES (null, LAST_INSERT_ID(

Re: [PHP-DB] Help: Arrays with Session Variables not happening

2004-10-08 Thread Stuart Felenstein
K ..my problem seems to be combining echo on the menu values with the print array. If I echo $array[0]; that seems to work fine !? Stuart --- Stuart Felenstein <[EMAIL PROTECTED]> wrote: > Back again , sorry :) > > I had my form set up with 7 multi selects , on the > return page, all 7 arrays

[PHP-DB] Help: Arrays with Session Variables not happening

2004-10-08 Thread Stuart Felenstein
Back again , sorry :) I had my form set up with 7 multi selects , on the return page, all 7 arrays were returned correctly. Now that I've changed back 5 to regular menu selects (1 selection), the 2 arrays left won't return the values. The menus work fine. Here is my code: Page 1: Page 2

RE: [PHP-DB] Help: First Time Form with Sessions

2004-10-08 Thread Stuart Felenstein
Figured it out. Page 2 had to have the field name in the $SESSION parameters, not the holder from the Page1 array register. Stuart --- Stuart Felenstein <[EMAIL PROTECTED]> wrote: > Well I guess too much success at once is a bad > thing. > > For some unapparent reason, the variables here are

RE: [PHP-DB] Help: First Time Form with Sessions

2004-10-08 Thread Stuart Felenstein
Well I guess too much success at once is a bad thing. For some unapparent reason, the variables here are not carrying over. Anyone see anything wrong here ? Page1 (Somewhat snipped) Page 2: http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";> Untitled Document Your cart:\n"; f

RE: [PHP-DB] Help: First Time Form with Sessions

2004-10-08 Thread Bastien Koert
see interspered again ;) From: Stuart Felenstein <[EMAIL PROTECTED]> To: Bastien Koert <[EMAIL PROTECTED]>, [EMAIL PROTECTED] Subject: RE: [PHP-DB] Help: First Time Form with Sessions Date: Fri, 8 Oct 2004 08:56:48 -0700 (PDT) See interspersed: --- Bastien Koert <[EMAIL PROTECTE

RE: [PHP-DB] Help: First Time Form with Sessions

2004-10-08 Thread Stuart Felenstein
> http://www.planetthoughtful.org > Building a thoughtful planet, > One quirky comment at a time. > > > -Original Message- > From: Stuart Felenstein [mailto:[EMAIL PROTECTED] > Sent: Saturday, 9 October 2004 1:57 AM > To: Bastien Koert; [EMAIL PROTECTED] > Subject: RE:

RE: [PHP-DB] Help: First Time Form with Sessions

2004-10-08 Thread Murray @ PlanetThoughtful
net, One quirky comment at a time. -Original Message- From: Stuart Felenstein [mailto:[EMAIL PROTECTED] Sent: Saturday, 9 October 2004 1:57 AM To: Bastien Koert; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Help: First Time Form with Sessions See interspersed: --- Bastien Koert <[EMAIL

Re: [PHP-DB] Help: First Time Form with Sessions

2004-10-08 Thread Matt M.
> Warning: session_start(): Cannot send session cookie - > headers already sent by (output started at > /home/lurkkcom/public_html/Multi2Return.php:2) in > /home/lurkkcom/public_html/Multi2Return.php on line 3 read a little more about sessions. session_start is trying to set a cookie but output h

RE: [PHP-DB] Help: First Time Form with Sessions

2004-10-08 Thread Stuart Felenstein
See interspersed: --- Bastien Koert <[EMAIL PROTECTED]> wrote: > Hi Stu > > 1. why not check it on every page, then if it fails > the user won't need to > make it to the end and then have to go back to the > beginning to fix > something minor. > > 2. You could use hidden fields to pass the dat

RE: [PHP-DB] Help: First Time Form with Sessions

2004-10-08 Thread Bastien Koert
hat way if you are using other session vars, you won't get confused when deciding which one holds the data that you need. hth bastien From: Stuart Felenstein <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: [PHP-DB] Help: First Time Form with Sessions Date: Fri, 8 Oct 2004 06:23:09

[PHP-DB] Help: First Time Form with Sessions

2004-10-08 Thread Stuart Felenstein
Okay , so I'm working on the multi page form. Insert into DB will come at the last page. Couple of things I want to confirm: 1-Each page should have validiation for each field. Probably doesn't make any sense to wait for last page ? or maybe ? Below is the first page of the form: I only have

RE: [PHP-DB] Help needed

2004-10-04 Thread Gary Every
ator Ingram Entertainment Inc. 2 Ingram Blvd, La Vergne, TN 37089 "Pay It Forward!" -Original Message- From: Manoj Japher [mailto:[EMAIL PROTECTED] Sent: Monday, October 04, 2004 9:29 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Help needed hi, I am new to PHP and I am not sure

[PHP-DB] Help needed

2004-10-04 Thread Manoj Japher
hi, I am new to PHP and I am not sure if this is the right forum. I am trying to run PHP thro webmin using CGI scripts. PHP runs fine except that when I am trying to read variables coming thro' a form after hitting the submit button, I get NULL values. I can read and write to the database wi

Re: [PHP-DB] Help please, back to an error

2004-09-14 Thread Stuart Felenstein
Micah, Your right! I regretted this post after I hit send. The code generator is actually okay. I'm learning more about PHP, and what the code actually means, in the event it needs to be modded / edited. Sorry again for the post and thanks for the reply! Stuart --- Micah Stevens <[EMAIL PROTECTE

Re: [PHP-DB] Help please, back to an error

2004-09-14 Thread Micah Stevens
I'm thinking you should either get a better code generator, or learn more about php.. :) -Micah On Monday 13 September 2004 02:49 pm, Stuart Felenstein wrote: > Thanks to help here I was able to overcome some ivalid > query errors. > > Now I'm back, (probably the same mistake) > > It's coming

[PHP-DB] Help please, back to an error

2004-09-13 Thread Stuart Felenstein
Thanks to help here I was able to overcome some ivalid query errors. Now I'm back, (probably the same mistake) It's coming off of this line: $sql .= " And PostStart >= DATE_SUB(CurDate(), Interval ['search_fd1'] day )"; The 'search_fd1' is one of the form fields where a list of val

Re: [PHP-DB] Help, i'm really desperated

2004-08-25 Thread eoghan
This is my favourite. How can i execute this query: $myresult2 = pg_query($pgsql_conn, "SELECT url_negado from urls_negados > /tmp/urls_negados.txt"); from inside a PHP file as user postgres ? cant you do this...? select url_negado into outfile '/tmp/urls_negados.txt' from urls_negados -- PHP D

Re: [PHP-DB] Help, i'm really desperated

2004-08-25 Thread Mário Gamito
Hi Peter, Thank you for your answer. php runs as the same user as apache. Depending on any other security/system issues you could set apache to run as postgres. Unfortunately, i can't. There's too much variables involved :( Otherwise why not connect to postgres using the php functions and write

RE: [PHP-DB] Help, i'm really desperated

2004-08-25 Thread Peter Lovatt
nal Message- > From: Mário Gamito [mailto:[EMAIL PROTECTED] > Sent: 25 August 2004 11:09 > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Help, i'm really desperated > > > Hi, > > I need to run this command inside a PHP (web) script, in order to > produce a

[PHP-DB] Help, i'm really desperated

2004-08-25 Thread Mário Gamito
Hi, I need to run this command inside a PHP (web) script, in order to produce an acl list (url_negados.txt) for squid: /usr/bin/psql -t knet -c "SELECT url_negado from urls_negados" > /tmp/urls_negados.txt I'm using shell_exec to run it. Well, so far, so good. The problem is that i must run thi

Re: [PHP-DB] Help! WINXP/Apache2.0/PHP4.3.8 - Can't run PHP

2004-08-20 Thread Peter Ellis
This isn't really a database question, so I'm not sure why it went to a database-related list. Have you checked your Apache configuration to make sure it's set to handle the PHP extensions? Check the PHP manual on how to set this (I believe relevant instructions are under Installation). -- Peter

[PHP-DB] Help! WINXP/Apache2.0/PHP4.3.8 - Can't run PHP

2004-08-20 Thread Bestman4unowwa
When I have a html page with an embedded php method behind a button, when I click the button I can't run the PHP, instead my browser pops up a dialog box with a request a file download of my PHP script. Also, when I run a php in my browser either nothing happens or I get the file load. -- PHP

<    1   2   3   4   5   6   7   >