11,093 Topics
 | |
| | Good afternoon. I was hoping to get some query optimization tips. I am writing a php script to retrieve data from a mySQL database. Table A, which contains most of the fields that I need, contains just under 11,000 rows. Table B, which contains 3 fields that I need, contains … |
| | 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 * … |
| | I have a problem working out how to return users data when the user logs in. It needs to work so that when any user logs in only their data is shown. This is the current table structure; I have three tables set up; 'Users' 'Profile' 'Linkingtbl' The 'Users' table … |
| | How do you set database timezone for MySQL database? I tried: ALTER DATABASE SET TIME_ZONE = 'US/Eastern'; and it's not working, i get this error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to … |
| | Hi guys, I'm fairly new to PHP and mySQL, using a book to help me learn. I want to create a small site to help me improve my skills, but I'm a bit stuck on the database design part. I want to be able to list various public companies and … |
| | Hi, I can't seem to work around the problem. If someone could please point me in the right direction for why the login.php page reloads when I enter the correct empid and password from the database. here is my code: [CODE] <?php require_once("nocache.php"); if (isset($_POST['submit'])) { $id = $_POST["empid"]; $pword … |
| | Hi everyone, that's my first post in these MySQL forums :) In college they gave us a E/R in order to make it on MySQL Workbench and I'm not sure if it is OK. If you could help me it'd be great :D Because I started with MySQL just a … |
 | Hello, Anybody knows about Relational Database Primer. Is there any difference between Relational Database Primer & Relational database? What is the concept of Relational Database Primer? |
| | 1)CREATETABLEProject( ProjectNovarchar2(5)notnull,ProjectNamevarchar2(20), StartDatedate, FinishDatedate,PRIMARYKEY(ProjectNo)); 2)CREATETABLEAssignment( StaffNonumber(3)notnull, ProgramNovarchar2(4)notnull,PRIMARYKEY(StaffNo,ProgramNo), FOREIGNKEY(StaffNo)REFERENCESStaff(StaffNo), FOREIGNKEY(ProgramNo)REFERENCESProgram(ProgramNo)); 3)CREATETABLEStaff( StaffNonumber(3)notnull, StaffNamevarchar2(10), SalGradenumber(2)CHECK(SalGradebetween1and12), YearsExpnumber(2), ProjectNovarchar2(5),PRIMARYKEY(StaffNo), FOREIGNKEY(ProjectNo)REFERENCESProject(ProjectNo)); 4)CREATETABLEProgram( ProgramNovarchar2(4)notnull, Titlevarchar2(20), Languagevarchar2(20),PRIMARYKEY(ProgramNo), CHECK(Languagein('VB','JAVA','ORACLE','C','XML'))); for the code above, what type of integrity constraints will be on them? (how many do u think?) also; i've created this code (below) but there seems to be …  |
| | am new to php. my question is: i have 5 items in adrop down list box . i have items related to that list in mysql database. i want to list those items in textbox from database when user selects an item from drop down list box. example; i have … |
| | hey guys, im doing a databases project and im a little stuck this statement wont work(its part of a jdbc) and i get the following error messahe, any suggestions as to why? [CODE]stmt.executeUpdate("CREATE TABLE LOCATION (" + "serial VARCHAR(10)," + "notice TINYINT(10),"+ "intransit ENUM('T','D')," + "dtnoticeissued DATETIME," + "lat NUMERIC(8,4)," … |
| | Hello there, I've been having problems creating a part of my mail system that makes messages look red when they haven't been read, and white when they have been read. This is what I'm using right now [code=php]mysql_query("UPDATE Mail SET Read=1 WHERE ID={$messageID}");[/code] The SQL ID Field is a smallint … |
| | hi everyone i had been working on a project using random files (.dat) and now i want to change it to use a database instead. the thing is my project is quite long and it would be a hassle to go and change code. i had used hash tables to … |
| | I'm having this issue displaying the results I need. The issue is that I cannot condense my results and end up with extra. The code I currently have is below. [CODE] SELECT category.*, content.* FROM `category` LEFT JOIN `content` ON category.categoryid = content.parentid WHERE category.parentid = 1 ORDER BY category.title … |
| | Hi Friends, Kindly help i am using list menu i.e day month year i can get the data using the echo, and how do i insert the data into MySQL in DAY-MONTH-YEAR for example: i want to insert 10-MAY-2010 Regards Sachin |
| | I have this very weird project that my boss gave me. Given my cws.sql file inside "C:/", i need to create a batch file wherein it will automatically create database cws; and use cws; in MySQL Server. Hope Someone can help me. :'( |
 | Hi all... I am a developing a website using a joomla. I need to display a content but the should filter according to the date. I need only display content which are in between current date and before 30 days. my current mysql quary is SELECT * FROM events WHERE … |
| | Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:\xampp\htdocs\phplogin_v2.3\register.php on line 108 Insertion Failed: The Code [CODE]include 'dbc.php'; $err = array(); if($_POST['doRegister'] == 'Register') { /******************* Filtering/Sanitizing Input ***************************** This code filters harmful script code and escapes data of all POST data from the user submitted form. … |
| | Hello everyone! Okay so i am quite far into my website and suffering a annoying problem. What i want the code to do is to get all the achievements from the table 'achievementsList' and then match the ones that are in there with the ones that the user has. The … |
| | Hello.. i have this problem.. im doing some kind of late static binding. im really a new to this and don't know how to solve this problem. please help me to solve it... What i want to do is instead of using `static:: $arr[0].",".static:: $arr[1]` i want to iterate though …  |
| | I am developing a web page which retrieve data from a seperate mysql server on the same network musql_connect('192.16.1.2:3306', 'root', '123'); but ana error shows Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on '192.16.1.2' (13) in /var/www/html/index.php on line 3 the 2 servers are on 2 different virtual network … |
The End.