No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
6 Posted Topics
 | I keep getting the following error and cant seem to figure out where I'm going wrong with the code and have tried changing it but just seem to make is worse wonder could someone please help me, the code i am using is as follows: [CODE] this is the code … |
| | I am trying to get information from my database that contains a foreign key that relate to another table, I am trying to enter details of an order and then have the customer ID of that order enter automatically from the customer table. [CODE] [B]Customer Table [/B] CREATE TABLE IF … |
| | 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 … |
| | 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' … |
| | I am designing a website that connects to a database. I am using wampserver to connect to the website. In my customer add page I am trying to ask the website to generate an autonumber from the database. As my table in the database is set up as following: [CODE=SQL]CREATE … |
| | Hi I am having trouble trying to normalise my tables, I would really appreciate some help! So far I have: [B][U]Customer Table[/U][/B] CustId(pk) Cust Name Cust Address Cust Postcode Cust Email [B][U]Order Table [/U][/B] OrderID (pk) Order Date_Time CustID(fk) [B][U]OrderDetails[/U][/B] DetailsID(pk) Quantity OrderNo(fk) DeliveryID(fk) [B][U]Product[/U][/B] ProductID(pk) ProductType ProductDescription DetailsID(fk) PartID(fk) … |