10,946 Topics
 | |
 | I was designed a database model for my social network project. It has follower system. If you follow him the follower can see the status. All these operations are for one page. (This page is name **user_wall.php**) Its has a GET value and this is **userName**. For this case about … |
 | Hi, I have a problem with exercise 51 from sql-ex.ru, please help. Thanks in advance. # Short database description "Ships" # The database of naval ships that took part in World War II is under consideration. The database has the following relations: Classes(class, type, country, numGuns, bore, displacement) Ships(name, class, … |
| | Hey Im making an online store and cant figure out the section on inserting data into a table (in this case its inserting customer details into a customer table). Its the VALUES line that is displaying the error: mysql_query() expects parameter 1 to be string, resource given. I have looked …  |
| | Hi guys! I have a database which holds a table called users. in there i have a balance column which contains a numeric value. I have the following code and for some reason it doesnt work: <?php session_start(); include_once("config.php"); ?> <!DOCTYPE html> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Search</title> …  |
| | This is the table that gives error -- ----------------------------------------------------- -- Table `mydb`.`Supervise1` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `mydb`.`Supervise1` ( `S1_Date` VARCHAR(45) NOT NULL, `S1_Contracter` VARCHAR(45) NOT NULL, `S1_Contractee` VARCHAR(45) NOT NULL, `S1_ID` VARCHAR(45) NOT NULL, PRIMARY KEY (`S1_Contracter`, `S1_Contractee`, `S1_Date`, `S1_ID`), INDEX `Contracter_idx` (`S1_Contracter` ASC), INDEX `Contractee_idx` (`S1_Contractee` … |
| | I am trying to save 2 photos to my MySQL database. I can only see one of the 2 photos in the database (i.e. its name) but I see the 2 photos in the folder I store my photos. ( A picture of how the database looks like is attached.) …  |
| | I am trying to compare IF statements. if ($_POST['price'] =="see all"){ //show okolo } else if ($_POST["accommodation"] =="see all"){ //show chibuzo } This works but as soon as I add: else if ($_POST['price'] =="see all" AND $_POST['accommodation"]=="see all"){ //show henry } This stuff does not work, it now shows "okolo" … |
 | 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!  |
| | i have continued my developing my code on e-commerce website to grant the discount to client on basis of coupon code entered <?php /** * Consider and apply voucher codes * Types of voucher code * - = FIXED AMOUNT OFF * % = PERCENTAGE OFF * s = SET …  |
 | 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 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 … |
 | hy i'm having problem with this mysql qry, i dont whant to insert in the db if its empty the field, ive tryied with is NULL, but its not working... $qry=mysql_query("INSERT INTO trans_autista (autista, ditta) SELECT * FROM (SELECT '$trans_autista', '$cat') AS tmp WHERE NOT EXISTS ( SELECT autista FROM … |
 | Hi guys Im trying to save a combobox selected item to my database but i cant get it working, it saves "user" instead of the username that is stored in the combobox, any suggestions? here's a snippett Try '----------------Sends the message------------------------------------------------------------------- MysqlConn.Open() ' opening the connection to the DB Dim … |
| | i am trying to write a script that stores information from a html form into a mysql db. i have had the code work to stoer the information into the db but have since modified the code to accomodate the image up load also. i wan the code to stoe … |
The End.