11,093 Topics
 | |
| | A lot of code here. Basically I'm making an auction type site. This segment of code is for a user to upload a product: I'm pretty sure there isn't anything wrong with addproduct.php but for completeness I feel like I should post it. addproduct.php: <?php require_once('checklogin.php'); require_once('validate.php'); if(!isset($_SESSION['user'])) { //die("redirect"); … |
 | Hello there, How to add items in combo box from mysql database? 'mySQL statement 'tryCatch method ComboBox1._______ = myReader.GetValue(myReader.GetOrdinal("Uname")) I'm trying use this: ComboBox1.items = myReader.GetValue(myReader.GetOrdinal("Uname")) but an error occured.  |
| | Dear all, I have a huge problem and cant figure it out how to resolve it. I have a mysql database. which has plenty of entries in the table. I have linked my search.php page with my database everything is working fine the data is being fetched and showing the …  |
 | Hi all, I've problem with inserting data values from .csv file to MySQL data table. My query as follows; LOAD DATA INFILE 'C/Customers.csv' INTO TABLE pc.customers FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (CustID, RegDate, CName, CAddress, CPhone1, CPhone2, Order_OrderID) It returns error msg as follows; **Error Code: 1406. … |
 | Hi All, I have made simple CMS with PHP/MYSQL. It make use of TinyMCE as Javascript editor. I can delete as well as add the contents. But How can I load the contents from database to TinyMCE for editing and saving? Here is my PHP code to add contents using … |
| | Hi, I am a complete novice with MySQL but have been persevering with it for a project I am doing at work. I have created a results server to analyse and collect data I receive from quizzes I have created using QuestionWriter HTML5. I have figured out how to run … |
| | My school has an apache/mysql server that we make and host websites from as projects. I am doing an ebay type site where people bid on a product until time runs out. Problem is I don't know how to trigger that the product should be delisted and the buyer and … |
| | I have a MYSQL database that house user names and user numbers. the process is user goes to a url inputs all the information. Goes to the office they search for the user makes sure all the information is correct and assigns them a number inputs it into the the … |
| | Hello guys.. Do you have any idea how to make a Global Positioning System (GPS) using PHP & MySQL? I don't know where should I start. Do you think it's possible in PHP & MySQL? Please help. Thank's ! Regards, amulet_john  |
 | Hello everyone, My friend has been helping and he's been great however it's come to a halt :P I'm working with MYSQL at the moment but am having a few issues with my code. Index.php: <html><link href="stylesheet.css" rel="stylesheet" type="text/css"> <head> </head> <body> <div id="header"><img src="http://www.rhinosecurityltd.co.uk/templates/rhuk_milkyway/images/mw_joomla_logo.png" alt="Rhino Security"> </DIV> <form name="Form" … |
