10,946 Topics
 | |
| | Hey All, I have tried to work on a way to update all the date in a row called: "position", from a table called: "pages". The admin have a choise on where to place his new page, in the cms. The pages/links, are being pulled from the database by position … |
 | Hi I am experienced in ASP w/ C# but a beginner in PHP: How do I get the value of a unique index of a column of mySQL in PHP: [CODE=C#] try{ //do connect //insert data } catch(Exception ex){ if (ex.Message.IndexOf("Column_Name") >= 0) //<-- how do I do this in …  |
| | Hi, I'm using PhpMyAdmin 3.3.9 , on the tab Designer, I see the tables but I don't see the lines between them that mark the relations (like in sqlServer or Access) I defined the relations between the tables using the Relation View, so they exist..I even tried to creat relation … |
| | Hello, i am develop website in jsp as per our final year project rule of college.my project is public transportation.i am creating site for it. now my problem is to create database for bus train and flight ticket reservation.. how can i create database for it and also journey table … |
| | Hello, I'm doing a sql database as a school project, the database will be a book catalogue of sorts. What I would like to do is store a biography for the authors and a summary for each book only I'm not sure what the best way to go about storing … |
| | I have certain values in a table. car train metro car bike train car train car bike I want to count the number i.e. car(4) train(3) bike(2) metro(1) need help?????? |
| | Hi, I am using mysql 5.0.77. I am running queries like create table T1 as Select t1.arg0 as ARG0, t1.arg1 as ARG1, t2.arg0 as ARG3 from table t1, table t2 where t1.arg0=t2.arg0 I want to create the table if the select statement does not return an empty resultset. If I … |
| | Hey all, Can anybody tell me what is a stored procedure an what is the difference between a stored procedure and trigger? Thanks In Advance |
 | Hi I am new to PHP and looking to create a search php page, the search needs to be by Country, State and city. I have tried several methods over the last three weeks and none work, im slamming my head against my desk! Basicly I have three dropdown boxes … |
 | dear now i explain the specific problem here as i described earlier about the fruits so see the code as when i assign new currency from the drop down list , all the available currencies are there but for editing only the assigned currencies appear that i have assined earlier … |
| | I hate to post a thread on this since I know this topic has been discussed ad nauseum, but I've been searching for weeks and cannot find exactly the answer I've been looking for. I'm new to arrays and loops - I get the concept, but not the syntax. Here's … |
| | Hi guys, I'm trying to build a query that involves two tables, the course table and the studentsLink table. The StudentsLink table describes the link between students and the course. The tables are as below; Course courseID(bigint) - PK courseName (varchar) courseInstructor (varchar) StudentsLink courseID(bigint) - PK StudentID(bigint) - PK … |
| | Hi, I my admin area, where the administrator can create a new page, it is also possible to decide the position of the link. It is a menu in the left side of the screen, one link on top of the other, very simple nav. I have a dropdown list … |
| | Hi, I decided to try and upload images by storing their path in a database, but have run into an error when displaying the images. The form works and the folder is populated whenever I run the script. I have tried a lot of solutions from similar threads, but to … |
| | Hey all, Is there any way to check the time of insertion of a record. Means if i inserted a record in table on 03/21/2011 14:05:45 00:00 then is there any way to get this time after-wards  |
 | Hi, I have a table on two different database servers on server-1 it contains almost 2090 records and on server-2 it is empty i want to copy all the records from server-1 to server-2 both the database servers are identical but on different location and have no relation with each … |
| | Hi! how can create advanced api in php/mysql authenticate with api key, userid username etc. any good tutorials etc Please post links for me |
 | So I'm trying to figure out the best way to go about setting up an image upload system for my site. Basically we have, let's say, 2,000 stores in our database currently (that number expands by the day). I want users to be able to upload images for each store … |
