10,940 Topics
 | |
 | Hi, I made a table named staff_info containing 4 column name,day,duty_start,duty_finish. This table still have no parimary key. Now assume that there are 4 staff and they do their work in each day of the week.That means in each day there work 4 staff and 1 staff work in 7 … |
| | geeting a error Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\E_COMMERCE\MENU_PAGES\apparel_pages\male_print_image.php on line 35 line 35: while($row = mysql_fetch_assoc($item_query)) <?php ... if(isset($_POST['male_button'])) { $order_by_p = $_POST['order_by']; if($order_by_p == 'heigh_low') { $item_query = mysql_query("SELECT * FROM item WHERE sub_category='Male_T-Shirts' ORDER BY id DESC LIMIT 8"); } } … |
 | hi i have the following problem after importing databse in c#. i have import a mdf database in C#. but it has exception after pressing `F5` for debugging. `A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. … |
| | Hi all, using these tables, Im trying to write a query that will list the students that have taken any type of class (class_level) and how many of that particular type they have taken so using a count of somekind. Tables: ATTAIN PK FK Rank_Num integer refers to RANK PK …  |
 | Halu guys! How to store an *image* to **MySQL database**? Do it needs to convert? |
 | Hi guyz , PHP newbie and this piece is givin me a hard time please Help, have indicated the source of the error with a comment <?php ob_start(); include("dataaccess.php"); ?> <?php $strAction = "list"; $num = ""; $strTable = ""; $strkey = ""; if(!empty($_POST)) { if (trim($strTable) == "" ) …  |
| | Thanks you all in advance. I want to make a website showing the result of exams that are conducted in India. I want the user to enter his/her Roll Number in the form created at my website and as he/she press enter. His/her results should be displayed on the page. …  |
| | Hi ALL, Plz tell me how to retrieve data from mysql using vb.net as frontend. I created database in mysql and able to insert data from vb.net but i dont know how to retrieve data from mysql. Plz help me to perform this action. Plz post your reply for my …  |
| | Hello all: I have the following mysql query statement: SELECT COUNT(*) as ttl_rows FROM (SELECT DISTINCT(date(timeentry)) AS day, COUNT(*) AS total FROM history where MONTH(CAST(timeentry as date)) = MONTH(NOW()) AND YEAR(CAST(timeentry as date)) = YEAR(NOW()) GROUP BY DATE_FORMAT(timeentry, '%d') ASC) as ttl_row the statement performs a search for all records … |
| | I am trying to create a secure login app using php and MySQLi by following this tutorial: Link To Tutorial The tutorial is using a table(members) with 5 fields as:"id", "username","email","password",and "salt". but at the very beginning there is a an SQL INSERT function which is confusing me INSERT INTO … |
| | I'm having some trouble with selecting the Max values of three different tables in my SQL. I have 3 tables Car [CarID, Name] - Price [CarID, Price] - Group [GroupID, CarID] With these Values Car: CarID --- Name 1 ------- Car1 2 ------- Car2 3 ------- Car3 Price: CarID --- … |
| | Hi all. I am a beginner in Zend and I am wondering if there is any good book or tutorial for developing applications with Zend Framework, using json for data encoding and decoding and how to use jquery with Zend. Thanks. |
 | Hi! I cannot figure out how to install and use a database that I am given for a project. I'm running Windows 7. Can anybody help me?  |
| | Hi guys... i want to delete data from datagrid in mysql...i have also done update query using same datagrid... but i m not able to delete data... my code is <script type="text/javascript"> $(document).ready(function () { // prepare the data var data = {}; var theme = 'classic'; var source = …  |
 | Hi; I have an sql database with a table called: "stardate" with default value set up with "dat" I want to modify this column default value to current date (server side) I'm trying this: Alter table my_table Modify startdate DATE DEFAULT CURRENT_TIMESTAMP; with this error: Error Code: 1067. Invalid default …  |
 | Please people, i'm trying to create a chat room, and .... I jst nid some guidance pls |
| | I need a ajax way of updating the mysql table. Following is my code that gets the data from mysql table plus ajax function that will send data to processing file. Problem is it is sending every time only the data of the top row ( form). How can send … |
| | HI Im looking for a javascript game to download for free so I can give my users on my website a way to get points. so the points that they get in a javascript game would be added to the mysql database to add the points into their account. does …  |
| | |
| | ok first off I know how to make a update page with usernames and user info no problem.. I know how to do stock with the stock=stock -%d as a interger but what I am having a hard time with is I have no clue how to say for example … |
| | Hi, I want to know what code should be used in order for me to import data from an excel file to dataset and then adding it to the database, how can it be done? thanks |
| | hello, i'm having trouble getting my delete selected checkbox working for a code I'm writing: the trouble is really just in the bottom half of the code after i make the while loop...i made this off of an example that i found on a site but like it was pretty … |
| | Hi everyone, I have been trying to update a mysql database with the shortend url I get from bit.ly I have the shortend url displayed on the page, but everytime I try and update mysql with the variable $bitlylink.. instead of http://bit.ly/123abc the database is updated with http://the.full.website.url/directory/link.html How can …  |
| | Dear Experts, my website was hacked yesterday and when i retrieve my website it will give Ã, ¢â etc these character in my each and every page and post. Kindly tell me step by step process to remove these characters. I am new here sor plz kindly tell me step …  |
| | error connecting to databaseAccess denied for use 'root'@'localhost(using password:YES) using System; using System.Data; using System.Collections.Generic; using System.Linq; using System.Text; using MySql.Data.MySqlClient; using System.Windows.Forms; using DPUruNet; using System.Drawing.Imaging; using System.Drawing; namespace UareUBiometrics { class HelperFunctions { private static Fmd[] fmds; private static Fmd[] allDBFmds; public static Fmd[] GetAllFmds { get { … |
| | I just moved to a new server and installed Python 3.3. On my old box i was using Python 3.2. Now my scripts that import pymysql won't work, saying the module doesn't exist. Wher do I download this from? I'm on Win Server 2008 R2 (on both boxes) Thanks |
 | Hi, I'm really hoping someone can help me. I've created a clocking system. The user clocks in,the clockin time is stored in the db, the user clocks out, the time is stored in the db. However, I want to store the difference, in other words the hours that would've been … |
| | Hi Friends, I want to upload a image file to my mysql database. But before that i want to resize it. I have used the following code. But what happens is that the image is successfully resized but the quality is not retained. Please someone guide me with some help. … |
| | Hi all, I'm having some trouble inserting records into my MySQL db because of how I've set up my foreign keys. The problem is, I don't know how to fix it to make it do what I need it to. Here is my schema: http://imgur.com/t5bVt Here is my php code … |
| | I am new to JSP. I am doing a course. where they require me to build a registration page. and when we submit entries must be into database. So that when we log in the username and password must match then only welcome page should come otherwise error page. and … |
The End.