[phpmyadmin] Forum Topics

hello, i hope someone can help me i have a table ip in my database if there is 5 times in it he has to forward it in php to another page. thanks in advance

Hi, Not done any programming for a few years so am somewhat rusty again. I have two tables **users** table and **users_profiles** table. I want to update **users_profiles** table on the condition that **user_uid** matches on both tables (**users.user_uid** and **users_profiles.user_uid**) and where **users.user_login ** = 'johndoe' and **users.user_uid** = …

Linux Mint I logged into phpmyadmin and set the password option to 'no password' and now I can't log in. If I enter the password I was using I get this error -> `#1045 Cannot log in to the MySQL server` and if I don't user a password at all …

hello every one i have one small doubt i have the following code i want the user to enter the coupon code which has been randomly generated and saved in database now i want that when user enter the coupon code it is cross checked from database i.e entered coupon …

hello all I am a beginner... I want to move a wordpress site from a local computer to live server... live server: plesk parallels I followed some tutorials and it says: you must create a new mySql database on server... ok I went to parallels plesk panel and I created …

Hi, I have imported a csv file but for some reason in some values the data after . is missing for e.g. If my value in csv is 0.5 it displays 0. and 5 went missing but in my csv file i have value as 0.5 I don't what step …

Hi, I have imported .csv file and column is appearing as Col 1, Col 2... and the data I want as a column name is appearing as a first row. How do I convert my first row into column name in phpmyadmin. Thanks in advance

Hi all. I'm developing a quiz application consisting of multiple choice questions. Here are the tables that I've come up with. CREATE TABLE IF NOT EXISTS `student` ( `s_id` int(10) NOT NULL, `s_name` varchar(30) NOT NULL, `s_email` varchar(30) NOT NULL, PRIMARY KEY (`s_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; CREATE TABLE IF …

I have 2 tables: tblUser: +------+-----------+ | id | Name | +------+-----------+ tblItems(this table accepts multiple checkbox value depending on how many user selected): +------+-----------+---------------+ | id | items | name_id | +------+-----------+---------------+ `name_id` will get the value of `id` in `tblUser` I use this code to get the value …

Hello Community, Is there a website that has a database like phpmyadmin that i can access from my website? Please help...

Hi Friends i like to know more about the difference between mysql, Phpmyadmin, sql and also which one is more safe and secure for webpage. Can any one help me to know about it.

Hi With the code snippet given in the following post http://www.daniweb.com/web-development/php/threads/126361/csv-file-uploading-into-a-mysql-database I am able to import csv data into phpmyadmin. However, I am getting an error if csv data contains a text with apostrophe (‘) symbol (e.g. my book’s name is abc). Appriciate any suggestions to resolve this error. Thank …

Hi. I wanted to make a page that I can update a table in a database. But for some reason, I get this error: ***Warning: mysql_query() [function.mysql-query]: Access denied for user 'a1092592'@'localhost' (using password: NO) in /home/a1092592/public_html/folder/file.php on line 10*** and this error: ***Warning: mysql_query() [function.mysql-query]: A link to the …

hi...... i created my login page...everything is working fine. i want to know whether we can get the login date for each users when they login.. and when they login the date shud be posted in the database?? how to implement this...

I created a Javascript application that creates a moving quote.([url]http://economymoving.net/get_an_online_moving_quote.php[/url]) The quote page should insert a record in the db, display the record on a new page called viewquote.php and send an alert email to the company. Currently, the phpmyadmin database receives the record but viewquote.php doesn't display the correct …

Hello all, I've a seemingly simple question, but it's kind of got me thinkin there might be a "proper" way to accomplish my goal. My goal is a simple MySQL database schema install. In PHPMyAdmin I export a database, any database. I then save the file to the root directory …

I am working on a site and I want to be able to query the appropriate table based on their location. For example, if they input they live in NY, it should query the NY table. If they input they live in CA, it should query the CA table and …

I am trying to store millions of records with address, city, state, zip, etc. I originally had one table with 17 different fields with the primary key being id. However, I soon realized after inserting almost a million, the website began to lag and was slow. What is the best …

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:\AppServ\www\eUTM\login\logincheck.php on line 13 here is the code: <?php //login check require_once("dbconn.php"); $con=connectdb(); $idpengguna=$_POST['idpengguna']; $katalaluan=$_POST['katalaluan']; //login PELAJAR from table pelajar $pekerja_query="SELECT * FROM pengguna where idpengguna = '$idpengguna' AND katalaluan = '$katalaluan'"; $pekerja_result=mysql_query($pekerja_query,$con); $pekerja_row=mysql_fetch_array($pekerja_result); if(!$nama_id && !$katalaluan) { $err=1; …

Hi Daniweb, I am confused, how to explode the numbers from database. Simply I can Explode, but after explode I have to relate the numbers to another table. If any one not clear abt my problem, pls reply Eg: 1, 2 Relate to Basket, football [CODE] $sql1=mysql_query("SELECT impid FROM customer …

hi, i'm using phpmyadmin & would like to create an additional field in the following table. Field // Type Collation Attributes Null Default Extra Action user_id // int(10) first_name //varchar(20) last_name // varchar(40) email // varchar(80) pass // char(40) user_level //tinyint(1) active // char(32) registration_date// datetime the field would be …

I tried lot of way to pass the checkbox values from page 1 to page 2. But I only get successes on fruit id, how can pass the fruit charges. [CODE] // how can I pass room charges"$result[room_charges]" to page 2 // page 1 $sql=mysql_query("select * from fruit"); while ($result …