[rows] Forum Topics

Hi All, I have a sql query i am trying to get the count of how rows it returned. select a.field1, b.field2, c.field2 from table1 as a, table2 as b, table2 as c where a.field1=b.field1 Considered the above query return 9 rows. I want to get count of '9' in …

I have a python script that reads a csv file and converts it to two new files so that my database can add new emails or update existing ones. What im trying to do now is after it has converted them for it to send me a email with how …

I'm creating a table with PHP/MySql to enter local election results from my newspaper, I'm not a professional developer, more of just a hobbiest hack (who hasn't worked with PHP for a few years either), so feel free to correct existing code if you so please. What I want to …

Hello Community, I was wondering if there is a way to limit users on how many database entries they can insert then once they have reached 100 (Max entried) entries it will delete old entries. So if the user has reached 100 entried and they try to insert another entry …

Hello everyone :) I have this lines of codes and i get : > Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in D:\xampp22\htdocs\folder\index.php on line 52 ( 19 in the code below ) <form method="POST" action="index.php"> CODE : <input type="text" placeholder="Type the code" name="searchfor" /> <input type="submit" …

I know there are other post conserning this but they dont seem to help me. When I run the varaible `$results` through the function `Mysql_num_rows()` it returns as an error saying its not a valid result. Also same for the `mysql_fetch_array()`. function results(){ if ($_POST['search'] != "") { $search = …

im trying to get the user to enter information into a textbox and then after clicking submit button the page has a table containing with that information in the rows. so for example the table has the heading Artist, Songs, Year made, Gene and the user has to enter data …

hi :) is there a possible way where in we can combine two rows for an example i have this code: #include <iostream> #include <fstream> #include <string> using namespace std; int main() { ofstream outfile; outfile.open("1stRow.txt"); for(int i=1;i<10;i++) outfile<<i<<endl; outfile.close(); ofstream outfile2; outfile2.open("2ndRow.txt"); for(int j=2;j<11;j++) outfile2<<j<<endl; outfile2.close(); //return 0; } …

Is there any way to get this to work in Internet Explorer? It shows/hides multiple rows in every other browser, but will only show one class's row in IE. Any help would be great. Here's the code. Thanks! <style type="text/css"> li.merk { list-style:none; display: block; width: 925px; padding:8px; margin-top:-20px; } …

Trying to display events on my website based on what my clients want to view. I have 3 checkboxes setup to toggle the connected events, but I can't seem to make the onclick handle more than 1 event at a time. Basically, I want to know 1) how to display …

I had a jquery-based code that messed up the slider on my page @ http://formidablehoops.blogspot.com Is there a way to have those two co-exist, or is there a way to toggle my calendar at the bottom with javascript instead? I've removed the code for now, but I think it's a …

i have a view named vw_admissionform with columns familycode,Regno,studentname,class for admission form . now if i want to print a student admission form by enetring registration no "regno" in txt1.text then his siblings should also be mentioned on the admission form as requirment by client. for this am using familycode …

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 …

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 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 …

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 …

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 …

Im looking to Delete a row of information in my datagrid, but also from my database. im not even really sure where to start. I want to use a button to do this. so that when i highlight a row, then click the button it brings up a message box …

I have a text file in this format: AUGC U[B]1212[/B] A[B]2121[/B] G[B]3434[/B] C[B]4343[/B] I need to extract the number that I need depending on which variables (letters) I'm comparing. For example, I need the value for A and U, so the value I need to look up for or extract …

I call the getTitle function but it only returns the last DB value. I presume that is because there are many rows in the DB with the same 'code' However when I call the function I want to get all the values for TITLE where code is something in the …

I would have "thought" it would be a simple thing to get the (unformatted) text in each cell of a dynamic table but I have failed to solve this problem. So...I have a table that the user can dynamically load with data. They click an add button to insert a …

[CODE] public void setTableModel(List<Users> users) { eraseTableRows(); for (int i = 0; i < users.size(); i++) { Users u = users.get(i); tm.insertRow(i, new Object[] { stuff }); } } private void eraseTableRows() { for (int i = 0; i > tm.getRowCount(); i++) { tm.removeRow(i); } [/CODE] i've tried this and …

Hi, I am attempting to create a dynamic array using realloc in 2 dimensions. Currently i have managed to get it to work using realloc to dynamically resize the amount of rows but when I attempt to use realloc to dynamically resize the amount of columns per row I keep …

I have created simple database project, using vb.net, ado.net, oledb, datatable, datagridview. My program is working nice, I just need Help with how to add, delete, update and edit records. Can any one please and please help me in this case, or can provide any good tutorial or source code …