10,940 Topics
 | |
 | 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. … |
| | i have created a page which has a table that enables user to delete a record via a delete button but somehow the queary isnt working. php coding <?php include("dbase.php"); $idURL = $_GET['id']; // Connect to database server mysql_connect("localhost", "root", "") or die (mysql_error ()); // Select database mysql_select_db("studiobooking") or … |
| | I have a query that starts like this... SELECT COUNT(A.FISH), COUNT(B.MEAT), COUNT(C.FRUIT).... now my problem is this, how could I count when I need to consider an expiration date for each column,...and the expiration dates varies for each column... Can I do this in one query? Or is there any … |
| | Dear friends on daniweb, First of all hope all of you are ok. I post this article to suggest me some ideas about the attachment of paypal in php. I wish to try a booking site for travelling(as a dummy at this stage). For this, php language is better than … |
 | we have problem regarding to the list view portion as you can see on the figure. On the left list view, we have a list of authors which data bounded through the database. we want it to transfer several of the information on the right list view then get its … |
| | I have a database with a table, jobs and i have written this query to get information from this table. But i am getting no results with this data and i have no idea why? SELECT startDateTime, endDateTime FROM jobs WHERE startDateTime BETWEEN '19/11/2013' AND '20/11/2013' Database Structure: 1 jobId … |
 | I have the following code which I use in PHP-Liquid template engine. I want the ability to add or delete rows trough phpMyAdmin instead of adding/deleting new arryas. So I need to use MySQL, but how should I proceed to work it out with my example? $assigns = array( 'blog' …  |
 | Hi Master, please help me, i could not insert my multiple checkbox selected value into my table. please see and help me. its insert only one value like first one. here is code: **HTML code: ** <td width="75%"> <input type="checkbox" name="whats_include[]" value="Breakfast" > Breakfast / <input type="checkbox" name="whats_include[]" value="Lunch" > … |
The End.