10,940 Topics
 | |
| | I have 2 tables: 1. users - user_id(PK), firstname, middlename, lastname 2. user_shift_schedule - shift_code(PK), user_id(FK), effectivity_date I want to get all rows with the latest effectivity_date for each user_id. This is what I've got so far: [CODE]SELECT users.user_id ,users.firstname ,users.middlename ,users.lastname ,user_shift_schedule.shift_id ,MAX(user_shift_schedule.effectivity_date) FROM users JOIN user_shift_schedule ON users.user_id=user_shift_schedule.user_id … |
| | The error : syntax error, unexpected T_STRING But I checked all string objects and they worked separately.. [CODE]mysql_query("INSERT INTO downloadlogs(id, name, ip, time) VALUES('" . $Gid. "', '" . $nFile . "', '" . $IP . "', '" . date("l jS \of F Y h:i:s A") . "')")or die(mysql_error()); [/CODE] …  |
| | Dear All, I have a database with two columns, to keep several files of text with lots of text lines in each text: ----------------------- |---name -|- Text---| ----------------------- I want the column |-name-| to be a primary key, and to upload the text file I'm using the command: [CODE] LOAD … |
| | I have a MySql database that uses a time field to track when the entry was inserted. Now I want to query the table for entries by a time range. I would prefer to use MySql to extract the records instead of extracting all records then iterating and comparing time … |
| | Hi, I'm creating a form application using vb. I'm still new to this and I'm teaching myself via the internet so please don't be too mean. I wrote my code using queries that I created in visual studio. I don't quite remember how to create an update query and write … |
| | hello send me free download link of mysql for asp.net and how i connect it with asp.net |
| | How can i select the latest records from a table for each invidual equipment thats due calibration within 14 Equipment_id | Date_of_last_Calibration | Calibration_Cycle | Calibration_Due_Date test 10/02/2011 Annual 10/02/2012 test 10/02/2010 Annual 10/02/2011 test2 10/10/2011 Annual 10/10/2013 test3 08/02/2010 Annual 08/02/2011 I can select all records for calibration due …  |
| | HI There This is the error I am receiving when trying to register on the site: Column count doesn't match value count at row 1 error: failed to execute query INSERT INTO users (uname,uteln,umail,ustre,usubu,ucity,uprov,ucode,uuser,upass,uc_dt) VALUES This is the regi.php coding. I cannot figure out the problem <?php if (isset($_POST['register'])) { …  |
 | Hey Im looking to store date and time with miliseconds in TIMESTAMP column but it seems to be a new feature so Im not sure exactly how to store it. current_timestamp() doesnt allow me to do this. Im willing to change the column to some other datatype as the database … |
