=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
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
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
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.
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
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
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:
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
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-
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
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
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
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
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
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
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?
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
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
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
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
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
$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
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
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
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,
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
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:
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
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
//
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
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,
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
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
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
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
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
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
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
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
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
40 matches
Mail list logo