User Profile

Collapse

Profile Sidebar

Collapse
gerrybytes
gerrybytes
Last Activity: May 1 '08, 08:44 AM
Joined: Apr 8 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • gerrybytes
    replied to Keep adding into to same field
    Thanks Ronald,

    You have been of great help.

    G...
    See more | Go to post

    Leave a comment:


  • gerrybytes
    started a topic Keep adding into to same field

    Keep adding into to same field

    Hi,

    I was just wondering is it possible in mysql to keeping adding info to a particular field.

    I thought maybe the update query would work but that clears and previous data held in that field and all I want to do is add to it.

    Thanks

    G
    See more | Go to post

  • gerrybytes
    replied to Trouble returning id from auto increment
    It seems like a very trivial problem. Thanks for all your help in trying to get this sorted.

    My table uses auto increment, is value for this is BIGINT?

    Can this be changed so ur last suggestion can be tried?

    G...
    See more | Go to post

    Leave a comment:


  • Valid Query? (Insert into, values, select, where)

    Is the following a vaild query, or does any one have any suggestion on how to change it to get the correct info i'm looking for?

    [CODE=mysql]
    $Engineer = $_POST['Engineer'];
    $Ref_No = $_POST['Ref_No'];

    $query = "INSERT INTO engineer (Ref_No,Title,F orename,Surname ,Email,Branch,M essage,Severity ,Engineer)
    VALUES('$Engine er')
    SELECT Ref_No,Title,Fo rename,Surname, Email,Branch,Me ssage,Severity...
    See more | Go to post

  • gerrybytes
    replied to Trouble returning id from auto increment
    It returns Query error but no error message. This information is also still being posted to the database.

    G...
    See more | Go to post

    Leave a comment:


  • gerrybytes
    replied to Trouble returning id from auto increment
    Hi Ronald,

    No error message is returned because the information is sent correctly to the database, i check this manually.
    The page displays;

    Your unique Reference Number is =
    Back to main page

    No value is inserted after equals sign. It seems like its something small but I have no idea what.

    G...
    See more | Go to post

    Leave a comment:


  • gerrybytes
    replied to Trouble returning id from auto increment
    Hi Ronald,

    Thanks for your help but i must be doing something silly, when i implement your solution nothing is returned.

    Any idea why?

    G...
    See more | Go to post

    Leave a comment:


  • gerrybytes
    started a topic Trouble returning id from auto increment

    Trouble returning id from auto increment

    Could someone please help. I've searched alot of forums and website but none seem to give me the answer.

    I've posted info to my database and i'm looking to return the id using the mysqli_insert_i d() function. I'm posting it to php. Please someone help, going a bit mad as no integer is returned.

    [CODE=MYSQL]
    $query ="INSERT INTO New_Fault(Title ,Forename,Surna me,Email,Messag e)
    VALUES('$Title' ,'$Forename','$ Surname','$Emai l','$Message')" ;...
    See more | Go to post

  • gerrybytes
    replied to Using Java to connect to local host
    in Java
    Hi Nomad,

    I know about signing applets. I've done this ok and i get no error messages returned.

    Could it be, because i'm connecting directly to the local host or should i use the ip address?

    G
    See more | Go to post

    Leave a comment:


  • gerrybytes
    started a topic Using Java to connect to local host
    in Java

    Using Java to connect to local host

    Hi all,

    I created a Java application which allows me to send information to my mysql database using the jdbc connector via a JFrame. However when i modified the file to be a JApplet the info will not sent and i cannot connect to the database? Any particular reason for this?
    I need it to be a JApplet so i can add it to a browser window.

    [code=java]
    private void save ()
    {
    Connection conn = null;...
    See more | Go to post

  • gerrybytes
    started a topic Having trouble validating using mysqli
    in PHP

    Having trouble validating using mysqli

    I am using a form in html as a login. However when passing this info php to be validated I get an error from mysql statements.

    A point in the right direction would be of great help. I've been stuck on this for quite a while. The error is recevied when tring to connect to the database i am using.[php]<?php
    session_start() ;
    $host="hostname ";
    $user="username ";
    $db_password="p assword";...
    See more | Go to post
    Last edited by ronverdonk; Apr 9 '08, 10:49 AM. Reason: code tags
No activity results to display
Show More
Working...