| | Hi there, I have some code on a page to extract info from a database (like a back end system) and I just wondered if there was anyway I could do a shortcut around the code to avoid doing multiple SELECT statements. e.g [CODE]<?php $result = mysql_query("SELECT * FROM quackedup … |
| | Hey all, I have two tables one of which contains information about users (id, name ,department, team) and the other table is of team(is, name, leader) i joined users with team and aome other tables to display[B] |team name|Team Leader| Supervisor|department|[/B] etc now i want to add one more column … |
| | Hi, I have a situation where i am inserting to two tables from a web form but the first table needs to be inserted to so i can get the PK, then use the PK to insert into the second table. So what I would like to do is rollback … |
| | OK, I need help!!!!!!! I've tried every advice I could find on google, nothing works for me!!!!! my DB has data in hebrew I can't figure out how to set the collation and everything else right so that my site would show the data in hebrew when I echo it … |
| | I have a php script that pulls several rows of invoices from a database and displays them on the screen in table format. I have created an onclick per row within the while loop in order call another php script that runs a query to pull all the attachments for … |
| | Hey All, Can any one tell me how two remove duplicate records from a table? |
| | I Downloaded Wamp server 2.0 for my php and mysql installation. When i click on the wamp server through start/programs/wampserver/startwampserver2.0 it just has an icon 'start wamp server 2.0',is it the right file i downloaded?isnt it supposed to contain other clickable icons like phpmyadmin,mysql,apache ?? Secondly,do i need to download …  |
| | Hi All! I have made a small cms using php and mysql - I havent tried to export a databae to a webserver before, so I need a little help/confirmation. When I click export in phpmyadmin, and chooses type to be SQL, and saves it with the allready chosen/marked boxes, … |
| | Hi everyone. I am still very much in the learning phase of JQuery and AJAX, so your help is VERY much appreciated! I have created a webpage that has two tables of invoice records, which are printed to the screen using a php while loop. The first table is a … |
| | I am having great difficulty getting a query to work with multiple conditions. I have a very basic understanding, hence the two queries below (one commented out). I understand a smaller and more precise query would be returned by using INNER JOIN. Both queries work fine until I try to … |
| | Hi, If anyone can help me with this would be very mych appreciated. My problem is I have a database full of users that has been built up over the years. The password field in the db is not been encrypted and the password is visible to all. I would …  |
 | just started out on php, kinda having problems configuring the language (php), the database server and the web server on windows 7. what could i not be doing right. I have edited apache's conf file to use php and stuff. One problem is that i have IIS running as the … |
| | I have a simple jpg image saved in a field of type longblob. Now i need to get that image and put it in a JLabel or something similar to show the picture in the program. Anyone knows how can I do that please? I already know how to get …  |
| | Hey all, I am new in SQL my problem is that I have to select one by one to perform certain function can any one tell me how to loop through the records of a table. I have googled it a lot but still not able to sort out this … |
 | I am fairly new to MySQL and having some problems figuring out how to format a couple queries using the following database: branch ([U]branch_name[/U], branch_city, assets) customer ([U]customer_name[/U], customer_street, customer_city) account ([U]account_number[/U], branch_name, balance) loan ([U]loan_number[/U], branch_name, account) depositor ([U]customer_name[/U], [U]account_number[/U]) borrower ([U]customer_name[/U], [U]loan_number[/U]) I need to find all customers … |
| | I wasn't sure which section to post this under but I am working on an assignment in SQL and have created a batch file to make the tables, load the data into the tables, and then sends several queries to sql to get results. Is there a way I can … |
| | Hi, I have been trying to get a select menu to work for hours, and everything is working fine but for one little bit, everytime I select from the jump menu and load the same page again, the menu displays the first result that comes from the database instead of … |
| | Hi all, i am having issues with my php and sql script. I have created a an update form that is populated with the database contents, however, when i edit the fields, the update script fails to update the database. The form looks like; [CODE] <form action="update-stock.php" method="post"> <input type="hidden" … |
| | Hello All: I'm setting up a client management application as a hosted service; whereas the application itself will be accessed and ran from the internet. The application currently runs on one database and 9 tables for each client's account if I were running it on a standalone single system. Now … |
 | i have a very simple S/P called ClaimTotal [CODE]CREATE PROCEDURE ClaimTotal @Result varchar(50) OUTPUT as select sum(total) as Ctotal from claim[/CODE] i am struggling to get the Ctotal saved into the @result so that i can then pull this into my .net program. if anyone could help that would be … |
| | hi, I'm using xampp. By using phpMyAdmin, [CODE] select now() from dual [/CODE] it shows [B]2011-02-14 07:28:57[/B] but suppose today's date is [B] 2011-02-15 07:28:57[/B] is there anyone have rough idea where the date set? i've check the server date is correct 15 feb thankx |
| | I need help creating the tables for my database, I've got all my tables to work except the first one. For some reason it says it is unable to create the first table and i get this error " ERROR 1005 (HY000): Can't create table 'jfunchio.rental' (errno: 150)" I was … |
| | hello guys thank you for reading my post , guys do you know how to call stored procedure with out parameter in visual basic? hers my sample code but it is error Cmd.CommandType = adCmdStoredProc Cmd.CommandText = "proc1" Cmd.Paramters.Append Cmd.CreateParameter("@a", adVarWChar, adParamOutput, 255) Cmd.Execute my stored procedure DELIMITER $$ DROP … |
 | I am trying to display a Crystal Report developed using MySQL database and ASP.NET 2.0 (VS.NET 2005), and for some reason when I pass the database login information to the report it does not accept them (still shows a db login screen). Here is the code: [CODE] Dim cnString = … |
| | I keep getting the "ERROR 1005 (HY000): Can't create table 'jfunchio.rental' (errno: 150)" error where i run this code. I was wondering if anyone could help with what is wrong. I would really appreciate it. My code is below. [CODE=sql] create table rental ( item_rental_id varchar(8), customer_id varchar(8), movie_id varchar(8), … |
| | Friends, I am zero in PHP, but still i have managed to do something to fulfill my requirement. I am stuck with one thing now..So i need help on.... I am using one html+php form to submit database into mysql. I created a display of that table through php script …  |
| | How to just import one column of csv.file into mysql? Thanks!  |
| | hey, i have an applet project in the project i am trying to create an applet, applet draws a line line is drawn from coordinates which are stored in mysql database. in my other project which is web project which is created using tomcat servlets i added my applet project … |
| | i'm working on building my website but i'm facing stupid problem.. i don't know how to create a php file for my html's one to then connect them to the database .. i need my page to able me to insert,update and delete records from my database, and then submit … |
| | Dear All, For now I have two tables as below. The tblTyre store all the tyres.Then tblTyreConfig store the relevant tyreID in each of the column for instance fl(front left wheel),fr(front right wheel),b1LI(back first left in wheel),b1L0(back first left out),b1RI(back first right in wheel),b1R0(back first right out),b2LI(back second left in … |
 | hello, See "ABC4_HUMAN" is a database value.i need to search this value using a character say"A" or by a word say"ABC".But i need to check this value only in "ABC4" part of the value "ABC4_HUMAN". please provide me the query using "like" operator.. thanks |
| | i have connected an external device to my server. That device send some data through one port. Now how to read that data from port and store in mysql using php? |
The End.