| | I am trying to help prevent SQL injection using mysqli_real_escape_string, I have the following: <?php $Connect = mysqli_connect ('', '', '', ''); if (mysqli_connect_errno()) { die ("Couldn't Connect to the Database"); } $String = "Hello, my name is (*$<>)*$)!*)_£)(!*£$&"; echo $String."<br><br>"; $Escaped = mysqli_real_escape_string($Connect, $String); echo $Escaped; ?> The problem …  |
| | Hello, everyone. I've recently switched hosts and the same script I was running in the past is now causing the rest of my MySQL queries to be locked, and it seems the query never completes. The code is: <? $con = mysqli_connect('localhost','user','password', 'database'); $Q = "DELETE FROM `Table1` WHERE `Field1` … |
| | HI, I am new to mysql and have two problems. 1. I have two tables that need to have same values from one field , if that values are not same in second table change it to value of first table Frist table is ps_product and they all need to …  |
| | Hi im a beginner in mysql land and i need to derive AGE from my D.O.B column i am wondering if someone could explain how and whether you could break it down more simply... i know im asking alot but we all have to learn .. thanks hopefully barb :D |
| | I've been trying to make dynamic queries, where the user determines what will be queried. The reason is because I'd like the images being displayed in my gallery reflect the category selected by the user. mysql_query("SELECT(whatever category they chose) FROM products") below is the generation of categories as links. (not …  |
| | I am bulding a code for my site and have few problems 1. When I run this few times, it updates table ps_stock_available but with wrong values and after some time is stops to update that table? The problem is in the last query, two queries above are working ` … |
| | Hello, I'm sure I'm missing something small. If a category doesn't exist in the database yet, how can I have the query accept a value of 0 without reporting an error? The $subcategory is what the user selected. The result should either be 4 images or a blank place holder … |
| | I'm new to MySQL and following a tutorial in a book to design a PHP MySQL website. Following this tutorial, I created a PHP page from which I can update entries in the MySQL database. What's strange is that only specific entries in the database will not update, while others … |
| | Hello! I'm working on a simple messaging system for a project and I have this query and it isn't working for some odd reason, here it is: mysql_query("INSERT INTO messages SET user='$user', message='$msg', date='$date', to='$id', private='$checked' ") Here is my error: You have an error in your SQL syntax; check … |
 | hi i have a table like this for attendence: table name attendence. id std_rolNum std_fname date std_bkfast std_lunch std_dinner i want to make search on the base of `date`, `std_rolnum`, `std_lunch`, `std_bkfast` and `std_dinner`. so that if on the same date if student have already taken breakfast, lunch or dinner … |
| | hi m getting the following exception: `System.Data.SqlClient.SqlException: Incorrect syntax near '4'.` the following is what i was trying: public void hostel_cpacity(ManageHostelRoomsBE hmr) { string str; string conString = System.Configuration.ConfigurationManager.ConnectionStrings["Hosteluog"].ConnectionString; SqlConnection con = new SqlConnection(conString); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; con.Open(); DataTable dt = new DataTable(); DataTable dt1 … |
| | Hi All, I need to optimise the below query. The below query takes 13 seconds to run on live. Kindly, suggest how I can optimise this query and how can I index the table? The query is as mentioned below:- SELECT *, a.forxmlfeed, a.lastupdated, a.mark_for_deletion, a.is_mixed_use, p.value as projtypeformixuse, b.active … |
| | Hi there, I have been trying solve my error at this codes, it takes me too long. Code: Private Sub OK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK.Click Dim conn As New MySqlConnection Dim myCommand As New MySqlCommand Dim comm As String Dim myconnstring As String Dim UserID … |
| | Hello, It is my first time to post here. I have been spending many hours trying to figure out how to get imagedata from my MYSQL database. I have tried these following codes but it wont work for me. view.php <html> <head> </head> <body> </body> <?php include "dbconn.php"; $sql = … |
| | I'm not sure that my title is descriptive enough, but here is what I need to do... I had a bit of a screwup today with launching a site... Within about 10 minutes of opening the site, the members created 337 transactions (stored in trans_table) Each of those transaction should … |
| | I want to check if value is already exists in database with php. But this value can be as for example "John" or "JOHN" or "JOhn" or ... e.t.c how to check for all conditions?  |
 | Hi, I made a table named staff_info containing 4 column name,day,duty_start,duty_finish. This table still have no parimary key. Now assume that there are 4 staff and they do their work in each day of the week.That means in each day there work 4 staff and 1 staff work in 7 … |
| | geeting a error Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\E_COMMERCE\MENU_PAGES\apparel_pages\male_print_image.php on line 35 line 35: while($row = mysql_fetch_assoc($item_query)) <?php ... if(isset($_POST['male_button'])) { $order_by_p = $_POST['order_by']; if($order_by_p == 'heigh_low') { $item_query = mysql_query("SELECT * FROM item WHERE sub_category='Male_T-Shirts' ORDER BY id DESC LIMIT 8"); } } … |
| | hi i have the following problem after importing databse in c#. i have import a mdf database in C#. but it has exception after pressing `F5` for debugging. `A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. … |
| | Hi all, using these tables, Im trying to write a query that will list the students that have taken any type of class (class_level) and how many of that particular type they have taken so using a count of somekind. Tables: ATTAIN PK FK Rank_Num integer refers to RANK PK …  |
| | Halu guys! How to store an *image* to **MySQL database**? Do it needs to convert? |
 | Hi guyz , PHP newbie and this piece is givin me a hard time please Help, have indicated the source of the error with a comment <?php ob_start(); include("dataaccess.php"); ?> <?php $strAction = "list"; $num = ""; $strTable = ""; $strkey = ""; if(!empty($_POST)) { if (trim($strTable) == "" ) … |
| | Thanks you all in advance. I want to make a website showing the result of exams that are conducted in India. I want the user to enter his/her Roll Number in the form created at my website and as he/she press enter. His/her results should be displayed on the page. … |
| | Hi ALL, Plz tell me how to retrieve data from mysql using vb.net as frontend. I created database in mysql and able to insert data from vb.net but i dont know how to retrieve data from mysql. Plz help me to perform this action. Plz post your reply for my … |
| | Hello all: I have the following mysql query statement: SELECT COUNT(*) as ttl_rows FROM (SELECT DISTINCT(date(timeentry)) AS day, COUNT(*) AS total FROM history where MONTH(CAST(timeentry as date)) = MONTH(NOW()) AND YEAR(CAST(timeentry as date)) = YEAR(NOW()) GROUP BY DATE_FORMAT(timeentry, '%d') ASC) as ttl_row the statement performs a search for all records … |
| | I am trying to create a secure login app using php and MySQLi by following this tutorial: Link To Tutorial The tutorial is using a table(members) with 5 fields as:"id", "username","email","password",and "salt". but at the very beginning there is a an SQL INSERT function which is confusing me INSERT INTO … |
| | I'm having some trouble with selecting the Max values of three different tables in my SQL. I have 3 tables Car [CarID, Name] - Price [CarID, Price] - Group [GroupID, CarID] With these Values Car: CarID --- Name 1 ------- Car1 2 ------- Car2 3 ------- Car3 Price: CarID --- … |
| | Hi all. I am a beginner in Zend and I am wondering if there is any good book or tutorial for developing applications with Zend Framework, using json for data encoding and decoding and how to use jquery with Zend. Thanks. |
 | Hi! I cannot figure out how to install and use a database that I am given for a project. I'm running Windows 7. Can anybody help me? |
| | Hi guys... i want to delete data from datagrid in mysql...i have also done update query using same datagrid... but i m not able to delete data... my code is <script type="text/javascript"> $(document).ready(function () { // prepare the data var data = {}; var theme = 'classic'; var source = …  |
 | Hi; I have an sql database with a table called: "stardate" with default value set up with "dat" I want to modify this column default value to current date (server side) I'm trying this: Alter table my_table Modify startdate DATE DEFAULT CURRENT_TIMESTAMP; with this error: Error Code: 1067. Invalid default …  |
 | Please people, i'm trying to create a chat room, and .... I jst nid some guidance pls |
| | I need a ajax way of updating the mysql table. Following is my code that gets the data from mysql table plus ajax function that will send data to processing file. Problem is it is sending every time only the data of the top row ( form). How can send … |
| | HI Im looking for a javascript game to download for free so I can give my users on my website a way to get points. so the points that they get in a javascript game would be added to the mysql database to add the points into their account. does …  |
| | |
| | ok first off I know how to make a update page with usernames and user info no problem.. I know how to do stock with the stock=stock -%d as a interger but what I am having a hard time with is I have no clue how to say for example … |
| | Hi, I want to know what code should be used in order for me to import data from an excel file to dataset and then adding it to the database, how can it be done? thanks |
| | hello, i'm having trouble getting my delete selected checkbox working for a code I'm writing: the trouble is really just in the bottom half of the code after i make the while loop...i made this off of an example that i found on a site but like it was pretty … |
| | Hi everyone, I have been trying to update a mysql database with the shortend url I get from bit.ly I have the shortend url displayed on the page, but everytime I try and update mysql with the variable $bitlylink.. instead of http://bit.ly/123abc the database is updated with http://the.full.website.url/directory/link.html How can …  |
| | Dear Experts, my website was hacked yesterday and when i retrieve my website it will give Ã, ¢â etc these character in my each and every page and post. Kindly tell me step by step process to remove these characters. I am new here sor plz kindly tell me step …  |
The End.