10,940 Topics
 | |
 | 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 … |
The End.