| | Hi, i'm doing a page where user can register and give up of a course: [CODE]<td width="5%"> </td> <td> PROGRAMAÇÃO: <br/> <?PHP $cc=$_GET['cod']; $sql_prog = "SELECT prog_curso FROM cursos WHERE cod_curso=".$cc; $query_prog = mysql_query($sql_prog, $connect); while ($row = mysql_fetch_array($query_prog)) { echo $row['prog_curso']; } ?> <br/> </td> <?PHP if(is_logged()) { ?> … |
| | Hi everyone, [CODE]select sql_calc_found_rows DIST_NO from acquired WHERE FOLIO_NO='l01917' And STAT_FLAG <> 'Matched' union select DIST_NO from transfrd WHERE FOLIO_NO='l01917' And STAT_FLAG <> 'Matched' LIMIT 0, 5; [/CODE] The above query takes more than 4.5secs if i run the query without sql_calc_found_rows the execution time is 0.7 secs [CODE]select DIST_NO … |
| | Hi all, My web application uploads files from MySQL database. I have the text in ms word *.doc files, so I convert it to *.txt as UNICODE-UTF8, and mysql table charset is set to UTF8. I load the database entering this command: [CODE] LOAD DATA local INFILE 'file.txt' INTO TABLE … |
| | Can anybody tell me where i can find the connection string for using on a asp.net form. I am trying to connect a mysql database to it, and wanted to connect a access database to test the main functions. But i am having a hard time finding any of these … |
| | Hi everybody, I found an error-based sql injection in my webserver.My database doesn't contain any private info. I want to know if its possible to own my server just by using the info in information_shema. Please tell me because i want to know if i have to fix it.I don't … |
| | Hey all, I'm trying to show some concatenated data in a CheckedListBox so that users are able to select the data for use later on. Here is the code I am using currently: [CODE]Dim con As New MySqlConnection Dim theQuery As New MySqlCommand Dim theTables As New DataTable Dim theAdapter … |
| | Ok over the last several weeks i've been building a website for fun. Its basically a forum site, with topics and comments. I use queries in their basic form. Now that i'm trying to protect my site I'm getting the impression that i have to rewrite all of my code. …  |
| | [CODE] <?php // Duplicate entries remover from database // task :: load url check if more than 2 entries exists replace it with new entry session_start(); // no time limit set_time_limit(0); // connect to db include ("config.php"); // select data from database target woth and domain table $result = mysql_query( … |
| | Hi All, I'm copying a long text from word and pasting into a html textarea and from here I send it to MySQL database. If the submited text is too long nothing happens. Any ideas on how to submit a large amount of text from a webpage to a MySQL …  |
| | Hey guys...I have a MySql table like this. and [B]Grade [/B]column is a derived attribute. and it is based on [B]Marks[/B]. u know the basic thing. [CODE]create table Enrolled( student_id char(14), subject_code varchar(10), marks int, grade char(2) );[/CODE] I want to fill the [B]Grade[/B] column based on each student's marks. …  |
| | I am new to mySQL and is not sure where to start from. I have a database of username, password, date of creation, active/inactive (1 and 0), name and etc... I would like to know how I can add a field that involves with counting down the days. Say for … |
| | i got this error when i trying to submit a form.. 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 'order(firstname,lastname,email,address,city,postalcode,country,totalprice,paymen' at line 1 appreciate if you could assist me.. [CODE] $sql2= mysql_query("INSERT INTO … |
| | in the diagram provided in the attachment.i have created a table for the entity loan and now i am facing difficulty in creating a table for payment.i know that payment is the dependent entity.is the following way of creating a table correct???? create table payment( payment_number int, payment_date date, payment_amount … |
| | Hi, Can anyone please tell me how to log all activity of my mysql database. Also do you know if there any tripwire services/products that are available ? Thanks, |
| | Hi guys. I have a table as follows: [ICODE] ID | Data ---------------------- 1 | A 1 | B 1 | C[/ICODE] It is possible to make like this one. [ICODE]ID | Data1 | Data2 | Data3 ------------------------------------------------------- 1 | A | B | C[/ICODE] Thanks. |
| | Am having a hard time printing all record percent in my db my sql statement [CODE]$query="SELECT *, duedate,(TO_DAYS(duedate) - TO_DAYS(CurDate())) as difference FROM vehicle_info ORDER by svreg"; //$query="SELECT * FROM vehicle_info WHERE id='$id' ORDER by vreg"; $pager = new PS_Pagination($conn,$query,10,10); $accra = $pager->paginate(); while($row = mysql_fetch_assoc($accra)) { $id = $row['id']; … |
| | Hi everyone, I'm new to mySQL. I have a table like this one: [ICODE]+-------+-------+-------+ | date | plant | value | +-------+-------+-------+ | date1 | 1 | 10 | | date2 | 1 | 12 | | date3 | 1 | 15 | | date4 | 2 | 30 | … |
| | how can i select all records from a table where a future date column is less than 14 days away within a php table. somthing similar to? [CODE]SELECT DISTINCT FROM table WHERE 'Date_Column' <14 days [/CODE] Thanx In Advance KeeF |
| | Hi, I have attached a printscreen version of my excel template here, Now I just want to know, using vb.net code, on how can I import this data from a specific cell, including the header itself so I can insert it into mysql database. Thanks |
| | I need to select data available between 20:00 and 08:00 (8 PM to 8 AM). How do I achieve this? The column is of type TIME. |
| | how can i rearrange the name by the miles sorting smallest to biggest [CODE] $result = mysql_query("SELECT * FROM directory WHERE category = '$category'"); while($row = mysql_fetch_array($result)) { $latd = $row['latitude']; $lond = $row['longitude']; $name = $row['name']; $theta = $lon - $lond; $dist = sin(deg2rad($lat)) * sin(deg2rad($latd)) + cos(deg2rad($lat)) * … |
The End.