mysql

manage user permissions in php

i am creating a marks management system using php & mysqlwhere the concerned faculty will be able to login and enter the marks of the students. i can go with a simple table but the problem is there are 288 different subjects for which marks must be entered. So creating a mysql table with so many subjects does not look good for me. please...

mysql left join ascending

I have a query: SELECT reply.id, reply.message, reply.userid, reply.date, medal.id, medal.url, medal.name, user.id, user.name AS username FROM posts AS reply LEFT JOIN users AS user ON reply.userid = user.id LEFT JOIN medals AS medal ON medal.userid ...

Two left joins and a union in MySQL

I'm trying to do a pretty complex query in MySQL; complex for me, at least. Here's an example of what I'm trying to do: SELECT * FROM friends LEFT JOIN users ON users.uid = friends.fid1 LEFT JOIN users ON users.uid = friends.fid2 WHERE (friends.fid1 = 1) AND (friends.fid2 > 1) UNION SELECT fid2 FROM friends WHERE (friends.fid2 = 1) AN...

Importing .sql file into my database inputs them out of order

I am using phpadmin and I exported a .sql file to backup my database. When I went to import the .sql file it imports the rows in the wrong order. Is their anyway to remedy this problem? ...

PHP PDO fetch error. rowcount = 1 but fetchall returns false;

i ave been having trouble with a simple select sql query. using php PDO. for some reason the rowcount returns 1 but fetch and fetchall both return false; to me that means the execute failed or the query returned no results which would have a rowcount of 0. my sql syntax as far as i can tell is fine. here is the sql query SELECT * FROM...

The used SELECT statements have a different number of columns (REDUX!!)

There's another question out there similar to this, but it didn't seem to answer my question. My question is this: why am I getting back this error ERROR 1222 (21000): The used SELECT statements have a different number of columns from the following SQL SELECT * FROM friends LEFT JOIN users AS u1 ON users.uid = friends.fid1 LEFT JOIN u...

Learning LEFT JOIN in MySQL

dear all.i newbie at web programming and until now i still have learn about MySQL syntax. for now i start to use LEFT JOIN method. i know that this method use for make normalization between two or many tables. I have posted a question in SO, then I receive an Answer which make me confuse. I have modified that answer,but i still confuse b...

Hosting web services on Mac OSX Snow Leopard

Does anyone what options exist for developing and hosting web services on a Mac OSX Snow Leopard server? Is webobjects still supported, are there other solutions? Does Python or PHP have a solution on Mac that also has libraries for working with MySQL? Any help appreciated, Thanks // :) ...

Can't view XAMPP localhost Page except Apache "It Works!"

Hi there! I am currently using Windows XP SP3 with Apache 2.2, PHP 5.3, MySQL 5.1 and XAMPP 1.7.3 installed. However after installing everything including XAMPP, I could not see the "XAMPP Welcome Page" at all! I only see the Apache default Page "It Works!!" on http://localhost/ . I also tried http://127.0.0.1/ but it gives back the sam...

How can i search multiple criteria in dropdown list ?

I have a tutor database (MySQL) which store tutor available subjects, example:- tutor1 available subject = A,B,C tutor2 available subject = A,B tutor3 available subject = A in SearchTutor.php; <select id="select3" class="medium" name="upsr"> <option selected="selected" value="%">-</option> <option value="A">A only</option> <option valu...

mysql: which the better one use DAY() or WEEK()?

I have a web task for counting some data inside DB. I must count this data daily, weekly, and monthly. For weekly, I am still confused to decide which MySQL syntax I should use for this case. There are two suggestions to resolve this problem: using DAY() or WEEK(). I want this syntax is not limited by a confusing thing. As should decl...

Having trouble storing array values in mysql using php

I'm trying to explode a string into an array. A fullname to be exploded in firstname, middlename, and lastname. <?php include('conn.php'); $un=$_POST['uname']; $pw=$_POST['pw']; $fulnem=$_POST['fullnem']; $temp=explode('/',$fulnem); $email=$_POST['email']; $method="creates"; $sql="call compac...

Disable autocommit during hundreds of MySQL UPDATE statements in Django program

In a Django program, how to explicitly disable auto transaction management before hundreds of UPDATEs and enable it after the UPDATEs finish? I looked into http://docs.djangoproject.com/en/dev/topics/db/transactions/ but didn't find any clue. I tried to put the following code at the beginning settings.DISABLE_TRANSACTION_MANAGEMENT = ...

table types in Mysql?

what exactly are the transactional storage engines in MySQL ?? also please get me something in detail about the various table types for MySQL..... ...

Get database hosted on MySQL server

Im trying to create my own database with MySQL Workbench and run some queries on it. I have MySQL server 5.1 running and can enter queries in the command line tool to ask for version number and such. But how do I get the server to host the database that I created in Workbench? When I enter "use MijnDatabase" or "-u root@localhost -p Mij...

common function for all DB

I have a number of databases with the same table structure. When I write a function I have to copy it to all the databases. Is it a good idea to add the function to "mysql" database and call it from other DB using select mysql.fName() Are there any disadvantages? The advantage is that when I need to change it, I will change it only o...

MySQL Join and get all relations even if 0

I got two tables. One that holds all availeble trophys and one that holds the relation between user and trophy. trophy -------------------------------------- | trophy_id | name | -------------------------------------- | 1 | kill 100 people | | 2 | kill 200 people | | 3 | fly 5000 f...

how to get json data from iphone post request

Hi everyone, I am developing iphone App using JSON framework, I am calling a PHP script to update MySQL database on local server. Using these code: NSString *jsonString = [sendData JSONRepresentation]; NSMutableURLRequest *request = [[NSMutableURLRequest alloc] init]; NSString*post = [NSString stringWithFormat:@"&json=%@", jsonString]; ...

MySQL table synchronization

I have a server that constantly writes SQL queries it executes to a textfile. I want this textfile to be read by a second server, execute the queries there, and remove them from the textfile. This is done in an attempt to keep those 2 servers virtually synchronous with each other without changing existing code. ...

Jquery Not letting Me Save My FULL Text. Only 1 Word

I have the following code that will check to see if the div text has change and if so then update the text in the mysql table. but when i try and add spaces in the text and it dont allow it to save every thing i have write. Can somebody help me out please Thank you. <script>function save() { var div_sN6VmIGq = $("#64").text()...