7,368 Topics
 | |
| | I have been trying to download the community server edition of MySQL for 2 days with no success. I was able to download the installer and found the ZIP archive (both downloaded and mirrored properly) which I was also able to download but I cannot for some reason open the … |
 | Hello I am trying to develop a group site where a user can signup and create group and other user can signup and join the groups created by other users, each user will have a wall where the posts from the groups they joined will appear, I need help in …  |
| | Hi... I have this Web program running on UBUNTU... and I'm not familiar with Linux Systems... Heres the problem... I need to access the MySQL database on UBUNTU to create a report using VB.Net on WINDOWS... I downloaded an ODBC driver(MySQL ODBC 5.1 Driver) for MySQL then I tried to … |
| | [b]How to speed up the Group By Clause for a large 3GB database.[/b] I am using Group by clause for a large database having 148 columns and 5 million rows with approx 3GB of size. We need to apply the Group by clause on approx 1,00,000 rows at a time … |
| | Hi Guys, I am having trouble with my links, i am currently trying to use my $_SESSION['SESS_MEMBER_ID']; to automatically link it directly to the specific user page. However I always have this error: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\ThesisDB\DisplayThisUser.php on line 21 [CODE] … |
| | I have one table that I need to pull data from to display. there are two fields that a user's id can be attached to. Field1 and Field2, but they are always either or. In addition, I have a couple of extra where clauses in my query. My experience in … |
| | Hi, I am working on web application in java. I need to copy table from local database to web table database. So please help me solve this query. Thanks in advance. |
| | Hello, I have table with test results. Every user have 3 records in the table RESULTS Table RESULTS contains fields USERID (int), TEST_POINTS (int), TEST_TIME (int); I need query to sort up results, but only the best result per user. Best result for user is one with MAX points for … |
 | I have a database, test.db, with a table called Events. I tried this: [code] <?php try { // open the database $database = new PDO('sqlite:test.db'); $result = $db->query('SELECT * FROM Events'); foreach($result as $row) { // both of these lines produce a blank page //echo $row['EventName'] . ' | ' … |
 | I am new to SQL .. [code]SELECT status FROM statuses ORDER BY date;[/code] I know this will order by date but i want to alter the table and rearrange them by datestamp.. Is it possible to alter like that ? |
| | hello guys.. I am new to php. May I ask if it is possible to store a mysql result into a single cookie..(the mysql result has multiple rows..).if it is possible, how to do it.. thanks in advance |
| | I have table names 'payroll' with following data month , pay January , 1200 March , 1500 December , 2000 I want the following result Janury , 1200 February , 00 March , 1500 April , 00 May , 00 June , 00 July , 00 August , 00 September … |
| | Hi all, I am transitioning a bunch of data from html (yuck!) to some sort of separated schema. I was going to use xml: [code] <events> <event> <title> <date> <speaker> <description> </event> </events> [/code] but now I am wondering if I should use a real database instead. Can anyone comment …  |
| | hello people . i am writing a login system for administers , so i made the login page with this code : [CODE] <?php ##################################################### # created by : Awah Mohammed # # date : 23/12/2010 at 23:15 pm # # haha , i like writing such stuff in my … |
| | Hi, I am having an issue saving images to a MYSQL database as a BLOB, I have been for a few days now, I have used several different tutorials and even though the code works with no errors returned, nothing actually get put in my database. Here is my form … |
| | 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 … |
| | 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, … |
| | |
| | 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 … |
| | 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 … |
| | 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 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 … |
 | 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'])) …  |
The End.