[PHP-DB] Re: One additional thought

2005-09-13 Thread Joshua May
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

[PHP-DB] Re: image display problem

2005-09-13 Thread Sebastian Mendel
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

[PHP-DB] Re: Inserting same text into HTML files

2005-09-13 Thread Jens Schulze
I don't understand why you don't use searchreplace, as every normal html file should start with html. Jens -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Re: Inserting same text into HTML files. .

2005-09-13 Thread Norland, Martin
!DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.0 Transitional//EN http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd; html xmlns=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

Re: [PHP-DB] retrieving field names in ascending order

2005-09-13 Thread graeme_foster
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

RE: [PHP-DB] Possible MySQLi extension BUG!

2005-09-13 Thread Ziv Gabel
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

[PHP-DB] DataObject feature request

2005-09-13 Thread Alessandro Pasotti
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

[PHP-DB] mysql_fix_privilege_tables error

2005-09-13 Thread Carson Au
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

Re: [PHP-DB] mysql_fix_privilege_tables error

2005-09-13 Thread Micah Stevens
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

Re: [PHP-DB] mysql_fix_privilege_tables error

2005-09-13 Thread Micah Stevens
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

[PHP-DB] Question on CURDATE()

2005-09-13 Thread reclmaples
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

Re: [PHP-DB] Question on CURDATE()

2005-09-13 Thread Micah Stevens
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

RE: [PHP-DB] Question on CURDATE()

2005-09-13 Thread reclmaples
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

Re: [PHP-DB] Question on CURDATE()

2005-09-13 Thread Micah Stevens
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,

Re: [PHP-DB] Question on CURDATE()

2005-09-13 Thread Jordan Miller
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 =

Re: [PHP-DB] Question on CURDATE()

2005-09-13 Thread Micah Stevens
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:08 PM,

Re: [PHP-DB] Question on CURDATE()

2005-09-13 Thread Jordan Miller
Micah, Oh, my bad. I was trying to remember how I did something like this before, stringing together a lot of WHEREs. 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 WHERE BEGIN

Re: [PHP-DB] Question on CURDATE()

2005-09-13 Thread Micah Stevens
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

Re: [PHP-DB] Question on CURDATE()

2005-09-13 Thread Micah Stevens
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 on

[PHP-DB] Re: image display problem

2005-09-13 Thread umeed hayyat
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: