7,368 Topics
 | |
| | 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 … |
| | 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, 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 … |
| | 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 … |
| | |
| | |
| | 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? |
| | 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 … |
| | I am getting this error, and dont know what I should do to fix this. Column 'uptime' in order clause is ambiguous uptime = date uploaded set to NOW My Query: $select = ("SELECT * FROM photo_album, video ORDER BY uptime DESC LIMIT 10"); Maybe I cannot call a query … |
| | I'm building a local database with VS.Net, using C#. I have constructed the database and filled it with data. I've already been through the process of connecting to the \bin copy of the Db and setting the file to "Do Not Copy". Now, I want to design Views in the … |
| | Hi, can anyone help with formatting a date range query in MySQL? It's just a form to enter two dates, and a second page to run the query and show the output. The form looks like so: [CODE]<form id="getdate" action="tracking_result.php" method="post"> <table> <tr> <td> <input type="radio" value="single" checked="checked" name="type"/> </td> … |
| | Hi everyone! Is there a way to set a MySQL server to not automatically start execution until prompted by the user? I recently installed a MySQL server on Windows and I'm having a little bit of problem at start up. Everytime I go to the command prompt to type the … |
| | Hello all, I am new to MYSQL programming, although i have been working with MSSQL for a while now. I am using delphi on a project and the query below does not return any results, just cant find what is wrong with it Select Airwaybill, SDate, BLAccount, RCountry, PackageCodeDesc, TotalWeight, … |
| | [CODE]<?php $host="xxxxx.xxxxxx.com"; // Host name $username="xxxxxx"; // Mysql username $password="xxxxx"; // Mysql password $db_name="xxxxxxxx"; // Database name $tbl_name="xxxxxx"; // Table name // Connect to server and select database. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); // get value of id that sent from address bar $id=$_GET['id']; // Retrieve … |
| | A. Write a java program to do the following 1. Read text files from Directory 2. Use the xml tags on the text files to i. determine field names ii. extract actual value 3.write details of i and ii above into a database (eg. mysql) table. B. i. Read the … |
| | Hello, I'm trying to skip a line every 'x' queries that gets displayed. I can get the records to show but I can not skip a line every 'x' query shown. I've tried using javascript and php but can not get it to work. Can someone plz help or give … |
| | when i put this in phpmyadmin i get errors... can anyone look over it and find a mistake.. [code]CREATE TABLE Student { SID int NOT NULL default, SNAME varchar(200) NOT NULL default, ADDRESS text NOT NULL default, POST_CODE varchar(10) NOT NULL default, PHOTO mediumblob NOT NULL default, Primary Key (SID) … |
| | Hi, I have three tables as below. tbl1 [CODE]eid qnt pb 12 3 1 13 1 1 23 3 1[/CODE] tbl2 [CODE]tid eid fx so 1 12 0 1 2 13 0 1 3 23 1 1 4 23 0 1[/CODE] tbl3 [CODE]tlid tid eid fx 1 1 12 0 … |
The End.