2,570 Topics
 | |
| | I need to get the name of the table with the biggest number of rows, I can find the biggest number of rows with function count and than function max, but i don't know how to see from which table is that maximum, can anyone help? tnx |
 | I'm starting my Computing project and am using Python linked via sqlite3 to a database. As part of my project I shall be searching for maths books in the database via name or module etc. I wish to display the results on a GUI in python so need to set …  |
| | I'm working on making a user maintenance system for my class, I have created the add/delete user portion but as for the edit portion I am completely stumped. So far I have created the form but what I want to do is be able to hit find user and then … |
 | Hi Everyone, I am needing some help with a wordpress insert query. I have this update query $qry ="UPDATE `".$wpdb->prefix."comments_real` SET `comment_country` = '$country',`comment_number` = '$phone',`comment_smvcode` = '$ref' WHERE `wp_comments`.`comment_ID` =$comment_id"; how do I change this to insert a new record in a db table called "comments_real" Thanks in advance |
 | Hi all, Im working on a page that sends information to a mssql database. Its a basic registration page with a UserID, Password, First Name, Middle Name, Last Name, and Email box. When Sign up is clicked, all the information in the textboxes should be sent to the Users table … |
| | Hello. I'm trying to use SqlDataReader to return information from my database. It works fine until it comes to a datetime field. I'm getting an error saying: " Input string was not in a correct format." on the line where I'm declaring a variable to hold my field. Here is … |
| | Good Morning All, I need some help and guidance on a project I'm working on, I am having problems with the following code below, I have been trying to figure it out for days and cannot see anything wrong with it, I am getting the following error when processing the … |
| | Hello. I have an old access data project. I need to convert it to sql and .net. How can I do that? |
 | How do I connect from another machine to SQL Server 2008 R2 Express installed on Windows Server 2008? I've setup the network configuration to be enabled and the TCP port is set to 1433, but I still can not connect to an existing database on the server when creating ODBC … |
 | we should create a program that could run through two computers and the computers should be able to access 1 database for record sharing. how can we make that? we already made the system. the problem is, how can we implement this in a networked way? thanks in advance. :)  |
| | |
| | Hi Guys I am creating a site and i want users to be able to upload videos to a folder on a server, using SQL to store the path of the video and the name. I have created this Code. And it does upload all the details, but does not … |
| | Dear Sirs, I would like to ask you, if you know any solution, for querying a servers mysql database without phpmyadmin rights, for example, querying it from the website itself with a server side solution. To be a bit more specific, here is what I would like to query on … |
| | i have four tables (1) tbl_module: modNo | modName _ _ _ _ _ _ _ _ 1 | module 1 2 | module 2 (2) tbl_subject subNo | subName | modNo _ _ _ _ _ _ _ _ _ _ _ _ 1 | a1 | 1 2 …  |
| | Example 1 below works: echo "<p><h2>".$results['title']."</h2>".$results['shortdesc']."</p>"; I need to make the title linkable to the page url. I'm probably putting the ' and " in the wrong places for the link part. Example 2 - I've added the url code but does not work: echo "<p><h2><a href=http://www.example.com/".$results['url'].".$results['title']."</a>"</h2>".$results['shortdesc']."</p>"; Any help would … |
| | How can I change this so that my returned results will display as 2 tables instead of one? Its returning results from 2 different tables but its not displaying as 2 different tables As I want it to. Thanks for any help or tips you can provide <?php mysql_connect ("localhost", … |
| | I would like to have my users type in a term and display results from two different tables. I tried using union but i'm getting errors can you help please? <?php mysql_connect ("localhost", "","") or die (mysql_error()); mysql_select_db (""); if(isset($_POST['submit']) && !empty($_POST['submit'])){ $result = ""; //USED LATER /*$term = $_POST['term']; … |
 | I have an array ($arr) of arrays ($ar) in which I want to describe the columns in a report. The salient elements include the column headings and the MYSQL field to use: Array ( "City", 12, 29,"Y", "City_date", "City_Total" ), Array ( "Atmos", 8, 23, "Y", "Atmos_date", "Atmos_Total" ), etc. … |
| | Greetings! I'm building a PHP table from data I'm pulling from a MySQL database. I'm querying data from two tables where the common field between them is a customer ID. Table A contains customer ID and a customer score. Table B contains customer ID and a mailing code. The easy … |
| | OKay so this my have been asked before but I have more of a general question than an issue. I don't understand Mysql_num_rows() becuase I don't have any information within my database table so the number or rows should be 0 but what happens is I get an error and … |
 | Hi, i am new in asp.net and i found it quiet difficult... i was programming in classic asp and sql server, but asp.net looks quiet different, specially if i do program in C# .... Than i hase a couple of questions : 1) if i do a form with 2 … |
| | Hi there, Once i am on my second page where i have open the record from the database with my id record, how can i populate my textboxes with the values of my record? And ho can i populate a select with another table containig the type of user by … |
 | I have a database and I have 3 different values that I want to count, to say that You have x amount of tickets open. I am created an array $array = array( 'Pending', 'Waiting on parts', 'Waiting for customer response' ); and a query string $result = mysql_query("SELECT COUNT(*) … |
| | Hi there, i am new with asp.net and i would like to start with it!!! I was wondering if anyone could suggest me any good and easy to understand tutorial where i can learn how to make a list from sql and edit the record in a new page (add, … |
| | Hello. I've created 2 pages that i'm currently working on. One is called; Test.php -- which just includes a basic form in HTML. <Form name ="form1" Method ="POST" Action ="result.php"> Building Name: <INPUT TYPE = "TEXT" Name ="buildingName"> Room Number: <INPUT TYPE = "TEXT" Name ="roomId"> <INPUT TYPE = "Submit" … |
 | I am getting following error when trying to click the next or previous button on following site: http://bdworld.co/newest.php?categoryId=35 > Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/content/69/9332569/html/imagewar/newest.php on line 30 Newest Pictures! ( Others ) SQL query failed. Check your query. Error Returned: You have an …  |
 | Hi Guys, Completely new to PHP! Just wanted to play around with Fields and submit stuff to a database on localhost through xampp. This code writes to the database no problem, except no insert is happening with 'Telephone' and it throws this error; Notice: Undefined index: Telephone in C:\xampp\htdocs\Inputs\update.php on … |
| | i have two tables (they are fixed, not going to update any more) in my databae "phoneadd" phone_nos----name(primary id),home,office,college,friend. Examble: john 87954 45698 78965 12365 martin 45698 78962 45789 45789 trull 47896 14587 85632 14563 addresses----name(primary id),address Examble home first street,new town office second street,old town college thrid street,maxi world … |
| | sample asp.net with c# sql database connection  |
 | hi there, I have a hidden field in my page which i need to transfer to another page as request query string/paraameter. It works perfectly in IE and in chrome. When i try in Mozilla the value of the req string is always undefined. Can any one help me out. … |
The End.