10,940 Topics

Member Avatar for
Member Avatar for tech@gmail.com

[B]Hi All[/B] 2 db servers replication interval in every 60 secs right now needs to have length interval ncreased is this o.k. to do - pro's and cons of this Thanks for ur time and help..............

Member Avatar for mwasif
0
60
Member Avatar for jaasaria

hello sir... from our office we are using wamp for our mysqlserver... but i wanted to be connected to my sitemate database only changing the MysqlHost address.. username and also the password... the problem is i cant connected to it.. maybe u already incounter this before and im hoping that …

0
64
Member Avatar for Phaelax

Nevermind, I'm a retard. I had phpMyAdmin opened to the live server, not the testing server which is still empty. I need a drink.

0
72
Member Avatar for lydia21

hi I want to fetch data from four tables using a single query.please tell me how to do that. thanks in advance

Member Avatar for varmadba
0
98
Member Avatar for Fost

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 …

Member Avatar for tesuji
0
93
Member Avatar for daniyalnawaz

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

Member Avatar for varmadba
0
101
Member Avatar for nibbler

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.

Member Avatar for nibbler
0
157
Member Avatar for samarinder

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 …

Member Avatar for pritaeas
0
60
Member Avatar for kevin wood

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 …

Member Avatar for kevin wood
0
100
Member Avatar for Killer_Typo

[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, …

Member Avatar for michael.mckee
0
3K
Member Avatar for colcar2008

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

Member Avatar for peter_budo
0
77
Member Avatar for ztwalsh

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 …

Member Avatar for nav33n
0
70
Member Avatar for pranabmohanty

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

Member Avatar for a496761
0
115
Member Avatar for vamp.ali.ca

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

Member Avatar for pritaeas
0
78
Member Avatar for colcar2008

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` …

Member Avatar for kvdd
0
921
Member Avatar for dnalor

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; …

Member Avatar for masijade
0
170
Member Avatar for tanha

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.

Member Avatar for tanha
0
99
Member Avatar for webguru07

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 …

Member Avatar for fenixZ
0
69
Member Avatar for flashyflashy

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 …

Member Avatar for Ole Raptor
0
77
Member Avatar for Sheridan

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 …

Member Avatar for somedude3488
0
52
Member Avatar for tanha

Hi. I want to know how it is possible to write your own function "UDF" in MySQL? and how use that UDF in MySQL?

Member Avatar for tanha
0
150
Member Avatar for rickarro

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 …

Member Avatar for rickarro
0
5K
Member Avatar for madhavipoudala

[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]

Member Avatar for jwenting
0
70
Member Avatar for ceyesuma

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 …

0
50
Member Avatar for ryy705

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.

Member Avatar for ryy705
0
109
Member Avatar for dtmd

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 …

Member Avatar for huangzhi
0
159
Member Avatar for kevin wood

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 …

Member Avatar for nav33n
0
77
Member Avatar for kevin wood

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"; …

Member Avatar for kevin wood
0
137
Member Avatar for kevin wood

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 …

Member Avatar for kevin wood
0
69
Member Avatar for still_learning

Hey guys, Is there any way that I can just simply get the length of a row in a table? Thanks

Member Avatar for still_learning
0
297

The End.