Nollyvenon

My SQL query is: UPDATE REGISTRUDENT set qual=1 WHERE studentolevelsubjects AS sls INNER JOIN courserequirements AS csreq ON sls.subject_id = csreq.subject_id WHERE sls.stud_id = '$stud_id' AND sls.grade_id>=csreq.min_grade AND sls.examno = '$examno' AND csreq.course_id = '$course_id' I'm having issue comparing two different table to get if a registrant qualified based on …

How can I get the Machine IP of visitors of my website logged. I've used function getIp(){ $ip = $_SERVER['REMOTE_ADDR']; if($ip){ if (!empty($_SERVER['HTTP_CLIENT_IP'])) { $ip = $_SERVER['HTTP_CLIENT_IP']; } elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) { $ip = $_SERVER['HTTP_X_FORWARDED_FOR']; } return $ip; } BUt what I get is my server IP. Thanks

I intend to have w3html5.gif with clickable hotspots. I need to make the image clickable on different points. Point for Daily, Weekly. currently my code is: <video controls poster="/images/w3html5.gif"> <source src="movie.mp4" type="video/mp4"> <source src="movie.ogg" type="video/ogg"> Your browser does not support the video tag. </video> Thanks for your help.

I'm creating a query which checks if a client made payments for a given month and if not set charges of 20% of the agreed monthly payment. this is what i currently have: SELECT DAY(paydate) AS PayDay, clientid FROM transactions,clients where transactions.clientid=client.clientid and transactions.product=invoices.product and DAY(paydate)> 10 order by client.clientid …

How do I find the network type(EDGE, UTMS, HSPDA etc) of user accessing my site in php Thanks.

Please can someone help me optmize this query, it is slow and brings the same data for the debtage column SELECT customer.custid,customer.compname,customer.phone,customer.depot,acctofficer.acctfullname AS acctoff, STR_TO_DATE(mastorders.lastsuppdate,'%d-%m-%Y') AS purchdate, STR_TO_DATE(transactions.timestamp,'%Y-%m-%d') AS debtage, format( customer.balance, 2) AS balance, customer.balance AS balance1 FROM customer,mastorders,acctofficer,transactions WHERE customer.custid=mastorders.custid and acctofficer.acctoffid=customer.acctoff AND customer.depot='$depot' GROUP by customer.id ASC. …

I have a query which i am trying to get the last date and when i do, the purchdate and LastPayDate is the same for all the data. the query is below: SELECT DISTINCT customer.custid,customer.compname,customer.balance AS balance,customer.phone,acctofficer.acctfullname AS acctoff, preAgg1.LastPayDate,customer.depot, MAX(mastorders.lastsuppdate) AS purchdate, MAX(mastorders.id) FROM customer,mastorders,acctofficer, (SELECT DISTINCT T.custid, Max(T.timestamp) …

Please can i get a help on joining these 3 queries SELECT customer.id,customer.custid,customer.compname, customer.balance AS balance,customer.phone,acctofficer.acctfullname AS acctoff, STR_TO_DATE(mastorders.lastpaydate,'%d-%m-%Y') AS debtage,customer.depot, STR_TO_DATE(mastorders.lastsuppdate,'%d-%m-%Y') AS purchdate FROM customer,mastorders,acctofficer WHERE customer.custid=mastorders.custid and acctofficer.acctoffid=customer.acctoff GROUP by customer.id ASC SELECT customer.id,customer.custid,customer.compname, customer.balance AS balance,customer.phone,acctofficer.acctfullname AS acctoff, customer.depot FROM customer,acctofficer WHERE acctofficer.acctoffid=customer.acctoff GROUP by customer.id ASC …

Please i have a form that has textfields dynamically generated and work fine.but i want to have one of the field display from the database while an textfield multiply the value from database for each of the lines.how do i do that? below is my code: <SCRIPT language="javascript"> function addRow(tableID) …

Can someone help please i have a code and want the quantity to be retrieved from the database and loaded to each textfield row.can someone help debug. thanks. <SCRIPT LANGUAGE="JavaScript"> function getValues(objName,objName2,objName3) { var var3 = ""; var arr = new Array(); arr = document.getElementsByName(objName); arr2 = document.getElementsByName(objName2); arr3 = …

Hi!! This is some of the code I am using to add dynamic rows when user clicks the Add Row button.I want to show the calculated amount like: line_total=qty*unit_price; sub_total=total of line_total; total=sub_total+tax-advance; [CODE]<script type="text/javascript"> function addRow(tableID) { var table = document.getElementById(tableID); var rowCount = table.rows.length; if(rowCount<3) { var row …

I designed an invoice system that add rows automatically and computes the results, print it in another file that can be downloaded by other users.can i get help on how to multiply the price and quantity to get amount? this is my code: <SCRIPT LANGUAGE="JavaScript"> function showamt() { //var unitprice …

I designed an invoice system that add rows automatically and computes the results, print it in another file that can be downloaded by other users.can i get help on how to multiply the price and quantity to get amount? this is my code: <SCRIPT LANGUAGE="JavaScript"> function showamt() { //var unitprice …

How do i recode a china phone to show customize features like startup images, animations and sounds. this is my midlet code for image [code]//MIDlet-Name: startupScreen //MIDlet-Version: 1.0 //MIDlet-Vendor: MyCompany //MIDlet-Jar-URL: StartupScreen.jar //MIDlet-1: startupScreen, startupScreen //MicroEdition-Configuration: CLDC-1.0 //MicroEdition-Profile: MIDP-1.0 //MIDlet-JAR-SIZE: 100 import javax.microedition.midlet.*; import javax.microedition.lcdui.*; public class startupScreen extends MIDlet …

how to display formatted text, images and flash those url stored in mysql database in php?

how do i create java code that randomly assign numbers to letters, sum them, display them and store them in a database