In article [EMAIL PROTECTED],
[EMAIL PROTECTED] says...
Hello all,
I've got a bit of a problem at the moment. I'm using the dba_ functions to
do some simple database access, and I have the need to delete some items
from the database from time to time. When dba_delete() is called, it
Try something like this:
SELECT USERS.Username,FILES.Filename
FROM USERS LEFT JOIN FILES USING(Id)
WHERE FILES.Filename IS NOT NULL ORDER BY FILES.Stamp DESC LIMIT 1;
If Filename declared as NOT NULL then use FILES.Filename!=''
MR I've been racking my brain for too long on this one, can someone
At 04/06/2002 08:58, Evgeny Chuykov wrote:
Try something like this:
SELECT USERS.Username,FILES.Filename
FROM USERS LEFT JOIN FILES USING(Id)
WHERE FILES.Filename IS NOT NULL ORDER BY FILES.Stamp DESC LIMIT 1;
I think it's wrong because Id isn't the matching column in 'FILES'.
2nd line should be
I think this is something like you would want...
Adam
SELECT users.id, username, MAX(stamp) as stamp, filename
FROM users, files
WHERE users.id = userid
GROUP BY username
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Hello,
I'm hoping someone can please help me.
Solaris8 - Patched to 8_recommended
Apache 1.3.24
PHP 4.1.2
freetds .53
gcc 2.95
libgcc
libgcj
Im needing the mssql interface to work. After I compile Apache during the
make process I get.
/export/php/ext/mysql/php_mysql.c:1888: undefined
Hi there,
I am trying to get only records out of a table mathing a query. This should
be piped into a textfile. My problem is that I have to transmit this records
to a new machine. So the output should be a kind of sql commands which I
could run with phpadmin or similar to import them to the
[snip]
I am trying to get only records out of a table mathing a query. This should
be piped into a textfile. My problem is that I have to transmit this records
to a new machine. So the output should be a kind of sql commands which I
could run with phpadmin or similar to import them to the other
Original question:
[snip]
I am trying to get only records out of a table mathing a query. This
should
be piped into a textfile. My problem is that I have to transmit this
records
to a new machine. So the output should be a kind of sql commands which I
could run with phpadmin or similar to
[snip]
I did read on mysql.com and your article. Than I tryed to transfer the
datasets.
Export worked ok. The textfile contains the records.
Import message:
Query OK, 35 rows affected (0.04 sec)
Records: 35 Deleted: 0 Skipped: 0 Warnings: 630
The warning already tells it. the datasets are
Hi to all,
can anyone please tell me what I'm doing wrong in this query?
This one doesn't work when I use operator
INSERT INTO record_status(rec_id) select 150bk.ID from 150bk
WHERE PHY_ST'IN' Or PHY_ST'OR' Or PHY_ST'PA' Or PHY_ST'IA' Or
PHY_ST'MN' Or PHY_ST'CO' Or PHY_ST'ME' Or PHY_ST'TN' Or
Instead of use !=
Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
Pay It Forward
mailto:[EMAIL PROTECTED]
http://accessingram.com
-Original Message-
From: Natividad Castro [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 04, 2002 11:06 AM
To: [EMAIL PROTECTED]
found my problem .. thank you for your help! You guy put me in the right
direction to solve this problem.
Thanks!!
Jason Wong [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
On Tuesday 04 June 2002 00:52, James Kupernik wrote:
yes because I'm using it in
hi to all,
I have a drop down menu where users will select a word. After they submit
it, I will generate a code number where I want to display the first three
characters of the word they selected follow by Month and Date and three
number that will be generating randomly.
I don't have any problem
I've been plugging away at learning a bunch about PHP, but now I'm stuck.
I've found a search utility at
http://www.digitalgenesis.com/software/dgssearch.html , and I was able to go
through and customize it.
But then I came upon the problem of correct URL's for the search results. I
just
Hi all
I'm having trouble displaying some content into a multiline form. Some part
of the field's data seems to be missing. I'm using the following code:
?php
$query = select * from sections where id='.$sectionid.';
$result = pg_exec( $db , $query );
$r = pg_fetch_row($result, 0);
$description
On Wednesday 05 June 2002 03:56, Natividad Castro wrote:
hi to all,
I have a drop down menu where users will select a word. After they submit
it, I will generate a code number where I want to display the first three
characters of the word they selected follow by Month and Date and three
On Wednesday 05 June 2002 02:51, Paulo Nunes wrote:
Hi all
I'm having trouble displaying some content into a multiline form. Some part
of the field's data seems to be missing. I'm using the following code:
echo PContents: brtextarea length =8000 cols=50 rows=20
name=\content\ value=.\
Hi there everyone,
I have a db and the last column is id2 this adds a 1 everytime a
banner is clicked so that I can track which banners are being clicked
the most that works great, no problems but how can I get the result
out as a chart on the screen? Id like to list the 5 most popular
never done it myself but look into the png/jpg routines built into PHP. You
can use them to dynamically create an image. What you DO with the image is
up to you. :)
Seriously, there are some tutorials out there about this very topic. hit
phpbuilder.com or google.com to find them.
=C=
*
* Cal
I am moving to php-4.2.1 now and still looking for explanation how to use
exeption
handling in informix stored procedures. As I've wrote a year ago here,
when I trying to execute the following php code:
?
$connid=ifx_connect(basename,username,password );
$q=execute procedure test();
You can also use something like jpgraph (http://www.aditus.nu/jpgraph/)...
-Original Message-
From: Chris Payne
To: [EMAIL PROTECTED]
Sent: 6/4/02 10:00 PM
Subject: [PHP-DB] how to create a graph from a db?
Hi there everyone,
I have a db and the last column is id2 this adds a 1
Howdy All-
I've poked around the net for some snippets, and have done my own in the past,
but wanted to get some more ideas on how you do a permissions system. This
means, in your application, how do you control and enforce different
permissions for different users?
Simple example: An image
Hallo,
Directly I have problem with php_oci8.dll.
And i have instaled Oracle9i and problem is, that my PHP application doesn´t
work correctly.
I can´t connect to Oracle for expample and etc. Therefor I would like to
know If I need another php´s dll for Oracle9i working.
Thanks a lot ...
Thailon
Take a look phplot.php
http://www.phplot.com
Chris Payne wrote:
Hi there everyone,
I have a db and the last column is id2 ? this adds a 1 everytime a
banner is clicked so that I can track which banners are being clicked
the most ? that works great, no problems ? but how can I get the
Hi Chris,
this is very easy done with a library called jpgraph.
Check out:
http://www.aditus.nu/jpgraph/
A nice example can be found on my website at:
http://www.globosapiens.net/community/03010001.html
Hope this helps,
Andy
--
Hi there,
I have a table containing cities of the world. Now I am running into
problems because people are starting to complain that some mayor cities are
not in the db like Tokyo. After checking my table I discovered that there
lots of cities are written with some non latin characters.
Tokyo
26 matches
Mail list logo