10,940 Topics
 | |
| | Hi Friends, I want to search a table with 25 columns using multiptle fields, i.e. Multiple column search Please help me with the query, i have tried using AND but no luck Field to search 1.Date 2.Name 3.Surname 4.Fathername 5.MotherName Rgrds Sachin |
| | [CODE] private DataViewManager dsview; private DataTable dtgen; MySqlConnection myconn = new MySqlConnection("server=localhost;database=octupus_db;userid=root;password=sys"); MySqlDataAdapter sqlgender = new MySqlDataAdapter("Select * from gender", myconn); MySqlCommandBuilder comgen = new MySqlCommandBuilder(sqlgender); sqlgender.TableMappings.Add("gendermapping","gender"); DataTable dtgen = new DataTable("gender"); sqlgender.Fill(dtgen); cbxgender.Items.Add(dtgen.Rows()"sex".ToString); [/CODE] My problem looks simple, but i cannot crack it. I have connected to my DB, … |
| | Hello! I need your help again... thanks! I have a table where I need to insert the same value in all rows and dont know how to. Table: equipment, Column: available How can I enter a number 1 in column "available" in all rows? Thanks again! |
| | Hi all, can someone help me here - I ave a regisration script where I am uploading an image to mysql, The problem im having at the moment is this..... The script creates a new folder by using the mysql_last_id function as shown below - The problem im having is … |
| | Hi all, thanks for reading my post ) My name is Yuriy Horobey, I am developing web for more than 10 years. There are some same geeks like me arround me, so I am forming my company, registering it and searching for partners. What do we offer? -- Full cycle … |
| | I have memebrship system with mysql database. In the table I have comumns named Username, password, information... I have to found the row with the username who have logged in and put the text from information column in textbox... |
| | Hi all I'm trying to learn php by myself I got as far as creating my first data base and table using the following code: [code=php]$con = mysql_connect("localhost","root",""); if (!$con) { die('Could not conect: '.mysql_error()); } //Create database if (mysql_query("CREATE DATABASE FATBYTES",$con)) { echo "Database created"; } else { echo …  |
| | Hy sorry for my bad english I have transaksi_pembayaran table and have a tgl_tran field, tgl_tran is a date but has type varchar, how can I get date range in mysql? date range like this : 14/2/2005 to 27/2/2005 (d/m/y) |
| | Hi, I have tested this and get no errors. However when i am updating a mortgage record for a client it changes the client id?? So if i am updating a mortgage for clientid = 1 Test Case and Mortgage ID = 1 once i click update in my php … |
| | I create my code on my own machine and tested it on my own machine and everything worked perfectly fine but as soon as I uploaded it to my server it seems to have stopped working. None of the code has been changed except for the database user, pass and … |
| | Hi, I have page that allows the user to search using a "date range" AND "location". I'm able to do this individually. Its like, if the user searches using the date range (from begin date to end date) the results show. Then if the user searches using a specific location … |
| | hi! I have a table which contain files paths. my problem is, that when I insert a path, MySQL omit the separator char. for example: INSERT INTO A VALUES ('C:\qqq\www\eee.ttt'); will be saved in A as: C:qqqwwweee.ttt what can I do for saving the path as it is? (ofcourse, I … |
| | G'day, I've got a table [CODE]CREATE TABLE IF NOT EXISTS `attractions` ( `attID` int(11) NOT NULL AUTO_INCREMENT, `attName` varchar(255) NOT NULL, `adultPrice` double NOT NULL, `childPrice` double NOT NULL, `referenceID` varchar(255), PRIMARY KEY (`attID`), KEY (`attName`) ) ENGINE=InnoDB;[/CODE] Now my initial set up was that [B]referenceID[/B] was linked to [B]attID[/B] … |
| | Download.php not working.. i was just making a download.php file which accepts the song_id from the url and fetch it from database.. example: download.php?id=111 this will download the song with id=111 from the database.. but the song is not being downloaded.. no response just blank screen. the details i am … |
| | Hi, i'm trying to setup a connection in dreamweaver. so now I have the diologbox open with the different fields I have to write in. First no problem with the: connection name, mysql server, user name and database fields. But when I get to the field password, I don't really … |
| | I need to merge to identical tables, but one column (areas_sub_local_obj) has a reference to the Id column (Primary Key). I need a script to insert the data from table 1 into table two and to change the value in the column areas_sub_local_obj to the new Id that corresponds to … |
| | Am to develop an application (MIDP) running on mobile phone which can connect to database through a servlet and returns exams available in MYSQL database and stores it in a RecordStore and finally lets the user to pass an exam and view results after finishing exam. So please help me …  |
| | hi guys! i need ur help because im noob at web programming.well.. i would like to insert formatted text (html) in the mysql database and retrive it to a page. do i have to save text with all tags? what is the best way to do that? example: i hav … |
| | Hello All, I am a new Ajax learner... i am trying to do one simple script to handle the following.. Adding, deletion and modification of records in one mysql table using php and Ajax. I have created following code so far... if anyone could lead me to a better simple … |
| | I'm having a problem creating a dropdown list and populating it with information from a database. When I display the page below I get this PHP code displayed in place of the drop down menu: " \n"; while ($row = mysqli_fetch_array($result)) { $str .= '' . $row['systemName'] . ' ' … |
| | Hello everyone Im new to this forum as well as new to MySQL. Ive read countless forums about using blobs and referencing. Im the type of person who learns by seeing. I kinda understand the referencing but I would like to see an example if I am doing it correctly. … |
| | Hello everyone! This is my first post, been a long time reader though. First of all, it's been a while since I don't program and I'm rusty (very). The problem is: I just can't learn how to use the JOIN or UNION commands, everything I read is confusing. I'm simply … |
| | How do I get data from mysql and send it to Excel and have it update every 30 minutes using VB2005? Thanks for any help! |
| | So I went to mysql docs to check out if they had info on what to do. I found this [QUOTE] “[0-9]*” matches any number of digits, and “.*” matches any number of anything.[/QUOTE] So, I tried them both out & have no result that back back. The query I … |
| | I have an application written in JSP running in Apache Tomcat Server and back end is MySQL and m having problem in my code tried many things like creating a .bat file but dint got a code to run .bat file from jsp page. Also the following code i tried … |
| | Hi, I'm creating a simple analytics script to use on my website(s). I started of very simply by just creating a new record for every session, and updating the sessions (i.e. incrementing the number of pageloads for that session) when a new page is loaded. I also save the browser/version … |
| | hi! I hope this is the place for my my question: I work on a file tagging system. I write it in java and use MySQL as my DB. I have a table that contain only one field: file's path. when directory is renamed, it's path changes. and that's mean, … |
| | hi, Is there any sql query to check if a table exists already in a database? Thanks in advance.:) |
| | Hi all... I've been teaching myself PHP and MySQL for the past few weeks so I'm pretty new at it. But this question has more to do with javascript (which I have been using for some time) than it does PHP. I am letting the user enter a date into … |
| | #include <mysql.h> and [code]//try to make connection to database MYSQL *connection, mysql; MYSQL_RES *result; MYSQL_ROW row; int query_state; mysql_init(&mysql); connection = mysql_real_connect(&mysql,"http://1.1.1.1","user","password","database name",0,0,0); if (connection != NULL) { cout << "database connected \n"; }[/code] this code gives me 1>main.obj : error LNK2028: unresolved token (0A000294) "extern "C" struct st_mysql * … |
The End.