10,946 Topics
 | |
| | hi I 'm finding a bit delay in search of a name in my database where more than 1 lakh records entered using wildcard. I use vb6 and mysql. thank you, susanorent |
| | Hi guys, i need some help with a too complaicated query for my little brain. I have the following query: [CODE]$query = " (SELECT pic, text, main, gr, min(nr) AS nr FROM info WHERE (gr>0) AND (stl LIKE '$stl') AND ((quantity >= 0 and utg!='J') or (quantity > 0 and … |
| | Hi guys, Once again here i am asking for your wise knowledge, i am having porblems with deleting a record. I can update the record but when i am trying to delete it i cant it it does nothing here is my code [code] <?php require_once('Connections/hello.php'); ?> <?php if (!isset($_SESSION)) … |
| | Hi All, i need yr help guys, i am developing a software in which i want to add one class object in MySql table, since there is no datatype available in MySql so that i can write object in to it, please do me a fever, what i should do …  |
| | What are the main differences between trancate and Delete? And is "select" command is DML or DDL?  |
 | i have a small app that reads a forecourt program's database. i want to get the current shift's info from that and display/print it out. SELECT name, liters, amount FROM salemast ORDER BY name the above statement was my first idea, but that didn't add them. just got a long … |
| | Hi How to start mysql with binlog option enabled in windows. thanks in advance awaiting your reply regards aras |
| | Hey Guys, I want to know how can you connect to multiple tables at a time. I need one table to validate the username and pasword. I need another table to show his details. Please Give Some suggestions(I am using php and MySQL) |
| | hello! i'm implementing an e-commerce system to distribute key codes. right now i'm thinking of a sql syntax to do the following: i have a table: orders here i have the orders_id field (unique for each order placed) with this orders_id field there may be more than one products ordered … |
| | I have two tables Organisation and Employee having one to many relation i.e one organisation can have multiple employees. Now I want to select all information of a particular organisation plus first name of all employees for this organisation. What’s the best way to do it? Can I get all … |
| | Hey Guys, I've heard that SQL Injection is one of the most common tool that the hackers use to hack a web application. Can anyone please give me a brief overview of what SQL Injection is or any webpages that I can refer to. Thanks |
| | I am currently working on a program that should update mysql database online at an interval of an hour automatically. The user on the other side should be able to download the information in the database for use in his/her local machine. I am stuck in the process, I now …  |
| | Hi all, I have a problem with my php and mysql project. I use an auctions software, named phpauction for my project. I import into my database with utf8 encodingm and I can see the greek letters inside the fields. The problem is that when i go to the site … |
| | Hello, I have set up a photo gallery and would like to resize the width for each photo displayed! However, I cant seem to get the coding right! Here is the snippet of code: [CODE] //Outputs the image and other data Echo "<img src=/photos/".$info['photo'] 'width=200' . "> <br>"; Echo "<b>Description:</b> …  |
| | Hi all, I am currently doing on this project and i am struck at this section - which is deleting multiple rows from mysql with checkbox. The code i am using is [CODE]<?php $host="localhost"; // Host name $username="root"; // Mysql username $password="root"; // Mysql password $db_name="advert"; // Database name $tbl_name="test_mysql"; … |
| | dear all, i have 2 tables with no common column. and i wanna add the columns of the second table to the first. but when i use the below command a cartesian product happens! [code=sql]select column1,column2,column3,column4 from table1,table2 [/code] but i want the number of rows be fixed. so i … |
| | Hello again, I'm having a problem and don't know what is causing it. I'm copying from a book. double checked and can't figure out why I'd be getting this error (below in quotes) Link to live view of what is being accomplished (trying to be accomplished) [URL="http://skywardz.com/address_book/addEntry.php"]http://skywardz.com/address_book/addEntry.php[/URL] LINE 87 : … |
| | Hi guys, Probably this is something really over discuss but would you be so kind to teach me. I want to store prices on MySQL table, i currently have my Data Type as FLOAT with my prices on the table but it renders only the same number, what is the … |
| | Hi, I have a cookie with 5 products. There will be a loop to read one by one and reduce from stock in database for each product. Now, If something goes wrong half way through i want to cancel whole transaction. For example; everything went ok for first 3 products … |
| | Hello, Im a little bit confused with this piece of coding I have! Im basically trying to add a script I have converted to a web page! The original code was using echo statements which was fine on a separate page but now I want it to be apart of … |
 | Im Not sure if I have spelled well the DLL file but It is file that comes with MySQL 4 and Now in MySQL 5.1. It is standalone server version of MySQL to embedd in App. Is there anyne who knows how to connect to it and Execute SQL commands … |
