10,940 Topics
 | |
| | [B][COLOR="DarkRed"]this is post table [/COLOR][/B] [IMG]http://www.divran.com/script/upload/images/post.jpg[/IMG] [B][COLOR="DarkRed"]this is thread table [/COLOR][/B] [IMG]http://www.divran.com/script/upload/images/thread.jpg[/IMG] lie you see firstpostid in thread table = postid in post table and threadid's i wanna update title column in thread table as title in post table but how ? i create following query for trying but i … |
| | Hi everyone, I've been a reader for a long time, now I've joined up, as I'm fairly stumped on this one!! I'm currently teaching myself mysql and php at work, and have a problem. I am using php to produce a listing of restaurants on a page, and I would … |
| | Hi Been trying to write a query... I have a table of documents, and a table which registers everytime someone downloads a copy of the document. I want to create a report, in one query, which pulls out each document and counts the views... I thought it woudnt be too … |
| | hi there, im sorry if this has been posted before i have searched through the threads and have not found what i am looking for, however it is entirely possible that i have missed it, i have spent the whole day looking at search results and basically i need some … |
| | Hello, New here so hello. I need to transfer an Excel file to Mysql with a large amount of data. I looked on a few forums but have not found much. Do you know how to do this? Is there an easy solution? Thanks a lot. |
| | i m searching for it from last two hrs. but didnt find anything useful.. i hope some reply to this topic..!!! i just need a php script to upload excelsheet data into mysql table..!! thanks  |
 | I would like to get everyones opinions on what processes should be used to validating and protecting the input into your storage medium aka MySQL. In particular listing possible php functions that hsould be run and maybe once we have a list we put them in order, from most to … |
| | A company has several employees and projects. Each employee may be working on several projects. Design a database to hold information about projects and employees, choosing some sensible sample fields and data. Write an SQL query to display the number of women and the number of men working on each … |
| | The below mysql query yeilds the following result: [CODE]SELECT COUNT(ProgramType) AS Counter FROm credential_state GROUP BY ProgramType;[/CODE] Results: Counter 4 7 7 I would like return the max from the above (7). The following query is giving my an error that says: Every derived table must have its own alias. …  |
| | Can any one help me in solving my problem. My problem is I have Windows 2003 server which maintain different user with different authentication. No I am developing a login program in PHP (PHP and CSS file is attached) I need to fetch the user details from Active Directory of … |
| | I need to make ten selections. One of all the datetimes in the last 24 hours, the next one from 24 hours to 48 hours, and on back in 24 hour blocks for the last ten days. I've tried various approaches to this, but this is what I currently have: … |
| | I tripped on this one. I have an HTML form that has all kinds of input elements - text, textarea, radio buttons and checkboxes. I have no problem inserting or updating data in MySQL DB from the HTML form. But when I want to display what is already in the …  |
| | I have the following python code to access a MySQL database: [CODE] #!usr/bin/python # server_version.py - retrieve and display database server version import MySQLdb con = MySQLdb.connect (host = "localhost", user = "username", passwd = "password", db = "test") cursor = conn.cursor () cursor.execute ("SELECT VERSION()") row = cursor.fetchone () … |
| | Just so you know, I'm a PHP beginner, so I won't understand complicated stuff or anything of the like. xP I've started to make a part of my website (may I link to it, or should I just post the code) and I'm pretty happy with it. A user can … |
| | Can someone help me store a string that has an apostrophe within it? I thought that using [B]mysql_real_escape_string[/B] was supposed to add a slash when retrieving, but remove the slash before storing. Here is a portion of my code and then also the result of the data after it is …  |
| | I got a query to calculate the percentage as , [CODE] Select votes, rating, votes/sum(votes) as percentage [/CODE] But I want to take the values from two different tables. I tried [CODE] Select elec.sum(votes) from elec, stat.sum(rating) from stat where year=2009, elec.sum(votes)/tat.sum(rating) as percentage; [/CODE] This doesn't work. plz help. |
| | How can I use Mysql for JDBC connection.How to make data source? I can able to done with MS-SQL. |
| | Hello, I have a MySQL 5.0 Database used for management of my service, with 13 tables. The two tables most important now are "customers" and "cust_packages". The table "customers" has one column "cust_email". This column has e-mails of customers of the my service. The table named "cust_packages" has one column …  |
| | I keep getting this message Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/j/a/c/jackattacksite/html/register.php on line 80 Here's the code: [CODE=php] // Connect to database include_once "scripts/connect_to_mysql.php"; $emailCHecker = mysql_real_escape_string($email1); $usernameChecker = mysql_real_escape_string($username); $emailCHecker = eregi_replace("`", "", $emailCHecker); $usernameChecker = eregi_replace("`", " ", $usernameChecker); // Database …  |
 | mysql_connect("localhost", "root", "") or die(mysql_error()); mysql_select_db("test") or die(mysql_error()); $root = 1; function display_tree($root) { // retrieve the left and right value of the $root node $result = mysql_query('SELECT lft, rgt FROM tree '. 'WHERE name="'.$root.'";'); $row = mysql_fetch_array($result); // start with an empty $right stack $right = array(); // now, … |
 | Hi and I have been working on a project involving a rather large database. My question is "For a database with over 20529860 rows, is it better to have 3330 tables spreaded equally or to split into multiple databases or would it be better to have 49950 tables in the … |
| | Hi, I am trying to get the primary key (which is number) from a field of the same table. however i encountered "Undefined index" shown on my screen. [CODE] $orange_insert = "INSERT INTO orange (orange_id, orange_name, orange_add) VALUES (NULL, '$val_name', '$val_add')"; $result = mysql_query($orange_insert) or die (mysql_error()); $orange_sel = "SELECT … |
| | For example, when searching string_1 in MySQL table found NO RESULT, then want to add string_1 into database table. Using code below: while (res->next()) cout<<"This word means "<<res->getString(2); if (res==0)/[U]/I use this if statement , but don’t work![/U] { cout<<"Would you like to add this word to database?"<<endl; } What …  |
| | I am facing problem connecting problem connecting remote MySQL server which is firewall protected. I used the valid user name and password, but it throws me the error [I]OperationalError: (2003, "Can't connect to MySQL server on 'www.myreomtemysqlserver.com' (10061)")[/I] I want to connect from python. I searched in Google is there … |
| | |
| | |
| | Hi I really hope I am posting this in the correct forum area. I have a html page on my currently existing web site where I sell books over the internet. I need to change this page so that it can do a search on my MySql database that I … |
| | i have a project that implements the using of database. i chose to use php as the application interface and mysql as the database. at the end of this month, we should submit the softcopy. now, i'm confused with the files of my project. i'm using wamp server, and in … |
| | Is there a simple way to link up a data website to my newly created Access program? I need specific information to fill in the tables, and currently I am manually entering the info in from the site; it would be much easier to have this website post it for … |
| | Hi, I want to create a mysql table in a database in C#. this table should have unlimited fields where the user can add more information to it without having to overwrite the already existing information. I want to do this cos I will not know the amount of info …  |
The End.