10,944 Topics
 | |
| | GOOD DAY. Is there any application that would convert my MS Access database to MySQL? It takes time for me to reconstruct my tables in Access to MySQL. If there is/are application that would make my work easier, please let me know. Thanks |
| | Hi Everyone, I have been trying to understand mysql a little further - with some small steps in the right direction. but I have come across a problem I am unable to fix / get working. I have a form, that has a variable $country - I am trying to … |
| | So I've got this piece of code: [CODE=php] /* BEGIN ZENDINGEN */ $zendingheader = mysql_query("SELECT z.ID, z.Bestemming, z.Datum, m.Aantal_Duiven, s.Aantal_Manden FROM Shipments AS s JOIN Zendingen AS z ON s.Zending_ID = z.ID JOIN Manden AS m ON s.Mand_ID = m.ID WHERE z.Actief = 1 order by s.Aantal_Manden, m.Aantal_Duiven ASC LIMIT … |
| | I am trying to create at user search for my website and I'm not sure where to start. My table name is users with user_id, user_name, name I'd like to be to search and have a page come up with the top 5 closest results. Sorry if this question has … |
| | hi friends.. I need an alternate query without using UNION for below query.. [CODE]select DIST_NO from acquired_tbl WHERE FOLIO_NO='l01917' And STAT_FLAG <> 'Matched' union select DIST_NO from transfrd_tbl WHERE FOLIO_NO='l01917' And STAT_FLAG <> 'Matched'[/CODE]  |
| | 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']; … |
The End.