11,093 Topics
 | |
| | Hi, I'm not sure if this is the right place for the question but it is related to databases, i think. I have been developing a site on a win server 2003 box using MySQL 5 and PHP 5. While I have been developing it the client wanted the site … |
| | |
| | Hi all, I'm an absolute newbie on the site, first ever post! I have been scratching my head for a while now so hopefully one of you DB pro's will be ableto help me :) I have a friend that has asked me to design a database for his small …  |
| | Helllo! I'm working on a user information tracker that will allow users to write data to their profile through it's web interface and with a Java Application for wireless devices. My the issue is the Java app, how do I let public applications access a mySQL database securely? I can't … |
| | OK this is driving me mad and it needs to be done for a deadline. It is just a simple query to update a few database fields. Here's the PHP for it. [code=php] $sql5 = "UPDATE videos SET title='$new_video_title' WHERE artist_id='$i' "; $query5 = mysql_query($sql5) or die( mysql_error() ); $sql6 … |
| | hi all, I have been trying to convert my phpnuke setup over to mysqli.I am running it as mysql at the moment on apache 2.2.9, php 5.2.6 and mysql 5.0.51b.I have attached the unmodified file as i have been playing for a week and have got no closer. is it …  |
| | hai ! im into a project where ive got to display the table in the form of a datagrid....im in a look out for a really gud one ....pls help....  |
| | hi, iam new mysql with vb.net , i am install mysql in my machine 3 more user have to access the mysql database , my question is that , i need to install mysql in all the client machine? looking forward ur suggestions kannan |
| | I have a form in jsp and if someone enters special character (like single quote ') in text field (ex L'orel) and submit, it gives a error. I know this is a special character conflict, but how can I override special characters by submitting a form through JAVA. Is there … |
| | hai when the no of columns is 10 rows to be more than 2000 ....which type of insert is best?? INSERT INTO example (name, age) VALUES('Timmy Mellowman', '23' ); or INSERT INTO example (name, age) VALUES('Timmy Mellowman', '23' ),('jimmy','16' ),(' johnn', '19' ); |
| | |
| | Hey everyone, I want to use mysql to list all of the makes of vehicles and I want the user to be able to click a make and the years that make were made pop up. Is there a way to do this using PHP? I've got the makes to … |
| | Please i need someone who can help me Display Date from Mysql which is in format YYYY/MM/DD to DD/MM/YYYY the code below sends data to mysql but when i`m displaying date it comes in YYYY/MM/DD. [code] <?php include"config.php"; $comment=$_POST['comment']; $news_id=$_POST['news_id']; $name=$_POST['name']; //$rece_user=$_POST['rece_user']; $query="INSERT INTO newscomment (name,news_id,time,comment,date) VALUES('$name','$news_id',CURTIME(),'$comment',CURDATE())"; $result=mysql_query($query); if($result){ //echo"<i><b><font … |
| | Hi, I am trying to query a terms database with multiple text boxes. The user has a choice of how many text boxes they want (i have this part done), they would put one term into each text box. The would have the option of checking a check box for … |
| | Hi all, I have a question about mysql_real_escape_string. Is it just used for login scripts or is it also used for inserting data to a database. My problem is this: [CODE] $connection = mysql_connect("*****", "*****", "*****"); $database_select = mysql_select_db("*****", $connection); $firstname = $_POST['firstname']; $lastname = $_POST['lastname']; $firstname = stripslashes($firstname); $firstname … |
| | Hi, I have a problem. I would like to, from a text form, filter out what the user wants to see. I have a mysql database with info on every order placed. Each row is a new order. All users has their own ID. I would like the users to … |
| | In my Database(mysql) i have 100 members registered,Now there is page i want to display only ten members, but after each page refresh i want other ten members to display at the very same place Meaning replacing the current shown members. Any one with the idea on how i can … |
| | i know this maybe to easy for you, this is what i need to accomplish: 2 list menus 1.- Manufacturer (Honda, Kawa, Susuki) 2.- Model (cr250, cr125,etc..) each manufacturer has their own models 3.- Year(1999.1998,etc..) So i would like to have the first list menu listing the manufacturers options and … |
| | Hi guys, How can i store multiple image paths in one single MySQL field, help please Thank you OCBPHOTO |
| | 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 … |
The End.