11,093 Topics
 | |
| | Hello every one! I'm developing one simple site, and I need to make an "archive" script. My MySQL Table looks like: [CODE] | id | title | content | is_deleted | pub_date | [/CODE] *pub_date is in PHP time() format. Example: 1258150430 So, what I want to make is an … |
| | [CODE] #include "includes.h" MYSQL *con; con=mysql_real_connect(con, server,user, password, database, 0, NULL, 0); //mysql check: int act; int reb; reb=mysql_query(con,"SELECT * FROM cq_rebirth"); act=mysql_query(con,"SELECT * FROM cq_action"); if(act !=0 || reb !=0){ cout << mysql_error(con); return 1; } [/CODE] Error: Commands out of sync; you can't run this command now i …  |
| | Hi There I've been hammering my head with this for quite a while, and every solution I've tried didn't work, so I was wandering if you could help me with this. I've got a small div that is displayed for each record existing in the database, in order that, later, … |
| | Hi! I use a paginate feature on my website, it works great on the front page, but when I use it in the comment section I get this: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/content/56/6296656/html/comments.php on line 77 code: [CODE] $query = "SELECT where … |
| | |
| | Im not even sure if these are called variables. But I am trying to call information from the database a different way than I usually do. This is what is not working: [CODE]$id = mysql_real_escape_string($_GET['id'], $con); /* once the file is imported, the variables set above will become available to … |
| | Hi All: I have 2 php files feeding one MySql record. I have an INSERT query in file1.php working fine, it then sends me to a highly animated form file2.php that calls a processor.php file. The processor.php file needs to update the mySql record. I have [U]tested[/U] the processor file … |
| | I am currently trying to set up my Database for a small store. I would use something like Zen-Cart but I dont think that is necessary at this level. What I am stumped on is what cell setting within my products table would I put the actual paypal code in … |
| | Hi: I'm having an issue posting to MySQL using the animated_form.html below. My objective is to have 4 db entries posted to MySQL when the user clicks on the <a href="javascript: submitform()"><input alt="Show Results" id="btn_results" src="a_data/form_btn_show_results.png" type="image"></a> image. The form uses jquery and it produces 0 results in MySQL. Using … |
| | Hi, i am trying to connect to MySQL database [ICODE]mysql[/ICODE] using JAVA .. using code given below, [CODE]import java.sql.*; public class dbExample{ public static void main(String[] args) { System.out.println("Listing all table name in Database!"); Connection con = null; String url = "jdbc:mysql://localhost:3306/"; String db = "mydb"; String driver = "com.mysql.jdbc.Driver"; … |
| | Okay, So I want an array to get userinformation by the username that is provided. But in the other tables, it only has a ID field to link with... [CODE]$sql = "mos_users.id as userid, block, username, email, lastvisitDate, firstname, lastname, avatar, cb_age, userip FROM mos_users, mos_comprofiler, mos_comprofiler_plug_iplog WHERE mos_users.username = … |
| | Hello, I made a PM system but the thing that makes it read isn't working. Can you take a look at it anybody? [code] $postid = $_GET['postid']; mysql_query("UPDATE pm SET read=1 where id=$postid") or die(mysql_error()); [/code] And it gives this error: You have an error in your SQL syntax; check … |
 | 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 … |
| |
The End.