I have two tables - incoming tours(id,name) and incoming_tours_cities(id_parrent, id_city) id in first table is unique, and for each unique row from first table there is the list of id_city - s in second table(i.e. id_parrent in second table is equal to id from first table) For example incoming_tours |--id--|------name-----| |---1--|...
Hey, I'm creating tables using phpMyAdmin and want to define two different columns as indices. I'm not trying to create a multi-column index but phpMyAdmin creates them as such. Are there any possible issues with that? The fields don't relate to each other directly and both fields will not be used in WHERE clauses simultaneously. Consi...
(if i searched for "phpmyadmin and excel", i get answers like "hot wo import excel-files"....) i searched for a phpmyadmin-alternative that works faster with ajax and i want to edit once fields directly like EXCEL! click n edit via ajax!! i dont like to click the row and say "now edit", then edit, and click "ok", return and new loading t...
I cannot figure out how to connect to the server with php 000webhost doesn't have localhost as their host name I tried to get it by doing one variable but it did not work when I tried to connect to the server with the code provided well I am writing an if statement that says if my site cannot connect then "die();" with the code provi...
I want to put a map in a web page where users will be able to put interactive marker (location pins) as many as they want. Now, whenever a marker is placed, I want to store that specified marker's lat, long value to be saved in a database that I have in my server (phpmyadmin). Trying to get started with Google Map Data API. Have seen l...
I have access to phpMyAdmin, but NOT the MySQL command line. I need to recreate the table structure elsewhere along with certain tables that need to be 'pre-populated'. I can, of course, export the empty table structure and then export the tables one-by-one, but is there a better way to export a bunch of table data together? ...
Hi all, I'm going to put a new application I created the last few weeks in production. Is there a hosting company that is best for Symfony or doesn't that matter at all? Or are there hosting companies you recommend or don't recommend in my case? It's a very small application written in php (Symfony 1.4) and a db mysql with phpmyadmin. ...
Look at this query please SELECT max( val_amd ) FROM `best_deposits` I have the max value in the table equal to 14.6(the fields has type float), But it returns 14.3599996566772 why does it happen, and how can i get the exact value? Thanks much ...
I am getting server has gone away errors when i try to re import a database created with mysqldump. I don't get that error when I export from phpmyadmin. I am trying to mimic the phpmyadmin export output with mysqldump. phpmyadmin has something called "Maximal length of created query" set to 50000. What option does that translate to in ...
Hello all, I saw this to get PHP MySQL Apache configured on my windows 7 and was successful. But when I tried installing PhpMyAdmin as per the link I'm not able to get it installed properly. First it was not able to load mcrypt extension in PHP which i resolved by editing php.ini. But now the problem is when i type http://localhost/pma...
I have access to the lesser account. I want the password to the All Privileges account. I've tried a few options but can't seem to get the password to reset. Suggestions? I'm also on Twitter asking for help... @BrentDPayne Thanks, Brent D. Payne ...
I am trying to import a .sql file and its failing on creating tables. Here's the query that fails: CREATE TABLE `data` ( `id` int(10) unsigned NOT NULL, `name` varchar(100) NOT NULL, `value` varchar(15) NOT NULL, UNIQUE KEY `id` (`id`,`name`), CONSTRAINT `data_ibfk_1` FOREIGN KEY (`id`) REFERENCES `keywords` (`id`) ON DELETE CASCADE ON...
Hi.. My purpose is to setup a forum in php just locally on my Windows 7 machine to test how it works. I have installed Apache HTTP Server and PHP v5 successfully. Then I downloaded and extracted the phpbb-forum software and put it in my root folder. Then I realized that I needed some kind of database so I downloaded and installed MySQ...