BDY.RTF
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Hi there,
I can easily get results of my tables when i try to get character-type
fields but when I try to get a numeric-type field i receive the following
messages:
Warning: Sybase: fieldname field not found in result in filename.php on line
32
Line32 tells me: $Var = mssql_result($res, $i;
Three things I see:
1. You seem to be assigning hard-coded values to u_mange_users, and "0" ,
as it is last, will always win. I think, I alsway have to mess with them a
bit. That's why checking your SQL is important.
2. You are embedding a semi-colon in SQL statements. That's not necessary.
Hi!
I am looking for a SQL Statement that would allow me to remove a column
from the table in the database. Just give me what you know and I'll check
out the SQL Reference I have for the database. Don't worry about what type
of database do I have, that's what hte SQL Reference is for. (It
scott,
try " alter table drop(column)"
-u
-Ursprngliche Nachricht-
Von: Scott Fletcher [mailto:[EMAIL PROTECTED]]
Gesendet: Mittwoch, 28. Februar 2001 14:50
An: [EMAIL PROTECTED]
Betreff: [PHP-DB] SQL STATEMENT?
Hi!
I am looking for a SQL Statement that would allow me to
alter table remove column_name
Or something along those lines.
Hope that helps a little bit.
Wesley Choate
Daymark Group
Programmer / Web Developer
Phone: (501)-968-4038 X2204
Email: [EMAIL PROTECTED]
Web: www.daymarkgroup.com
-Original Message-
From: Scott Fletcher [SMTP:[EMAIL
I know there is an issue about encrypting an already encrypted
string, or encrypting something twice. I believe it is against the law in
the US for some algorithms (like MD5). They [they] have to be able to crack
your stuff.
Maybe someone can confirm?
How does this
There have been a number of mails about the SQLParamData error when starting
Apache after installing the solid database installation. Here is a list of
the actions we had to take to get solid working correctly with PHP 4.04pl1 I
hope it saves some time since it cost us a lot !
Solid version is
I have a homepage which has a news headline system. Bascially via form the
admin of the site can submit news which appears on the front page, the only
problem is the news just keeps coming and I have a front page with too many
headlines on.
How can I make it so that say 7 articles appear on
Yep. This one got me.
/var/lib/mysql had these permissions: drwx--
Changed to: drwx-r-x-r-x
Worked like a charm.
Many thanks to Joe and Rick
rick
-Original Message-
From: Joe Brown [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 27, 2001 10:24 PM
To: [EMAIL PROTECTED]
Hey,
If you're using Mysql to store the items, you could
use the Limit statement to limit the number of items
displayed. If you're using the file system it'd
probably be a little more difficult, but not
impossible. For example, if the news items were stored
in a text file with one entry per
Matthew,
Do you want to be told how, or want to read an interesting article on just
this, including PHP script to build your archives. It's one of the early
PHP tutorials -- try a search on "php movie database".
I adapted code from that for my own archive, although I run a shell script,
php-db Digest 26 Feb 2001 19:12:23 - Issue 477
Topics (messages 6951 through 6963):
Re: Server side or client side?
6951 by: Uioreanu Calin
6953 by: JJeffman
Re: OCI 8 and rowid cause SIGSEGV
6952 by: Thies C. Arntzen
Re: cookies, email and passwords
6954
php-db Digest 27 Feb 2001 08:38:46 - Issue 478
Topics (messages 6964 through 6974):
dns script
6964 by: Liz Bander
6968 by: php3.developersdesk.com
Re: Can't connect to local MySQL server error
6965 by: Brunner, Daniel
6967 by: Rick Emery
Re: onMouseOver
Matthew,
My MySQL syntax is a little rusty. But if you define tables as type
"MYISAM" and implement a primary key like this "nArticleKey integer
unsigned not null auto_increment primary key" you will have a steadily
incrementing count on your articles, as you add them, with no intervention.
You could then issue as select statement like " select * from articles
limit 7 order by nArticleKey descending" (maybe it should be "top"
instead of "limit", check your MySLQ syntax) and feed those to the front page.
select * from articles order by nArticleKey desc limit 7
although a better
I have a tricky database query I can't figure out how to write. I have a PHP app
using MySQL that does a query like this:
(main query)
select * from A left join B on something
where B.thing = "1"
This gets me everything in A where its corresponding element in B has a certain
attribute.
What
At 09:50 PM 2/28/2001 -0500, you wrote:
Is there a way to do this in MySQL? Or do I have to just query
everything, and then have the skipping logic be in PHP? I'd love to
encapsulate this in a query. Would it involve subqueries (something I
know that MySQL doesn't directly support)?
The
18 matches
Mail list logo