kgizo

I have Post code column and I want to get 60, 30 and 10% for each area code that I have, but the thing is there is a between statement which makes things a bit complicated. I need 60% from the first postcode then 30% from the second and 10% …

Good day I have a table which I have already uploaded a list on however I want to return all the records which are duplicated and have a year between 2014 and 2015, i.e if I have a table like this Year IDNumber FirstName Surname Email 2014 8809254 Tom Jackson …

Good day everyone I just want to know whether its possible to upload a file using joomla that wouldnt be downloable at all, I tried saving the file as a read only pdf file but that still made the file downloable on the web. Taking into consideration that the internet …

Good day What I would like to do is to alter a mysql table with data in it then add manipulated string data to that created column i.e I first add an extra column to my table then add a reverse string coded from data that had already been inserted. …

Good day I want to start using php on the command line and I keep getting two errors, the first is that access is denied and the second is that xampp is not recognized as an internal or external command. I have already set my environment variables to the php …

Good Day I have been struggling lately to get the right path to execute php scripts on the command line. My php folder is found in c:\>xampp\php which I specied as the path above by accesseing the environmet variables directory. I was wondering whether I am doing anything wrong because …

I would love to know whether this code is the correct manner to send mysql data to a remote database. $host = 'www.domain.tld'; $user = 'remote_user'; $pass = 'remote_password'; $time_end = microtime(true); //grant per;misions to connect to remote host if (!function_exists("ssh2_connect")) die("function ssh2_connect doesn't exist"); // log in at server1.example.com …

Good day I need help incorporating a progress bar into my code, I first needed to export a query from my database but however the time taken for the query to be exported to a xls file should be shown in a form of a progress bar. if i exit …

Hi I have data to upload to a Mysql database and I need to get the time taken for each row to be inserted so that I can pass that number through to a progress bar. I have alreay tried accomplishing this by determining the number of rows affetced by …

Hi I have been struggling with this query for a while now I need to get the number of rows inserted into my database table, but I keep getting this error I can't seem to get rid of. $result3=mysql_query("INSERT INTO dest_table.create_info SELECT * from Profusion.source_cdr"); $num_rows = array($result3); $progress=mysql_num_rows($num_rows); echo …

Hi I've already read data in another file which is an array, which is now in a string format, what I want to do is change the array into an integer so that I can add the elements of that array. Code given below import java.io.BufferedReader; import java.io.DataInputStream; import java.io.FileInputStream; …

Hello I want to send xml values to a database I just created, here is the xml file <record> <name>tcpmux</name> <protocol>tcp</protocol> <xref type="person" data="Mark_Lottor"/> <description>TCP Port Service Multiplexer</description> <number>1</number> </record> <record> <name>tcpmux</name> <protocol>udp</protocol> <xref type="person" data="Mark_Lottor"/> <description>TCP Port Service Multiplexer</description> <number>1</number> </record> I've got 4 columns in my database:- ServiceName, …

Hi I am using Mac OS X and I just installed eclipse but it just cant seem to read my headers. I saw a coulple of manuals on the internet but none of them seems to work, I need to know what directory should I enter in the GNU C++ …

Hello, I would love to display the values of 65 columns which have been added and then display them on the screen, at the moment only 59 of the 65 columns added appear. here is my code. $result = mysql_query("SELECT SUM(segment) AS segment, SUM(funct) AS funct,SUM(pronoun) AS pronoun.............. right up …

Hi I need to represent data from my mysql table into a graphical format. I summed all the columns I needed then I need to represent the addition of each individual column onto a graph, but I want to print the correct data onto my screen first then represent the …

Hello I want to send xml values to a database I just created, here is the xml file <record> <name>tcpmux</name> <protocol>tcp</protocol> <xref type="person" data="Mark_Lottor"/> <description>TCP Port Service Multiplexer</description> <number>1</number> </record> <record> <name>tcpmux</name> <protocol>udp</protocol> <xref type="person" data="Mark_Lottor"/> <description>TCP Port Service Multiplexer</description> <number>1</number> </record> I've got 4 columns in my database:- ServiceName, …

Hello I just read a document using PHP and I need to skip the first 58 lines of that document and then start sending the data that follows from those lines to my database. How do I go about skipping the first 58 lines of the document. I really need …

Hello, I'm trying to read a text file which is on the web and then insert its contents in a database using PHP. I think my code is okay but I keep getting this error message which I think might be permission problems so I just need clarity on this. …

hello I'm developing an online game for this mini project we are about to embark in. The game I'm developing is similar to battle ship its just that I will use my own entities instead of using battle ships. Now I've already have a full code for the game which …

Hello I've got a problem whereby I need to block access to my survey, I do not want a situation where a user can access the survey by just entering the URL of the survey, the survey has been integrated with mediawiki. Thanks in advance kgizo

Hi everyone I'm currently working on a survey project,now my problem is that my while loop isn't giving the correct results. i have a mysql table that looks like this. sectionID SurveyID sectionTitle sectionInstructions 1 2 section1 answer the following questions 2 2 section2 answer the following questions Ive already …

hi i'm new to ajax i've already got a drop down menu populated with values from my database and the code is underneath here, when i click on any province in the drop down menu the cities have to appear on the next page which are also from my database.The …

Hi what i want to do is pass a php variable in a script i've already got a drop down list now what i want to do is as soon as you click on any province in the drop down menu the cities appear in the text area. what is …

hi i'm new to php, i already have a database called msansi its table called provinces i've already created a drop down list of all my nine provinces now what i want to do is, i want the cities associated with the provinces to display on the same page as …