11,093 Topics
 | |
| | I want to use asp.net membership in my website for login/logout functionality. I am using MySql ODBC driver for database access and I didn't find any tutorial regarding my problem. I found the same topic but for MySQL Connector/NET not for MySql ODBC driver as per my requirement. if it … |
| | I haven't used the mySQL permissions mechanism to any great degree & could use a little help while still at the design stage. Is it possible to grant certain users access only to certain RECORDS within a table (based on the value of a field in those records). If not, … |
 | Hello guys, how can to make correct query if in the typed values have a special chars (e.g. ' ") ? If the typed values have a one special char I know how to make the correct query, but if it have more then one special chars then I don't … |
| | [code]"SELECT tbl1.staff_ic, tbl1.staff_name, tbl2.dec_status,tbl4.location, tbl3.post,tbl3.grade FROM staff_detail tbl1 INNER JOIN staff_declare tbl2 ON tbl1.staff_ic = tbl2.staff_ic INNER JOIN staff_post tbl3 ON tbl1.staff_post = tbl3.num INNER JOIN staff_department tbl4 ON tbl1.staff_dep = tbl4.no ";[/code] isn`t my coding is right?? why when i execute my command just certain data are appear and … |
| | Hi all. I am writing a utility to manage virtual users on a mailserver w/ mysql backed. Unfortunately I am having performance issues when querying for the user's last access date/time. DB has this structure table [B]users[/B] [CODE]+------------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra … |
 | Hi All, I'm still exercising with that small PHP/MYSQL CMS of mine. I have a question that I need help from you guys. I see in many CMS like Drupal where there is loong articles let say 10 of them are displayed on single page. For some technique I don't … |
| | We have been using dbase4 in our workshop for all our database requirments for the last 12 years. for example our stores management, finances, salaries, challans, quotations etc. Now i want to upgrade to open source software, but i am quite unsure as to whether "mysql" will fulfill all my … |
| | I have an API parsing script, which inserts into the db more than 40,000 rows.and maybe due large numbers of queries getting fired continuously, after some specific time the script throws "MySQL server has gone away" error. I know the reason behind this error can be closed connection or any … |
| | Hi all, I tried to install DBD::mysql module in my MacBookPro 10.5.8. But it is ending with an error message that is fail to find out the mysql_config file. I installed the mysql system using fink command. It will be great if you can suggest a way to fix that. … |
 | Please could someone just clear up, or point me to the right thing to read regarding mysql and php. Once you have made a query and saved it to results, I understand that the query accessed with a number of functions to extract that, such as mysql_fetch_array() and so on. …  |
| | I am busy with a project for fun and I am finding it tricky to set balues for mysql queries. If I do the following: [CODE]function CalcPostByTime(){ include 'DB_connection.php'; $result = mysql_query("SELECT ztime FROM blogpost;");[/CODE] What is the simplest way to set an array, which will be a return value … |
| | Hi frnds... here i m doing search for my website... [CODE] $mcat='abc'; $query="SELECT * FROM news WHERE topic LIKE '%$mcat%' "; [/CODE] here , the problem is in my db table $mcat value stored as doublequotes ...the word itself having double qoutes.... the above query working for all other sarch … |
 | Hi all, The following code displays the form, but when i click submit, it empties all of the fields. I get no error messages at all. Im stumped [code] <?php include("includes/connectpdomysql.php"); if (isset($user_username, $user_password, $user_email)) { //Prevent SQL injections $user_id = mysql_real_escape_string($_POST['user_id']); $user_username = mysql_real_escape_string($_POST['user_username']); $user_password = md5($_POST['user_password']); $user_fname = … |
| | Dear all, I am trying to submit my data on a php created form to mysql database where it is separate by 2 tables (device) and (location). As some of the devices shared the same location, 2 tables are created as below. For location table, i had created 2 fields: … |
| | Hello! I need some help please.. i searched a lot, and tried everything... can someone help me please.. here's the deal: i have this select: [CODE]SELECT * FROM localizacao, cliente, dispositivo WHERE disp_id = clien_disp_id AND disp_id = local_disp_id ORDER BY local_id desc[/CODE] it's output: [URL="http://i.imagehost.org/0746/tabela.jpg"]http://i.imagehost.org/0746/tabela.jpg[/URL] but what i really … |
| | I’m going to demonstrate a very short and simple method of avoiding SQL Injection at the SQL query level. You’ll need MySQLi support, on Debian you can apt-get install php5-mysql will contain everything that you need, and would be installed by default with your LAMP Installation. Calling: [url]http://www.mynonexistentdomain.com/test.php?user_id=10&record_number=1[/url] Ignoring any … |
| | Hi all, I have a pdo connection script to mysql, which works fine. What im a little stuck on is that when i "include" the file, its connected, but how do i call the table to which my query is related to? The first snippet is the connection, and the … |
| | Hey all, need some advice. which would you say was more efficient i've checked the execution times of both scripts and they average out about the same tbh, just wondered if one way was a 'better' way of doing it. Code 1 [CODE=php] <?php $url_home = 'url'; $top_10 = "SELECT … |
| | I am a new SQL user and I have created my code but when I execute it I get this error : [COLOR="Red"]Msg 2714, Level 16, State 6, Line 1 There is already an object named 'Job_Title' in the database.[/COLOR] I do not understand why I keep getting this same … |
| | Hello, I'll preface by saying this is a school project. I just need to be pointed in the right direction. I'm trying to develop a database of books. In and of itself, that's simple enough, but I'm also trying to implement a tagging system following [URL="http://www.pui.ch/phred/archives/2005/04/tags-database-schemas.html#toxi"]this solution[/URL]. Where I'm getting … |
| | Hi, I am creating a website where users will be able to submit forms. In the form they will be able to submit text and uploaded images. With regards to uploaded images, once they are submitted, what is the best way to save them? Is it to a MySQL database … |
| | Hello ALL: New to the forum. I have run into a problem over the past 48 hours for which I can't seem to be able to resolve. I am running an Apache 2.0 Server, with PHP, and MySQL. All servers were working fine until 48 hours ago when all hell … |
| | Dear. everybody. when i progress the developing some functions using mysql db with vc++2005, i have the following problems i connected mysqldb and i runned the query to insert some records to my table in the DB, but i cant success in inserting. my sample code is followed as : …  |
 | As the title says, I'd like to select a certain number of rows from a table starting from a specified row. So for example, I have a table with 250 rows and the rows are numbered incrementally using a column called 'ref'. I now want to select rows 51-100. How … |
| | Dear. everybody. when i progress the developing some functions using mysql db with vc++2005, i have the following problems i connected mysqldb and i runned the query to insert some records to my table in the DB, but i cant success in inserting. my sample code is followed as : … |
| | I want to insert multiple records or update those records if 2 specific column values do not exist in a record. But the 2 values are NOT UNIQUE, so I can not use ON DUPLICATE KEY. I am trying to not use IF...Then statements. It seems to be bad programming … |
| | Hello, I have a piece of code that pulls data from a mysql database. I am displaying the results in a table but want to format the background of certain cells based on the query results (ie red for no green for yes). Here is my code: [CODE] $query = … |
| | Hi all, I'm a newbie in sql, please can someone help me out in constructing a query. What I want to achieve is to have filter/search menu with a list of the different options/optionsvalues that applies to a particular category of products and a count of the products that possess …  |
| | hi dear, i'm going to develop database that can access file in the user profile folder. but, i dun know how to create link in database mysql. i have 5 field in database.username,password,email and file. file contain link that access the file in file://C. i dont know how to do … |
| | While creating a DTS package i want to include a Stored Procedure with input parameters? Can any help in this. |
| | Hello people, Well The problem that I am facing is: I have a date in string format like 30 Jun 2009, how can I insert it into MYSQL table as DATE data type? I created the table and declare data type for Date column as DATE, when I insert 30 … |
| | While creating a userid the password is saved in type md5 in mysql The below script to change password does not save password in md5 in mysql and hence user after changing password cannot login The script also gives password chaged sucessfully but also says you have typed wrong password … |
| | I need to import TEST.TXT (located in the same directory as my script It has 1 Record: "6","Lunch","234" Iget this error message: Warning: mysqli_close() expects exactly 1 parameter, 0 given in C:\wamp\www\test\import.php on line 19 Why? Heres my script: [code=php]<?php // Connect to the MySQL server and select the corporate … |
| | MySQL database server is running on ubuntu. I have installed an GUI for everybody in office to access the database called Navicat. It uses ssh to access the database. It was working on almost everybody's machine week back. Now its not working on few machines and I am not sure … |
| | I'm building a few simple CMS variables into an Dynamic site that I half-built with Dreamweaver. The following code is the initiation of a paginated recordset display generated by Dreamweaver: [CODE]$currentPage = $_SERVER["PHP_SELF"]; $maxRows_creditsList = 6; $pageNum_creditsList = 0; if (isset($_GET['pageNum_creditsList'])) { $pageNum_creditsList = $_GET['pageNum_creditsList']; } $startRow_creditsList = $pageNum_creditsList * …  |
| | Could anyone lend some help? Trying to figure out how to do this in SQLite3 (this is mySQL) [code] CREATE TABLE car_contacts ( id INTEGER NOT NULL AUTO_INCREMENT, carriers_id CHAR NOT NULL, name CHAR NULL, phone CHAR NULL, phone_ext INTEGER NULL, fax CHAR NULL, email CHAR NULL, PRIMARY KEY(id, carriers_id), … |
| | I use MySQL and Turbo C++. I can connect correctly to the server but when I try requests on the server (like INSERT INTO or DROP TABLE), it does not work although it returns that the command executed correctly. Does anyone have an idea why this may happen ? |
| | Hi, Check out [url]http://www.landwatch.com/Land_For_Sale[/url] Notice the filters on the left column and how they all have the count of the entries within them. I am sure they are not calculating all these count at the run-time. They have these values stored somewhere and just retrieving the top 5 values. Not …  |
| | |
| | Why it won't send this to mysql.Connection is ok.Here is the code. [CODE]<?php $connect = mysql_connect ("localhost","root","") or die (mysql_error()); mysql_select_db ("login4") or die (mysql_error()); session_start(); $_SESSION['username']; $username1 = $_SESSION['username']; $username = $_POST['username']; $submit = $_POST['submit']; $micro = $_POST['micro']; if ($submit){ $queryreg = mysql_query(" INSERT INTO messages VALUES ('','$micro','$username') "); … |
| | i have to call Mysql Procedure from Php... I dnt know how it is work..!! Waiting for positive reply..!! :) |
| | [CODE] Newbee in php Below is my table and script, I know it should change the password I am using a registration application the password is saved in this manner 1d7d2fcc49f157c0be4456580011a58d469c71b6 I could not make out if this is a md5. I echoed the php, the password i type in … |
| | hi, can any one tell me how to i use my sql sever's databse itno ms sql 2008 server. I tried to to do dat with the help of mysql backup file & execute it on ms sql server, but there are some syntax related problems. please help me. thanks …  |
| | Hi, Basically what im looking to implement is a function where a user performs a search on my site, and is presented with the results and an option to be emailed similar items in future. I have all the search stuff done, but have no idea where to start on … |
| | How can I create a SQL Script using MySql? I already created a database and tables. I populated the tables and wrote queries to solve the questions in my homework. But the professor want me to submit the SQL script. Can anyone help me?  |
| | I need a bit of help with a mysql join query. I have tried and tried and keep getting unhelpful errors. I have two mysql tables: friends: friend1 INT friend2 INT members: member_id INT name varchar lname varchar Basically I want to loop through friends and find all records where … |
| | Hi all, The following code should link 2 tables, showing: student id, surname, firstname, study type, start year. However, its not :-). its just a white screen. ive got php5.ini with ERROR_REPORTING (E_ALL); in it but im still getting nothing at all. The tables definitly exist! have i missed something … |
| | HI GUYS, I HAVE A PROBLEM IN FINDING OUT AN INTERFACE FOR PYTHON 2.6.3 AND MYSQL-5.1.31. IS THERE ANY COMPATIBLE VERSION FOR BOTH THE ABOVE???? WHEN I RAN THE setup.py file of MySQL-Python1.2.2 version, i got the following error. -[COLOR="Red"]-------------------------------------------------------------------------- [COLOR="Green"]This script requires setuptools version 0.6c5 to run (even to … |
| | [CODE] <?php $host='localhost'; $user='root'; $pass=''; //establish database connection $conn=mysql_connect($host,$user,$pass) or die('Unable to connect'); //select database for use mysql_select_db('acumenchain') or die('Unable to select database!'); $query2 = "SELECT tblclasslist.studentNo FROM acumenchain.tblclasslist JOIN acumenchain.tblregistration ON tblclasslist.studentNo = tblclasslist.studentNo"; $result = mysql_query($query2) or die('Unable to execute Query' . mysql_error()); $num = mysql_num_rows($result); //close connection … |
| |
The End.