Loïc moisy wrote:
Hi Everyone !
I've coded a php site for a musical store. At the end of every page, before
closing the connection, I send an UPDATE request to increment a statistical
tool. Recently I saw weird results, so I tried to understand. Looking in my
logs, I saw that this request could be
Hi Everyone !
I've coded a php site for a musical store. At the end of every page, before
closing the connection, I send an UPDATE request to increment a statistical
tool. Recently I saw weird results, so I tried to understand. Looking in my
logs, I saw that this request could be sent several time
Folks --
I've been trying to figure out where the Oracle client libraries live, but
I'm confused as hell.
I've read the PHP-DB archives, and everyone keeps talking about installing
the client libraries (libclntsh et al), and how that's all you need for
Oracle 9i PHP support. Great -- but which o
How about:
DELETE FROM users WHERE userid IN (SELECT u.userid FROM users AS u
LEFT JOIN roles AS r ON (u.roleid = r.roleid) WHERE r.roleid IS NULL
LIMIT 1);
On Mon, 14 Jun 2004 11:59:25 -0400, Brock Jimmy D Contr 74 MDSS/SGSI
<[EMAIL PROTECTED]> wrote:
>
> I've been able to figure how to use a d
I've been able to figure how to use a delete subquery to delete all rows, but how do I
use a delete subquery to delete only one row?
I have two tables: users and roles with the following fields:
Users:
userid
roleid
Roles:
roleid
I want to be able to delete a rowid from the role
Wathever you are ging to do with meta tag they still are html tag, so as
long as you embend the tag in php code it shuold just work fine.
";
?>
Any text editor should help you modifying the code by "find & replace"
tools.
Hope can help
ps. FORZA ITALIA AGLI EUROPEI
Franciccio
"Ale
I hope that phpers will be not angry if I'm posting that maybe stupid
question.
I have the following script, an URL Directory Manager (PHP4 from Wrox Press).
I'd like to pass the variable "category" into the TITLE META TAG from
php_category when I select the corrispondent category_id into the URL
D
take a look at the sql insert sintaxe...
it's supposed to be: INSERT INTO table VALUES (val1,val2,...,valn);
all string and date values go between ' '...numeric values don't need
them...
here's an example: INSERT INTO table VALUES ('abc',500,'12-12-2003');
if your table has 5 fields but you don'
Hi
if you change the field type to TIMESTAMP mysql will do it for you
http://dev.mysql.com/doc/mysql/en/DATETIME.html
Peter
> -Original Message-
> From: Gawie Marais [mailto:[EMAIL PROTECTED]
> Sent: 14 June 2004 09:25
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] auto update mysql tab
"Gawie Marais" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> hi guys,
>
> me again ! i need to update a record in a mysql table. now i have defined
a
> datetime field when a record is modified... i want to 'auto update' that
> field whenever a record is modified... what would the ph
hi guys,
me again ! i need to update a record in a mysql table. now i have defined a
datetime field when a record is modified... i want to 'auto update' that
field whenever a record is modified... what would the php script be for
something like that... ?
thanx,
gawie.
--
PHP Database Mailing
thanx guys, it's working like a charm !!
"Marcjon" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I think the problem is he wants to limit after he's sorted them. The
> only way I know of to do that is to do the whole query without a limit
> clause, then run through the results bu
"Marcjon" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I think the problem is he wants to limit after he's sorted them. The
> only way I know of to do that is to do the whole query without a limit
> clause, then run through the results but only do whatever you have to do
> with the
13 matches
Mail list logo