10,946 Topics
 | |
 | 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 … |
| | here i am store the dynamic row values into mysql. i am using jquery and javascript for dynamic rows and auto calculation and then stored to mysql using php coding. that works perfectly. i already added dynamic row value into mysql perfectly. But, now i want to edit the table … |
| | i want to insert new data but the data didnt show up in database and didnt display for user when i click foe change theres nothing happend i couldnt find any error...ples help me (BookingnDisplay.php) <h1><?php if($_SESSION["name"]) { ?> Welcome <?php echo $_SESSION["name"]; ?>. Click here to <a href="logout.php" tite="Logout">Logout</a>. …  |
| | Hi All, I have a problem with my Microsoft SQL Server. When I execute my queries, it did not appear. The screen says, "Save Result as". I already unchecked the "Prevent saving from changes...." from >>Tools>>Options>>Designers>>Tables and Database Designers but it keeps in appearing. Please help! Thanks in advance :) |
| | Hey, does anybody know how to read cloumn from MySQL? I mean, like if I have in my MySQL the schema "Bdatabase" and the table "accounts". In that table there are username and password. How can I do in my program that it'll read the username and password?  |
| | I need help playing audio from mysql blob. I know how to save audio file as blob but I don't know how to play it in vb.net. Is there a way to play audio from mysql blob without saving it first as a file? If so, I need sample codes, …  |
| | Hey guys, yes my problem is very, very trivial and im sure it does not rank importance to be posted but im really frustrated. See my coding was fine as in it executed as i wanted it to and now i dont know why but it isn't and i have … |
 | I have some problem about uploading and database. I upload the file (abc.jpg) and the file already insert to the folder name (uploads). But when I check in database (php), the file did not enter. Here is my code. Hope anyone can help me.Thank you. <? include "conn.php";?> <?php error_reporting(0); … |
| | i have retrieved mysql data from one table in json using the following script [CODE]$table_first = 'abc'; $query = "SELECT * FROM $table_first"; $resouter = mysql_query($query, $conn); $set = array(); $total_records = mysql_numrows($resouter); if($total_records >= 1){ while ($link = mysql_fetch_array($resouter, MYSQL_ASSOC)){ $set[] = $link; } } echo json_encode($set);[/CODE] how can … |
 | I have a query that used union all.. and produces a table like this: `+-------------+------------------------+-----------+--------------+ | Type | Name | IDNum | Warnings | +-------------+------------------------+-----------+--------------+ | M | sample | 2013-1 | 4 | | L | sample | 2013-1 | 2 | +-------------+------------------------+-----------+--------------+` now i made a while loop … |
| | edit.php coding... <?php $uid = (int)$_GET['id']; ?> <form action="update.php" name="myform" method="post" onsubmit="return(validateform());"> <input type="hidden" name="edited" value="<?=$uid;?>"> <?php $tariff_query = mysql_query("SELECT * FROM ebvouchertariffs WHERE VoucherID_Fk = $uid"); if(mysql_num_rows($tariff_query)>=1) { echo "<table width=960 align=center cellspacing=0 cellpadding=0> <tr> <td width=68 height=50 class=tabtext>SL.NO</td> <td width=106 class=tabtext>DATE</td> <td width=204 class=tabtext>PARTICULARS</td> <td width=117 class=tabtext>NO OF … |
| | i wish to capture user input regarding workhistory on one form - how do I catch the same infor structure, ie. company name, position, duration, job description, for 3-4 companies, dynamically in PHP and write it to mySQL. I need direction on how to do this re...form structure and table … |
| | Hi! I have in my database few tables and each table have a column with dates of inserting records. I don't know how to go through the database, through all tables, in chronological order, from the first inserted record until the last, can anyone help? tnx!  |
| | i want to populate my jtable with selected items in my jcombobox below is the code i wrote to perform the action but it does not. please am still new in java so i will appreciation the help. if(AssetCategories.getSelectedItem() == "LAND & BUILDINGS"){ try { String sql = "SELECT Description … |
| | I have two table company table , product table and customer table compnay table have C_id as PK , FK P_ID of product product table have P_ID as PK and cust_ID FK of customer customer table have CUST_ID as pk and P_ID as fk I want to add data to … |
| | Hey guys, So, as the title says, trying to join four tables. The purpose of the script is to: 1. Get the username of members being "followed" from table called following 2. Find the status updates of members in step one from table called status 3. Retrieve all comments on … |
| | below's code is a code i wrote to get the value of 'monthly Depreciation' when i select the row on my jTable by either mouse-clicked or key-pressed. but it only selects the first value for 'monthly depreciation' when i click on the rows or key-press.the problem i know is coming … |
| | Hi! Can anyone know the result of this query: SELECT COALESCE(MAX(ID),0) + 1 FROM Table123 |
| | I have a searchable database.. I would like to change the style of how the table is displayed... I have a css file of how I would like the table displayed.. Can that be done? If so..How? |
| | <?php include("config.php"); if (isset($_POST['submit_val'])) { $cmeal = mysql_real_escape_string($_POST['meal']); $meal = "INSERT INTO ebmealplans( MealPlanName, CreatedOn ) VALUES ( '{$cmeal}', NOW() )"; if(!mysql_query($meal, $link)) { die("Error : " .mysql_error()); } $croom = mysql_real_escape_string($_POST['room']); $ref_key = mysql_insert_id(); $room = "INSERT INTO ebroomtypes( RoomTypeName, CreatedOn ) VALUES ( '{$croom}', NOW() )"; if(!mysql_query($room, $link)) … |
| | index.php coding <td><input type="text" name="slno[]" value="" size="2"></td> <td><input type="text" size="10" name="date[]" id="SelectedDate" onClick="GetDate(this);" readonly="readonly"/></td> <td><input size="24" type="text" name="particulars[]" value="" placeholder="Description"></td> <td><select name="noofnights[]" value="0"> <option value="empty"></option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> <option value="6">6</option> <option value="7">7</option> <option value="8">8</option> <option value="9">9</option> <option value="10">10</option> <option value="11">11</option> <option value="12">12</option> <option … |
| | hey guys, so im trying to display data from my database into a table but i got this error : Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\CashFlow\balance_report.php on line 45 code: <?php require "connect.php"; if($_SESSION['name']) { $name = $_SESSION['name']; $query=("SELECT * FROM asset WHERE name … |
| | i have a problem in choosing data type for this column in SQL..can anybody help me??? result (tournament_id*, player_id*, round) i've done the first 2 columns, i'm confused about the data type of round=='...i wondered if it was cstring or text or numeric here's my code : tournament_id int, player_id …  |
| | i have a database (hello) and it has 2 tables 1. login_tbl and 2. users_tbl both contains the 3 fields id,username,password and id,first_name,last_name respectively. now plz help me to write the php code according to this which helps to search the users details in users_tbl and fetch all the records. … |
The End.