10,940 Topics
 | |
| | hello, i wanna know whats the best way to show query results from mysql onto a webpage.. some says this can only be done in form of table.. but nowadays table less design is preferred..tell me teh most demanding way if somebody knows.. |
| | i have an issue with this new form im using based roughly on a design template that i found online, it looks great for the purposes that i need it for, but the problem is i cant seem to get the input data from the form to pass to the … |
| | 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 … |
| | hello i doesn't want to get the same results each time i query mysql db.i want the results to be shuffled each time i query .please tell some time saving technique for shuffling result set from mysql..  |
| | Hi, I have a table `id - Product_Name - Price - image` Some value like : `1 - My Product A - 50 - mpa.jpg` `2 - My Product B - 10 - mpb.jpg` `3 - My Product A - 40 - mpc.jpg` `4 - My Product C - 20 … |
| | Hi,am new in php and appreciate your help in this matter....tried to save the record below into mysql database but couldn't.The field are blank and the Targetid field is always 0.Below is the coding...Please advise...Tqvm <html> <body> <form action="progress1.php" method="post"> <p> Quantitative Progress: <input type="text" name="Quanprogress1"></p> <p>Qualitative Progress: <input type="text" …  |
| | Is it possible to. Have Apache and MySQL started and running well as service on Ubuntu (I can get to MySQL through terminal and Apache works by correctly executing code which I can see by looking at localhost), then use virtual machine of Windows 8. Start there Apache and phpMyAdmin? … |
| | Hi, am trying to update google map markers without refreshing the map page. I used an ajax to refresh the php part of the code, hoping it will couse the markers to move,but no,lol. From what i found out online i need some kind of respond command for it to … |
 | Hy i have a db with 1 collum(with 20rows) i whant to create a custom table view of this database with the sum at the end of the table but with custom search function, i cand find an script to do this for me? Thanks  |
| | |
| | Hy i have two tables articles and iniziale, articles have a collum c2,and iniziale have c1 i whant to do like this c1(whic its have one value only)- sum(c2)(entire collum) ive tryied like this but nothing...:( <?php $result = mysql_query("SELECT *,SUM(iCarl)-SUM(CarrelliCC22) as total2 from articles,iniziale"); $row= mysql_fetch_assoc($result); echo "<h4>" . … |
 | Hello althouh i delete records from the database when i call them on a query they appear. Not the other records of the data just the id i have already deleted. I dont use WHERE because i want to return all records from table. Any guess why the id is … |
| | I have written some SQL code which does not appear to work. Any pointers will be provided 1. Update Table 1 Column 1 with the value of Table 2 Column 1 2. Update Table 1 Column 2 with the value of Table 3 Column 1 3. Update must be based … |
 | Hi all, I have to clarify a few ambiguites regarding mysql client to use for i running database scripts 1).Firstly i want to flush the root password set by me earlier using :mysqladmin -u root password 'root password goes here'. 2).Second i am faced with a problem of "Acces denied … |
| | unable to insert values into mysql table, only showing blank page. but after commenting mysql query code it's displaying echo $success part and not throwing any error message. code: if(!empty($_POST)) { // keep track validation errors $first_nameError = null; $last_nameError = null; $mobile_number1Error = null; $addressError = null; $magent_cityError = … |
| | Hi, am interfacing gps tracker TK106 with our online platform. The data we get from gps device is in this format (06667778889-9BP05000066677788899140815A0533.8206N00009.7045W000.0165936157.6200000000-L0000F51C) Instractions form [this site](http://sourceforge.net/p/opengts/patches/1/) explains the variours data sets in the string above, for example the first 11 digits 06667778889 is the device's programmable ID ,used in placed … |
 | studentmgt.php $search = $_GET['search']; echo $search; ?> <div align="center"> <div style="width:700px;text-align:left;padding-top:5px;"> <?php if (isset($confirmation)) { echo $confirmation; } ?> <form method="get" action="<?php $_SERVER['PHP_SELF'] ?>"> <br/> <?php //LOAD STUDENTS INFO $result = mysql_query("SELECT * FROM `student` INNER JOIN `group` ON group.group_id = student.group_id INNER JOIN `access` ON access.access_level_id = student.access_level_id ORDER … |
 | Hi, The following code selects and displays a record from the "emailtbl" table as desired except for the the date and it doesn't update the "lastused" (date) field to the "numbers" table via "lastused.php" include. No error messages. I need help. <html><head> </head> <BODY> <?php include ("lastused.php"); include ("counter.php"); $id="''"; … |
| | hi, i have an import csv script but it does not get entered into the database. only "uploaded successfully" and the data is echoed but nothing in the database is something wrong with it? and is it sql injection safe? <?php if(isset($_SESSION['sess_user_id'])) { if (isset($_POST['ubmit'])) { require "connection.php"; $session = …  |
| | Hy io have this php script(if you can call php script) anyway i whant that every result to show it one down the another(mysql grid table) but with that kind of search....i've tryied but unf nothing.... this is the "code" <?php $i = 0; if ($_REQUEST["string"]<>'') { $search_string = " … |
| | How to create a JDBC for Oracle and MySQL?  |
 | This is my script when any registed user click on checkbox then he insert tbl1 table and we set a cookie and run events after 36 minute event will run and insert data in to another table called tbl2 my code is <form action="course01.php" method="POST"> <input type="checkbox" name="chk1" value="701" />I … |
| | is it possible to run a php script using mysql event if so how to do that i mean syntex thanks in advance. |
| | While pressing start button in control panel it's showing some problem detected. |
 | Hi, I need some help with my college work, with the database I am designing. # Assuming I want this to happen: # **Main Category:** Level1 Level1 >Level1.1 >Level1.2 >>Level1.2.a >>Level1.2.b >>>Level1.2.b.a >>Level1.2.b.a.a >>>Level1.2.b.b How do I design this? Thank you!  |
 | Hey guys, so I'm considering moving my mysql scripts to be compliant with PHP 5.5 and above (mysqli). Is it a pretty staightforward transition? Can functions basically just be replaced with the new verions, or are there other things that have to be done as well? Also, I'm interested to …  |
| | Look at my table design below. It is a table that shows the roles of users. CREATE TABLE `userrole` ( `userid` bigint(20) unsigned NOT NULL, `roleid` int(10) unsigned NOT NULL, PRIMARY KEY (`userid`,`roleid`), KEY `fk_userrole_roleid` (`roleid`), CONSTRAINT `fk_userrole_userid` FOREIGN KEY (`userid`) REFERENCES `user` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE, … |
| | Hi all, i am hoping i will be able to get some quick help here. Ok i am basically building a web application where the user will be able to add,update,delete and edit fields in a database. So far i am on the Update part. I have a page called … |
| | This is my query : CREATE TABLE userrole ( userid BIGINT NOT NULL, roleid INT NOT NULL, PRIMARY KEY(userid,roleid), CONSTRAINT fk_userid FOREIGN KEY (userid) REFERENCES user(user_id) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT fk_roleid FOREIGN KEY (roleid) REFERENCES role(role_id) ON DELETE CASCADE ON UPDATE CASCADE ) So, what i want … |
 | I have a table with highschools in different cities. I want to give the user the option to choose a certain city and view the schools there, or view all schools. This is my original query: SELECT * FROM highschools WHERE city = '$givenCity' I need to compare 'city' to …  |
The End.