Jump to content

Joey46

Members
  • Content Count

    150
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Joey46

  • Rank
    Member

Profile Information

  • Location
    Australia
  1. i tried this <object data=http://www.web-source.net width="600" height="400"> <embed src=http://www.web-source.net width="600" height="400"> </embed> Error: Embedded data could not be displayed. </object>it did not work and i have no idea what Inline Frames are as we have not been taught and we only have a couple of weeks left in the course matecan i place that line of code anywhere Synook?
  2. How do i embed a website that i created into my new homepage, rather than have links to the other websites i have created for clients please
  3. various techniques and specific information employed by a web developer for collecting data about users ?? pls help me with this question
  4. various techniques and specific information employed by a web developer for collecting data about users ?? pls help me with this question
  5. Joey46

    Help Please

    What command do i use so my internal css page links with my external css page or can't that be done?Thank you before hand in case i forget later : )
  6. This is what i am getting back nowSomething went wrong. MySQL reports: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 'diploma', 'flex')' at line 1 so then i played around with it and it says added now so it is fixed thankyou for your help much appreciated mate
  7. This is my php script now$CourseNumber = $_POST['CourseNumber'];$CourseName = $_POST['CourseName'];$StudyMode = $_POST['StudyMode'];// assemble the sql query string to insert a record$query = "INSERT INTO Courses (CourseNumber, CourseName, StudyMode,)"; "VALUES ($CourseNumber, '$CourseName', '$StudyMode')"; // open a connection and select the database$conn = mysql_connect($host, $username, $password);@mysql_select_db($database, $conn) or die( "Unable to select $database database"); // add the recordif(mysql_query($query, $conn)){ echo "Record added successfully!";}else{ echo "Something went wrong. MySQL reports: <b>", mysql_error(), "</b>";} mysql_close($conn);This is now the error msgSomething went wrong. MySQL reports: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
  8. You were right of course but when i tired it after fixing it i still get this errorSomething went wrong. MySQL reports: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') VALUES ('', 'Diploma', 'flex')' at line 1
  9. This is my PHP code below$CourseNumber = $_POST['CourseNumber'];$CourseName = $_POST['CourseName'];$StudyMode = $_POST['StudyMode'];// assemble the sql query string to insert a record$query = "INSERT INTO Courses(CourseNumber, CourseName, StudyMode,) VALUES ('CourseNumber', '$CourseName', '$StudyMode')"; // open a connection and select the database$conn = mysql_connect($host, $username, $password);@mysql_select_db($database, $conn) or die( "Unable to select $database database"); // add the recordif(mysql_query($query, $conn)){ echo "Record added successfully!";}else{ echo "Something went wrong. MySQL reports: <b>", mysql_error(), "</b>";} mysql_close($conn); // reuse the previous forminclude("Courseadd.htm");?>This is my HTML code<h2 align="center">Add Course</h2> <form method="post" action="Courseadd.php"><table width="450" border="5" align="center" cellpadding="5" bordercolor="#CCCCCC"> <tr> <td width="150">CourseNumber</td> <td width="300"><input type="text" name="CourseNumber_ID" /> </td> </tr> <tr> <td>CourseName </td> <td><input type="text" name="CourseName" /></td> </tr> <tr> <td>StudyMode</td> <td><input type="text" name="StudyMode" /></td> </tr> <tr> <td><input type="reset" name="Reset" value="Cancel" /></td> <td><input type="submit" name="Submit" value="Add Course" /></td> </tr></table> </form><p> </p><div align="center"> </div></form>This is the ERROR MSGSomething went wrong. MySQL reports: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') VALUES ('CourseNumber', 'Diploma', 'flex')' at li
  10. This is now working Thank you for your help JustSomeGuy
  11. When i try to print out a mysql query this is all get to do the query with [sELECT * FROM `students` WHERE 1] so then i go to the next column and add this next bit [`ID`, `Name`, `Password`, `Email`, `PhoneNumber`] as that is all that is in the box then i get this error[ErrorSQL query: SELECT * FROM `students` WHERE 1 `ID` , `Name` , `Password` , `Email` , `PhoneNumber` LIMIT 0 , 30 MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`ID`, `Name`, `Password`, `Email`, `PhoneNumber`LIMIT 0, 30' at line 1 ]Now other than doing that i am not understanding what you want me to do or how to do what you want me to do mate
  12. i have tried to do what you asked now this last time i copied just that small piece of code into the php query othere than that i am not sure how to do what you are asking me to do i have very little knowledge on mysql and only a small amount on PHP I am sorry about the error
  13. this is what i got back from thatSQL query: $sql = "INSERT into students (ID, Name, Password, Email, PhoneNumber) values ('$ID', '$Name', '$Password', '$Email', '$PhoneNumber')" MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '$sql = "INSERT into students (ID, Name, Password, Email, PhoneNumber) values ('$' at line 1
  14. this is what i get when i query the php page in mysql queryThere seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problemERROR: Unknown Punctuation String @ 1STR: <?SQL: <?$host = 'db.kwilliams.cessnock-ict.net';<?$host = 'db.kwilliams.cessnock-ict.net';<?$host = 'db.kwilliams.cessnock-ict.net';<?$host = 'db.kwilliams.cessnock-ict.net';<?$host = 'db.kwilliams.cessnock-ict.net';<?$host = 'db.kwilliams.cessnock-ict.net';<?$host = 'db.kwilliams.cessnock-ict.net';<?$host = 'db.kwilliams.cessnock-ict.net';<?$host = 'db.kwilliams.cessnock-ict.net';<?$host = 'db.kwilliams.cessnock-ict.net';<?$host = 'db.kwilliams.cessnock-ict.net';<?$host = 'db.kwilliams.cessnock-ict.net';<?$host = 'db.kwilliams.cessnock-ict.net';<?$host = 'db.kwilliams.cessnock-ict.net';<?$host = 'db.kwilliams.cessnock-ict.net';<?this is what i get when i add the isert into There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problemERROR: Unclosed quote @ 7STR: "SQL: $sql = "INSERT into students`ID`, `Name`, `Password`, `Email`, `PhoneNumber``ID`, `Name`, `Password`, `Email`, `PhoneNumber`SQL query: $sql = "INSERT into students`ID`, `Name`, `Password`, `Email`, `PhoneNumber``ID`, `Name`, `Password`, `Email`, `PhoneNumber` MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '$sql = "INSERT into students`ID`, `Name`, `Password`, `Email`, `PhoneNumber``ID`' at line 1This is what i got when i did that 1 lineSQL query: $sql = "INSERT into students (ID, Name, Password, Email, PhoneNumber) values ('$ID', '$Name', '$Password', '$Email', '$PhoneNumber')" MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '$sql = "INSERT into students (ID, Name, Password, Email, PhoneNumber) values ('$' at line 1
×
×
  • Create New...