10,940 Topics
 | |
| | please help me to correct my answer: [B] STUDYCASE:[/B] The Following tables from part of a database held in a relational Database Management System (DBMS). Hotel ([U]HotelNo[/U], HotelName, City) Room ([U]RoomNo[/U], [U]HotelNo[/U], TypeHotel, Price) Booking ([U]HotelNo[/U], [U]GuestNo[/U], DateFrom, DateTo, RoomNo) Guess ([U]GuestNo[/U], GuestName, GuestAddress) Note: Underlined words is primary key … |
| | Hi everyone. I'm using sqlite3 in Linux and I currently have a problem. I have a database and 2 tables in it: db1 and db2. db1 has 3 columns: empID, empName, empAddr. db2 has just 1 column: empID and its value is set to 0 by default. I created a … |
| | I know there are many other threads about this same error, but none have helpped me, here is my code: [CODE] <?php $mysql_id = mysql_connect('mysql3.000webhost.com', 'a2778852_556875', 'pendolino390'); mysql_select_db('a2778852_555676', $mysql_id); $result = mysql_query("SELECT personalexperience, sex, age, sexuality, FROM Personal_experience"); while($row = mysql_fetch_array($result)) { echo $row['personalexperience'], $row['sex'], $row['age'], $row['sexuality']; } mysql_close($mysql_id); ?>[/CODE] …  |
| | I really want this echo to not include people not listed as 1 in the row "activated" in my database. So if its 0 they wont show. [CODE] // Print each user while($row = $result->fetch_assoc()) { echo " <tr> <td>{$row['username']}</td> <td><a href='{$row['website']}' class='example7'>{$row['website']}</a></td> <td align='center'>{$row['disabled']}</td> </tr>"; } // Close table … |
| | I want to export some of the records of a table to a file in Linux. Is there any command for this?  |
 | I use Visual studio 2008 I use MySQL 5.1 I have created een database (test) table (table1 ) with field (Images) Data Type mediumblob size The maximum length of mediumblob is [COLOR="Red"]16777215[/COLOR] (2^24 - 1) characters I want to Check file size before save in MySQL table1. [COLOR="Green"]I want to …  |
