10,940 Topics
 | |
| | Using javascript, a field in an html form is formatted for time. When the user types in 344, the field formats onblur to 3:44. This field is then echoed in PHP an appears properly formatted. However, in the MySQL database it is inserted into, it appears as only "3". Everything … |
| | Lately I have been learning how to use 'sessions' (with some degree of success) for transferring parameters between pages. I have come across a new error report that is so weird that I would not be able to envision how I could do a Google search to find what is … |
 | Hello, I am having trouble with MySQL on a newly installed Fedora 14. I have found that there are several issues with MySQL on Fedora but none of the issues I have found have exactly fit my situation. To start off, when I installed Fedora, I chose the Web Server … |
| | i cant update... is there any error in it... i'm getting an error" you are using a safe updating mode.... please help me.... [CODE] UPDATE $tbl_name SET MUSE_RETRYCOUNT='0', MUSE_ISLOCKED='0' WHERE MUSE_LASTRETRYTIME <=DATE_ADD(SYSDATE(),INTERVAL -6 hour) [/CODE] |
| | i have a problem in query i have attached a sql for query and my searching code is following [code]<div> <form name="frm" action=search.php method=post> <select name="facilities[]" id="facilities[]" style="width: 130px;" multiple="mutiple" size="3"> <option value="17">Conference hall</option> <option value="16">Meeting</option> <option value="14">Danceing</option> <option value="15">Swimming</option> <option value="18">A/c room</option> <option value="19">Dining hall</option> <option value="20">Cooking facility</option> <option …  |
| | Hey guys, I'm getting the above error, could any of you tell me why? Here's the code [CODE]$mysqli=new mysqli("localhost", "***", "***","***") ; if(!$mysqli){ die("Database error"); } function checklogin($username, $password){ global $mysqli; $result = $mysqli->prepare("SELECT * FROM users WHERE username = ?"); $result->bind_param("s", $username); $result->execute(); if($result != false){ $dbArray=$result->fetch_array();[/CODE] |
| | This is not a homework assignment. :) I'm a MySQL newbie and we just bought a product that uses it. The vendor has indicated that what I want is a special request and wants to schedule professional services time (several weeks in the future) to write us a personalized script. … |
| | I'm currently building a website for a small charity and they've asked me if it was possible to make an admin area where they could access some of their work when they're out and about so they don't have to fill in forms twice. I can do this as I … |
| | Hi, I have been trying to execute a query and for some reason it returns 0 when there should be 1 in the result. [CODE] SELECT count(TaskID) AS DueToday FROM tasks WHERE TaskDueDate = CURRENT_DATE AND Completed = 'No'[/CODE] I have tried NOW() and various others reference [url]http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_current-date[/url] however it …  |
| | Hi, I am trying to create a group of html links that are dependant on two arrays. The data of the arrays is populated from a mysql database, here is my code: [code=php] <?php include_once 'title.php'; include_once 'checkuser.php'; if (isset($_GET['view'])) $view = sanitizeString($_GET['view']); else $view = $user; $sql = "SELECT … |
| | hi 2 all m new to mysql and want to make a table in mysql so please help me Table for Name Email Phone number Comment  |
| | hi when i check apache status there is too many line like 198-92 - 0/0/4 . 0.00 78719 0 0.0 0.00 0.00 127.0.0.1 noc1.server.com OPTIONS * HTTP/1.0 i think this is related mysql or not is there anyway to close this pid in 5min or 10min? [CODE]0-112 1881 0/16/24053 _ … |
| | hi, i have just applied a view to my database and when tested works fine if their is a value from the tasks and allrenewals tables of "clientID" or clients_ClientID however i need to be able to view the entries even if the clientid or clients_clientid from the 2 tables … |
| | Hello peeps! I really need a pagination for this code: [CODE]<body> <div class="myFiles-content"> <div id="myFiles-upload"> <table> <tr> <td class="login-form"> <form action="index.php?page=user_upload2" method="post" enctype="multipart/form-data"> <input class="button1" type="file" name="uploaded_file"><br> <input class="button1" type="text" name="description" maxlength="60" value="Description" onClick="this.value='';"> <input class="button1" type="submit" value="Upload"> </form> </td> </tr> </table> </div> </div><br> <table cellpadding="0" cellspacing="0" border="0"> <tr class="myFiles-thtable"> …  |
| | Hey guys, nice to meet you. I have PHP/MySQL driven site. I have finally found an AJAX script to load my data in a div on the same page. It works if i click a static link, but the main purpose i need is to click link with dynamic album … |
| | Hi, I have this question about how to retrieve a column with DateTime from MySQL as String and put the data in a textbox. :| So I've been using something like this... [CODE]Private Function check_ResitDate_ResitNumber() Dim SQLquery As String Dim rrnRD As OdbcDataReader Dim DiTi As DateTime SQLquery = "SELECT … |
| | im new to sql but long story short. just installed mysql server 5.5 and started the configuration and it failed to apply the security settings with error message 2003, cant connect to server on local host. so i cant finnish the installation and canot run mysql.exe. it just beeps at … |
| | Hi There! Our company became a reseller, and we didnt get the product info's in normal way (cd, email, xml, etc). So we have to go to their website and download all of the product infos (name, description, price, pictures) one by one. This could be fun if you have … |
 | Hi all, Im a bit stuck. I think im staring the answer right in the face but cant see it. Im after a query that references 1 table. Its output will be each unique source code along with a total of grouped data from a single column. SOURCECODE Count of … |
| | Hi, I have table structure as follows Table Name- facilities facility_id | hotel_code | facility_name 1 1 Parking 2 1 AC 3 2 Parking 4 3 Parking 5 3 AC 6 4 AC Now i have to find the 'hotel_code' that having 'Parking' and 'AC' both facilities ie 'hotel_code' as … |
| | Hi guys. I have previously been developing a Java application using 2 Windows Vista PCs that both have MySQL as the database. I have always created a user for each PC (specifying their IPs as allowed hosts to connect) on the other and then in the application the code for … |
| | I need to restrict access to other table id's by making a check against an (id) of a table named users and then check that the (user_id) of another table is the same i.e table1 id username password table2 id somedata user_id if table1 id is the same as table2 … |
| | I have been searching for ways to do this but I was not able to find any. What I want to do is this: movie_genre (Table) movidId movieTitle movieGenre (Varchar) 1 Copying Beethoven (2006) Biography 2 Copying Beethoven (2006) Drama 3 Copying Beethoven (2006) Music movie_plot (Table) movieId movieTitle moviePlot … |
| | Hi there, Noob here sry. Mysql DB 1. How can i insert an H1 tag <h1>Listings</h1> to a table structure as field ? A functional H1 tag. 2. How can i insert or import a nationalities csv file to a table ? Thx a lot and happy new year!! |
| | I'm trying to run a date range query which works, but I also need to get data outside of the date range inside of the same query which I get to work. The issue I'm having is when the start date is in say 2011 and the end date is … |
| | I am a programmer and i use 64-bit windows 7 as my OS and i need a free localhost server i can work on my PHP and perl on. I also need it to have MySQL PHPmyAdmin. If anyone has any ideas, please let me know. Thanks :D |
| | hi guys, thanks for viewing my thread. i have a program in java application and i want to connect to mysql database because i need to use database for a few parameter.the result will b showed in web-page using php. my question is how can i connect my program to … |
| | I am displaying data from an sql database in a textarea which will be altered by the user then re-submitted to the database. The problem is displaying a line break. I get <br /> displayed in the textarea rather than the newline. Can anyone help? |
| | Hi!, I have a contacts table in MySQL and I want output in a select menu. Problem is, some rows dont have any record in it, and it is displayed in very odd way as it outputs blank fields and some data in between. My overall code is: [CODE]<?PHP $query=mysql_query("SELECT … |
| | Can anyone tell me if I am going in the wright direction with this, or if there is a better way, I am trying to create a session check so that if logged in clients change the url id number example.com?id=192 it won't show other clients contents. Its the first … |
The End.