Re: [PHP-DB] Logicproblem in WHERE statement

2002-01-16 Thread DL Neil
=An alternative approach:- I am building a user search engine. Now I do not know how to gett following: a mandatory field and a voluntary field For example I would like to get all female users and those who are from canada. The results should show all users who are female

Re: [PHP-DB] sorting on the first 8 digits....

2002-01-16 Thread DL Neil
John, Ok, I did something stupid and now I am paying the price... =boy am I glad that I'm not the only one in the world! How come the 'people' who extract these prices don't accept Mastercard? In an internal database that tracks the time and date something happens on our site, I

[PHP-DB] mySQL administration on Linux through NT

2002-01-16 Thread Jerry
Hi, I have mySQL on LINUX Does anybody knows a windows software to manage mySQL through win2k (TCP/IP - Intranet) ? With mySQL on win2k, you can manage it using a windows interface. I'm looking for the same kind of interface to manage mySQL on a Linux platform from win2k. Thanks. Jerry

[PHP-DB] select into array

2002-01-16 Thread George Lioumis
Hello everyone! I have the following table: |name |-- |n_id |n_name |ns_id --- I do a select: SELECT n_name from name and I want to put all selected n_name values into an array (say it names) How can this be done?? Thanx in advance.

Re: [PHP-DB] select into array

2002-01-16 Thread Miles Thompson
George, Whether you can select into an array directly depends on your database. In any case, PHP executes database queries and returns a handle or container which is accessed as an array. Here's the example from http://www.php.ca/manual/en/function.mysql-fetch-array.php ?php

Re: [PHP-DB] mySQL administration on Linux through NT

2002-01-16 Thread Miles Thompson
Jerry, For a command line interface, you can use either putty or TerraTermSSH. I prefer the former and it's available at http://www.chiark.greenend.org.uk/~sgtatham/putty/ . The latter is more Windows-ish. For a Windows-like interface, through a browser, there is phpMyAdmin, and others, but

RE: [PHP-DB] mySQL administration on Linux through NT

2002-01-16 Thread Howard Picken
If you're running a web server on your Linux box then simply download, install and use phpMyAdmin. All your management is then down through web pages. I use it all the time. HP -Original Message- From: Jerry [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 16 January 2002 10:48 PM To:

RE: [PHP-DB] How can recommend a book for SQL and DB design

