Hello,
Finally I made time to put a new Metabase release together celebrating
the 2nd aniversary since its first public release which is also the 3rd
aniversary since I started developing it.
For this release I added new features that either were requested or
contributed:
- Query result bulk da
On Tuesday 22 January 2002 13:18, Sommai Fongnamthip wrote:
> Hi,
> I have problem with these mysql's query:
>
> select * from holder, management where holder.id=management.id or
> (holder.name=management.name and holder.surname=management.surname) order
> by holder.no
>
> It ta
Hi,
I have problem with these mysql's query:
select * from holder, management where holder.id=management.id or
(holder.name=management.name and holder.surname=management.surname) order
by holder.no
It take a long time (more than 1 minute) with thousand record. I have
Technically, you should have a list of saved orders associated with a
customer ID. You should be able to search the saved orders for all customer
IDs that purchased the current product ID. Then, generate a giant list of
all products that all those customer IDs purchased, and compile them into a
bi
I am trying to figure a simple way of creating a
script for a news site to recommend articles that are
similar [i.e. about the same company]
Two examples are:
http://www.theroyalgazette.com/apps/pbcs.dll/artikkel?Avis=RG&Dato=20011218&Kategori=BUSINESS&Lopenr=112180020&Ref=AR
(See the "Linked A
A few things to check:
1. You have a connection to the database (I'm assuming you do).
2. mysql_query() is a php function so you should not put a dollar sign
before it (indicating it is a variable. If you want mysql_query() to return
a variable, do something like this: $result = mysql_query("UPDA
Hi
I use
$sessionID = md5(uniqid(rand()));
setcookie (sessionID , $sessionID ,0 , "" , "" ,0);
which works
hth
Peter
> -Original Message-
> From: jas [mailto:[EMAIL PROTECTED]]
> Sent: 22 January 2002 06:51
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] tracking users...
>
>
> I am fai
Post up some code and somebody will help :) Joe
James Kupernik <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I'm creating this form where the person needs to enter a password to move
> on. When they enter the password it just loops back to enter the passwor
Hi there, you could use the SUM function in your sql statement...like "SELECT
SUM(count_view) FROM TABLENAME";
Hope this helps :) Joe
Barry Rumsey <[EMAIL PROTECTED]> wrote in message
3C4C4D15.0A.00872@weiz-main">news:3C4C4D15.0A.00872@weiz-main...
In one of my tables I hav
What's up guys? I was wondering if any of you knew of a stats package written in PHP4
and MySQL that has the same tracking features and reports as WebTrends and is free for
download.
Any suggestions would be kosher
--
___
Sign-up for your own F
By what do you mean code should be readable ?
=look at the code you've quoted below. Is it easy to read - can you even easily
distinguish where one
instruction ends and another begins?
=does it work now?
=what does the .cx TLD have to do with Kiwi Xtra?
=dn
---Original Message---
Fr
jas:
> - Original Message -
> From: "jas" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, January 21, 2002 10:50 PM
> Subject: [PHP-DB] tracking users...
> I am fairly new to PHP and have setup a site that connects to a MySQL db
to
> store different information from our u
Hi,
I'd like to use iODBC in mod_php (Apache DSO) on linux to access an
Access database running on a Windows box elsewhere. I'm using an RPM of
mod_php. Is it possible to compile the iODBC support as a PHP module
without having to recompile mod_php? If so, how? Does iODBC have to be
compiled
Tables should be opened and closed
- and (please) code should be readable!
=dn
- Original Message -
From: Barry Rumsey
To: [EMAIL PROTECTED]
Sent: 21 January 2002 17:54
Subject: [PHP-DB] theme header query
I'm trying toadd thefollowing codeto atheme:
."\n"
I am fairly new to PHP and have setup a site that connects to a MySQL db to
store different information from our users, however what I would like to
setup is something that I could place on a few pages to track users for
demographic purposes. What I need to do is as a page is visited I need to
ge
Quoting from the MySQL manual:
In MySQL Version 3.23, you can use LIMIT # to ensure that only a given
number of rows are changed.
So then, it's LIMIT # instead of LIMIT #,#
Obviously, the way around it would be using WHERE instead of LIMIT, but
I don't know your table structure so I can't provid
Looks like LIMIT can only contain one number, when using UPATE the offset
parameter cannot be added.
http://www.mysql.com/doc/U/P/UPDATE.html
UPDATE [LOW_PRIORITY] [IGNORE] tbl_name
SET col_name1=expr1, [col_name2=expr2, ...]
[WHERE where_definition]
[LIMIT #]
So . . .
"UPDATE catal
I'm trying toadd thefollowing codeto atheme:
."\n"
."$sqlhostname = "localhost"; $login =
""; $password = ""; $base = "xplyrics"; $db_connect =
mysql_connect($sqlhostname,$login,$password); $base_selection =
mysql_select_db($base,$db_con
In one of my tables I have a field called count_view, How do I add
all the totals up to come up with one grand total of
views.
IncrediMail - Email has finally evolved -
Click
Here
when I try to do the update with a limit on which records, it gives me a
sytax error on the limit, is there anyway to get around this?
UPDATE catalogs SET PROCESSED = 'Y' LIMIT $i,10
thanks
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For addit
http://www.mysql.com/doc/U/P/UPDATE.html
UPDATE catalogs SET PROCESSED = "Y" WHERE PROCESSED IS NULL LIMIT $i,10
Is this what you are looking for?
Robert V. Zwink
http://www.zwink.net/daid.php
-Original Message-
From: James Kupernik [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 21,
Is it possible to select 10 records that have a NULL field and update that
field to become Y instead of NULL? If so what would this syntax be?
This is what I have now
$result = mysql_query("SELECT * FROM catalogs WHERE PROCESSED IS NULL LIMIT
$i,10");
I want to add an UPdate to it, but not sure
On Tuesday 22 January 2002 22:35, Johannes Hiemer wrote:
First of all, please keep the discussion on the list!
> >What did you want it to do?
>
> I want it to do things like inserting into Mysql-dbs
> Fetching arrays. Just every Mysql-command which
> Is also suported in PHP.
> What is it doing n
On Tuesday 15 January 2002 16:04, you wrote:
> On 1/14/2002 12:54 PM +0200 Markus Lervik wrote:
> > Is there any way to combine INSERT...SELECT and INSERT INTO so
> > one could insert a new row with a few values inserted by hand and
> > others from another table? something like
> >
> > INSERT INT
Hi Chris,
Can anyone see what is wrong with this query? I am trying to update some fields, if I
do an echo everything
looks good but it doesn't update the fields in the DB - am I missing something obvious
here?
$mysql_query ("UPDATE search6 SET email = '$email',description = '$comments',categ
25 matches
Mail list logo