| | Hello Friends, I've around 1000 records in mysql database. in content table im using image source url like 'img.mydomain.com' so today I've registered new domain. so i want to find replace following domain and update my new domain in image path url. so please let me know how to find/replace??? …  |
| | I am new to conneting to MYSQL through a C++ code; so this is what i did i installed MySQL Server 5.1 (it was a EXE), and thats it. i opened the MYSql command line client and created a DB, and added a table and values to it. This is …  |
| | Hi, Im trying to run a MYSQL query to check if the input value exists first. A user fills in an input field and clicks "Add Tag" The java script on the same page checks the MYSQL table if that tag is already there and if so returns a faded … |
| | THe project is about to design a calender (that should be embedded on a website) that will be able to read from database and pick up event for chosen day and place  |
| | I need some help to write to a MySQL database using C++. any basic tutorial will be appreciated. I did google but couldn't find a beginner tutorial. I am sort of lost here. :(  |
| | How would I make a code that dynamicly gets MySQL and makes it like ?UserID=54556 :-/? |
| | Hello, my code is [code]import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class LoadDriver { public static void main(String[] args) { Connection conn = null; try { // The newInstance() call is a work around for some // broken Java implementations Class.forName("com.mysql.jdbc.Driver").newInstance(); } catch (Exception ex) { System.out.println("daaaaaaaaaa"); // handle the … |
| | This looks like a repeat of a previous thread, but I still haven't cracked it. I'm doing everything on a single Windows XP pc, so no servers or clever stuff involved. I blew the space on MS Access so I'm attempting to return to plan A of using MySQL. Installed:- … |
| | .I am creating an online quiz using PHP and MySQL. .what i want to come up with is a quiz page having a frame where the user is able to see the question and then choose from the available answers on the dropdown list. after which the user then clicks …  |
| | Hi, I am trying to check MYSQL table field for existing Tags. If they exist i dont want it to insert the tag. If they dont exist i want it to run the INSERT query. My code below wont work though.. it just keeps returning already exists even when the … |
| | the problem is that its an undifined varible ($last) intill i type the second word, i [code=php] if($_POST) { $q=$_POST['searchword']; $q = explode(' ', $q); $first = $q[0]; $last = $q[1]; $sql_res=mysqli_query($mysqli, "select * from dogs where firstname like '%$first%' and lastname like '%$last%' order by id LIMIT 5"); while($row=mysqli_fetch_array($sql_res)) … |
| | Hi, After completing a PHP website, with html, javascript and mysql connections - What can I do to ensure good security and what threats should I be aware of? Thanks, Ashton. |
 | I am creating a website where when an unregistered user comes to the site they'll only be able to access a limited amount of the site. It's only when they pay for access to the site that they can receive the full content. I'm wondering how I should go about … |
| | Hi, I am trying to perform a few basic operations on MySql database through my delphi application. I am using MySql server 5.1 with Delphi 7 Here is what I have done( please correct me if I am wrong with the approach) - Created DataSource with MYSQL ODBC 5.1 driver …  |
| | Hi there, Im new with PHP/MYSQL and really need help from u guys. I want to find a code on how to select date range from MYSQL using PHP. Example I want to find a data with the date range is between 12-10-2010 until 15-12-2010. Im using this format date …  |
| | Hi, I need some help with this MySQL Update I've got three tables as below. tbl1 id eid quantity 1 3 2 2 4 3 tbl2 tid eid qnty status type 1 3 1 1 1 2 3 0 1 0 3 4 1 1 1 4 4 0 1 … |
| | Hi, I am working on a script that populates a table with a user's news entries. First I get the username from the URL, then go to the database and get the user_id. From the user_id, I query the news table for the user's news entries. [CODE] $idgrabber = "select … |
| | Hello everyone. I am looking for a paid web hosting deal with MySQL, cPanel, and phpMyAdmin. Can someone please tell me some good ones?  |
| | Alright this is a little hard to explain, but I have two tables of very different data. Both tables have a date timestamp. The timestamps are not going to match, but I need to join table2 on to table1 via the next date equal to or less than. So.. Table1 … |
 | Hi Guys, I have php mysql code which display data by date. if date is similar to the another it will display as one. When i implement an accordion it does not work. But if i will get the accordion it really works. And I am kinda stack of it. … |
| | Basically. I have this query that is executed on a form submit. [code] $add_proc = mysql_query(" INSERT INTO `proc` (active, title, desc, notes, link, tags1, tags2, tags3) VALUES ( '".$_POST['add_proc_active']."', '".$_POST['add_proc_title']."', '".$_POST['add_proc_desc']."', '".$_POST['add_proc_notes']."', '".$_POST['add_proc_link']."', '".$_POST['add_proc_tag1']."', '".$_POST['add_proc_tag2']."', '".$_POST['add_proc_tag3']."' ) [/code] Now. The form doesn't require you to enter all 3 tags. … |
| | Hi Daniweb, I am confused, how to explode the numbers from database. Simply I can Explode, but after explode I have to relate the numbers to another table. If any one not clear abt my problem, pls reply Eg: 1, 2 Relate to Basket, football [CODE] $sql1=mysql_query("SELECT impid FROM customer … |
 | Hi all, I'm trying to figure out how to stop MySQL errors being displayed to the user. I have turned off all the necessary options in php.ini such as [CODE]display_errors = Off log_errors = On error_log = /path/to/log/[/CODE] I have even tried to override these settings using ini_set() in my …  |
| | I cannot get this mysql update query to work. Please help. I am new at this.:) <?PHP session_start(); ?> <?php //it's getting the data from the post fine. I know this part is working. $ud_id=$_POST['ud_id']; $ud_fname=$_POST['ud_fname']; $ud_lname=$_POST['ud_lname']; $ud_type=$_POST['ud_type']; $ud_used=$_POST['ud_used']; $ud_sdate=$_POST['ud_sdate']; $ud_edate=$_POST['ud_edate']; if ($ud_id == "") echo " No record ID … |
The End.