2002-01-16 Thread Leotta, Natalie (NCI/IMS)
I'm a recent student but I sold back my DB text in hopes I'd never have to know the stuff again (I guess that $20 wasn't worth it). The current book my old prof is using is: Introduction to Database Systems, 7th Edition by C.J. Date. but since I don't know if that's the one I used I don't

RE: [PHP-DB] How can recommend a book for SQL and DB design

2002-01-16 Thread matt stewart
finished University nearly two years ago, but back then, this book was the one we used too - very in depth introduction to general database theory, well worth investing in if you need very well designed databases for large volume applications. all the best, Matt -Original Message-

RE: [PHP-DB] FreeBSD 4.2 and ODBC

2002-01-16 Thread Andrew Hill
Paul, Sure, email away. I'd hazard a guess that your syntax errors were due to not matching the threading of your OS. And I recommend the OpenLink Multi-Tier ODBC drivers, from your architecture needs. They are available for a free download at http://www.openlinksw.com/main/softdld.htm. Best

RE: [PHP-DB] How can recommend a book for SQL and DB design

2002-01-16 Thread Andrew Hill
Matt, The forthcoming Wrox book Professional PHP4 covers database normalization, database design, etc., as well as specific PHP, and designs a sample application so you can put it into practice. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software

[PHP-DB] Authentication

2002-01-16 Thread Adam Royle
I have a successful website with authenticatin and logons. There are sections that I allow anyone to get to, but the others have to be authenticated. This site is not using frames at all. its a page by page, with the unit that does the authentication and sessions being included in

[PHP-DB] Re: [PHP] mysql_insert_id?

2002-01-16 Thread Martin Wickman
Dl Neil wrote: 2 because the (function argument) controlling feature is the connection, it is not possible for another concurrent user to 'steal' your ID or influence the ID returned to you - it's all yours! Ok, assume you are correct, but what if you are using persistent connections (ie

RE: [PHP-DB] Re: Moving from MySQL to MSSQL Server 2000

2002-01-16 Thread Frank Flynn
There are few things you should consider; perhaps you already have. You may not be replacing the OS of your Web server but you will be adding a new OS for the database since MS SQL only runs on Windows. So now your site will have a Solaris / Apache piece and Windows cluster running MS SQL. I

[PHP-DB] MSSQL - PHP4 on Win 2K - will not run a query.

2002-01-16 Thread Frank Flynn
Hello all, I'm having a problem getting PHP to run a query against a MSSQL 7 database. I have installed PHP, the MSSQL client tools and the php_mssql.dll all according to the documentation. PHP will connect to the database just fine. But if I send the query to execute it will never return, no

[PHP-DB] Count

2002-01-16 Thread Barry Rumsey
How do you add a count feature to a link. I can get stuff from the db but want to know how many times it's been read or click on?

Re: [PHP-DB] Re: [PHP] mysql_insert_id?

2002-01-16 Thread DL Neil
Hi Martin, 2 because the (function argument) controlling feature is the connection, it is not possible for another concurrent user to 'steal' your ID or influence the ID returned to you - it's all yours! Ok, assume you are correct, but what if you are using persistent connections (ie

[PHP-DB] Re: [PHP] mysql_insert_id?

2002-01-16 Thread DL Neil
Hi Jimmy, 2 because the (function argument) controlling feature is the connection, it is not possible for another concurrent user to 'steal' your ID or influence the ID returned to you - it's all Ok, assume you are correct, but what if you are using persistent connections (ie

[PHP-DB] Re: [PHP] mysql_insert_id?

2002-01-16 Thread DL Neil
Hi Jimmy, the only problem i can think of might occur with pconnect is, last_insert_id() will return you the last inserted ID from previous 'session', not current 'session'. to prevent this, you should call last_insert_id() only when your INSERT query executed succesfully. =Of course

Re: [PHP-DB] Count

2002-01-16 Thread Miles Thompson
Afterthought -- you could make this self-maintaining by doing a select for $PHP_SELF and inserting the record if mysql_num_rows() returned 0. Downside is that it would add greatly to the overhead. Miles At 04:42 PM 1/16/2002 -0400, Miles Thompson wrote: Barry, Before leaping to the wrong

[PHP-DB] Unique Results?

2002-01-16 Thread Chris Payne
Hi there everyone, (Sorry if you got this twice, I don't think my mail server posted it earlier). I use the following code to populate a dropdown box from a MySQL database: $db = mysql_connect(localhost,^^^,^^^); mysql_select_db(mydb,$db); $result = mysql_query(select country from search); if

Re: [PHP-DB] Unique Results?

2002-01-16 Thread Janet Valade
$result = mysql_query(select distinct country from search); Janet - Original Message - From: Chris Payne [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 1:29 PM Subject: [PHP-DB] Unique Results? Hi there everyone, (Sorry if you got this twice, I don't think

[PHP-DB] Re: Logicproblem in WHERE statement

2002-01-16 Thread Jaime A. Chavarriaga L.
Andy == relevance ?? ... or define a calculated field for these relevance... and order the results by this value... SELECT (sex = 1 AND country = 'CA') AS relevance, sex, country FROM table WHERE sex = 1 ORDER BY 1 DESC ... note the relevance includes all the fields... and the

Re: [PHP-DB] Logicproblem in WHERE statement

2002-01-16 Thread Jaime A. Chavarriaga L.
Jason SELECT * FROM TABLE WHERE sex = 1 OR country = 'CA'; Will select all users who are female as well as all users from Canada. You may get duplicate records (for people who are female and from Canada) so you may want to use DISTINCT as well. ok... you are right... but this error

[PHP-DB] Re: [PHP] mysql_insert_id?

2002-01-16 Thread DL Neil
Jimmy, However it is also possible that in order to save time the LAST_ID information is built into the resultset coming back from the INSERT - thus when mysql_insert_id() is called PHP would not need to go back to MySQL/last_insert_id(). yes, what you said could be true also. Well,

RE: [PHP-DB] Combining INSERT...SELECT and INSERT INTO

2002-01-16 Thread Beau Lebens
if you are using mysql then no i don't think you can do that, since it doesn't support nested queries - postgres or some other db may well support it tho but like miles said - give it a go :) (maybe on a test database/table just in case) hth -b // -Original Message- // From: Markus

RE: [PHP-DB] What is REG_BADRPT, and why do I get it?

2002-01-16 Thread Beau Lebens
on a guess - echo the value of $search_name in between each call to see what happens to it as it goes through - you may find that something is going haywire in there somewhere (or that it's blank) -b // -Original Message- // From: Markus Lervik [mailto:[EMAIL PROTECTED]] // Sent:

[PHP-DB] PHP-informix-Apache undefined symbol

2002-01-16 Thread Fernando Carter
Hi , I compile PHP --with-informix=yes and everithing went ok , until I restarted apache I got the following error. Cannot Load /etc/httpd/modules/libphp4.so into server /opt/informix/lib/esql/libifgen.so undifines symbol: stat Please Help ! What I'm I doing wrong? Many Thanks in

RE: [PHP-DB] Problem with mail function

2002-01-16 Thread Beau Lebens
also - rather than change the ini file, you can just put ?php set_time_limit(43200); ? which gives the script 12 hours to run (or however you think you need) i have a simple script for mailing out bulk mail done in php - it has successfully worked on 700 emails so far - so it works :) -b //

Re: [PHP-DB] A weird images database/web page problem

2002-01-16 Thread chip
Let's tackle the first one first - On Tuesday 15 January 2002 10:20 pm, Steven Cayford banged out on the keys: On 2002.01.15 23:30:25 -0600 chip wrote: won't work) ? $new_pic=$pic+12; Is $pic already set by the HTTP_GET_VARS here? I don't know. How do I set this? I was reading the

RE: [PHP-DB] Optimizing mail()

2002-01-16 Thread Beau Lebens
hey olinux - i did something like this with a mailing list thing i have for a website (insertfashionhere.com - about to be relaunched) and all i did was ordered the emails to be sent by their server - as you have said. mine were in a database, so in my select i did something liek SELECT email,

[PHP-DB] Searching a variable

2002-01-16 Thread Chris Payne
Hi there everyone, Thanks for all the help recently everyone, it's very appreciated. I just have one last question if that's ok :-) I have a string taken from a form, now this string could contain 1 word or it would contain 10, what I need to know is how do I search a DB for each word in the

RE: [PHP-DB] Searching a variable

2002-01-16 Thread Beau Lebens
i don't doubt that there are probably better ways of going about this chris, but you can do something like; ?php $words = explode( , $searchText); $query = SELECT * FROM table WHERE ; foreach ($words as $word) { $query .= field LIKE '%word%' AND ; } $query .= field!='' ORDER BY

Re: [PHP-DB] Re: Redirecting to a new page

2002-01-16 Thread Pete Lacey
And while 'gurix' is correct, the function you're probably looking for is 'header()', as in header(Location: admin.php); Cheers Pete Php wrote: hea a better way is to include your admin pages. if ($myrow[Admin] == Y){ include(admin.php); }else{ include(user.php) ; } so you

Re: [PHP-DB] Logicproblem in WHERE statement

2002-01-16 Thread Jason Wong
On Thursday 17 January 2002 06:27, Jaime A. Chavarriaga L. wrote: Jason SELECT * FROM TABLE WHERE sex = 1 OR country = 'CA'; Will select all users who are female as well as all users from Canada. You may get duplicate records (for people who are female and from Canada) so you

Re: [PHP-DB] PHP-informix-Apache undefined symbol

2002-01-16 Thread Miles Thompson
Fernando, First of all, where is libphp4.so located? You may have to copy it into that directory. On my system it's in /path/to/apache/libexec. Try that and see if apache will start. If the libphp4.so error is gone, but the other remains, try this. In your /etc directory is a file named

Re: [PHP-DB] A weird images database/web page problem

2002-01-16 Thread Steven Cayford
On 2002.01.16 19:59:37 -0600 chip wrote: Let's tackle the first one first - OK. On Tuesday 15 January 2002 10:20 pm, Steven Cayford banged out on the keys: On 2002.01.15 23:30:25 -0600 chip wrote: won't work) ? $new_pic=$pic+12; Is $pic already set by the HTTP_GET_VARS

[PHP-DB] Re: Session and authentication questions in frames

2002-01-16 Thread TJayBelt
I realized that I was not doing a page_close(); In the other site, there is a footer that all pages use, that automatically does this for me. I just forgot it. It had nothing to do with frames. Just a dumb thing that I forgot. Tjaybelt [EMAIL PROTECTED] wrote in message [EMAIL

Re: [PHP-DB] A weird images database/web page problem

2002-01-16 Thread chip
On Wednesday 16 January 2002 08:57 pm, Steven Cayford banged out on the keys: On 2002.01.16 19:59:37 -0600 chip wrote: Let's tackle the first one first - OK. On Tuesday 15 January 2002 10:20 pm, Steven Cayford banged out on the keys: On 2002.01.15 23:30:25 -0600 chip wrote: won't

[PHP-DB] phplib authentication questions

2002-01-16 Thread TJayBelt
I use phplib's session management and authentication. Adding my own info into it where necessary. So, it does ask to login when appropriate. However, every once in a while, I get errors in insert. Its an error in the table with a duplicate entry. Its trying to insert a record that is already