No
i checked the name of name of image values returned.
all is working fine
As i already mentioned tht it is working the right way on my local server.
reagrds
umeed
[EMAIL PROTECTED] wrote:
php-db Digest 13 Sep 2005 22:56:53 - Issue 3090
Topics (messages 40255 through 40261):
Re: image
Hi,
I just noticed I was wrong, the original SQL statement would return rows, but
only if BEGIN = CURDATE(). I stated it would never happen, and that's wrong.
Sorry. :)
-Micah
On Tuesday 13 September 2005 9:42 pm, Micah Stevens wrote:
> Hi Jordan,
>
> Syntactically, there is no restriction
Hi Jordan,
Syntactically, there is no restriction on OR'ing or AND'ing conditions. You
could very well do this:
Select somefield where otherfield = 1 and otherfield = 2;
Of course, otherfield would never be both 1 and 2, so this is a worthless
select statement, however, my point is, there woul
Micah,
Oh, my bad. I was trying to remember how I did something like this
before, stringing together a lot of "WHERE"s. You're right, though,
it wasn't "WHERE", it was "OR".
Rich,
I think you need "OR" instead of "AND", OR else I'm just totally out
to lunch tonight:
SELECT * FROM WEEKS WH
You can't do that in SQL, that would give you a big fat syntax error.
On Tuesday 13 September 2005 7:45 pm, Jordan Miller wrote:
> Rich,
>
> Did you try putting "WHERE" twice?
>
> try:
> SELECT * FROM WEEKS WHERE BEGIN >= CURDATE() and WHERE END <= CURDATE;
>
> Jordan
>
> On Sep 13, 2005, at 9:0
Rich,
Did you try putting "WHERE" twice?
try:
SELECT * FROM WEEKS WHERE BEGIN >= CURDATE() and WHERE END <= CURDATE;
Jordan
On Sep 13, 2005, at 9:08 PM, reclmaples wrote:
I am trying to write a statement that will basically do this:
SELECT * FROM WEEKS WHERE BEGIN >= CURDATE() and END <=
What's the exact error you're getting, I am able to do this:
SELECT curdate( ) AS one, curdate( ) AS two;
which results in this:
one two
2005-09-13 2005-09-13
No error, there is no limit to the number of times you can issue a date call
according to the MySQL documentation.. well, i
I am using mysql Ver 12.22 Distrib 4.0.16
Sorry for not including that.
Thanks
-Rich
-Original Message-
From: Micah Stevens [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 13, 2005 9:13 PM
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Question on CURDATE()
What SQL server are you
What SQL server are you using?
On Tuesday 13 September 2005 7:08 pm, reclmaples wrote:
> I am trying to write a statement that will basically do this:
>
> SELECT * FROM WEEKS WHERE BEGIN >= CURDATE() and END <= CURDATE;
>
> But for some reason I can only use one CURDATE() reference in my sql
> s
I am trying to write a statement that will basically do this:
SELECT * FROM WEEKS WHERE BEGIN >= CURDATE() and END <= CURDATE;
But for some reason I can only use one CURDATE() reference in my sql
statement, does anyone know why? Is there a way I can get around this?
Any help would be greatly a
Now that I'm looking at it, it just seems that the password was wrong, or you
no longer have a root user (which you shouldn't if the database has been in
use.. )
You may need to re-create it?
Can you log in like this:
mysql -u root -p
using that same password?
-Micah
On Tuesday 13 Septem
Does the root user have full permissions? You'll need more than grant if you
are going to run this script.
-Micah
On Tuesday 13 September 2005 3:56 pm, Carson Au wrote:
> Hi Guys, I am a newbie and having a lot of trouble with PHP/MySQL
> lately... We have a number of PHP/MYSQL solutions de
Hi Guys, I am a newbie and having a lot of trouble with PHP/MySQL
lately... We have a number of PHP/MYSQL solutions developed on our
server and I have the pleasure to maintain them...
The copy of MySQL 3.23 has started crashing and refusing to start, so
what I did was I backed up all the DBs
Hello,
This is just an idea, DataObject already store most information about the
fields, there is still a feature that is really useful during input
validation, this is field max length for varchar fields.
Do you think it is possibile to store also this important piece of information
into .ini
this is probably the reason that everything I do that got somthing to do with
programming is always in english
I don't understand why you need all this problems when you can make all your
"background" work (mysql db names,fields,variables) in english and spare the
trouble of having to debug enco
how about usort($myarray, "strcasecmp");
graeme
hope wrote:
Well now i m retrieving results into an array
Then i m using sort($myarray)
but the problem is that it sorts in this way
(
e.g.
ABB MBB
ZZZ
abc
def
ztt
)
i.e it sorts capital letters first n then it sorts the small letters
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
http://www.w3.org/1999/xhtml"; xml:lang="en" lang="en"
dir="ltr">
... Not necessarily.
cheers,
- Martin Norland, Sys Admin / Database / Web Developer, International
Outreach x3257
The opinion(s) contained within this email do not necess
I don't understand why you don't use search&replace, as every normal
html file should start with .
Jens
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
umeed hayyat wrote:
Hi
I have a form where user can add a category or edit some existing
category.
It is perfectly running on localhost but when i uploaded it to an ftp
server (that was Linux based), it isnt displaying any images when i add
any image through image uploading script, neither can
to write files, you could use file_put_contents (if you're using php5)
which really simplifies the process.
you might want to check out file_get_contents, too, to streamline your
file reading process, so you don't have to loop the array.
to loop each directory, have a look at the readdir functio
20 matches
Mail list logo