RE: [PHP-DB] Authenticating through a php script

2003-01-10 Thread Maureen Roihl
One reason you might be having difficulty is if the remote host does the basic authentication procedure of checking that the username/password is being submitted from a specific host or script (in which case it will see that you're attempting to submit the information from somewhere else and

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

2003-01-10 Thread Jack Schroeder
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

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

2003-01-10 Thread Jeremy Wood
http://www7b.software.ibm.com/dmdd/library/techarticle/scott/0614_scott.html is a good place to start. Also search google for db2 php...i got a lot of hits...Sorry if anyone get this msg twice. :) Jeremy - Original Message - From: Jack Schroeder [EMAIL PROTECTED] To: [EMAIL PROTECTED]

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

2003-01-10 Thread Jeremy Wood
Here's a a site that has the basics. I got a whole lot of matches with db2 php at google. Jeremy - Original Message - From: Jack Schroeder [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 10, 2003 8:54 AM Subject: [PHP-DB] Will PHP work with IBM DB2 dbms? Can anyone

RE: [PHP-DB] Design suggestions - performance improvement

2003-01-10 Thread Matthew Moldvan
What does your SQL look like? I would say make sure you use UNIQUE if that doesn't mess up your implementation ... also, some code snippets would help if you need assistance. Regards, Matthew Moldvan --- System Administrator Trilogy International, Inc

RE: [PHP-DB] Authenticating through a php script

2003-01-10 Thread Matthew Moldvan
Sorry if this was already answered ... I think what Dave intends to do is give your students some kind of authentication (you can use a generic account), then have PHP connect to the database without the student ever seeing the login information (besides the script that is doing the basic

RE: [PHP-DB] which DBMS... MySQL or PostgreSQL

2003-01-10 Thread Matthew Moldvan
Why not direct your energy to an existing project? No sense in reinventing the wheel ... http://phprpg.org/. BTW, they are using MySQL, and it is open source. Regards, Matthew Moldvan --- System Administrator Trilogy International, Inc

RE: [PHP-DB] Stumped...

2003-01-10 Thread Matthew Moldvan
Out of curiosity, what was the solution? It's always good to learn from someone else's mistakes ... :) Regards, Matthew Moldvan --- System Administrator Trilogy International, Inc http://www.trilogyintl.com/ecommerce/

RE: [PHP-DB] Examine button

2003-01-10 Thread Matthew Moldvan
Oh I see ... you need to use the input type=file HTML tag within a form that points to a PHP Script. Now depending on what you want to do with the file, that will have to be done by your PHP code. www.google.com, search for: HTML input tag file Regards, Matthew Moldvan

[PHP-DB] PHP and mySQL help!

2003-01-10 Thread Dzung Nguyen
Hi! I have a PHP page with a few text areas where users can enter different combination of fields to query a mySQL database. An example of a query would be like this: $query = SELECT build_ids.build_id, build_ids.username, build_ids.host, build_ids.configuration,

[PHP-DB] QUERY question (group by) - please help

2003-01-10 Thread Damir Dezeljin
Hi. Maybe this isn't the correct list for asking the below question (if so sorry ;) ). I want to calculate how many rows my MySQL query which uses 'GROUP BY' returns. The query: SELECT something FROM test WHERE (kid=1) OR (kid=2) OR (kid=4) GROUP BY cid,aid; Is it posible

RE: [PHP-DB] PHP and mySQL help!

2003-01-10 Thread John W. Holmes
Are you sure $date and $host have a value? Is register globals on or off? Echo your query to the screen before you execute it to make sure it's what you think it is. ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/

Re: [PHP-DB] PHP and mySQL help!

2003-01-10 Thread Dzung Nguyen
Thanks for the quick reply! Perhaps I should describe my problem more specifically so that u could have a better idea: The code on PHP page to create forms for users to input field names: $tempdate = $date ; $tempselect = $select ; echo font size=$fontsize-1Choose datebr/font form

RE: [PHP-DB] PHP and mySQL help!

2003-01-10 Thread Hutchins, Richard
If you update $date and nothing else on the page, are any of the other values in the URL (HREF) set? You have two separate forms. $date is in one and $host is in the other. However, all of the other variables in your URL (HREF) are from the second form where $host is. My guess is that since you

RE: [PHP-DB] QUERY question (group by) - please help

2003-01-10 Thread Hutchins, Richard
Just a side note in case it's important, mysql_num_rows() is a PHP function, not a native MySQL function. Not being nitpicky, but it might be relevant if, for some reason, Damir cannot use PHP to obtain the number of rows. From the tone of the original post, it seems that might be a possibility.

[PHP-DB] How to copy databases?

2003-01-10 Thread Frank Peavy
If I have a database x with populated tables and I would like to copy it to another empty database for Testing purposes, how is that done through phpMyAdmin? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] QUERY question (group by) - please help

