10,940 Topics
 | |
| | [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 … |
The End.