10,940 Topics
 | |
| | seems like a simple issue but i can't wrap my head around this. i need to get all rows where date is today BUT a new day starts not at 00:00:00 but at 02:00:00 the results are displayed all the time (page is refreshed every few minutes) so the current … |
| | Hi.I'm Nizam. Sorry if the question I asked is unclear. I have the table as below **Classroom** - id - capacity - code - ...... **Schedule** - id - group_id - classroom_id - ...... The schedule will be filled with the group and classroom. My problem now is how can …  |
 | i search a lot of reference in web, but still im not satisfied to solve this problem, i used datetimepicker in vb.net to retrieve from database. i am using BETWEEN statement to search the specific date and its data. here is my code to search the data with specific date, … |
 | I have one table that I want to separate them into two to normalize the data. I want a opinion of the best way of doing it. My table has lots of columns and one of them I was storing Varchar values separated by comma, for instance: John, Mary, Joseph …  |
| | i need help..to anyone who expert in servlet & Jsp.. my problem is..i do not know how to upload image via html/jsp.. >before that i already ask mr.google but.. i got sux answer. so, this code work's and upload succesfully but it must manually put the destination file type string …  |
| | Sir, I am using these codes <?php if(isset($_POST['login'])){ require_once("connect.php"); session_start(); // username and password sent from Form $myusername=addslashes($_POST['username']); $mypassword=addslashes($_POST['password']); if(empty($myusername) || empty($mypassword)) { echo '<script>alert("User name and password must not be empty")</script>'; }else{ $query="SELECT name FROM admin WHERE mobile='".$myusername."' and password='".$mypassword. "'"; $result=mysql_query($query); if(!$result) { echo "<script>alert('username, password query is … |
| | I am using below query for fetching result using union of two tables. I am trying to get total number of records after union of two tables Need Suggestions. ` SELECT a.* FROM svn_headline a where a.newstypeid=2 UNION SELECT b.* FROM svn_crimenews b where b.newstypeid=2 order by newsdatetime desc SELECT … |
 | is there a way to mouse over the previous image and keep the previous image there but use png file that only has a play button in it. I echo my images out like this so I cant use java in the start of the page as I dont have … |
 | What's wrong with this code: <?php include('include/con_database.php'); $result2 = mysql_query("SELECT * FROM banner ORDER BY DESC"); while ($data2 = mysql_fetch_array($result2)){ echo '<td>'.$data2['images'].'</td>'.'<br>'; } ?> Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in E:\xampp\xampp\htdocs\IndonusaCMS\index.php on line 39 Line 39: while ($data2 = mysql_fetch_array($result2)){ |
 | please am new to database management but the question i have a form for my input by new users but i want to get the user name and password from the form to create new priveleges to the database so that when the user log-in the next time his username … |
| | Hello All, I am getting error "*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*" on running my php script. My SQL Syntex is: $query = "SELECT (movie_name,movie_year,movie_director,movie_leadactor,movie_type,movie_running_time,movie_cost,movie_takings) FROM movie … |
| | this is my table subjects in lecturer database No subject credit_hour 1 (111) AAA 4 2 (222) BBB 3 3 (222) CCC 4 4 (333) DDD 3 this is my testing1.php <?php $conn = mysql_connect('localhost','root','password'); mysql_select_db('lecturer'); if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } ?> … |
| | Hi <form action="check.php" method="POST"> <input type="text" name="keywords" /><br /> <input type="submit" value="Save The Keywords" /> </form> I need the keywords to be links for example : when the member put : php,mysql it should turn like this in the database : <a href="#">php</a> <a href="#">mysql</a> so when I query the … |
| | how to store JTree data hierarchically in mysql database from netbeans. I am new to this topics so I need a program and tables you are using in database . for ex: Items |-shoes |-shirts |-half shirt |-sarees when i click on add button it should add nodes to parent …  |
 | Hey all, I have a query like this one: `select * from topic order by topic_view_time limit 10` the topic table has a PK topic_id and some other varchar fields. It also has topic_view_time which is int and has the value of time() (in php) updated whenever a user view … |
| | I have a login page that uses email and password and also an admin checkbox. i have already created the coding for email and password login but not the coding if checkbox is checked it will direct admin.php coz well im not sure how. normal users will be directed to … |
| | so my newest problem! i have a save button and that save button already has the insert into query and working fine now what i wanna do is when the user clicks on the save button what it does first is, it checks if a record of that user already … |
| | I have three table **customer** c_id NUMBER c_name VARCHAR2 c_address VARCHAR2 **order** o_id NUMBER fk_c_id NUMBER o_name VARCHAR2 o_price NUMBER o_orderDate DATE **order_history** oh_id fk_o_id fk_c_id oh_status VARCHAR2 oh_dateChanged DATE When the customer make an order it will show default status as pending then if the status change to approve … |
 | Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in F:\xampp\htdocs\s.php on line 95 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR...l1-strict.dtd"> <!-- --> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta name="keywords" content="" /> <meta name="description" content="" /> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> <title>Yakity Yak</title> <link href='http://fonts.googlea...=Oswald:400,300' rel='stylesheet' type='text/css'> <link href='http://fonts.googlea...css?family=Abel|Satisfy' rel='stylesheet' … |
| | Ok so I have three tables Customers,Invoices,and Delivery with the fields: Customers: CustomerID Address ........ Orders: OrderID DeliveryID ....... Delivery: DeliveryID DeliveryToAddress ...... So what I want to do is update my delivery table for the DeliveryToAddress for when the customers address changes within the customers tables. To get the … |
 | Hi, I have a already designed web page with tables and stuff, but there are challenges for me to insert or include php and inserting the data that is from mysql to the tables in the webpage. I do not know how to do it to maintain the integrity of … |
 |  look at this image. when i send this page via email it shows the php code. it does not fetch the details from mysql and then i'm fetching the mysql records based on the particular voucher id. how to send mysql fetch records page via email? |
| | i am fetching values from a database in a page using while loop..the page where i ma fetching values from database have 8 columns , out of 8 , 6 cloumn values are coming from database , now on this page i have added two columns , now what i … |
 | hi there, I want to upload a video in my project folder(e.g. uploadedvideo) and save the name of the video in mysql database using jsp servlet. earlier I have found some code in net which required the destination path like c:\...\uploadedvideo etc. I think if I use c: it will … |
| | Hey all, I would like to know why when having big data in mysql table, executing a query for the first time takes 0.1.. sec, but if executing again the same query later, it will take only 0.0006 sec ? Exemple: SELECT name FROM `users` where id > 310000 limit …  |
| | i want to ask is my coding correct or not.. ive been trying for many times and cant find the errors. thanks in advance if you guys help me with this problem. <!-- ubah.php --> <!-- Interface of update data. --> <?php include("db.php"); $idURL = $_GET['id']; $query = "SELECT * …  |
| | Hi I'm working on a website and every thing is going great untill I faced this problem with the editing page! here is my code : <?php session_start(); if(!isset($_SESSION['admin'])){ echo "Only admin has access to this page"; header("Refresh: 3;url=login.php"); }else{ require("inc/config.php"); require("inc/header.php"); $id = (int)mysql_real_escape_string($_GET['id']); $title = $_GET['title']; $describtion = … |
| | <form action="searchdetail.php" method="post"> SEARCH BY: <select name="searchby"> <option value="gname">Guest Name</option> <option value="city">Guest City</option> </select> <input name="query" type="text" /> <input name="subval" type="submit" value="Search" /> </form> and searchdetail.php include("config.php"); if(isset($_POST['subval'])) { $query = mysql_real_escape_string(trim($_POST['query'])); $sql = mysql_query ("SELECT * FROM voucher WHERE gname = '$query'"); echo "<table border=1 width=860 align=center cellsapcing=5 cellpadding=5>"; … |
| | Hi every one, I am using this funtion function get_last_inserted_id($table) { include "dbsetting/adm_vars_config.php"; include "dbsetting/classdbconection.php"; $dbacosis = new dbacosis(); $sqlacosis = $dbacosis->queryacosis("SELECT LAST_INSERT_ID() AS `last_id` FROM `pcosis_courses`;"); if(!$sqlacosis or mysql_num_rows($sqlacosis) == 0) { return false; } else { $data = mysql_fetch_array($sqlacosis); return $data['last_id']; } } $id = get_last_inserted_id("courses"); echo $id; … |
| | <?php $input = $_GET['input'];//Note to self $input in the name of the search $terms = explode(" ", $input); $query = "SELECT * FROM `#####` WHERE 1 LIMIT 0 , 30"; foreach ($terms as $each){ $i++; if ($i == 1) $query .= "keywords LIKE '%$each%' "; else $query .= "OR keywords … |
The End.