10,946 Topics
 | |
 | Hello )) Please tell me - How to receive surnames of students and their mark in all subjects? in this form -[CODE] SURNAME1 1hismark1 1hismark1 1hismark1 1hismark1..... SURNAME2 2hismark1 2hismark1 2hismark1 2hismark1.....[/CODE] I use this database - [CODE] table STUDENT ( STUDENT_ID NUMERIC not null, SURNAME VARCHAR(60), ); table SUBJECT … |
| | Hi,I,m taking mysql database backup through code behind,by using process.start method.It's taking backup but the problem is that after execution of process.start method,it's showing one command prompt for 2-3 seconds and executing.I dont want to show that command prompt.Please help me how can i do that?  |
 | Hi pals, I try a code in my Dev -C++ Environment v 4.9.9.2 in Windows XP. I save file as "satwant_mysql.cpp" in E:/C++/ Directory.... [CODE] #include <mysql/mysql.h> #include <stdio.h> int main(){ MYSQL mysql; MYSQL_ROW row; MYSQL_RES *result; unsigned int num_fields; unsigned int i; mysql_init(&mysql); if (!mysql_real_connect(&mysql,"localhost","root","","MyDatabase",0,NULL,0)) { fprintf(stderr, "Failed to … |
| | hello i have this in my code [CODE]$providers_offer=strip_html_tags($_POST['services_offer']); mysql_query("UPDATE providers SET providers_offer='$providers_offer' WHERE user_name='$_SESSION[provider]' ") or die(mysql_error());[/CODE] simple update on my data. my problem is if i type a data in my services offer. with this kind of characters ( sample's ) i got a syntax error on updating or … |
| | I have the database movies (movie_id INT, actor VARCHAR(80)) and i want to answer to this question ’Six degrees of separation’: Given two actor names, determine their ’degree of separation’, defined as 1 follows: Two actors ’A’ and ’B’ are 1-degree away if they played in at least one movie … |
| | I am new to php (sorry). I cannot figure out how to make 'field_4' below display as a click-able URL. It is stored in my mysql db in a varchar field. Any help would be great, thanks. [CODE] $result = mysql_query("SELECT * FROM units ORDER BY `field_1`, `field_2`"); echo "<table … |
| | [CODE] global $db; $tracks = ""; $sql = "select description from movies where movieid=".$movieid." and mp3link IS NOT NULL"; $db->query($sql); while ($db->next_record()) { $tracks .= "<p>" . $db->f("description") . "</p>"; } echo $tracks;[/CODE] This is a code I'm using to get all records from a database with a certain ID … |
 | look at the code first, [CODE]<?php $name=$_POST['name']; ?> <form method="POST" action="<?php echo $_SERVER['PHP_SELF']; ?>"> <input type="text" name="name"> <input type="submit" value="GO" name="submit"> </form> <?php include ('db.php'); if(isset($_POST['submit'])) { mysql_query ("INSERT INTO example (name) VALUES('$name')") or die(mysql_error()); } if (!isset($_GET['startrow']) or !is_numeric($_GET['startrow'])) { $startrow = 0; } else { $startrow = (int)$_GET['startrow']; … |
| | Hello everyone, I'm having some trouble converting from cell values in excel to datetime in sql queries. BTW I'm using AdvantageDatabase and Excel 2010 Let's say I have a cell value D4 "12/12/2010" Inside Microsoft query I have the following: SELECT * FROM mytable WHERE mytable.Firstdate =? Microsoft Query then … |
| | can l plz ask you something ... l hav a database with 4 tables i.e User(fname, lname,email and userid ------primary key{userid} ) Exam( examid, examname-------primary Key{userid}) Exam_user(examid, userid------primary key{examid}) Exam_category(categoryid, categoryname----prmary key{categoryid}) HOW CAN YOU WRITE AN SQL QUERY THAT ALLOWS U TO CREATE/retrieve A NEW TABLE WITH FIELDS;;;; (fname, … |
| | i want my code to Prevent fetching data on page refresh [CODE]<?php $name=$_POST['name']; ?> <html> <body> <form method="POST" action="<?php echo $_SERVER['PHP_SELF']; ?>"> <input type="text" name="name"> <input type="submit" value="GO" name="submit"> </form> </body> </html> <?php include ('db.php'); if(isset($_POST['submit'])) { mysql_query ("INSERT INTO example (name) VALUES('$name')") or die(mysql_error()); } if (!isset($_GET['startrow']) or !is_numeric($_GET['startrow'])) …  |
| | Hi guys, Need your help. Currently my development server using Wamp server. please read below for services details: * Apache/2.2.11 (Win32) PHP/5.3.0 * MySQL client version: mysqlnd 5.0.5-dev - 081106 - $Revision: 1.3.2.27 $ * PHP extension: mysqli * Server: localhost (MySQL host info: localhost via TCP/IP) * Server version: …  |
| | I am using PHP and MySQL E-Commerce book and when i want to see department list i got these errors. I did lots of things but nothing happened. does anyone help ? [COLOR="Red"] ERRNO: 2 TEXT: include_once(catalog.php) [function.include-once]: failed to open stream: No such file or directory LOCATION: C:\xampp\htdocs\seeshop\presentation\departments_list.php, line … |
| | Hello, I am trying two days now and I have spent about 12+ hours on this and I can't find a solution :( Please help, or I am gonna lose my mind! I am trying to save user's monitor resolution on MySQL. I almost done it but, I have a … |
| | Sometimes a person can get too close to their work that they cannot see what is going on wrong. I hope that is the case here. I have been working on my favorite project, a large wood knowledge base at: [url]www.prowebcanada.com/taxa[/url]. There is enough data to look up already and …  |
| | Dear Sir/Madam, We are using NSIS to install an application. and we have a MySql Script file, which is using inside the installer class. This file is working with Mysql but not from the installer. This is giving a ERROR 42000 syntax error. Any help will be appreciated Arun G.K  |
| | I have a photo management system that I have build locally which uses mysql to store the images. the problem is that I exceed the max_allowed_packet value when my images are too large. I know how to set the max_allowed_packet value through the CLI with: [CODE=sql]SET GLOBAL max_allowed_packet=16*1024*1024*1024;[/CODE] The problem … |
| | Hi Pals, I am Anes , from Kerala ,India. I am a PHP Programmer Basically but have interest and now studying C++ , I plan to take data from MySql in C++, for that I install mysql-connector-c++-1.1.0-win32.msi in my Windows XP. I got a Script from net , but it … |
| | Hello Friend, I have made windows application using c# in visual studion 2005 and i am using MySql DataBase, Now I want to Deploye my application with MySql DataBase...but i don't know how "configure MySql" in client PC And how to install "mysql-connector-net-" (as client PC may be not configure … |
| | Hi. is it possible to decrement a value inside a table every seconed or day or whatever? if it's in the wrong section i'm sorry. |
| | php mysql simple form help whats wrong with my code ?? every time i refreh my page a new field is created in database 'example' i want my code to create new field in database only if something is insert in text field here is my code [CODE]<?php $name=$_POST['name']; mysql_connect("localhost", … |
| | Dear All, I have a scenario where I notice in my log file for few different instances there is one query running and another one is called and kills the former running query.My application is based on C# and using .net connector.I have attached two sample cases but I have … |
| | I have data value of a table column. I want to know in which database and in which table and in which column the data value appeared in mysql. |
| | Hey guys, I'm trying to normalize a database for a friend, who has a car database. I'm trying to separate the database by having one table for the car brands (BMW, Honda, etc), one table for the car types (SUV, car, sports car, etc), and the final table for the … |
| | Hai friends how to connect the Mysql in C please reply  |
| | Hello, Is it possible to select a specific row in one table and post it into another table in a different database? Thanks, Waffles |
| | Hello all I am on a windows application form where people can log in and add status ... and it's all online via sql database. What i am looking for is a sql query that Insert into the table the current time,so i can print on the application the time … |
| | Hello all I am on a windows application form where people can log in and add status ... and it's all online via sql database. What i am looking for is a sql query that Insert into the table the current time,so i can print on the application the time … |
| | Hello, anyone has an idea of how to use php to check to see if a field in a mysql table is empty or has no values? i tried this $query="SELECT fieldId FROM table WHERE fieldName IS NULL" ; but this works only if the field in the table has … |
| | I have an idea for a friends list based off a user's account info. 'guid' is the character id number 'account' is the player's account number 'friend' is the player he is friends with 'online' 1 = online; 0= offline Here's what the layout is like: Friends List [CODE] `character_social` … |
| | can you please help me guys.. i just wanted to start practicing phpandmysql and my only problem is the apache,php, and mysql 1. i tried to install the apache 2.2.17 to my computer and the installation was successful. i tried to browse the localhost to my web browser and it … |
| | I had created a MySQL database to install wordpress but due to some tinkering I did in the phpmyadmin it displayed an error "No Privileges". I'm don't have much knowledge in mysql databases, I spent a week searching for a solution, tried many but nothing seemed to work. In the … |
| | I face the problem:: To Insert data to update data When I go www.myweb.com/cpanel user:xxxxx Pass:xxxx Go Database PhP MyAdmin by this way I can update my database.. But when I connect by PHP... I failed... Pls suggest some one.......pls !!1 1) test.php.. of a row <a href="update.php?id=<? echo $rows['id']; … |
| | Good day) Advice please - is it permissible to use this syntax - [CODE] insert into EXAM_MARKS ( EXAM_DATE) values (str_to_date('26-05-2000', '%d,%m,%y')); [/CODE] This line does not work. I can not understand on what went wrong. Thank you for your answers) |
| | Hi guys ! Please help make a sql-query - There are three tables - [CODE] table STUDENT ( STUDENT_ID NUMERIC not null, SURNAME VARCHAR(60), ); table SUBJECT ( SUBJ_ID NUMERIC not null, SUBJ_NAME VARCHAR(100), ); table EXAM_MARKS ( EXAM_ID NUMERIC not null, STUDENT_ID NUMERIC not null, SUBJ_ID NUMERIC not null, … |
| | Dear all, I want to connect the my mysql database in the below java program.But i could not able to connect the myslq database. i have downloaded the below jar file and put the jar file in the below path. Jar File: ========= mysql-connector-java-5.0.8-bin.jar Path: ==== /usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0/lib mysql version ============= … |
| | I have a table with 3 fields: id (auto_increment), name (string), x. in my x field i want it to be kind of like a auto_increment but with letters and numbers being used. For example, if id field is 1, x will be "aaaa". if id is 2 x will … |
| | |
| | I have made this stored procedure DELIMITER // DROP PROCEDURE IF EXISTS find_max; CREATE PROCEDURE find_max (IN type INT,OUT maxx INT) BEGIN SELECT max(card_id)+1 INTO maxx FROM cards; END; // DELIMITER; and i want to have this stored procedure DELIMITER // DROP PROCEDURE IF EXISTS add_card; CREATE PROCEDURE add_card (var_member_id … |
| | i am learning php and i am trying to insert data into a database from a form using php. here is the php [CODE]<?php include "connecttodb.php"; $name = $_POST['name']; $email = $_POST['email']; $password = $_POST['pass']; $query = "INSERT INTO ******* SET username='$name', password='$password', email='$email'"; mysql_query($query) or die('There was an error … |
| | Here's the code I have [code] $query = "SELECT partID, fname, lname FROM tblPartInfo WHERE lname = '$lname' or fname = '$fname'"; [/code] Works like a charm. Now, I want to be able to use wildcards so that the user can enter, for exemple, HO to search for HOUSE so … |
| | i have created new database it is there in C:\xampp-win32-1.7.3\xampp\mysql\data that directory but it can't visible in [url]http://localhost/phpmyadmin/[/url] in that phpmyadmin that combo box please can u help me |
| | I am only new in vb 2008 .I Want to populate a combo box in vb 2008 with mysql, but when i run the thing that appear is "System.__ComObject"..kindly check the errors...plz.. [code] Dim conn As ADODB.Connection Dim rs As ADODB.Recordset conn = New ADODB.Connection rs = New ADODB.Recordset With … |
| | I'm having trouble getting my python scripts to insert into a mysql database. I'm able to do other commands successfully such as adding or dropping tables, selecting items from tables but inserting into tables isn't working. I can manually insert but the script won't do it. I have an entry …  |
 | Hi guys! Im kinda new here and lately I'm developing a[B] PHP MySQL Module Generator[/B] that will help us to easily manipulate the database. since I want to make thing fast and I know lots of you agree with me that doing data manipulation stuffs like MySQL is boring so … |
| | I am still fairly new to PHP, so I will do the best at explaining what I am trying to do here... I have a database table where I store a bunch of invoices. I am now trying to make a front end to run queries. I don't know how … |
| | Hi, I'm trying to create a drop down menu with dynamically populated options. So, within a typical HTML form I have: [CODE] $conn = mysql_connect ("localhost", "xxxx", "xxxx"); mysql_select_db ("wkho_TTX", $conn); $query = "SELECT * FROM venues"; $result = mysql_query($query) or die(mysql_error()); $num=mysql_numrows($result); $i=0; while ($i < $num) { $option … |
| | Is there any free migration tool for mySQL to Oracle ? |
| | Hi, I'm trying to access two databases and retrieve the same data from each but I only want one "No People are on" to be displayed if there is no one on in both databases. If one user is online, in only one database, I would like only the users … |
| | Hello everyone, I have a database with a list of characters and I would like to display which characters are currently logged in on a webpage I have. My database looks like this: [CODE]`characters` (`account`, `name`, `online`) VALUES (6, 'Frod', 1);[/CODE] I hope that makes sense. So if 'online' = … |
The End.