• Member Avatar for john_111
    john_111

    Replied To a Post in SQL

    also look at this bit CREATE TABLE Product_Product( IDProduct_Composee Integer, IDProduct_Composer Integer, FOREIGN KEY (IDproduct_Composee) REFRENCES EProduct_Composee(IDproduct_Composee)ON UPDATE CASCADE ON DELETE CASCADE, FOREIGN KEY (IDproduct_Composee) REFRENCES EProduct_Composee(IDproduct_Composee)ON UPDATE CASCADE ON …
  • Member Avatar for john_111
    john_111

    Replied To a Post in SQL

    When you reference another table as the place that a foreign key comes from, you have to have created that table before you reference it. So order your code so …
  • Member Avatar for john_111
    john_111

    Began Watching SQL

    I am a beginner in this field and I have some mistakes in ((codes)) who can tell me what my mistakes. Physical model (1) Employee (SSN, Salary, Phone) CREATE TABLE …
  • Member Avatar for john_111
    john_111

    Replied To a Post in Pseudocode

    This is pseudo code First do this to collect first number Then do that to collect second number do an if continue or issue error message start collecting data again …
  • Member Avatar for john_111
    john_111

    Began Watching Pseudocode

    Im not really familiar with this kind stuff I really need help with this: develop an algorithm pseudo-code that will accept the names of each sales staff members and their …
  • Member Avatar for john_111
    john_111

    Replied To a Post in SQL Error: ORA-00907: missing right parenthesis?

    IN('PROCESS','FULFILLED,'BACKORDER,'CANCELLED')) can you spot the error? Look at the ' and the ,
  • Member Avatar for john_111
    john_111

    Began Watching SQL Error: ORA-00907: missing right parenthesis?

    Hi Please why I got this error(SQL Error: ORA-00907: missing right parenthesis) whats wrong in my code? CREATE TABLE artphoto( photonr NUMBER(10), artnr NUMBER(10) NOT NULL, filtyp VARCHAR2(5) NOT NULL, …
  • Member Avatar for john_111
    john_111

    Replied To a Post in Simple takeaway database

    Second thought As I am not well (got a throat bug and headache) and replied at midnight, I realised one other table was required when I got into bed, your …
  • Member Avatar for john_111
    john_111

    Replied To a Post in Simple takeaway database

    Yes, you are overcomplicating things. Go for one table {id, item, size, cost} or table {id, item, size, cost, description} Things available on certain days you handle with the php …
  • Member Avatar for john_111
    john_111

    Began Watching Simple takeaway database

    Hey guys. So this should be a pretty simple question (but doesn't appear to be) that I'm hoping some of the database wizards out there can help me with. I'm …
  • Member Avatar for john_111
    john_111

    Replied To a Post in how to store a data from a form in multi dimensional array

    Give your input fields names like id1, id2, id3 etc and amount 1, amount2, amount3, etc THEN build your array by putting these values into their corresponding places in your …
  • Member Avatar for john_111
    john_111

    Began Watching how to store a data from a form in multi dimensional array

    Actually i want to add both the values of ids 2 and the ids 3 <form method="post" name="fo" action="#"> <input type="text" name="ids[]" value="2"/> <input type="text" name="amount[]" value="100"/> <input type="text" name="ids[]" …
  • Member Avatar for john_111
    john_111

    Replied To a Post in an unusual problem of building multiple sites towards a longer term goal

    If someone has as many domains as this, the sensible option is to group them into related sets eg example.com, example.net, example.org, bigexample.com, bigexample.net, bigexample.org, otherexample.com, otherexample.net, otherexample.org Then create …
  • Member Avatar for john_111
    john_111

    Began Watching an unusual problem of building multiple sites towards a longer term goal

    ok, this is possibly an unusual one... I have a friend who owns a shed-load of domain names, which he's always had the intention of setting up with full blown …
  • Member Avatar for john_111
    john_111

    Replied To a Post in Microsoft Edge

    https://meta.wikimedia.org/wiki/Fixing_transparent_PNGs This was top of the page in the first google search I tried.
  • Member Avatar for john_111
    john_111

    Began Watching Microsoft Edge

    Hello, I am having a problem showing png picture that suppose to be transparant in Ms. Edge. Any clue why my png file is not transparant in edge? Check this …
  • Member Avatar for john_111
    john_111

    Replied To a Post in Creart Setup File

    Windows XP ??? you are joking aren't you!
  • Member Avatar for john_111
    john_111

    Began Watching Creart Setup File

    Dear Friends, i Developed a C# Project with SQL Server Database (Database is not LocalDB) and i want to create a setup file to install on client system havin windows …
  • Member Avatar for john_111
    john_111

    Replied To a Post in Contact us Page in Html

    A contact us page will require that you use a form and the form needs to have an action - the action is which other file, usually a php file, …
  • Member Avatar for john_111
    john_111

    Began Watching Contact us Page in Html

    I want to know how to make contact us Page in Html. I don't have clear idea regarding this because I am new in this field. Please notify me as …
  • Member Avatar for john_111
    john_111

    Replied To a Post in Need Help with Database project

    Why should the scenario need changing every year??? It's still a valid problem to be solved, and could easily be one of a set of two or three scenarios that …
  • Member Avatar for john_111
    john_111

    Began Watching Need Help with Database project

    Hello all members, I am new to this this website. I am working on an assignment and I have a scenario where I have to find the key attributes, entities …
  • Member Avatar for john_111
    john_111

    Replied To a Post in Should we use Shopify web developing services for e-commerce websites?

    I know spam when I see it...
  • Member Avatar for john_111
    john_111

    Began Watching Should we use Shopify web developing services for e-commerce websites?

    Online business is not a simple environment. Because of the increasing number of online store, store owners need to compete with each other to develop their business. Indeed, it is …
  • Member Avatar for john_111
    john_111

    Replied To a Post in SQL results in table

    `<td Bgcolor=<?php echo $row['PMStatus']?>` this says the Bgcolor= the $row['PMStatus']? And bgcolor is not a valid style name, and you should be using css to style it anyway. Also you …
  • Member Avatar for john_111
    john_111

    Began Watching SQL results in table

    as seen in the pic a table. I have the following im trying to fill the boxes based on rows. So line one will fill by the correct ordergoing left …
  • Member Avatar for john_111
    john_111

    Replied To a Post in Need advice on ER Diagram

    With usbwebserver, you run it on your local computer or local network, you don't need to put it on the web at all. It's a standard way to create and …
  • Member Avatar for john_111
    john_111

    Replied To a Post in Need advice on ER Diagram

    Business rules - how thingsare done in reality - can sometimes overwrite ideas on how it should be done in a perfect database. How to create actual system - make …
  • Member Avatar for john_111
    john_111

    Replied To a Post in Need advice on ER Diagram

    THIS year a tire can be in one location, next year it can be in a different location. Therefore you have to have a way of knowing which location is …
  • Member Avatar for john_111
    john_111

    Replied To a Post in Need advice on ER Diagram

    Phone number is NOT an integer You don't add, subtract multiple or divide them Phone numbers are strings. And often have spaces in them for ease of reading (integers don't …
  • Member Avatar for john_111
    john_111

    Began Watching Need advice on ER Diagram

    I had a quick course of database few years ago and I forgot a lot from there. So you can say I'm starting from zero. I will try to explain …
  • Member Avatar for john_111
    john_111

    Replied To a Post in Why is not mysql getting UPDATED ?

    <form method="post" action=""> this occurs at two points in your code - line 46 and 54. So with no action to carry out, you will not get any updates of …
  • Member Avatar for john_111
    john_111

    Began Watching Why is not mysql getting UPDATED ?

    Hiya Folks, Why is not mysql getting UPDATED, do you reckon ? <html> <head> <title> <?php $user?> Home Page </title> </head> <body> <body background=".png"> <?php session_start(); require "conn.php"; /*Check if …
  • Member Avatar for john_111
    john_111

    Replied To a Post in Multiple Keywords Search separated by commas in PHP/Mysql?

    Your input form is only asking for ONE job field. You can add to the form two or three more job fields ( or state fields as well I suspect). …
  • Member Avatar for john_111
    john_111

    Began Watching Multiple Keywords Search separated by commas in PHP/Mysql?

    I have a database with only one table which has around 2 Million rows and 60 columns. I created a php application with multiple search filters like name, country, state, …
  • Member Avatar for john_111
    john_111

    Replied To a Post in How do you convert a website so that it becomes mobile friendly

    Read up on media queries. These set widths based on screen size with some sizes chosen to correspond to a few popular sizes of devices. You create a series of …
  • Member Avatar for john_111
    john_111

    Began Watching How do you convert a website so that it becomes mobile friendly

    I have a website that is not mobile friendly, its designed in plain html and css how do i make the website responsive how do i make the menu go …
  • Member Avatar for john_111
    john_111

    Replied To a Post in Select Data from two mysql tables using one query not working properly

    A union is intended to produce all the results as if they were in one table so for tableA {x,y,z,a,b,c} and tableB{p,q,r,s,t} , a union that asked for columns x,y,x …
  • Member Avatar for john_111
    john_111

    Began Watching Select Data from two mysql tables using one query not working properly

    I want to retrive data from two tables. I used below code : (SELECT sum(total_amount) as tr from loan where loan_status = 'not finish') union (SELECT sum(amount) as tt from …
  • Member Avatar for john_111
    john_111

    Replied To a Post in return value to php form after image upload

    You could add a few lines after that last if statement as an else to it (ie it has successfully been moved) to display the filename in another pop-up perhaps. …
  • Member Avatar for john_111
    john_111

    Began Watching return value to php form after image upload

    I have a simple form that I want the user to input their name and submit a picture. The name user name and photoname will goto the database. The form …

The End.