vmavrou

Hi, i'm trying to activate the export to pdf function but it seems that is not so easy i have the following * Apache/2.0.63 (Win32) PHP/5.2.5 * MySQL client version: 5.0.45 * PHP extension: mysql phpMyAdmin * Version information: 3.0.1.1 i executed first this file i have attached that comes with the phpmyadmin package then i executed these : GRANT USAGE ON mysql.* TO 'pma'@'localhost' IDENTIFIED BY 'pmapass'; GRANT SELECT ( Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv ) ON mysql.user TO 'pma'@'localhost'; GRANT SELECT ON mysql.db TO 'pma'@'localhost'; GRANT SELECT ON mysql.host TO 'pma'@'localhost'; GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv) ON mysql.tables_priv TO 'pma'@'localhost'; then this one : GRANT SELECT, INSERT, UPDATE, DELETE ON phpmyadmin.* TO 'pma'@'localhost'; and then i inserted into config.inc the following : $cfg['Servers'][$i]['controluser'] = 'pma'; $cfg['Servers'][$i]['controlpass'] = 'pmapass'; $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin'; $cfg['Servers'][$i]['relation'] = 'pma_relation'; $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords'; $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages'; Am i doing something wrong? Thanks in advance [attachment deleted by admin]

hi, thanks for your reply first the #center was going to used for a banner with the repeat function...anyway i didn't used that finally so that' why it was there. the name #center doesn't mean it was for adjusting text, but i removed them. also about the margin: auto 0; i have this : <style type="text/css"> body {margin: 0px; padding: 0px;} </style> isn't the same for the whole body?

Hi! i have made this : http://vmavrou.freetzi.com and i have this problem,when you click one of the buttons at the main page,at the second page if you don't view the page full screen and you start to decrease the size of the window, the home button at the right , is overlaying with the text. Any idea of what css script should i use to stop that? Thanks in advance.

Solved, using css. Thanks for your help.

Hi, i wanted to ask here : http://vmavrou.freetzi.com next to the login box is two lines with text. Is there any way to center them to the whole page? because with the <center> put them in the middle but after the login box. So i mean if there is anyway so the login boxed will be ignored at the align and the text will go to center. The text is dynamic so we don't know how many letters will be each time to adjust them manually. But the maxsize is ok so that if centralized won't fall on login box. Thanks in advance.

oh!! i'm dumb...you are so right ! fixed it! thanks alot! (missed the "")

yes you are right... i got this : int(1997) but what this means? and what am i doing wrong??

Hi, i want to check for dates with this form yyyy-mm-dd, ex 2009-11-20 i have made this : $pattern = "((19|20)\d\d[-](0[1-9]|1[012])[-](0[1-9]|[12][0-9]|3[01]))"; $test =2009-11-01; if (preg_match($pattern,$test)>0) { echo "ok"; } else { echo "false"; } but always getting false..am i doing something wrong with the pattern?

Manage to do it, by making up this solution. posted in case someone interested. $queryy = "DELETE FROM groupspu WHERE"; $result = mysql_query("SELECT * FROM groupspu"); $fields_num = mysql_num_fields($result); for($i=0; $i<$fields_num; $i++){ $field = mysql_fetch_field($result); $ff = $field->name; if($i==0) { $queryy = $queryy." ".$ff; } else{ $queryy = $queryy." ='0' AND ".$ff; } } $queryy = $queryy." ='0' "; $result = mysql_query($queryy);

yep, it worked in this form : DELETE FROM groupspu WHERE admin ='0' AND public ='0' AND dokimi ='0'  ... Thanks alot!

Hi i wanted to ask if i can use a query like this : DELETE FROM groupspu WHERE (proistamenos && dokimi && public && admin) = '0' because when i run it it deletes every row and not only the ones that the fields at the query are equal to zero. It is important the certain format that's why i'm asking if this query is possible without altering the (proistamenos && dokimi && public && admin) . Because that info is taken from other place of the program. Thanks in advance

hi! i have an array that contains name of fields. for example : $ff[0] = a $ff[1] = b $ff[2] = c and i know of course the length of the array. is possible to create a query to delete a row in a table where the contents of the array will be equals to zero for example . something like that. if($ff[0]==0&&$ff[1]==0&&$ff[2]==0) { delete row } but everytime we call that the array it could change. One time it might has 2 cells,other 3,4 etc. so we want to read the array and based on the results to automatic create a query. Is that possible to create a "dynamic" query to handle a case like this? Thanks in advance

Finally figure it out,the problem was a bad declaration at tha phpmyadmin . Thank you very much for your time and your help. Really gratefull,it was very hard to find out what was wrong. respect

here i use require_once (mysql_work.php) where set character and set names are included,at the page that updates the db.at the page that reads i have include_once. Does it makes any difference?

Yep,it's working, but the the problem is that when i submit it with the form then at the phpmyadmin value is not correct,is like ????????. It works only if i edit myself the field into phpmyadmin and enter the greek value. The it shows it fine. Is a problem at the storage now?