[table] Forum Topics

I need to add a check box on the end of each value in my html table that will be checked if the user would like to remove that value from the mysql database, my current cod elooks like this: <?php $con = mysqli_connect("localhost", "root", "", "numbers") or die(mysqli_error($con)); // …

I have following tables for photo album script. How to display Album title and album cover inside anchor tag? (Display Albums cover on homepage and redirect to gallery page, when clicked, to see images inside that album) * get id of album * get album title * get album cover …

Hi all I just started using Crystal reports in vs2010. I have created a Dataset in the Designer and pulled data from an access DB. The dataset is being populated fine. My Issue is when I assign the dataset to crystal database expert and drag the columns to the report …

i got complete details in html table and willing to update 2 values

I want to add one of the column in a database table as components in a combobox. How to do it? I am using visual studio 2012 and c#. Help me please. Thank you in advance.

I need help trying to get my mysqli_query() function to work right. I have this so far: $raw_results = mysqli_query($con, "SELECT * FROM numdata WHERE numb='%".$k."%' UNION SELECT * FROM numdata2 WHERE numb='%".$k."%' UNION SELECT * FROM numdata3 WHERE numb='%".$k."%' UNION SELECT * FROM numdata4 WHERE numb='%".$k."%' UNION SELECT * …

Hi all, I need your help, I'm having a trouble with writing the database at the same time when I'm using the time.sleep function. I can be able to create the database table without have any problem, but when I use the time.sleep function, it will stop writing the data …

Hello, How to create a table with a sort feature. You can sort the table based on the header of the table. For example: Name City Age David Brazil 28 Vicky Spain 25 Ashley Spain 21 If you click the header=name it will be sort by name, else if you …

I want to load database tables in dropdown list and display selected table in grid view. I am trying to convert the following code into asp. Net. I am getting error as, Variable conflicts with property adapter Private adapter As New OleDbDataAdapter(String.Empty, Me.con) DisplayMember' is not a member of 'System.Web.UI.WebControls.DropDownList' …

Table: numdata id numb 1 123 2 456789 3 123 4 456789 5 123 6 456789 7 123 8 456789 9 123 10 456789 11 123 12 456789 13 123 14 456789 ...... What i would like to do is combine the data in numb only, so the desired data …

Hi friends, In my site, simply I want to save the configuration data, site details in the php file. For an example, in vBulletin they are using config.php file to save all the general details. // ****** DATABASE TYPE ****** // This is the type of the database server on …

Hello I am build pagination but its give me stuck. **admin_cont Controller Page** $this->load->library('pagination'); $config['base_url'] = "http://localhost/Job-portal-CI/admin_cont/search_me"; $config['total_rows'] = $this->db->get("admin_emp_job_description")->num_rows(); $config['per_page'] = 2; $config['num_links'] = 20; $this->pagination->initialize($config); $data['records'] = $this->db->get('admin_emp_job_description',$config['per_page'],$this->uri->segment(3)); $this->load->view('admin_jobseeker/search_lists',$data); **View Page** <?php echo $this-> table-> generate($records); ?> <?php echo $this->pagination->create_links(); ?> **Problem** Its give me Link but when …

I have vb.net application with MDF-Sql database. I retrieves data from Table in MDF-Sql into datagridview by TableAdaptermanager/binding navifator. Although it displays data but when I want to save by this code, its not working.This code is working in vb.net with OleDb application but not here. Is there any another …

Hi, I want to display the department no. and the no. of employee in each department from EMP Table.(in a Single Row). Pls help me how to write the query for that. I had one query which display the result in 3 rows. select deptno, count(*) from emp group by …

I have two tables with column name price I want to order by price from both columns so if is in first table 100eur and in second is 200eur I want to order results like this: 200, 100 SELECT a.price, b.price FROM table1 AS a INNER JOIN table2 AS b …

[code=sql]insert into desg values(" & Val(txtsno.Text) & ",'" & Trim(txtdesg.Text) & "'," & Val(txtbasic.Text) & ");[/code] this how i used for inserting data to my access table in vb code. how to do in c#?

I have a specialization hierarchiy with one parent table and two children. I am in a situation where one column in the child table is a pk, fk, fk and unique. TICKET_NUMBER = pk, fk1, fk2, u1 This is how I have currently tried to create this table but im …

Hi All, As usual I here with a PHP & MySQL problem. Most of you know, I am developing Music Download system. Today I have created Widget to display last 5 songs. <?php include('datab.php'); $get = "SELECT * FROM `songs` ORDER BY `id` DESC"; $getres = mysql_query($get) or die(mysql_error()); if(mysql_num_rows($getres)> …

Hi all, I get 'Invalid string or buffer length' exception when trying to do this. String s=resultSet.GetString(1) Exception: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid string or buffer length at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6956) at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7113) at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(JdbcOdbc.java:3906) at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(JdbcOdbcResultSet.java:5697) at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:353) at sun.jdbc.odbc.JdbcOdbcConnection.buildTypeInfo(JdbcOdbcConnection.java:1503) at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:381) at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174) at java.sql.DriverManager.getConnection(DriverManager.java:579) at java.sql.DriverManager.getConnection(DriverManager.java:243) at Controll.Test.sselect(Test.java:72) at …

