11,093 Topics
 | |
| | Is this a correctly made JOIN: [CODE] // Build SUBJECT navigation and gather SUBJECT data here-------------------------------- $sqlCommand = "SELECT id, linklabel, pos FROM subjects INNER JOIN pages on id = pages.subjectid ORDER BY pos ASC"; $query = mysqli_query($myConnection, $sqlCommand) or die (mysqli_error()); [/CODE] ? Klemme |
| | I am creating a cms, where I have a Global horizontal navigation(SUBJECTS) in the top, and a local navigation(PAGES) on the left, all database driven. First I decide if either a subject or a page has been set, to display the correct information: [CODE] if (isset($_GET['sid'])) { $subjectid = ($_GET['sid']); … |
| | Hi all, I'm new and I currently am developing a website on fishing fred's fishing. The site is an experiment for a portfolio ect. There is a feature, the guestbook. The Guestbook is managed by a MySQL database and the PHP is responsible for creating and echoing the data. I … |
| | I have fields UserID, Status and etc. The status of the user will be either active or inactive. I want to count how many UserID of Active users only. I have a code here but it's not working..It says "Invalid or Unqualified reference". Can you please help me check this … |
 | Hey guys, I need some help with selecting 2 Tables from a MySQL database. Can anyone help. Currently I am using this, and I want it to be able to select from another table called Admin and Display the Admins under admins in my table. [CODE]<?php $host=""; // Host name …  |
| | Hi guys, I am working on a web application project where I use MySQL database. Now I need to export my database/table as a CSV file and I'm using SSH client to access my MySQL. I have no clue how to export it. I would really appreciate if someone could …  |
| | Hi I am having a problem with code i have created to delete a customer from my database, would be grateful if someone could tel me where i have gone wrong [CODE]<?php include ('db.php'); $cid=$_POST["cid"]; $cname=$_POST["cname"]; $cusadd1=$_POST["caddress"]; $cusadd2=$_POST["caddress1"]; $cusadd3=$_POST["caddress2"]; $ccounty=$_POST["county"]; $custpc=$_POST["cpostcode"]; $custele=$_POST["ctelephone"]; $cusemail=$_POST["cemail"]; print $cid; $str="delete from customer CustomerName='$cname',CustomerAddress='$cusadd1',CustomerAddress1='$cusadd2',CustomerAddress2='$cusadd3',County='$ccounty',CustomerPostCode='$custpc',CustomerTelNo='$custele',CustomerEmail='$cusemail' where … |
| | Hello everybody i am new to PHP and trying to learn more and more. now i am trying to make a reservation system i solved my date time problem but now i am stick on comparing two date from my form with two dates on my database here is my … |
| | [CODE]SELECT * FROM question LEFT JOIN answer ON question.Que_ID=answer.Que_ID AND question.Que_Answer1=answer.Ans_Answer1 AND question.Que_Answer2=answer.Ans_Answer2 AND question.Que_Answer3=answer.Ans_Answer3 AND question.Que_Answer4=answer.Ans_Answer4 AND question.Tes_ID=7 AND answer.Use_ID=1[/CODE] This should only show record that are use_ID=1 and Tes_ID =7. But in MySQL, there are data for test ID=8 and etc. isnt it only suppose to be 7. |
| | Hi I am having a problem with code i have created to delete a customer from my database, would be grateful if someone could tel me where i have gone wrong [CODE] <?php include ('db.php'); $cid=$_POST["cid"]; $cname=$_POST["cname"]; $cusadd1=$_POST["caddress"]; $cusadd2=$_POST["caddress1"]; $cusadd3=$_POST["caddress2"]; $ccounty=$_POST["county"]; $custpc=$_POST["cpostcode"]; $custele=$_POST["ctelephone"]; $cusemail=$_POST["cemail"]; print $cid; $str="delete from customer CustomerName='$cname',CustomerAddress='$cusadd1',CustomerAddress1='$cusadd2',CustomerAddress2='$cusadd3',County='$ccounty',CustomerPostCode='$custpc',CustomerTelNo='$custele',CustomerEmail='$cusemail' … |
| | 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 all, I have a java database application which mainly deals with database operations. Im concerned about the performance, as I have many update statements. As there are many records, each row has to be updated with a calculated value. So can anybody help me out to suggest for efficient … |
| | 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 … |
The End.