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