I am unable to get my text file data.txt to read correctly into my database. This is what my text file looks like 9889483782,6068378394,6069437364... and so on for like 50 numbers I have to get each of the comma seperated values to show up in the database, id like them …

i made union to two mysql tables select cashid, sum(amt) as ramt, NULL AS pamt from receipt where cashid in ('17', '23') GROUP BY cashid union all select cashid, NULL AS ramt, sum(amt) as pamt from payment where cashid in ('17', '23') GROUP BY cashid and now i want to …

Hello, Can anyone help me find the logic behind this program? input_berita_static.php <?php include('../includes/koneksi.php'); $post_id = isset($_POST['post_id']) ? $_POST['post_id'] : ''; $confirmation = isset($_POST['confirmation']) ? $_POST['confirmation'] : ''; $kategori = isset($_POST['kategori']) ? $_POST['kategori'] : ''; $news = isset($_POST['news']) ? $_POST['news'] : ''; $judul = isset($_POST['judul']) ? $_POST['judul'] : ''; $page …

Good Evening Everyone, i am currently facing a problem. I want to append data to an excel file but before that i want to check for duplication records in the excel file before appending. For example, an employee want to check in to a company but he can only check …

$query1= mysql_query("select PageId FROM page"); $result = mysql_query("SELECT * FROM page"); echo "<td><a href='http://localhost:1234/usman/page_update_insert.php'> <img src='IMG/create.png'>Add New Record</a> </td>"; echo "<table border='0'> <tr class='tableheader'> <th>PageName</th> <th>MenuName</th> <th>ParentMenuId</th> <th>LinkWidth</th> <th>OtherUrl</th> <th>Status</th> <th>CreatedDate</th> <th>OnMainMenu</th> <th>FooterMenu</th> </tr>"; while($row = mysql_fetch_array($result)) { echo "<tr class='tablerow'>"; echo "<td>" . $row['PageId'] . "</td>"; echo "<td>" . …

Good Day. Call me Angel. I'm havng trouble with **Live Edit Table**. Appears not to be working for me. I have this system. A small rental system actually, that would save the details for the rented properties. Here's the actual table: <img src="https://fbcdn-sphotos-g-a.akamaihd.net/hphotos-ak-xpa1/t1.0-9/10314749_882248248457445_2787632760191268129_n.jpg"> (other columns are trimmed) The admin has …

Can anybody help or point me in the right direction what is missing on my code. The postcode is a mysql table and one field stores user's choice of postcodes in the form of array(a,b,c,d and etc....) Now I want to load selectedPostcode in checkboxes for user_id = 2 to …

**I have a table with 4 columns = a(ID),b,c and d.By using LINQ, how can I calculate 'd'* 'b' / 'c' while changing 'a' with a combobox?And would it make any difference if it is a VIEW? is it a fair question? and do you need more information? **

I am trying to change my ways and wonder if someone could help me find my way... LOL Honestly. I've always used forms in my scripts that a visitor had to submit, and it would reload the page and check the input and display any errors, etc... What I would …

<tr class="tablerow"> <td>Page Id</td> <td><select name='PageId' class="select"> <option value='0' >select any page</option> <?php $sql10 = "SELECT Id,Title FROM abc"; $rs = mysql_query($sql10) or die(mysql_error()); while($row = mysql_fetch_array($rs)){ echo "<option value='".$row["Id"]."'>".$row["Title"]."</option>"; } mysql_free_result($rs); ?> this done show all title from table but when i update form i want that the tile …

Hi all guys, I want to do, for the administrators, a page where are displayed all the "routes" regarding the pages etc. This is the html markup: <?php /** * @var IV_View_Base $this */ ?> <table class="table table-bordered" width="100%"> <tr> <td> <table width="100%"> <tr> <th width="13%">Path</th> <th width="13%">Module</th> <th width="13%">Controller</th> …