10,940 Topics
 | |
| | i have a mysql table which is categoryid categoryname parentid now the senario is that i want to grab all categoryid of a parentid ... like if i put parent id = 12 so that parent id has now become root id and it should get all the sub sub … |
 | :icon_confused:I have made the change from access to mysql. I am using vb6 to connect. The connection seems to be fine, it was some code sample that I have downloaded from the net. The app is reading the databases, but as soon as I select a database, i get an … |
| | Two different servers a and b, using the same database and table, select one of the tables, about 3000 records To use phpmyadmin to view, use the default configuration, 30 records per page 1 1 shows, a server page shows spend more than b servers 0.0002-0.0003 seconds (a typically 0.0006 …  |
| | I have two dropdown lists in my HTML form. In first dropdown list, I have some countries name already added in HTML form. In second drop down list there is no item yet except "Select choice". Now my problem is that I want that when i click on any country …  |
| | [CODE]$query = "INSERT INTO update_feedback (updateID,comment,timestamp) VALUES ('$updateID','$comment',NOW())"; $result = mysqli_query($dbcon,$result) or die('Error saving feedback into database. ' .mysqli_error($dbcon));[/CODE] Gives me this error: [QUOTE]Error saving feedback into database. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax … |
| | I am new to mysql workbench and databases in general. I have 250 sql files I need to upload to a mysql database and I am wondering if there is a way to do it other than one at a time. If there is a way to do it using … |
| | Hello, Now i have 3 tables which are: [CODE]CREATE TABLE IF NOT EXISTS experience( experience_id int(11) NOT NULL AUTO_INCREMENT, salarie_id int(11), consultant_id int(11), post varchar(255), entreprise_name varchar(255), start_time varchar(255), end_time varchar(255), description varchar(10000), PRIMARY KEY(experience_id) ); CREATE TABLE IF NOT EXISTS salarie( salarie_id int(11) NOT NULL AUTO_INCREMENT, name varchar(255), ..., …  |
| | HI Friends, I tried: I inserted a row in mysql using php in the first webpage and second webpage i tried to retrieve it. I got: But in the next page i did not get the lastely inserted row. When inserted the another row, i was able to get the …  |
 | Hi All, Can anybody give me some good pointers on cause, effect and workarounds for injection attacks please? Id really like to know actual commands that people use, where they use them and how to stop them. Answers on a postcard...............:-) |
| | Hi All, I have a table in mysql in which there is a column which have following kind of data $Category=>Income;$NAV=>10.2181;$Repurchase;Price=>0;$Sale;Price=>0;$Date=>26-Feb-2008; I want to Bifurcate the data in that column into 5 separate columns in the same table in this way $Category=>Income in this thing "Income" in column "category". $NAV=>10.2181 … |
| | Hi, I need some advice on how to edit records from a mysql database using php. Basically the record will be displayed after a particular field is chosen. What i need to know is how can i show the field data in a drop down box one after another and … |
 | [size=4]PHP and MySQL Web Development[/size] [b]by Luke Welling, Laura Thomson[/b] Extremely useful - This is a very useful book. If you're a web developer, and you're starting out with PHP, it will do wonders. It covers many important things such as creating a successful shopping cart, web based e-mail, web … |
| | I have a question, for example I input something on edit and in that time when I'll click on search button it will show find message, but it shows mysql error :'( why? what I am doing wrong in this code? :( [CODE]HWND edit; char t[MAX_PATH]; char query[MAX_PATH]; GetWindowText(edit,t,MAX_PATH); mysql_query(conn, … |
| | I have a dropdown list that is automatically populated with book titles from a database. When I select a item from the dropdown list I want a text area next to it to show the description of the book from the database. Is there a way to do this without … |
 | Hi all I have a little problem. I have a table that has up 300 rows in it. There is a column where a day and date is inserted. The data looks like this: Monday, 08 March Tuesday, 09 March Wednesday, 10 March Thursday, 11 March Friday, 12 March Right … |
 | Hi! I'm using various CMSs on my server and since I don't know PHP coding and also don't have the time to modify the scripts, I'm searching for an easy way to disable the MySQL errors. I'm talking about the errors that show in browser whenever the database table is …  |
| | Hi, I am using a shared hosting which has EST US time, since i am on shared hosting that's why i cannot change the server time zone but i wanted to display local Indian time to my users. What is a solution for this? Thanks |
| | Hi all, When running the following i get this error: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'user_id' cannot be null and heres the code: [code] function upload(){ /*** check if a file was uploaded ***/ if(is_uploaded_file($_FILES['userfile']['tmp_name']) && getimagesize($_FILES['userfile']['tmp_name']) != false) { /*** get the image info. ***/ $size = getimagesize($_FILES['userfile']['tmp_name']); … |
| | I have a table that looks like this: [code] Database: Testdb Table: Testtable ID | Value -------------- 1 | 105 2 | 105 3 | 105 4 | 105 1 | 255 2 | 255 2 | 311 3 | 311 4 | 311 1 | 500 3 | 500 … |
| | Hi, I have stored 800 images in root/Images and store link in DB for reference along with another information. There is a search box through which I get all the info. For viewing images I used [ICODE]<a href=".$row['image']." target=_blank>".$row['ch']."</a>[/ICODE] Ch value is click here to view. Now I want that …  |
| | Just wondering if it normal and acceptable use both on one string before entering it into a database or displaying it? For example: [CODE]$project_name = mysqli_real_escape_string($dbcon,htmlspecialchars($_POST['project_name']));[/CODE] |
| | Hi, I am new to mysql.I have two questions. 1)why AUTO_INCREMENT Have primary keys.? 2)Why should we declare default in below example? (ex)create table test (name varchar(15) not null default ''); Regards, prem  |
| | Hi, my table has id,startdate,enddate,starttime,endtime,salelocation,imagename both dates are in date type and starttime and endtime are in time type. I want to check if my data consisting of startdate,starttime,enddate,endtime cannot be present in table and must be a valid date and time duration. How to check this valid date and … |
| | Hi all, Im pretty ok with PHP and have recently been breaking down a project using foreign keys to identify various bits of information. This is my problem. I have an items table, which is made up of ID, country and area. It previously has the actual word of the … |
| | I have this table publication_en Field Type related varchar(200) public_area int(11) title text detail text file varchar(200) and i am trying to do this INSERT INTO publication_en (related, public_area , title , detail , file) VALUES ('none','1','"helped"','la' "kajakjajk"','J3.pdf') but it doesn't work any idea why it doesn't work ? Thank … |
| | Hi, I want to learn sql injection.I searched in google but the information is not sufficient to me.Will u provide some links to learn sql injection. thank u  |
| | hi i am getting field names in $productname through post method that i have to insert into while loop.... while($res=mysql_fetch_array($result)) { $resproductname=$res $productname;']; } is there any way to do that ...plz help...thanks in advance... |
| | i have some problems with mysql database query and its as below : Tables : i) departments id department description ii) farmers id name sex address age category remarks iii) scientists id departmentid name remarks iv) scientistvisits id scientistid farmerid datevisited purpose remarks Here, i want the query of number … |
 | Hello DaniWeb Community! I am trying to create a web page that utilizes Ajax and PHP to connect to my mySql database and look up a username and password. You have all most likely seen the web page that has the template code on it: [url]http://www.phpeasystep.com/workshopview.php?id=6[/url] This code is nice … |
| | Hi friends, I have a form to create a company details.. which will insert the details into a table. For this table, I need to have a auto increment field as character.. when we have autoincreament as Integer... whenever the new company is created..the number will increase from 0, 1, … |
The End.