7,368 Topics
 | |
 | I am sorta new to MySQL and not 100% sure of what I can and can not do with it yet. I have an xml file with course information such as ReferenceNo. CourseName, CourseType, CourseLocation, and I want to load in into a database table that has column names such … |
| | Can somebody explain me why does this mysql query SELECT * FROM mytable WHERE F='d2f2' AND Tot>Pmin AND Tot<Pmax omit this row ID ¦IDa¦F ¦Pmax¦Pmin¦Tot --------------------------- 124¦160¦d2f2¦200 ¦12 ¦182 thanks!  |
 | when i run select on temporary table in mysql it gives all records. But when i tried in my php page it give blank reason. Please help me out. |
| | Hi, I am working on a test site locally. I am loading an xml file into my database with teh following sql query: LOAD XML LOCAL INFILE 'C:/courseInfo18.xml' INTO TABLE wp_courses ROWS IDENTIFIED BY '<Course>' (ReferenceNo, ProviderCode, ProviderName, CourseID, CourseName, CourseTypeID, CourseTypeName, LocationCode, LocationName, StartDate, FinishDate) ; It works fine …  |
| | Hello, I have a script that allows user to upload a file to a mysql 5 database. That is working OK. The File size is accurate. However, my download script is for some reason downloading the files without any content - 0KB. The files are OK when I open them … |
 | Hi, My query: $query = "select * from ( select * from students union all select * from students ) as tmp order by rand() limit 5"; $myquery = mysqli_query($db_connect, $query); while($students = mysqli_fetch_assoc($myquery)){ $stdid =$students['stdid']; $name = $students['name']; $dept = $students['dept']; echo "<br><br>".$stdid."<br>".$name."<br>".$dept; } There are 20 rows for …  |
| | I have news pages generated dynamically using page news.php taking data that is input into a MySql table and would like to have the page title to be the same as the news headline of each page. I'm searching internet and although there is lots of info on this subject … |
 | Hi Everyone, I am looking for the best way to create a PHP MYSQL Query to help me output a complete list of categories from my db. The categories are football team names & I would like to display everyone who supports each football team. For Instance: I have 44 …  |
| | I'm trying to parse a few references from a file and load them to mysql table but keep on getting this error everytim,e i run the script: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the … |
| | Hello Sir I want the php code to import the excel data into mysql . pls hel me Thanks |
 | // this works sql = "SELECT * FROM `image_upload` WHERE location='article' AND image_id='7'"; // this works sql = "SELECT * FROM `image_upload` WHERE location='article' AND image_id='9'"; // this does not work sql = "SELECT * FROM `image_upload` WHERE location='article' AND image_id='7' AND image_id='9'"; // I wonder why? |
| | I am posting this doubt already as a last resort. I want to insert 0 or 1 into the Boolean / TINYINT. I used var_dump and I see that html always passes as False (0). I will post part of the code of html, php and mysql. Any help will … |
| | Hi there, I am developing shopping cart website using php pdo. what i want, stock quantity has to decrease when an order is placed. Give me some idea guys. |
| | I have the following code: <?php session_start(); include_once("config.php"); $query = "SELECT Category FROM books"; $result = mysqli_query ($mysqli, $query); echo '<select name="dropdown" value=""><option value="">Dropdown</option>'; while($row = mysqli_fetch_array($result)) { echo '<option value="' . $row['Category'] . '">' . $row['Category'] . '</option>'; } echo "</select>"; ?> the values of the drop down box …  |
| | Hello, I am getting a bit confused regarding apostrophes in my SQL statement. I can get it to work but I would like to understand why it works when it does or, conversely, why it doesn't work when it doesn't. If you know what I mean. Anyway - here goes: … |
| | Hi everyone. I want to store greek letters in mysql table my table collaction is utf8_general_ci and i'm calling this function after database connection mysqli_query($connection, "SET NAMES 'utf8'"); mysqli_query($connection,"SET CHARACTER SET 'utf8'"); but all greek letters in database are like "??????? ???" Question mark how to resolve this ??? I … |
| | Hello everyone, I am trying to connect my android application to MYSQL database. I have used the following: MYSQL already created database test (accessed via xampp using localhost/phpmyadmin) Created a table named as student in the database test consisting of Name and Roll No columns and 2 records. A user … |
| | In this website there are strange thing or missing point Database is : http://files.engineering.com/getfile.aspx?folder=d93b360c-2dad-41da-bd63-23327dae5863&file=Database.JPG see no 15,16 different in language Interface PHP See Difference http://files.engineering.com/getfile.aspx?folder=9fc7f64f-6800-4427-baa6-ef05f3431839&file=PHP_WEB.JPG same interface code but different only in language How to change ???? to الصيانه i set collision for table is utf8_general_ci i set collision for … |
| | I like to join the 3 tables in without using joing query is possible... |
 | Hello :) I'm trying to create web application. I followed the tutorial given in this site : http://aspsnippets.c...-in-ASPNet.aspx My problem now, after I create a table and the UI. Next step show about stored procedure. What is stored procedure use for? Do I need this even though I had a … |
