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
t
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:
>
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 PROTECTE
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 th
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 ld.so.
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)
> >
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") ;
>
i don't doubt that there are probably better ways of going about this chris,
but you can do something like;
as for ranking the results - i have heard people mentioning the fulltext
index in mysql, and there's some cool calculations floating around in the
archives somewhere, but they escape me a
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
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,
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
also - rather than change the ini file, you can just put
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
// -Original Message-
//
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 advance
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: Monday,
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 Ler
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
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.
$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
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 sear
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
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 c
Barry,
Before leaping to the wrong conclusion, what exactly do you want to count?
You can derive the number of times a page has been fetched from your web logs.
Alternately, you could add a table to your database, and at the top of the
page the link points to, after you've established your da
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 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
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
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 ha
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
Try DBTools from www.dbtools.com.br I use it religiously next to the
command line. Probably the best management tool I've ever seen.
Ryan
-Original Message-
From: Howard Picken [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 16, 2002 08:54 AM
To: [EMAIL PROTECTED]
Subject: RE: [PH
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
> connection
It's probably correct to day that Date, along with Codd, is the other
father of relational database theory. The book will be solid, and probably
pretty abstruse in places. These two books I've found really helpful:
The Practical SQL Handbook, by Bowman, Emerson and Darnovsky is very good
and
> 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 (i
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 http://www.openlinks
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
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-
From:
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 know
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: [EMAIL
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
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
\n";
echo "user_i
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.
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
--
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 mistak
=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
43 matches
Mail list logo
