[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 i

[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 f

[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 User ID atau Password yang anda masukkan tidak benar "; } else { echo " W

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 h

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

[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 fo

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 question

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

2003-01-10 Thread John W. Holmes
You'll have to put something in each of the files you want to protect. It usually better to use an include() call to the same auth.php file for each of the files you want to protect. If you're looking to protect your .jpg or whatever image files, you can't unless they are outside of the web root o

[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 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"

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 ge

[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 err

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 I

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() FROM ... Regards, Matthew Moldvan --- System Administrator Trilogy International, Inc http://www.trilogyintl.com/ecommerce/

[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 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. >

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

2003-01-10 Thread Matthew Moldvan
Try mysql_num_rows() ... http://www.php.net/manual/en/function.mysql-num-rows.php for the documentation. Regards, Matthew Moldvan --- System Administrator Trilogy International, Inc http://www.trilogyintl.com/ecommerce/ --

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 ha

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 "Choose date

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/ > ---

[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 FROM test WHERE (kid=1) OR (kid=2) OR (kid=4) GROUP BY cid,aid; Is it posible to get nu

[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, build_ids

RE: [PHP-DB] Examine button

2003-01-10 Thread Matthew Moldvan
Oh I see ... you need to use the http://www.trilogyintl.com/ecommerce/ --- -Original Message- From: Sabina Alejandr Schneider [mailto:[EMAIL PROTECTED]] Sent: Friday, January 10, 2003 11:54 AM To: Matthew Moldvan Subject: Re: [PHP-DB] Examine button He

RE: [PHP-DB] Stumped...

2003-01-10 Thread NIPP, SCOTT V (SBCSI)
The source of my problem is that in my INSERT statement I was trying to enter a new row of data and not having data for every column. Basically, my table had 7 columns but in my INSERT I only had 5 columns of data to be put in. -Original Message- From: Matthew Moldvan [mailto:[E

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] 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 http://www.trilo

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 authenti

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 ht

RE: [PHP-DB] Examine button

2003-01-10 Thread Matthew Moldvan
Sounds like maybe he/she wants to print a directory listing and save it in a database ... ? As good of a guess as I could figure ... =P Regards, Matthew Moldvan --- System Administrator Trilogy International, Inc http://www.trilogyintl.com/ecommerce/ ---

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

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]

[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

[PHP-DB] RE: [mysql - php] Newline to BR problem

2003-01-10 Thread Maureen Roihl
It depends on how else you're going to use the info. If you're positive you're only ever going to display it on a webpage, you could go ahead and convert it before you insert the data. However, if you might want to use it for something else (include in an email, a report, whatever), it might be si

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 won't

[PHP-DB] mysql_errno() list?

2003-01-10 Thread James Booker
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 mysql error is a certain number, and thats all fair enough because every time i encounter an error I can write down what that error was. However, it