10,946 Topics
 | |
| | Hi guys, Im working on a bit of MySQL and was wondering if there is a way (without using php arrays or other) to search a table for a value (say 1) and return the rows which '1' wasnt found in. != wont work because the table contains more than … |
| | hi, i have two entities products and categories. both have many-to-many relation. how can i get the products that are not related with the categories. i mean the ones which not not mapped in junction table. thank you! daniyal nawaz |
| | I'm looking for some guidance on how to develop a msql query that loops through elemenets in a php array. The array is constructed from a multiple line list box. |
| | Hi I have two databases ...1st is server database which is in MySql and 2nd is local database which i will create in oracle. I want to have some of fields of 1st database to be populate in in my local database which should be refreshed automaically ... plz let …  |
| | i have found this code and would like to know how i can get the column titles to show up at the top of the page. [CODE]$result = mysql_query( "SELECT * FROM merc_users" ) or die("SELECT Error: ".mysql_error()); $num_rows = mysql_num_rows($result); print "There are $num_rows records.<P>"; print "<table width=1000 height=400 … |
| | [php] <?php /* declar some relevant variables */ $Host = "localhost"; //location of mySQL on server $User = "michael"; //my username $Pass = "koolaide"; //my password $Name = "phpaccess"; //name of the database to be used $Table = "info"; //name of the table within the database mysql_connect ($Host, $User, $Pass, … |
| | Hi, Can you please help me? I need to store the path to an image in a mysql database. Would anyone be able to provide me with a script that can do this? Thanks Col  |
| | I am creating a movie database. Right now I have each movie set up as its own table. Inside each table there are fields for title, summary, rating and so on. On one of my web pages, feeding off this database, I want to show the movie title, summary and …  |
| | hello all, i m new to asp.net.....can anyone send me the complete code to write into the mysql data base.....plz mention the complete code to insert data to mysql database..... i m using asp.net and C#...... thanx in advance |
| | i need some help i wana talk about security in mysql 5.2.5 plz send me links (i searched mysql.com site and still i'm not able to get anything about mysql 5.2.5 , no informations were found) 10x |
| | Hi, Can anyone help me here, I want to display an image using the path of the image and the image title from a mysql db? I can upload the info to the db, but I have trouble displaying the image. Here is the code: [code=sql]CREATE TABLE `trailer` ( `id` … |
| | package packagePgmaLibrarySystemRolandgasparDizon; import javax.swing.SwingUtilities; import java.awt.BorderLayout; import javax.swing.JOptionPane; import javax.swing.JPanel; import javax.swing.JFrame; import java.awt.Dimension; import javax.swing.JLabel; import java.awt.Rectangle; import javax.swing.*; import java.awt.*; import javax.swing.JSlider; import java.awt.GridBagLayout; import javax.swing.border.SoftBevelBorder; import javax.swing.JScrollPane; import javax.swing.JTable; import java.awt.GridBagConstraints; import javax.swing.JButton; import javax.swing.BorderFactory; import javax.swing.border.EtchedBorder; import java.sql.*; import java.awt.event.*; import javax.swing.ImageIcon; import java.awt.SystemColor; import java.awt.Color; … |
| | Hi. I know this is MySQl forum, but maybe some one help me through the below issue: I don't know which file I should download to install postgreSQL, could nayone please guide me which I should download ??? [URL="http://www.postgresql.org/ftp/source/v8.3.1/"]http://www.postgresql.org/ftp/source/v8.3.1/[/URL] I am using Windows OS. |
| | Hi, I am making a mailing program and the problem i'm having is that I want to display the message exactly as it is entered for example, when the sender presses enter for a new line the reciever see's it. I have thought of using <pre></pre> tags but if the … |
| | Can we arrange a single table in two ways within a page .? I'm in a situation where I need to arrange a single table in two ways within a page, When I test the first piece it works ,even the second piece works great when tested alone, but when … |
| | I am trying to execute a mysql query of the form: [code=php] $query = "Select * from individuals where MotherId like '%".$iName."%' or FatherID like '%".$iName."%' "; [/code] I am getting an "unexpected FatherID" error message. FatherID is of course an attribue of the queried table. The query works as …  |
| | Hi. I want to know how it is possible to write your own function "UDF" in MySQL? and how use that UDF in MySQL? |
| | I have a form that inputs data to a database. All is working fine, but what I'd like to do is when it gets to the [code] $result = mysql_query($query) or die ("Error in query: $query. ".mysql_error()); [/code] instead of the mysql_error, I want to display my own error with … |
| | [b]hello, i want a help for you all. about mysqlprocedures and functions i am enable to create procedures and functions in mysql so that i am enable to do jdbc colleable statements programs. please help me[/b]  |
| | Is someone farmiliar with the travel database that installs with the netbeans installation? I can finally connect to the db and it shows folders to hold tables etc yet there is no tables in the folder. Is there a way to obtain the scrip for the travel db so I … |
| | Hello, mysq_query($query) returns a valid result set. However, [CODE] function query($query) { return mysql_query($query); } [/CODE] returns a 1. Why does this happen? Is there a way around it? Thanks in advance. |
| | Hello, i have a database that came with MYSQL statements to get it working but we are using MSSQL and have managed to convert a large proportion of them but there are two statements we are having trouble with and wondered if anyone could help. The first is below: [CODE]SELECT … |
| | is it possible to add a number to a number that is stored in mysql db without extracting the stored number first. i have a count and i am updating the count periodically but i would like to know if i can update the count while it is in side … |
| | after i have run my query on a mysql db how can i set the result to equal a variable that i will use later on in the page. i have set the query up like this [CODE] <?php $rand = rand (0, 100); $query = "SELECT broad1 FROM images_broad"; … |
| | i have created a table to store the number of a count which i need for some subtraction at a later date. when i try to get the information out of the table instead of getting the number 5 i am getting resource id # 5. the table has been … |
| | Hey guys, Is there any way that I can just simply get the length of a row in a table? Thanks |
| | Hi, I wan to know where the MySQL variables stored? when I execute the [CODE]show variables; show status; [/CODE] I see many more variables, so I want to know the place they are stored in? and the file name too? |
| | For some reason I deleted a sample database that was in the netbeans tutorial. Of course now I need it and I don't where to get it( I tried the google,and will try again) but does anyone know how to obtain the script? Thanks -Steve |
| | Hello All, Is there a way how we can pass a PHP variable whose value has been retrieved from MySQL database to the next page? Initially I tried this which didnt help me anyway. [code=PHP] // if user login information is CORRECT then redirecting them to the user home page … |
| | I am running a MySQL cluster test on 3 nodes. 1 management node 2 storage nodes. I can't seem to get mysql to start successfully. All 3 nodes are running Ubuntu Server 8.04 with MySQL 5.1 ... I know this is totally new, however, we are trying to test out … |
| | Hi, I need to match rows from one table to another table that may or may not have a match on one common column.... the problem begins with bringing back the most recent row in the other table. So, the query I'm starting with is: [code]SELECT * FROM data LEFT … |
| | Hello Is there a way i can have a MYSQL query to run automatically at a certain time without me running it myself? |
| | Hi. I want to GRANT privileges on two tables, but I dont know why error, but on one table it is ok. what is wrong? [CODE]GRANT SELECT ON mysql.db, mysql.user TO 'user'@'localhost' IDENTIFIED BY 'password';[/CODE] I dont know why it is not working on two tables??? |
| | I keep getting an error where the symbol cannot be resolved and the arrow pointing to where i have written statement.ExcecuteUpdate Am not able to insert any data into my database, can anyone see where i may have gone wrong. thanx heres the code: <%@ page import="java.sql.*" %> <%@ page … |
 | somebody knows how to call mysql Procedure in PHP? i extract almost forum regarding procedure in php on google but didn't find solution. pls. reply ASAP. thanks in advance  |
| | I am using adodb to import a CSV file into a MySQL database. One of the fields is lastname. One of the contacts being imported has a last name of 'null' (yes, that is really his last name). It always gets valued as a NULL value, not null the string … |
| | Hi everyone I was wondering if there is a way to store data to a mysql db after it is screen scraped? Thanks |
 | I currently have a database that is just one table with products and is using the myisam engine for the fulltext capabilities on two columns. The question I have is that this database has about 390,000 rows with a lot of duplicate entries namely manufacturer, price. I have been searching … |
| | Hi all, I wonder if it is possible that someone can drop me a code or something on this particular problem which I am currently dealing with. in_date out_date 18/03 30/04 20/04 So how am i supposed to pair up 30/04 and 20/04 as 1 pair and show it up … |
| | Hello everyone, I'm currently building a cms system and have hit a brick wall in relation to the error I'm getting below. Any help would be greatly appreciated. Thanks James. The error: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\wamp\www\widget_corp\includes\functions.php on line 41 The functions.php: …  |
| | Hi people. This is my first thread, i hope you can help me. I'm a newbie and my english is so bad, but, i hope you can understand me. this is my question: I've a table TURN with this field IDTURN (int) SEASON (string) SORT (string) another table GROUP IDGROUP … |
 | Hey, im having a problem getting this email check to work it basicly prints out in a very origional way how manny eails you have... [COLOR="Green"][B]Check Inbox [/B]([I]3[/I]) [/COLOR] Heres the code: [CODE]$find_content = "SELECT * FROM email WHERE email_too_id = '$userid' OR all = 'true'"; $content_sql = mysql_query($find_content) or … |
| | how to copyng data from another database postgre to mySQL database without cronjob with realtime... thanks |
| | Hey, could use a little help here. I must be brain dead but I can't think at all, I need help. I have a table with a bunch of IP addresses in it and a lot of them are the same, how do I -- Remove all the IP's except … |
| | Straight to the point...:) I have problem connect to database. when I click Login button, the code can't read the username in my database. I have checked the codes but i think there are some mistakes, but i don't know where it will be. Please help me. Here with I … |
| | I get the following when attempting to view a project I have, I have MySQL 5.0 and Tomcat 6.0. Both services are running. As far as MySQL connectors, I have both "mysql-connector-java-5.0.7-bin" and "mysql-connector-java-3.0.8-stable-bin". This has not worked with either one. HTTP Status 500 - type Exception report message description … |
 | I am new to VB. Yesterday I learnt how to connect to a database. My work computer has Microsoft SQL Server (which I could connect to) but I use mySQL at home and do not know how to connect to it. Can somebody please help? |
| | I'm a C++ beginner. What's an easy to use (in terms of both installation and use in code) library for using MySQL in C++? Is there one that's a lot more commonly used than others? Note that I'm using MySQL 4.1.22 on GNU/Linux. I've found the following: [LIST] [*][URL="http://dev.mysql.com/doc/refman/4.1/en/cplusplus.html"]MySQL++[/URL] [*][URL="http://www.sqlapi.com/"]SQLAPI++[/URL] … |
| | I've fired a query which result some data with the respective count from the table and after that i want to fire a query to get the total number of count on that count which i got it from my first query. Could anyone helps me out to get the … |
| | I was trying to create a moving average. Here's the sample data: [code=MySQL] create temporary table if not exists window (id int); delete from window; insert into window(id) select 1 union select 2 union select 3 union select 4 union select 15 union select 6 union select 7 union select … |
The End.