10,940 Topics
 | |
| | 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 … |
| | Here is part of the html <body> <table> <tr> <td id="ctl00_ContentPlaceHolder1_TD_Unlimited_Usage_PerDay" class="form_label" colspan="2"> <table width='100%' cellspacing='2' cellpadding='0' border='0'> <tbody> <tr> <td align='center' bgcolor='#E1E1E1'>Date</td> <td align='center' bgcolor='#E1E1E1'>Download Usage</td> <td align='center' bgcolor='#E1E1E1'>Upload Usage</td> <td align='center' bgcolor='#E1E1E1'>Total Usage</td> </tr> <tr> <td class='table_item' align='center' bgcolor='#EBEBEB'>2012-11-02</td> <td class='table_item' align='center' bgcolor='#EBEBEB'>1.269 GB</td> <td class='table_item' align='center' bgcolor='#EBEBEB'>0.286 … |
| | |
| | i Always getting : **mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\wamp\www\class\function.php on line 28** please give the suggestion friends config.php <?php define('DB_SERVER', 'localhost'); define('DB_USERNAME', 'root'); define('DB_PASSWORD', '12345'); define('DB_DATABASE', 'class'); class db_class { function db_constractor() { $connection = mysql_connect(DB_SERVER, DB_USERNAME, DB_PASSWORD) or die('Oops connection error -> … |
| | I'm getting this error in one of my scripts: **You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-25,25' at line 1** Below is part of the code any help would be great <?php … |
| | Hi... I am using following query to get data from a table *select * from emp where ename regexp 'rajkiran'* It will return only the rows with ename=rajkiran but I want to select all the rows with ename =raj kiran & ename=rajkiran using a single query |
| | Hello DaniWeb, First off, I am not looking for code, at least not yet. I also honestlly don't know where to post this, but since I'm using PHP, what the heck. If you're an admin and can help me find more relevant answers by changing the "forum type", so be … |
| | I'm doing a delete page, and this part is the part where all the data were supposed to be echoed. but, the problem is I don't really know how to print the checkbox within the php. The line 6 is wrong. Kind men, do show me how to write it … |
The End.