2003-01-10 Thread Matthew Moldvan
Well, I just assumed he was using PHP since this is a PHP list ... :) Otherwise, he'd have to use SELECT count(something) FROM ... Regards, Matthew Moldvan --- System Administrator Trilogy International, Inc http://www.trilogyintl.com/ecommerce/

RE: [PHP-DB] How to copy databases?

2003-01-10 Thread Matthew Moldvan
Choose the database from the list on the left, then do a dump of the database by selecting Structure and Data. Then, create the new database and use the INSERT that was generated by your dump. Regards, Matthew Moldvan --- System Administrator Trilogy

[PHP-DB] HTML tags in auth.php script

2003-01-10 Thread narendra . talele
PHP 4.2.3 APACHE 1.3.27 Windows 2K Hello every one. I am still learning how PHP works. Can some one answer this for me please. This piece of code here works fine ONLY without the HTML tags (The first line and the last lines in the code). The moment I add these lines I get the following

Re: [PHP-DB] HTML tags in auth.php script

2003-01-10 Thread 1LT John W. Holmes
Hello every one. I am still learning how PHP works. Can some one answer this for me please. This piece of code here works fine ONLY without the HTML tags (The first line and the last lines in the code). The moment I add these lines I get the following error: (By the way I don't get these

Re: [PHP-DB] HTML tags in auth.php script

2003-01-10 Thread narendra . talele
ThX John...One other question. I have an images folder and other 25 sub-folders underneath this folder. Each of this sub-folder is a web album with it own default index.html and thumbnails pics in it. My question is : Is there an easy way of having a folder level access control to the IMAGES

[PHP-DB] Re: mysql_errno() list?

2003-01-10 Thread Adam Royle
Just use a combination of mysql_errno() and mysql_error(): echo mysql_errno() . : . mysql_error(). \n; Adam PS. Documentation always rocks! Hi guys, I've been playing with PHP for a while now, and love the mysql functions, but there's one thing I'd like to know... I want to check if a

Re: [PHP-DB] HTML tags in auth.php script

2003-01-10 Thread Steve Cayford
Check out the auto_prepend configuration option here: http://www.php.net/manual/en/configuration.directives.php I believe you can do this on a per-directory basis, but haven't tried it. -Steve On Friday, January 10, 2003, at 02:56 PM, [EMAIL PROTECTED] wrote: ThX John...One other

[PHP-DB] guestbook to db to email

2003-01-10 Thread Bruce Levick
Bruce Levick - Vivamotion Hi, I am going to build some form elements to use as submitting to a DB for a guestbook. Then display those inputs on another page as the entries to the guestbook. I also want to send the information they submit to an email address. I know how to manage sending simple

RE: [PHP-DB] guestbook to db to email

2003-01-10 Thread John W. Holmes
I am going to build some form elements to use as submitting to a DB for a guestbook. Then display those inputs on another page as the entries to the guestbook. I also want to send the information they submit to an email address. I know how to manage sending simple form elements to an email

RE: [PHP-DB] Session on PHP with MySQL

2003-01-10 Thread John W. Holmes
I have some confusing about my script, this is story I have login page, and then the user got current page with various menu, but when user click one of menu, its has error mesage, here my script [snip] do I have mistake with my script, pls give me solution thanks all for yr help

[PHP-DB] Session on PHP with MySQL

2003-01-10 Thread Afif
Dear all, I have some confusing about my script, this is story I have login page, and then the user got current page with various menu, but when user click one of menu, its has error mesage, here my script html p align = center ? //require setup.php; require common.php; include setup.php;

[PHP-DB] Re: QUERY question (group by) - please help

2003-01-10 Thread Martin Ramsch
Damir Dezeljin [EMAIL PROTECTED] wrote: I want to calculate how many rows my MySQL query [...] returns. For the C API see http://www.mysql.com/doc/en/mysql_affected_rows.html http://www.mysql.com/doc/en/mysql_num_rows.html The MySQL interface in every other language should have similar

[PHP-DB] Re: QUERY question (group by) - please help

2003-01-10 Thread Martin Ramsch
I wrote: For the C API see http://www.mysql.com/doc/en/mysql_affected_rows.html http://www.mysql.com/doc/en/mysql_num_rows.html The MySQL interface in every other language should have similar functions available ... Ups, I _am_ in a PHP list/newgroup, so the more specific answer is, of