10,940 Topics
 | |
| | 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 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: …  |
 | Hello Iam getting an error in the pagniation page "Warning: mysql_real_escape_string(): Access denied for user 'username'@'localhost' (using password: NO) in /home/livehuqu/public_html/abcd.com/pptindex.php on line 19 " Warning: mysql_real_escape_string(): A link to the server could not be established in /home/livehuqu/public_html/abcd.com/pptindex.php on line 19 Iam using the same code in other website and … |
| | 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 , … |
| | I am trying to create a search box that searches the county field of the database. If the criteria matches then the records will be displayed in the table. I have got the different counties in the dropdown box however when I click the record the table does not change. … |
| | 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 …  |
| | I'm coding a simple portal do maintain work history and I'm facing a problem. While php retrieve data from mysql I would like that he create a btn or a link to download a file in a directory (path on mysql). 1- script: http://pastebin.com/mBHCdChK 2- script to retrieve path and … |
 | 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 … |
| | Hello everyone, I have the following script: <?php $con=mysqli_connect("localhost","name","name","database"); // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } $resultaat = mysqli_query($con, "SELECT `question` FROM databasename WHERE `id`= 2"); while ($row = mysqli_fetch_assoc($resultaat)) { echo '<table>'; echo '<tr>'; echo '<td>'. '<input type="text" value= '.$row['question'] … |
 | 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 … |
| | how to hide specific values from mysql php? Please help me anyone... |
| | how to make active in dynamic multi level css drop down menu with php mysql ? i given my html and php code. <nav class="navbar navbar-default navbar-static-top" role="navigation" style="margin-bottom: 0"> <div class="navbar-header"> <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse"> <span class="sr-only">Toggle navigation</span> <span class="icon-bar"></span> <span class="icon-bar"></span> <span class="icon-bar"></span> </button> <a class="navbar-brand" href="index.html">SB … |
 | Hello, Am trying to fetch data from one table of one DB and put it into another DB's table. I wrote below connection code for this: <?php $date = date('Y-m-d H:i:s'); /* OLD EIMS connection values */ $old_host= "localhost"; $old_uname="root"; $old_pass="ABC"; $old_database ="EIMS_OLD"; /* NEW EIMS connection values */ $new_host= … |
| | I have three tables that I query. Problem is my ORACLE MIF table has 500,000 rows. And it takes more than 1 hour. How can I reduce the time? SELECT WB_FIELD_REQ.MODEL, WB_FIELD_REQ.MFG_SERIAL_NUMBER, CONFIG_SERIAL_NUMBER, SH_CONTRACTS.EQUIPMENT_ID, "", SH_CONTRACTS.SERVICE, "", SH_CONTRACTS.CONTRACT, "X", "", "X" FROM WB_FIELD_REQ INNER JOIN SH_CONTRACTS ON WB_FIELD_REQ.MFG_SERIAL_NUMBER=SH_CONTRACTS.MFG_SERIAL_NUMBER NOT IN … |
The End.