10,940 Topics
 | |
| | Does anybody have any experience with changing an INT column to BIGINT so it will handle larger integer numbers? I have read a lot from searching the subject, but still a little leary of changing it on a live database. Would be nice if someone here has done it without … |
| | halo every body: sorry ! my english not good,i only can use very simple english.. i use "fgets" get a webpage date,but website is use utf8.. when i use "substr" get some string,then i write into mysql. but mysql filed can't show big5!i don't know solution.... my mysql version mysql-3.23.58-1.9 … |
| | I'm not sure why I suck so bad at this. I was recommended by my prof to use date as opposed to timestamp. I'm starting to think going back to timestamp would be easier due to built in php functions I can use. so in my original addproduct.php form I … |
| | Hi I am planning to create web based association Management project. Can any one please provide me some sample or details which would me more helpful for me to develop the project. |
| | 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?  |
The End.