| | hi friends I need the query , I have stored the ids like this 4,10,12,13,14 in one filed. I need to search the id 4 avaliable in the one filed , how to search the number one single filed? Please advise |
| | Hi i'm a newbie to PHP and MySQL. I was wondering if anyone could help me with some code to Add 1 to a number that is assigned to a person in the database. So, the person types their name in a form. Then the form has to find that … |
| | hi, i'm using LIMIT command in mysql query to retrieve top 9 records but it takes 10-12 min. pl help. thank you in advance  |
| | Hi, again... Can someone help me with the following code: [CODE](LINE 74:) $get_addresses_sql = "SELECT address, city, state, zipcode, type FROM address WHERE master_id ='".$_POST['sel_id']."'"; (LINE 75:) $get_addresses_res = mysqli_fetch_array($mysqli, $get_addresses_sql) or die(mysqli_error($mysqli));[/CODE] it brings up this error: [QUOTE] Notice: Undefined index: sel_id in /hermes/bosweb/web185/b1859/sl.mavedog21/public_html/address_book/selEntry.php on line 74 Warning: mysqli_fetch_array() … |
| | pleaseeeeeeee hepl meeeeeeee!!!!!!!!! i have 2 tables : time1 (noo integer,days varchar,times varchar,Tindex integer,primary key (noo,Tindex)) timetable1_1(COn integer,coursename varchar,dayss varchar,timess varchar, primary key(COn)) i have created a new table temptime1 and tried to fill it with the rows in time1 which their days and times are not available in timetable1_1 … |
| | Hi, newbie here just been going through the "Sam's Teach Yourself - PHP, MySQL" book. I've retyped the code for viewing records in an address book. My problem is this line appears to have a problem. Does it look correct? [CODE]$get_list_sql = "SELECT id, CONCAT_WS (', ', l_name,f_name) AS display_name … |
| | i need some help in making a database....what are need entities in making database such as forums,bulletins and login purposes.... pls repzzzzzzzzzzz  |
| | Hi, MySQL function below is not working. I cant find the mistake. Can you help me? Thanks [code] CREATE FUNCTION testVAT(DECIMAL(4,2)) RETURNS DECIMAL(4,2) DETERMINISTIC BEGIN DECLARE myVAT DECIMAL; SET myVAT = (myMoney * 0.17); RETURN myVAT; END; [/code] |
| | Hello, I have two mysql db which contains 23 tables. The problem is that i have merge them in a one db. Is it possible? Thank you! |
| | Hello guys! The situation is the following - I have some databases on local host and now I am going to upload website to hosting! My friend provided me with some place on his hosting account and now I am going to test a website! Could you please explain how … |
| | Hi Friends I am working to draw a graph . I need to get the data monthly, for example JAN total hours FEB total hours , How to write the query get the total values per month? Advance thanks for your reply. |
| | Hello, I am trying to show a list of information using a FETCH and WHERE statements. This is my code: [code] $buds = mysql_query("SELECT * FROM buds2 WHERE bud_me = '$userid' AND confirmed= '1'"); $x = 1; while ($array = mysql_fetch_array($buds)) { $buddy = fetch("SELECT display_name,username FROM members2 WHERE id …  |
| | Hi, I am very new to SQL and I am working on a query. I am to use a flat select statement I am to : Print all S#s such that the indicated supplier supplies a London project and also supplies a Paris project There are 3 tables, one with … |
| | Hey Guys, I have the following code, which averages the scores in a select statement and works no problem. [code] SELECT AVG(score) as 'avg' FROM (SELECT d_key_id, frequency, weighting,(frequency*weighting) as 'score' FROM users_to_keywords WHERE s_user_id=$user_id AND d_key_id = $score_key ORDER BY score DESC)a [/code] However, as there are some duplicated … |
| | hi, I am trying to replace certain strings in my mysql database. I have addresses such as this: 60 W 23rd St, New York 10010 Btwn 5th & 6th Ave I would like to get rid off all the words starting from New York including the comma before the word … |
| | Hi guys, I'm new to ASP.NET and MySQL. I've worked with Microsoft Access for a while (6 months or so) so I have an understanding on how databases work. However, now I am trying to create a website with ASP.NET 3.5 and MySQL. So far I've been able to get … |
 | Does mysql_real_escape_string() escape HTML character entities? I want people on my comment board to be able to post quotes in their comments, but they get escaped as raw ascii, so I run them through htmlentities() first, but it doesn't help. I only get it to work when I remove mysql_real_escape_string(), … |
| | Hey. I'm trying to make an activation script for a website, but for some reason my sql query is giving me errors. [CODE] $sql = 'UPDATE user SET active = 1 WHERE (password = "$_GET['hash']") AND (timestamp = ".base64_decode($_GET['stamp'].")'; $result = mysql_query ($sql) or die (mysql_error()); if( mysql_num_rows($result)==1 ) { … |
| | Hello everyone. I know this is a C++ forum not MySQL forum but I need help with the C++ library for MySQL I am hoping that there will be people here who are knowledgeable about MySQL++. My problem is that I can't get the g++ compile to link to the … |
| | Hi all, Im very New to My SQL and have done alot of googling and simple studies. I have two Questions: 1. Where can I start with Complete no knowledge of MySQL and databases in general (though i know a little) 2. I have tried to play with MySQL for … |
| | [CODE] CREATE TABLE `categ` ( `id` int(10) unsigned NOT NULL auto_increment, `categ` varchar(32) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ; INSERT INTO `categ` (`id`, `categ`) VALUES (1, 'General'), (2, 'Politica'), (3, 'Sport'), (4, 'International'), (5, 'Cultura'), (6, 'Hitech'), (7, 'Showbizz');[/CODE] [CODE] CREATE TABLE `ziare` … |
| | I will explain... I downloaded `"mysql-5.0.45-win-src.tar.gz"` from Mysql download area.I tried to built Mysql.sln inside that,but i am getting errors(about 58) like Error 149 fatal error LNK1181: cannot open input file '..\zlib\release\zlib.lib' mysql_upgrade Error 319 error PRJ0019: A tool returned an error code from "Performing Custom Build Step" mysqld Error …  |
| | Hello all! I have a few questions about putting images into the database. I have chosen to put the images on my server and then the location will be put in the database, instead of doing the blog thing. However, I am having a hard time trying to figure out … |
| | In MySQL 5.1, I am using a table that has 3 integer fields a,b and c. I need a create a trigger that will UPDATE field c with the results of field a-b. ANy help would be appreciated. |
| | Hello all, I have a fairly good grasp on how to design a database (took a couple courses on it) but I'm not sure how to set up a database for use with a website. My plan is to develop the website with ASP.NET and MySQL. The website will have … |
| | hey guys, i am using XAMPP and i want to take the back up of my database. Please give some suggestions  |
 | Has anyone been able to compile the lib files using Microsoft Visual C++ 2008 Express compiler? I downloaded and installed MySQL 5.0 Server yesterday, then downloaded MySQL++ source. Attempted to compile and got a bunch of link errors. I used dumpbin.exe to get a list of all the symbols in … |
| | hey guys, i have made a database which has two fields namely username and password. Now when the user enters the password, i want that the password should be stored in encrypted form in the database so that the admin cannot see the password. Please give some suggestions. |
| | Can someone please give me a brief overview of MySQL. It's advantages,disadvantages,security and other features. Thanks. |
The End.