| | Hi All, I want to copy the missing 'data' field from 'tb1' to 'tb2' based on the 'id' value. Please suggest the possible queries. mysql> select * from tb1; +------+------+ | id | data | +------+------+ | 1 | A | | 2 | B | | 3 | C … |
| | Hi All, I have a requirement first to fetch top unique company_names out of duplicate values based on the product name search and then fetch rest of the record randomly.Below is my sample table structure but the actual table has more than 90k records. id com_id company_name product_name package_id 1 … |
 | I need to create a form in php and mysql in which it will create a table on a default set database for example "ramgest" and i want it to be only one text field with table name and one file upload which will get the imported .csv into the … |
| | I have a search box and a dropdown box. I am using these to filter data being displayed on my table from the MySQL table. I can type a county name in to the searchbox and all the records with that county name will be dsiplayed. THAT works fine, however …  |
| | SELECT * FROM basketball_market where (name LIKE '%- Total Points' OR name LIKE '%- Money Line' OR name LIKE '%- Spread') AND type_id like '266' basketball_market table: http://my.jetscreenshot.com/5886/20150305-us2v-35kb SELECT * FROM `basketball_participant` WHERE `market_id` =242319098 LIMIT 0 , 30 http://my.jetscreenshot.com/5886/m_20150305-dfdx-16kb.jpg SELECT * FROM `basketball_participant` WHERE `market_id` =242319099 LIMIT 0 , … |
| | Hello! I am Basil and I am a freelancer, I work in the United Kingdom. I wish to start my own business but for starting I need a solution for sending **bulk SMS** to my customers and potential customers. I have researched a lot through Google, to find an ideal … |
| | Hi, I want to output a simple result. I join 2 tables and SUM one column in one, i get the SUM results correct but cannot get the num_rows proper. My Code: $clientid = 24; $query = "SELECT items.itemid, SUM(prices.priceid) as PR FROM items JOIN prices ON items.itemid = prices.itemid …  |
 | Hello everyone. I have setup a website and the common.php is configured but the site seems to not be linking to the database. For example, if I mouse over a link mydomain.com/details.php?id=1 and click the link it takes me to mydomain.com/details.php and says no results found. In the database it … |
 | I am recieving a notice(s) multiple times when running a file: Notice: Undefined index: Telephone in C:\xampp\htdocs\demo\nest_Demo_thrasher.php on line 111 Notice: Undefined index: eMail in C:\xampp\htdocs\demo\nest_Demo_thrasher.php on line 112 I have researched this and the ways to solve it. Most ways involve isset it seems, but none of my code … |
| | Hi, I'm looking to optimize my query. CREATE TEMPORARY TABLE table1 SELECT a FROM ( SELECT a FROM my_table WHERE DATE_ADD(my_table.`date`, INTERVAL -4 HOUR) >= DATE_FORMAT(NOW()- INTERVAL 6 HOUR, '%Y-%m-01 00:00:00') ) a GROUP BY b ; what this sql does is to get something from the begining of the … |
The End.