10,946 Topics
 | |
| | how can i fecth my record from mysql database from two rows in asingle table? and both feild are different where i want to fetch my record?  |
 | Hello I'm running a php function to get some user information from mysql using pdo. The problem is that i don't get the results i want. This is my php code: <?php require_once('db_connect.php'); function mila(){ global $dbh; // Set dummy variables $required_id=1; // Select table with query $sth = $dbh->prepare("SELECT … |
 | Hello, I am a mysql table called: adsmgt which consists of: idads and time I would like to count the number of row in adsmgt how to do so? I try this: mysql_select("select TABLE admgt count(idads)"); This error appears: (it doesn't matter if the idads are twins they still have … |
| | Hi, I have a problem to delete data from mysql database using checkbox. This the error appear in my page and the data cannot delete. <?php $host="localhost"; // Host name $username="root"; // Mysql username $password=""; // Mysql password $db_name="mentormentee"; // Database name $tbl_name="appointment"; // Table name // Connect to server …  |
 | Is there any way to set the long_query_time for the slow query log to less than < 1s? We consider anything over 0.5s something wrong. Or can you recommend any MySQL monitoring software that can handle a super high load without a super amount of storage space? |
| | I am using Decimal data type to store time like 1.30(1 hour 30 min),0.40(40 minutes) in MySQL. I want to calculate total time. When I use SUM function it was giving result in unexpected way. example: 1.30 + 0.30 = 1.60 -> SUM function gives like this. But I want … |
| | Hi I have variables set in the head of the page as they are used for other parts of the page. I have a problem where by I am trying to get the variable to echo out in the result. I have tried several ways but either ther eis an …  |
| | hi... i want to insert data from array using mysql from php..and now i using this code : for ($i = 0; $i < count($data1); $i++) { $insert_sql = sprintf("INSERT INTO detail_paket (id_paket, menu_paket) select paket.id,'\"%s\"' from paket where paket.nama_paket='$nama_paket'",%data1[$i]); mysql_query($insert_sql); } data1 is the array.. what is the correct …  |
| | I need to find valid records as part of a database cleanup script. What I need is a regular expression that will match, for a single column: records containing BOTH numbers AND letters (or any other character). records containing ONLY numbers (including decimals) Invalid records are those which contain ONLY … |
 | Hi guys, im kind of curious, is there a query or some way to fuse two colums like `select a.col1,b.col1 from table1 a left join table2 b on a.id=b.table_a_id` then as a result i want to display only one column containing a.col1,b.col1 thanks =) |
 | I am trying to get my code working so that I can store the path of an uploaded picture onto a table so that I can call upon the uploaded file whenever I need it. So what happens on the web page is, a person enters information on a vehicle … |
| | Hello everybody , Im created an Application in vb6.0 . In that application i have to store data in a web Mysql database.How can i connect tht |
| | Hi, I need a hand from a kind MySQL guru. I am running XAMPP for WinXP ver 1.6.8, phpMyAdmin ver 2.11.9.2, PHP Version 5.2.6 - on a local host (my laptop). I'm running Joomla 1.5.7 (on both my net server and on my local host). What I need to do … |
 | Here is my query UPDATE tracks SET People_id_Reference = (SELECT People_id FROM People RIGHT JOIN top100 ON People_name=top100.artist LIMIT 1) WHERE People_id_Reference IS NULL; But that query inserts same people_id value into all rows of People_id_reference Can some on help me with this. Thanks in advance |
| | Hello, I'm developing script php about cell phone specific, now I want to insert an uploader for image of cell phone. I want to upload image to a fecific folder and save url to mysql table. Can you help me to create form and how to do this? |
 | hi i need to connect a vb application to a mysql database which is in a remote server plz suggest solutions thank u very much |
| | I am getting an error..Need help.. " Parse error: syntax error, unexpected T_STRING in C:\xampp\htdocs\test2.php on line 24"; line 24 is --"header("Content-Type: application/xls");"-- <?php $DB_Server = "localhost"; //MySQL Server $DB_Username = "root"; //MySQL Username $DB_Password = ""; //MySQL Password $DB_DBName = "test"; //MySQL Database Name $DB_TBLName = "sample"; //MySQL Table … |
| | Hello. I have a larger database that I want to import and I cannot do that using phpmyadmin. I tried to do this in many possible ways by command line, but I get message 'wrong syntax'. I have Windows Vista, MySQl version 5.5.24, wamp server. The path to mysql.exe is: … |
| | hi friends, here is my problem i'm designing a page with no. of checkboxes but not able to insert its value in mysql... here is my php code: **<?php $host="host"; // Host name $username="root"; // Mysql username $password=""; // Mysql password $db_name="packtest"; // Database name $tbl_name="test"; // Table name // … |
| | I am reading data from a mysql database and displaying it on a web page for the user to make changes. One of the values that I am getting from the database is to be displayed in a Select tag: Manufacturer: <select name="Manufacturer" tabindex="1" > <option></option> <option>Aprilia</option> <option>BMW</option> <option>Moto Guzzi</option> … |
| | I am not able to restore sql file from linux command prompt. I have used the below command. Here is the message.No table is restored. I am running this in my local machine adminuser@virtualboximagescom-VirtualBox-34s7dkv4:/$ mysqldump -u root -p replication_test </home/adminuser/Downloads/rp.sql Enter password: -- MySQL dump 10.13 Distrib 5.5.28, for debian-linux-gnu … |
| | Hello again! Now i stucked with another little problem. I have a table: ID____Name______Age_______City 1_____Robert_____20_______London 2_____Fabio______31_______Rome 3_____Hans______35_______Berlin 5_____Josh_______25_______London Now i don't know how to get a city which has the most population in this table. With my code: SELECT City, COUNT(Name) AS Population_number FROM Person GROUP BY City; I get … |
 | Hello buddies , I have no Idea what is subquery, every time I tried to link two tables in one sql query I failed here is the scenario I want: in this pic I have posts with "**user_id**" only I need to show the username which stored on another tables … |
| | Ok So I have seen a few things.. But is there anything that goes into depth more but sort of squared away... From what it looks like if you develop something in mysqli - it will be faster mysql pdo - works with a bunch of other databases.. I found …  |
| | Hello guys! Please help me with a little problem. I have one table(Person) where are some values. My current syntax is: SELECT Status, COUNT(Name) AS Number FROM Person WHERE Status = 'Married'; Result: Status_________Number --------------------- Married__________3 But I want to get the result for each status. That would be something …  |
| | I made a wesite which have a webforum something like this site. Where a user can send message to each other. i am using php-mysql. i want to know how to store info about if user had read his message or its still unread. my site is [www.thar.co][1]. mysql table-column … |
| | CREATE PROC [dbo].[INRv2_GetAllSavedJobs] AS SELECT plm.jobcode [Job No],si.seminartitle [Seminar Title] FROM (SELECT DISTINCT pm.jobNo jobcode FROM inr_mailinglist pm) plm INNER JOIN (SELECT js.jobno, sm.seminartitle FROM inr_seminarmaster sm INNER JOIN inr_jobshedule js ON sm.seminarid =js.seminarid) si ON plm.jobcode =si.jobno ORDER BY plm.jobcode RETURN GO > This SP retruns [Job No] rows … |
| | I have a textbox which pulls the maximum value from DB. But it gives wrong value. Can you help figure out what went wrong here? **basicfunction:** private function basicInformation() { // initialize variables $host = "localhost"; $db_name = "test"; $tbl_name = "ballpark_details"; $username = "root"; $password = ""; // connect … |
| | Hello; I need to normalize a mysql database by placing it in a 3NF. Could someone please recommend a good book, topic or a webpage from where I could start learning about this matter? Thank you very much! Joey  |
| | Hi everybody, i want know how make admin panel and to it news system via [b]PHP[/b] and [b]Mysql[/b]! Is here anybody who knows how make it, and if here is somebody who knows, then can you help me? I'll try make a website where is news about sport things what …  |
| | Hi, I've just switched web hosts, and I have this script that ultimately connects to a database and displays it on a webpage. It used to work fine, however now I can get it to display the database info in the webpage, however I can't update the fields. I can … |
| | Could you help me please? I have a table List: List( cinema char (15) movie char (20)) I need to get movies which are shown in most cinemas and the number of times they are shown. If there are more then one movie shown the same number of times, there … |
| | **For our final requirement before my groupmates and i can graduate we have to develop a LAN-Based Enrollment system we searched about the pros and cons when it comes to using either Access or MySql as the database and the majority of the results are in favor of using Mysql …  |
 | is it possible to load the data contained in an Excel file into a MySQL table using PHP? |
 | first i'm not much professional in JAVA programming but if you mentioned a code how hard is it I'll understand it ... I want to create a desktop application that is connected with an online database to insert/retrieve data from it ... I've searched a lot on google but no …  |
| | I have a database on both the servers with different table values and a third server with the same named db and tables in MYSQL server1-db1-table1 table1 ID Number 1 101 2 102 3 103 server2-db1-table1 table1 ID Number 4 201 5 202 6 303 How can I merge these … |
| | How to change collation of a mysql table which is created on MYSQL 4.1.22 ? I used following query ALTER DATABASE `testdb` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ALTER TABLE `testtab` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci It displaying following error messages ****Error SQL query: ALTER DATABASE `testdb` DEFAULT CHARACTER … |
| | # What I am trying to do is as follow: # I have a html form with dropdownlists that populated by php and mysql, on the same page I have a table that displays the data that was enter in the form (obvious when submitted) my table structure: CustomerlocationId ProducttypeId … |
| | Hi, I have a error message when I try and execute the following code $ccid = cleanQuery($_SESSION['cid']); $ip = $_SERVER['REMOTE_ADDR']; $today = date('Y-m-d'); // check to see how many entries in the tbllog have already been entered $qry5 = mysql_query("SELECT count(id) AS total FROM tbllog WHERE cid=$ccid AND action='EMAIL_REFER' AND … |
| | I'm currently building a website for my friends and me, and I've decided to have the homepage use a news system. I have the page working with PHP to load articles from my MySQL Database, and that's working fine. My real issue is with the page that adds items to … |
 | hi every one. i have two tables table_1 ( std_id primary key, std_name, tchr_id foreign key ); table_2 ( tchr_id primary key, tchr_name ); as from the above tables i have the foreign key constraint. it mean if i want to delte teacher id it must be firstly deleted from … |
| | hi all i want to store the error of `mysql_error()` in a variable. i was trying the following: $alert_error = "<script type=\"text/javascript\"> alert('".mysql_error()."') </script>"; $id =5; $query = mysql_query("DELETE FROM abc WHERE id ='$id'") or die ($alert_error); actually my there is a foreign key constraint so when i click to … |
| | Hi all friends, I am trying to insert XML data using DOM, i completed mostly but little bit left, issue in the <field></field> the data between that not inserted in db, please consider the below mentioned XML file... <?xml version="1.0" encoding="UTF-8"?> <form name="mc1.dpp" application-name="mc1.dpp" application-id="34" document-id="1342" producer="Penvision Formidable Application Server" … |
| | Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\E-COMMERCE\admin\inventory_list.php on line 66 line 66: $productCount= mysql_num_rows($sql); //count the output amount <?php //block grab the whole list for viewing $product_list = ""; $sql = mysql_query("SELECT * FROM products ORDER BY date_added DESC"); $productCount= mysql_num_rows($sql); //count the output amount … |
| | I need to generate sequences of games using the round robin algorithm. I have the php page where the user can input the tournament name which will be inserted into the database and it has got a drop down menu up to 32 teams (select number of teams). So if … |
| | hi, ok so i hae googled and looked on many sites. basically i created my database application using dreamweaver. i now want to convert it over to an android app. i have came across tools that can convert html to this. however is there any tools to convert my php … |
| | Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in \xampp\htdocs\proj\demo.php on line 57 Can anyone explain my problem. Thanks! <?php $result = mysql_query("SELECT * FROM internet_shop"); while($row=mysql_fetch_assoc($result)) { echo '<div class="product"><img src="img/products/'.$row['img'].'" alt="'.htmlspecialchars($row['name']).'" width="128" height="128" class="pngfix" /></div>'; } ?>  |
| | so im trying to make a very basic multiplayer game that gets a players x y from a server then displays the player. the script works fine when there is only one user in the database but when more users are added the script wont display the right player. i … |
 | hi.I have created a table named stu_info.Here present 3 column named id,name,dept.here id is primary key and every column is varchar.Now i typed the following query Update stu_info set id='0904009' and name='mr. x' and dept='CSE' where id='0904199' and name='mr. y' and dept='CSE'; But it made the id=0 instead of 0904009.What … |
| | hi, im trying to write a mysql query to join tables. I basically i have the following tables: tblwinners = table that shows all the winners PK reward_id customer_id tbluser = table that holds all the user accounts PK customer_id tblcompleterewards = completed rewards PK reward_id tblrewards = holds a … |
The End.