10,946 Topics
 | |
| | Hey I have to make statistics to call from base I have for example one line of [CODE]<p>Mesna zajednica <select name="mesto"> <option value="donji_grad">Donji Grad</option> <option value="karadjordjev_dud">Karadjordjev Dud</option> <option value="plavinac">Plavinac</option> <option value="seone">Seone</option> <option value="ladna_voda">Ladna Voda</option> <option value="lestar">Lestar</option> <option value="zlatno_brdo">Zlatno Brdo</option> <option value="slavija">Slavija</option> <option value="papazovac">Papazovac</option> <option value="carina">Carina</option> <option value="sveti_sava">Sveti Sava</option> <option value="25maj">25. … |
| | hello how can distinct data of select mutiple column having repeated data. example id name city locality 1 deep b 11 2 rohit b 11 3 deep c 12 4 mohit c 11 5 rohit a 13 6 moni a 13 from above table, what query i used to fetch … |
| | Hi, i recently found an sql injection vulnerability on a server, In the db, there's a table named users and inside there's the username: admin and password : ******* Is knowing this password enough to hack the server ? Thanks |
| | Hi I tried to insert russian language to mysql db but after inserting ,I am getting some strange things in database INSERT INTO table(adtex) VALUES('1с бухгалтерия 7 Cкидка 42% на 1С:Предприятие 8 базовые версии!'); Output adtex | +----------------------------------------------------+ | 1? ??????????? 7 C????? 42% ?? 1?:??????????? 8 ?? Plz guide … |
| | I have a time stored in table 8:00AM-9:30AM TTH . I want to check time range, if user selected 9:00am-10:30am Thursday comes in between time 8:00AM -9:30AM TTH? How to trap it out in php. Time is stored in table as below Time Day 8:00AM -9:30AM TTH 10:30AM -12:00PM MW … |
| | [CODE]include ("config.php"); // select data from database $w3db = mysql_query( "SELECT * FROM w3dbx" ) or die("SELECT Error: ".mysql_error()); $worth = mysql_query( "SELECT * FROM worth" ) or die("SELECT Error: ".mysql_error()); $w3db_rows = mysql_query($w3db); $worth_rows = mysql_query($worth); // fetching data //while ($get_infox = mysql_fetch_assoc($resultx) && $get_info = mysql_fetch_assoc($result)) while ($get_w3db … |
| | For a couple of months now I've been working on a community website; however I haven't got past the registaration because MYSQL can't connect to my HTML and PHP codes.Also my laptop treats .PHP documents as text documents and I can't open them, is this related? Thanks in advance :D. |
| | Can anybody tell me how many storage engines are there in MySQL and which engine is the default engine in MySQL? Kindly post answer if know it |
| | Hi All! I'm trying to read ms word documents stored in my dataBase in a BLOB column. However, concerning the encodings there are issues with characters. My web application can read the ms word documents the to an iframe with POIFSFileSystem without problems. [CODE] File docFile = null; [COLOR="Green"]WordExtractor[/COLOR] docExtractor … |
| | Hello! On my website I'm looking to create a dynamic HTML table from the contents of a MySQL database. I have no idea how many rows there will be, and I need it to look a bit like an iPhone home screen. Here is some code: v1: // Make a … |
| | I was browsing a MySql database using phpMyAdmin and I have probably inadverdently changed a setting. I have a field which contains quite large text entries. Before this problem arose the display showed just a few words of the text entry followed by a "...". Now the display shows the …  |
| | Hi, I'm currently working on a school project ..i was wondering if someone can help, i'm creating a system which get's data from a database and creates a CSV file ..i Google a lot none of it helps, i want to get several rows from a table and write it … |
| | 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']; … |
| | 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)) * … |
| | hi guys. i hav this drop down menu, which i need to populate with data from one column of a particular table of MySQL dbase. i hav read a lot on this, but have not been able to come up wid any code. any and all help in this regard … |
| | Hello, I want to create a favorites option for something I am working on. I have two tables. The main table where the posts are kept called "place". [CODE]+---------+--------------+------+-----+-------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------+--------------+------+-----+-------------------+----------------+ | id | int(11) | NO | … |
| | *********************************************** select * from table_name where RIGHT_CODE IN (SELECT GROUP_CONCAT(''',`RIGHT_CODE',''')as right_code FROM table_name GROUP BY `GRP_CODE` , `ROOT_DESC` HAVING count( `RIGHT_CODE` ) >=2 **************************************************** Actually the above query returns empty result. But the query Inside IN cluase which returns ('1','28').. If i directly pass the value inside IN clause means … |
The End.