76 Topics
|
|
hi friends... The following code is for getting tables list from specific database from MySql... =================================================================== #include <windows.h> #include <iostream> #include <mysql/mysql.h> using namespace std; int main() { //connection params char *host = "localhost"; char *user = "root"; char *pass = ""; char *db = "prakash"; //sock MYSQL *sock; sock … |
|
Hello Everyone So I have 2 datagridviews that compare information between them and if it does match it colors the rows in green and after its done all the white spaces colors the rows in RED, so the main thing is that i dont know how to print only the … |
|
Hey all, Some rows of a single table in a database that I administer manage to have gone missing. Not that big of a problem: I have a backup. The issue is that there has been more information added since the old data was lost, so I can't do a … |
|
Title says it all. I am looking for a way to find the values of a column within a row. I am unsuccessful at being about to create a for loop that searches each value in the row and inputs a value if it is x. For example: [CODE] there … |
|
I have 2 tables: 1. users - user_id(PK), firstname, middlename, lastname 2. user_shift_schedule - shift_code(PK), user_id(FK), effectivity_date I want to get all rows with the latest effectivity_date for each user_id. This is what I've got so far: [CODE]SELECT users.user_id ,users.firstname ,users.middlename ,users.lastname ,user_shift_schedule.shift_id ,MAX(user_shift_schedule.effectivity_date) FROM users JOIN user_shift_schedule ON users.user_id=user_shift_schedule.user_id … |
|
Hi, i'm doing a page where user can register and give up of a course: [CODE]<td width="5%"> </td> <td> PROGRAMAÇÃO: <br/> <?PHP $cc=$_GET['cod']; $sql_prog = "SELECT prog_curso FROM cursos WHERE cod_curso=".$cc; $query_prog = mysql_query($sql_prog, $connect); while ($row = mysql_fetch_array($query_prog)) { echo $row['prog_curso']; } ?> <br/> </td> <?PHP if(is_logged()) { ?> … |
|
Hi, I have this code that will import the excel sheet to the datatable then inserts it in the database, but I have this problem. I have set the HDR to yes so that the first row will be considered as its header, but the problem now is that if … |
|
Hello, I am programming for my Robotics team, and I have to write code for a dashboard, including different camera feeds and setting up rows or columns for the different elements. I am quite new to Java, but I gotten through most of it except for the rows. I can't … |
|
I am working on improving the visual appeal of table rows. The data in table rows is generated dynamically and has lots of information. There is a column in that table which gives the time when that particular information row was issued. On the basis of the days/months etc before … |
|
Hi again! I have a database and some tables filled with data. [code=c#] var club = Baza.Clubs; //Baza is dataset, and Clubs is table var schedule = Baza.Schedule; // same as above for (int i = 1; i <= 90; i++) { if(schedule[i].day == 2) // BOOM! Breaks at first … |
|
Hi everyone! I've been looking for a solution, but i just can't find it anywhere... Ok, so the problem is: i have a database which looks something like this: user_id product_id score 14 . 235 . 79 23 . 235 . 32 53 . 665 . 21 14 . 235 … |
|
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> <SCRIPT language="javascript"> function addRow(tableID) { var table = document.getElementById(tableID); var rowCount = table.rows.length; var row = table.insertRow(rowCount); var colCount =table.rows[0].cells.length; for(var i=0; i<colCount; i++) { var newcell = row.insertCell(i); newcell.innerHTML = table.rows[0].cells.innerHTML … |
|
[COLOR="Green"]I am trying to select a row in my datagrid. There are two columns only. The row displays into two text boxes. I am trying to figure out how to select the next row in my datagrid. I have tried looking at your examples but I am still having trouble. … |
|
hi i display images from database, i want that there should be at most 4 photos in each row,when the number photos exceeds 4, it should displays the remaining images in next rows, the code i have written displays all images in the same row, i don't know how to … |
|
Hi all, So I have 2 files where one is an ajax script that calls another file that does some mysql database query. What is the best way to echo out multiple recordset rows to ajax?. Please see the source code below: ajax code: [CODE] <form name="form1" method="post"> Please enter … |
|
I have to design a database where one requirement says "For each project, for each user, for each skill, store the marks gained". Initially, i had a table where each skill was a column(proj_id, user_id, skill1, skill2, ......., skill_N) I felt this was a bad design because the number of … |
|
I have to design a database where one requirement says "For each project, for each user, for each skill, store the marks gained". Initially, i had a table where each skill was a column(proj_id, user_id, skill1, skill2, ......., skill_N) I felt this was a bad design because the number of … |
|
Hi All I would be greatfull if somebody could help me out with this one. ive been scratching my head all day in trying to find a solution. I have a order confirmation page which displays the entire order on a shopping cart. this page inserts a row into table … |
|
Hello. I have a small problem. I am working on a small website where people will be able to take quizzes for driving lessons. I take my questions and answers from a database. The problem is that i get the first questions and after i submit the answers, the next … |
|
Hi, I am really new to Python and I am having real trouble with this new language. This is what I want to do: I have two sets of .txt files that contain numbers. They look like this: FILE1 1028.085 283.795 2056.13 295.254 121912.4 11.346 0.004 147.932 780.677 966.771 289.326 … |
|
This looks as it should except that it needs more spacing between the columns. How would I do that? [CODE]<script type="text/javascript"> /* <![CDATA[ */ var numRows = "10"; var numCols = "10"; if (isNaN(numRows) || isNaN(numCols)) { }else { var tblHTML = "", rowHTML; for (var row = 0; row … |
|
Hello! I want to create a script which mails emails to subscribers. I'm almost done, but I'd like it to say "Sent to # people". I've tried using: [CODE]<?php $dbc = mysqli_connect('localhost', 'username', 'password', 'database') or die('Error: Could not connect to database'); $query = mysql_query("SELECT * FROM table"); $number = … |
|
hi i want to ask about how to disable the button when the datagrid have 9 rows? i want to control the button.after the datagrid have 9 rows, then the button.enabled=false. tq. |
|
So I've been giving a number of assignments to do but I'm stuck on one in particular now. I've to create a 2D array ([5][2]) and then say how many times ou of the 5 rows that the first row was bigger than the second. I imagined I would need … |
|
I have a Mysql database and I am trying to import multiple records with multiple columns into Flash AS3 using PHP. My problem is I am able to make it work with a single column and multiple records but for multiple columns I am not being able to format it … |
|
What is the fasted way to delete rows based on a condition in Column A using VBA? Anybody have an example? Thanks. |
|
Ok what I am trying to do is submit changes. I have all the information being collected. I'm just having trouble with the proper query to run. I currently have: [CODE] $sql = "UPDATE anime_list SET anime_name = '$animename' rating = '$rating' episodes = '$episodes' WHERE id='$id'"; $result = mysqli_query($dbc, … |
|
I have a DataGridView control and I want to know if the user has changed any data in the row when they leave one row and go to another row. Here's what I've done... In the Form Class I defined a Before and After row image as follows: Dim rwBefRow … |
|
Hi all, i wonder is it possible to display my images from database into table with 4 rows and 4 column? How can i do that? [CODE] $dbConn = mysqli_connect(DBSERVER, DBUSER, DBPASS, DBNAME) or die(mysqli_connect_error()); $sql = "select * from products"; $result = mysqli_query($dbConn, $sql) or die(mysqli_error($dbConn)); echo "<table border … |
The End.