11,093 Topics
 | |
| | Ive been looking around and havent been able to find anything like this yet.. I am new to mySQL. Im looking for a function like the "where" function of a query string.. but insted of it being exact i would like to select "where" datafield "contains" text.. example.. item is … |
| | this is my table: [CODE]CREATE TABLE IF NOT EXISTS `artikulli` ( `id` int(11) NOT NULL AUTO_INCREMENT, `autori` varchar(100) CHARACTER SET utf8 NOT NULL, `perkthyesi` varchar(100) CHARACTER SET utf8 NOT NULL, `category` varchar(100) CHARACTER SET utf8 NOT NULL, `titulli` varchar(350) CHARACTER SET latin1 NOT NULL, `nen_titulli` varchar(400) CHARACTER SET utf8 NOT …  |
| | i.e char fullname[80]; char * prt; [U]in MySQL we can write : select * from table1 where name='fullname'[/U] How to write in C++? while(fullname!=NULL) { executeQuery"select * from table1 where name='"+fullname+"'" }//----I tried this, but dont work. need your help please。。。。。 |
 | Hello evryone. I am new to PHP and MySQL. I have created an admin area for where selected people can add, delete, and edit data from a database. I have managed to get the add, and delete to work, but I am stuck with the editing. Can you help? [CODE]<!DOCTYPE … |
| | I tweaked a search script I found months ago, and am now getting back around to fixing it... I need some help debugging it... [code] if(isset($_GET['search'])) { $search = $_GET['search']; } $search = trim($search); $search = preg_replace('/\s+/', ' ', $search); $keywords = explode(" ", $search); $keywords = array_diff($keywords, array("")); if … |
| | Hi guys, I am working on progamm about reading some words in MySQL then display the results during run time command.But my code keep giving some MySQL errors about I can't read it. Am I making some mistakes with sequence? I am pretty new in C++. [code=cplusplus] //---------------here is code … |
| | Hello Every one, im in a need for some help i have the following issue : ---[B] Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\Hosting\00000\html\index.php on line 10[/B] this is what the code looks like Can some one please assist me on what is wrong …  |
| | Please tell me can we insert data in multiple table with single query in mysql. For example i have two table with name `table1` and `table2` and fields in `table1` are 'id' auto incremented and primary key, second field is 'name' data type varchar of 25 and another table `table2` …  |
| | hello dear friends i installed visual studio ( full installation) then i got xampp from their site i have mysql and apache running i downloaded the connector from mysql site and i created a simple project to check if i can connect to mysql or not i have made this … |
| | Hi there! I new learner in Python. And just couldn't get threading. I wrote this script. [CODE] import sys import MySQLdb if len(sys.argv)!=3: """the program name, mac and ip makes three""" """stop program and send error""" sys.exit("Must provide mac and ip!") mac = sys.argv[1] ip = sys.argv[2] print 'Connected to … |
| | hello I am inserting records into a MYSQL table via a loop Records are being inserted, but every now and then the program bombs out with the below message There is nothing wrong with the query line though (If i restart the job, this record will be inserted without issue) … |
| | Hi guys, Ok, so I'm using the code below to display the fields from a table on my webpage. I used some code to paginate the results as there's a lot of records, however I can't seem to get it working properly, and I'm going crazy trying to work out …  |
| | Hello, When trying to use mysqldump, I got this error message: [QUOTE]mysqldump: Got error: 2003: Can't connect to MySQL server on 'localhost' (10061) when trying to connect[/QUOTE] According to the MySQL Documentation Library, error 2003 means that my network connection has been refused and that I should check that there … |
| | is it posible to increase a mysql table default value to increase by a number based on another number E.X. i have a default value set to 10 how do i increase it by 1 every 3 minult also if i add a new number "3"(in a box or text … |
| | i have a data in mysql in this format.. 1,2,3,4,5,6... can i split and show this data in this format in mysql?? 1 2 3 4 5 6 thanks ijn advance |
| | Hello, Being on Access, I would like to transfer some data onto Mysql. But I cannot. Is there an easy way to transfer data onto Mysql? I am thinking that it should not be that hard to do. Thanks for your help.  |
| | Hiiiii, In my code i have to open mysql connection on all forms, but i dnt wnt to do that, actually i want at the time of log in I connect to datav=base & open connection then use this open connection on all forms and when i logout then close … |
| | I have database with a table called orders. The structure is below Index, OrderIndex, OrderNo 111, 1 112 , 1 113 , 1 114 , 2 115 , 3 116 , 3 I want a query that will loop thorugh the database and make the result Index, OrderIndex, OrderNo 111, … |
| | I Want transfer updated data between 2 Database MySQL that One of them is in the server Host and other is over localhost . Now What should I do? I'm waiting for your answer |
| | I'm running as mysql root user on my system. I can select load_file('/etc/passwd'); no problem But when I try to select load_file('/var/lib/mysql/mysql'); I get NULL as a result why? this file is good, I can cat it as root and view the mysql user data, why cant mysql load_file it? … |
| | |
| | I've got a database which is getting quite large and slow to query. I only really need the last month of entries for most situations so I'm looking to create structure-copies of two of my tables and then regularly move data from the 'live' two into the 'archive' two if … |
| | Can someone help me with this please? I’m playing with a stat tracker, and with the code snippets below I’m trying to get the total result for each page stored in the database. The problem is that I get this warning when I run the script: [B]Warning: mysql_result() expects parameter … |
| | Hi Every body Once again I'm in problem and want some help from you all I have written a small code to search a particular value in MySql database and then to display the record based on that value - Like to search a Employee code in database and then … |
| | Dear Users, I have used SHA1 encryption method to encrypt password and stored in login table as a blob field. Now, to authenticate the password, i need to decrypt it. I am not able to decrypt. Please help me to decrypt password  |
| | Can I store a photograph in a mysql table. ? What type it takes...how it is done. Do i have to store only the path??? please explain me. |
| | Hello and bonjour everyone I need a bit of hand-holding (pseudo-code) on how to go about accomplishing this task and will appreciate it if you could find 1 or 2 minutes to guide me through. Basically, i need to extract some information from database (different columns) and display it in … |
| | I've been working at this most of the day, trying to figure out how I can accomplish this sort of form, even looking through countless sites for anything vaguely close to what I'm trying to do for help on logic or syntax behind this (to little to no avail, of … |
| | I am designing a database system to store salary information. It includes different tables (salary,personal info , ect) I want to make it use for different companies. Also i want each set of data to be separated. (by company wise). (i.e. i dnt want all the employee names of every … |
| | hi everyone, I've written some code that displays information from a database. However, I added more code that would display a "no records found" message, should the area be blank. The code displays the records perfectly, however if there are no records returned it doesn't show the "no records found" … |
| | Hi all, I have a column in my table that auto increments as a counter as new records are added. I would like to renumber the entire column and have it start at 6000. Can anyone suggest an sql line that would allow me to acomplish this? Thanks in advance … |
 | i made a registration script but i dont know how to make the whole website and all its directories protected please help. |
| | [code] private void SubmitActionPerformed(java.awt.event.ActionEvent evt) { try { Statement s = con.createStatement(); Statement s1 = con.createStatement(); Statement s2 = con.createStatement(); Statement s3 = con.createStatement(); ResultSet rs = s.executeQuery("select MAX(Guest_ID) from Guests"); rs.next(); int maxGuestID = rs.getInt(1) + 1; //s1.execute("insert into Guests values(" + maxGuestID + ",'" + txtUserName.getText() + "',' … |
| | ok i can post the script if you guys want its kinda on the large side mostly i just need to bounce some ideas off you i made a event calendar and now i am making a script to email users of the current months events i have this working … |
| | Hi everyone, I am tasked to alter the front-end of the database and have been given the whole wad of PHP files and also an .SQL file. My question is, Why i cant see any changes to the database front-end when i change the .sql file. (I tried creating a …  |
| | |
 | Hi everybody I have been developing windows client application in .net framework 3.5. The system is supposed to copy the remote mysqldb and restore my local mysqldb with all the schema and data withing remote schema to my local mysqldb with the same database name. Well i found a solution … |
| | Hello all, Is there an easy way to edit the order of my colums in a table? Presently, my colums are: cust_num, name, email, location, bday_day, bday_month, bday_year, state I would like to list the "location" column after "state". Can anyone offer a simple suggestion. Thanks in advance. C- |
| | when I try to create a new mail account in my mail broadcast control center I get this message: SQL error: swd_act : ERROR: 1146 - Table 'craftyartsalesmailcatcher.swd_account' doesn't existContent-Type: text/html; charset=ISO-8859-1 SQL error: INSERT INTO swd_account (`isact` , `name`) VALUES ('1' , 'swd_act') : ERROR: 1146 - Table 'craftyartsalesmailcatcher.swd_account' … |
| | IN MySQl Stored Procedure how to pass Parameters with parameter name and values i.e. [code] DELIMITER // CREATE PROCEDURE GetOffice (countryName VARCHAR(255), countryId int(11)) BEGIN SELECT city, phone FROM offices WHERE country = countryName AND country_id = countryId; END // DELIMITER ; CALL GetOffice("India",1); [/code] This works fine but i … |
| | Hi all, 1) Users can belong to a specific group wherein when the group moderator publishes an event, its visible to all the members of group. 2) A normal user can publish event in his own calendar, to make that event visible to all users in group, the group moderator … |
| | I am trying to create a page that will look up values from a table to fill in drop down boxes, i have this working. Now when the user selects options and presses a button i would like these values to get written to a table. This code is my … |
| | Hi, I have a question regarding a SQL query. I am a complete noob, so please do not make fun of me. Here is a schema that I created: [code] JOURNALS(j_num, j_name, j_subject_area, chief_editor_r_ssn) ISSUES(j_num, i_num, i_date, i_num_pages) RESEARCHERS(r_ssn, r_name, r_address, r_phone, r_institution) ARTICLES(art_num, art_title, art_area_topic, art_abstract, j_num_submitted,date_submitted, j_num_published, i_num_published) … |
| | Hi, I am trying to transfer some data from a Mysql database onto a Microsoft SQL database. I would need your help on how to operate this migration as I am new to MSSQL. I have been looking on Google but there are not a lot of pages on that. … |
| | Can someone please help:(. I have a database with a field Date. I made the datatype to Date. But when I code the date in php I use the date() function to get the current date it donesn't want to insert in the database. Please help. For example my code. … |
| | Hey, This is my first post so go easy :) I’m in the middle of designing a website users can download files from. I’ve searched the web and found the perfect example of what I’m trying to achieve which is something clear and simple ([url]http://www.getfreefonts.info/free_fonts.a.html[/url]) From the category’s at the … |
| | hi, I have created 2 tables called "User_Info" & "Auth_Users". In "User_Info" table "ID" is the primary key. In "Auth_Users" table "ID" is the foreign key. I have created a "User Form" through which I am trying to capture the data. Since the primary key is an auto_increment value I … |
| | create a query that will display total no of employee and no of employee that hired in 1995,96,97 from employee table.. my employee table have field like emp_id name hire_date. |
| | Running php/mysql site where the db is constantly being changed with new products added, categories and prices changed all through php scipts. Just before it publishes the results to a static html file, there is a (my)sql file with product data that has been held "off table" so it cannot …  |
| | Hi there, here what my problem is - I'm trying to get data from MySQL database put in on global array and make calculation. The data in the MySQL table is 3000 rows and 2 columns. The type of data is double and date Here is the code: [CODE] #include … |
The End.