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 php-db-digest-help@xxxxxxxxxxxxx wrote: php-db Digest 13 Sep 2005 22:56:53 -0000 Issue 3090 Topics (messages 40255 through 40261): Re: image display problem 40255 by: Sebastian Mendel Re: Inserting same text into HTML files 40256 by: Jens Schulze Re: Inserting same text into HTML files. . 40257 by: Norland, Martin Re: retrieving field names in ascending order 40258 by: graeme_foster Re: Possible MySQLi extension BUG! 40259 by: Ziv Gabel DataObject feature request 40260 by: Alessandro Pasotti mysql_fix_privilege_tables error 40261 by: Carson Au Administrivia: To subscribe to the digest, e-mail: php-db-digest-subscribe@xxxxxxxxxxxxx To unsubscribe from the digest, e-mail: php-db-digest-unsubscribe@xxxxxxxxxxxxx To post to the list, e-mail: php-db@xxxxxxxxxxxxx ---------------------------------------------------------------------- To: php-db@xxxxxxxxxxxxx Date: Tue, 13 Sep 2005 12:15:09 +0200 From: Sebastian Mendel <lists@xxxxxxxxxxxxxxxxxx> Subject: Re: image display problem 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 i view any image > on edit_category page, nor i can view when i change image while i edit > any category. > > [...] > if(isset($Upload)) > { > $uploaddir = '../images/categories/'; > $uploadfile = $uploaddir . $_FILES['file1']['name']; > $name = $HTTP_POST_FILES['file1']['name']; try: $name = $_FILES['file1']['name']; check if $name holds the correct img name -- Sebastian Mendel www.sebastianmendel.de www.sf.net/projects/phpdatetime | www.sf.net/projects/phptimesheet To: php-db@xxxxxxxxxxxxx Date: Tue, 13 Sep 2005 14:18:12 +0200 From: Jens Schulze <jens@xxxxxxxxxxxxxxxxxx> Subject: Re: Inserting same text into HTML files I don't understand why you don't use search&replace, as every normal html file should start with . Jens Date: Tue, 13 Sep 2005 08:03:38 -0500 From: "Norland, Martin" <Martin.Norland@xxxxxxxxxx> To: <php-db@xxxxxxxxxxxxx> Subject: RE: Re: Inserting same text into HTML files. . "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> dir="ltr"> ... Not necessarily. cheers, - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -----Original Message----- From: Jens Schulze [mailto:jens@xxxxxxxxxxxxxxxxxx] Sent: Tuesday, September 13, 2005 7:18 AM To: php-db@xxxxxxxxxxxxx Subject: Re: Inserting same text into HTML files. . I don't understand why you don't use search&replace, as every normal html file should start with . Jens Date: Tue, 13 Sep 2005 19:21:44 +0600 From: graeme_foster <graeme_foster@xxxxxxxxxxxxxxxx> To: hope <umeed921@xxxxxxxxx> CC: php-db@xxxxxxxxxxxxx Subject: Re: retrieving field names in ascending order 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 > > but i want the display to sort in ascending order whether it is > capital or smal lettr. > i want my output to look like this > ( > abc > ABB > def > MBB > ztt > ZZZ > ) > > even if i use parameter > > sort($myarray, SORT_ASC); > > doesnt help. > > > Regards > > hope > > > Bastien Koert wrote: > >> AFAIK you can't order the > > >> SHOW COLUMNS from TABLE > > >> Yo could pass the results to an array and sort it in the array > > >> Bastien > > > >>> From: umeed921@xxxxxxxxx (hope) >>> To: php-db@xxxxxxxxxxxxx >>> Subject: retrieving field names in ascending order >>> Date: Thu, 08 Sep 2005 04:23:31 -0400 >>> >>> >>> hi >>> >>> how can i retrieve field names from a table(e.g products_attributes) >>> in ascending order??? >>> i need to display each of the fieldnames alongwith its datatype and >>> length on the page. >>> >>> >>> regards hope >>> >>> -- >>> PHP Database Mailing List (http://www.php.net/) >>> To unsubscribe, visit: http://www.php.net/unsub.php >>> > Date: Tue, 13 Sep 2005 17:17:18 +0200 From: "Ziv Gabel" <ziv@xxxxxxxxxxx> To: "Bastien Koert" <bastien_k@xxxxxxxxxxx>, <renich@xxxxxxxxxxxxxxxx>, <php-db@xxxxxxxxxxxxx> Subject: RE: Possible MySQLi extension BUG! 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 encoding problems best regards ziv gabel ________________________________ îàú: Bastien Koert [mailto:bastien_k@xxxxxxxxxxx] ðùìç: å 09/09/2005 20:05 àì: renich@xxxxxxxxxxxxxxxx; php-db@xxxxxxxxxxxxx ðåùà: RE: Possible MySQLi extension BUG! Questions: 1. what is the current database collation and character set? check with whatever GUI tool you use to admin the db 2. Are they the same? ie UTF-8 3. the query of course would be correct since it hasn't touched mysql yet. Its a straight representation from PHP. Notes: 1. Spaces in DB table/field names are a really bad idea and should be avoided if possible. Replace the spaces with underscores if you want the appearance of the space Bastien >From: Renich Bon Ciric >To: php-db@xxxxxxxxxxxxx >Subject: Possible MySQLi extension BUG! >Date: Fri, 09 Sep 2005 12:50:31 -0500 > >Ok, > >Firs of all, I wanna say I have spent a whole week looking for answers >elsewhere. The reason of this message is to look for a practical solution. > >My Systems: >Server: >Fedora Core 4 (up2dated) >PHP5.04 (cli) >MySQL 14.7 Distrib 4.1.12 >using mysqli extension >Apache/2.0.54 (Fedora) > >Workstation: >Windows XP SP2 >Zend Studio Enterprise 4.02 > >Well, let me explain the problem: > >I'm developing some aplications that require the use of foreign characters. >The language is spanish, so you use accends or tilde on some works >(example, comisi?n, ni?o, etc). > >I have a simple query that uses tables (named with this foreign >characters). Example: > >directorio > - Empresa > - Direcci?n > - Asistente de Direcci?n > >A query to this database should be as follows: > >SELECT * >FROM `Asistente de Direcci?n`; > >This returns an error like: > >Table 'directorio.Asistente de Direcci?³n' doesn't exist. > >I have changed EVERYTHING to utf-8 charset: > >httpd.conf - AddDefaultCharset = UTF-8 >php.ini - default_charset = "UTF-8" > mbstring.internal_encodign = UTF-8 > mbstring.http_input = UTF-8 > mbstring.http_output = UTF-8 > mbstring.detect_order = UTF-8,SJIS,ASCII >my.cnf - [mysqld] > datadir=/var/lib/mysql > socket=/var/lib/mysql/mysql.sock > old_passwords=1 > default-character-set=utf8 > [mysql.server] > user=mysql > basedir=/var/lib > > [mysqld_safe] > err-log=/var/log/mysqld.log > pid-file=/var/run/mysqld/mysqld.pid > > [mysql] > default-character-set=utf8 > >This config sets ALL my servers to utf-8 > >- Apache works perfectly fine in UTF-8, no problems >- PHP encodes everything to utf-8... at least thats what i think >- All my MySQL char variables are set to UTF-8, except >"default-character-result" its set to NULL > >As far as I know, there is no other config made to be done. > >My theory is this: > >Consider: > >> >$link = mysqli_connect('mysql.fedora', 'root', 'idontrecall', >'directorio'); > >if ( isset($_POST['submit']) && $_POST['submit'] == 'Search' ) >{ >$query = "SELECT * > FROM `Empresa`, > `Presidente`, > `Asistente de Presidencia`, > `Director`, > `Asistente de Direcci?n`, ` > Centro de Distribuci?n 01`, > `Centro de Distribuci?n 02`, > `Centro de Distribuci?n 03`, > `Centro de Distribuci?n 04`, > `Centro de Distribuci?n 05`, > `Centro de Distribuci?n 06`, > `Centro de Distribuci?n 07`, > `Centro de Distribuci?n 08`, > `Centro de Distribuci?n 09`, > `Centro de Distribuci?n 10` > >WHERE Empresa.Emp_Gro LIKE '%$_POST[input]%' >AND Empresa.ID = Presidente.ID >AND Empresa.ID = `Asistente de Presidencia`.ID >AND Empresa.ID = Director.ID >AND Empresa.ID = `Asistente de Direcci?n`.ID >AND Empresa.ID = `Centro de Distribuci?n 01`.ID >AND Empresa.ID = `Centro de Distribuci?n 02`.ID >AND Empresa.ID = `Centro de Distribuci?n 03`.ID >AND Empresa.ID = `Centro de Distribuci?n 04`.ID >AND Empresa.ID = `Centro de Distribuci?n 05`.ID >AND Empresa.ID = `Centro de Distribuci?n 06`.ID >AND Empresa.ID = `Centro de Distribuci?n 07`.ID >AND Empresa.ID = `Centro de Distribuci?n 08`.ID >AND Empresa.ID = `Centro de Distribuci?n 09`.ID >AND Empresa.ID = `Centro de Distribuci?n 10`.ID"; > >// Make the query >$result = mysqli_query($link,$query) or die(mysqli_error($link)); > >// Fetch the results >while ($data = mysqli_fetch_assoc($result)) >{ > // Print the data obtained > print_my_data($data); >} > >} >// Close conection >mysqli_close($link); > >?> > >if you add a "print $query;" just before it makes the query; and as long as >you have your webpage with the charset meta-tag set to "utf-8" and >everything utf-8 encoded... you'll get the right query... > >this is > >SELECT * FROM `Empresa`, `Presidente`, `Asistente de Presidencia`, >`Director`, `Asistente de Direcci?n`, ` Centro de Distribuci?n 01`, `Centro >de Distribuci?n 02`, `Centro de Distribuci?n 03`, `Centro de Distribuci?n >04`, `Centro de Distribuci?n 05`, `Centro de Distribuci?n 06`, `Centro de >Distribuci?n 07`, `Centro de Distribuci?n 08`, `Centro de Distribuci?n 09`, >`Centro de Distribuci?n 10` WHERE Empresa.Emp_Gro LIKE '%try this%' AND >Empresa.ID = Presidente.ID AND Empresa.ID = `Asistente de Presidencia`.ID >AND Empresa.ID = Director.ID AND Empresa.ID = `Asistente de Direcci?n`.ID >AND Empresa.ID = `Centro de Distribuci?n 01`.ID AND Empresa.ID = `Centro de >Distribuci?n 02`.ID AND Empresa.ID = `Centro de Distribuci?n 03`.ID AND >Empresa.ID = `Centro de Distribuci?n 04`.ID AND Empresa.ID = `Centro de >Distribuci?n 05`.ID AND Empresa.ID = `Centro de Distribuci?n 06`.ID AND >Empresa.ID = `Centro de Distribuci?n 07`.ID AND Empresa.ID = `Centro de >Distribuci?n 08`.ID AND Empresa.ID = `Centro de Distribuci?n 09`.ID AND >Empresa.ID = `Centro de Distribuci?n 10`.ID > >following the error >Table 'directorio.Asistente de Direcci?³n' doesn't exist > >As you can see, this is not logical. You had your query printed just above >and it printed out fine!... Sorry, if i got a little carried away... > >This is why i think that the mysqli extension haves a bug. I have my >connection, server, etc... variables set to UTF-8 in MySQL. The one that is >converting the code while using the "mysqli_fetch_assoc()" function is >php... > >If anybody knows how to correct this... or how to make the example work... >please tell me. I have worked on this too much. > >I know that if I change the tablenames, it will work. In fact, a query like > >SELECT * >FROM `Empresa`; > >Works perfectly fine. > > Help me and all the foreign php and mysql users use our own >characters! > >Things I have checked: >- Searched my.cnf, httpd.conf and php.ini for any "ISO-8859-1","latin1" >strings. >- Checked the db file names (/var/lib/mysql/) >- Checked if the script files are UTF-8 encoded >- Checked if the browser is accepting the UTF-8 charset > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php ************************************************************************************ This footnote confirms that this email message has been scanned by PineApp Mail-SeCure for the presence of malicious code, vandals & computer viruses. ************************************************************************************ ************************************************************************************ This footnote confirms that this email message has been scanned by PineApp Mail-SeCure for the presence of malicious code, vandals & computer viruses. ************************************************************************************ From: Alessandro Pasotti <ale.pas@xxxxxxxxxx> To: php-db@xxxxxxxxxxxxx Date: Tue, 13 Sep 2005 17:58:17 +0200 CC: Justin Patrin <papercrane@xxxxxxxxx> Subject: DataObject feature request 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 file? Such values could be used in the validate() function to check user input length on text fields. -- Alessandro Pasotti ICQ# 245871392 Linux User #167502 To: PHP DB <php-db@xxxxxxxxxxxxx> From: Carson Au <cau@xxxxxx> Date: Tue, 13 Sep 2005 15:56:47 -0700 Subject: mysql_fix_privilege_tables error 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 and then reinstalled version 4, things seems to be working ok. Then I discovered this: http://www.educ.sfu.ca/phpbb2/ and in phpmyadmin I get this message: "Warning: Your privilege table structure seem to be older than this MySQL version! Please run the script mysql_fix_privilege_tables that should be included in your MySQL server distribution to solve this problem!" So I tried to do the following... $ sudo -s $ mysql_fix_privilege_tables mypassword And this is the errors I got: This scripts updates the mysql.user, mysql.db, mysql.host and the mysql.func table to MySQL 3.22.14 and above. This is needed if you want to use the new GRANT functions, CREATE AGGREAGATE FUNCTION or want to use the more secure passwords in 3.23 If you get Access denied errors, you should run this script again and give the MySQL root user password as a argument! If your tables are already up to date or partially up to date you will get some warnings about 'Duplicated column name'. You can safely ignore these! ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) Creating Grant Alter and Index privileges if they don't exists You can ignore any Duplicate column errors ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) Creating the new table and column privilege tables ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) Changing name of columns_priv.Type -> columns_priv.Column_priv You can ignore any errors from this ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) Fixing the func table You can ignore any Duplicate column errors ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) Any suggestion? I have checked the permission table using phpmyadmin and grant=Yes for "root". Anything else I need to do differently? Regards, Cars __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com