10,946 Topics
 | |
| | I'm using mysql as database . I use odbc connector to use the database , it's working fine with select statements ,but when I use insert statement with parameter it is not working. may I know if the command parameter property works with mysql or it only works with mssql.  |
| | Hello, I've read on how to insert properly into two linked tables using mysql_insert_id() function from: [url]http://www.webproworld.com/web-programming-discussion-forum/87197-php-insert-different-records-into-multiple-mysql-tables-same-unique-id.html[/url] now how about if i want it to be from 4 linked tables? can I still use the function? and I want some to be a dropdown lists. My tables are: Client(clientID, Name, … |
| | This has puzzled me for more than a week now. I have been trying to develop a web site for managing a sports league. On of the pages I have is used for changing things like scores and dates and times for games. It is very simple stuff. I have … |
| | Hello, I am working on a code which should execute any *.exe file in java. I have used a sample code which works for UI based application but do not work for command prompt applications like cmd.exe or mysql.exe. Please advise for the improvement. Thank you in advance. Here is …  |
| | Hello, I am importing a .csv file in mysql. I am facing problem when it comes to date. Let me elaborate. CaptureDate 20071101 20071101 20071101 20071101 20071101 This is data. But when i Load the file, it displays only last record correctly but not the rest 4. Please help. Thanks … |
| | hi all i want to insert an image into mysql database using stored procedure, i need to pass the image from c# plz help me |
| | Hi, i'm just looking for some advice in relation to retrieving data from a MySQL database and displaying in nice looking rows. Basically, what i want to do is call the data into separate rows similar to what is on [URL="http://www.rent.ie/houses-to-let/renting_dublin/dublin-city-centre/"]here[/URL]. I'm not sure if these are separate divs or … |
 | Unfortunately I seem to have forgotten everything I ever knew about PHP and MySQL (which wasn't a lot anyway) and I've had one hell of a headache all day which is somewhat clouding my thinking. :X I have two PHP includes on a current site I'm working on advertising a … |
| | Hello, I am importing a in.csv file in mysql. I t contains one variable called CaptureDate. load data infile 'C\in.csv' into table table name lines terminated by '\n' ignore 1 lines; Once I executed, I got errors like row 1 doesn't contain data for all columns. I changed the data … |
| | Hello all. I want to add the mysql to ODBC sources. Im currently running windows vista, and in the control panel, Data Sources (ODBC) when i try to add a system Dns as source i cant find mysql in the list. Here is a pic(so you dont spam [url]http://dev.mysql.com/doc/refman/5.0/en/connector-odbc-configuration-dsn-windows.html#connector-odbc-configuration-dsn-windows-5-1[/url] or … |
| | I need help with this. I am sure its an easy thing.. but I am stumped for some dumb reason.... all this works just fine.. but what I want to echo out is fname and lname of each person once they are selected as well as the next section of …  |
| | [code]$sql = "SELECT * FROM schedule ". "WHERE CurriID ON (SELECT CurriID FROM curriculum ". "WHERE (Pre_Requisite LIKE (SELECT CONCAT('%',SubjCode) ". "FROM studgrade WHERE (Grade >=1 and Grade <=3) AND StudentNumber='$id') ". "AND Pre_Requisite LIKE (SELECT CONCAT(SubjCode,'%') FROM studgrade WHERE ". "(Grade !='5' and Grade !='INC') AND StudentNumber='$id')) OR Pre_Requisite … |
| | Hi all, I want to find out logging ability of mysql when modification is high. In other words, to find out if mysql has an in-built feature to support bulk updates, while monitoring or logging individual record updates. Our aim is to improve performance of bulk updates while logging individual … |
| | Hi all, i am new to php, i dont know how to run the php files, i am going through some tutorials, but not able to install it on my pc. i have dowloaded . . but dont know how to proceed further so please help me out ...... regards, …  |
| | Its sure that you know about the flash flip books. I have the problem with that. Ok the scenario is about to have the tabs or buttons we can say which are alongside on the right of the book and we can use them to navigate the pages using the … |
 | Hi Lets say i have just sent a query to my database and its bought me back a value. I've stored this value in $value1 . How would i get this value into a flash movie ? Any help would be greatly appreciated. |
| | Hello all. I have a small problem with sql. I have a table that has name and rank. For example the ranks would be getted like : select name,score from scores order by score desc So the first line i would see would be person with rank 1, second line … |
| | Hi, Is it possible to have Flash query a MySQL database, retrieve the data, and then do whatever it wants with the data (stored in a variable, or displayed to the screen in a text box perhaps) ? Is it challenging? If I can achieve this, I could perform a … |
| | Let me explain myself, and then hopefully you can tell me a better solution. I have paid web hosting (only $2.50/mo) and in the process of learning PHP, have learned how to work with MySQL databases. I was wondering if it is possible to create a program in C++ that … |
| | Hi Im using the following trigger to refresh my mview. [code]BEGIN DBMS_SNAPSHOT.REFRESH( LIST => 'EQUIPMENT_FEATURES_MVIEW' ,PUSH_DEFERRED_RPC => TRUE ,REFRESH_AFTER_ERRORS => FALSE ,PURGE_OPTION => 1 ,PARALLELISM => 0 ,ATOMIC_REFRESH => TRUE); END; [/code] I change the table from which the mview is created and does a commit, it throws the following … |
| | Hi Im trying to execute a the following query, but its throwing me an error [code]select apex_item.checkbox(1,"EQUIPMENT_ID") Tick, ef.equipment_type as "Device Type", e.equipment_name as "Device Name", ef.equipment_id, ef.Customer_Name as "Customer Name", ef.Site_Name as "Site Name", ef.Managed_Ip as "IP Address", dst.discovery_state_name as "Discover State", d.Error_Code as "Error Code" , d.Last_Discovery_Time as … |
| | I have a server which uses MySQL and supports many clients, and everything works perfectly fine when the MySQL database is on the same machine as the server. However, when it's on another machine, due to what I believe is the slow connection there are several requests from different clients … |
| | hey guys need a little help. i tried to save image into my database, it saves without error but when i tried to check if it saves in mysql, the data about my picture id save, but the image i save return a value of 0. please help me with …  |
| | Hi, can anyone please rewrite the following sql-query? It's working, but it takes some time to execute. [CODE=sql] SELECT `cd_e_calls`.`bedrijfs_id` AS gegevens_id, `gebeld` , `status` FROM `cd_e_calls` , `cd_e_gegevens` , `cd_e_negatief` WHERE `cd_e_gegevens`.`RvV` != '1' AND `bedrijfs_id` = ( SELECT `cd_e_gegevens`.`id` AS gegevens_id FROM `cd_e_gegevens` WHERE ( SELECT COUNT( `cd_e_calls`.`bedrijfs_id` … |
| | ok i cant seem to log in with a regualr password. this code works fine without md5 but it doesnt work when i use md5. yes i've already connected and selected database. $username = mysql_real_escape_string($_POST['username']); //so someone cant sql inject. [CODE]$ = mysql_real_escape_string($_POST['username']); $password = md5($_POST['password']); $result = mysql_query("SELECT * … |
 | hi there could you please help it's agent, i'm doing search button my code gives me this erro 'CurrentPageIndex' is not a member of 'System.Web.UI.WebControls.GridView'. here is my code [code] Private Sub txtSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles txtSearch.Click BindData() End Sub Private Sub BindData() Dim connection … |
| | I am trying to copy a list of email addresses in Excel and paste them into SQL. I am using Navicat. I am able to paste the text, but I lose the hyperlink format. What can I do? Obviously, I new at this. Any help would be appreciated. Thanks...Gadfly_1943  |
| | Hi Im rubbish MySQL joins, and need an assist please. i have a product table and an images table. Each product has 4 images associated to it by a foreign key product id in the images table. I need to pull out the product info (from prod table) and 1 … |
| | Hello it's me again! So I've managed to create 4 linked drop down boxes like: Country : [===Country===|v|] Client : [===Client===|v|] Environment : [===Environment===|v|] System: [===System===|v|] And it's working fine with the codes written at the end of this post. Next step is I wanted a Table to contain 2 … |
| | I'm currently working on APEX where I expect the following query to work.. But its not working or giving me any errors. here is the query [code=sql]select et.equipment_type, max(case when name='Managed_Ip' then value end) as SNMP_port, e.equipment_name as equipment_name, cu.customer_name as customer_name, st.site_name as site_name from equipment_feature ef inner join … |
| | I use Lunerpages Hosting. I want to use the Navicat 8 for managing the mysql database in my Lunerpages hosing. recently, I added a my IP address as Access Hosts in mysql database. but i can't access the mysql database of lunerpages using Navicat. please help! people claims that they … |
| | Hello, I have a MySQL database and I'm trying to make a dropdown list using PHP based on the value stored in my DB. So far I have this (copied, pasted, and edited from another forum): [CODE] <form action="maintest2.php" method="POST"> <table border="0" cellpadding="2" width="100%"> <tr> <td><b>Main Category:</b></td> <td> <select name="Name"> … |
| | hello, i have a php/mysql vehicle database with fields make, model, price and year. in my webpage ALL database records are displayed by default using the select command in a table. i would like add a filtering functionality on all 4 fields as such i have an arrow selector on …  |
 | [CODE]myconn.Open() MySQLstring1 = "select picture from naw where id = 17" myCommand1.Connection = myconn myCommand1.CommandText = MySQLstring1 myReader = myCommand1.ExecuteReader If Not myReader.HasRows Then MsgBox("now rows found") Exit Sub End If If myReader.Read Then Dim imgByteArray() As Byte imgByteArray = CType(myReader.Item("picture"), Byte()) Dim MyStream As New System.IO.MemoryStream(imgByteArray) [COLOR="red"]PictureBox1.Image = Image.FromStream(MyStream) … |
| | Recently only i cam eto know about Mysqli.. . . i was wondering What Esp. does Mysqli have..?? :O i have a store procedure.. which i can call in Mysql..!! than why should i use Mysqli.?? :O One more thing i want to ask.. $link=mysql_connect($server,$serveruser,$serverpassword,0,65536); what two parameters used for..? …  |
| | Hi! All I am working with database mysql5.0 on my system. But when i upload every thing in web it is not recognising host as [url]http://205.178.146.79/[/url] and giving Warning: mysql_connect() [function.mysql-connect]: Unknown MySQL server host 'http' (1) in /data/19/1/55/45/1870534/user/2032167/htdocs/music/LoginSystem.class.php on line 112 Unable to connect to MySQL Please help me … |
| | Hi guys, My question would be..... how do I repair a MySQL table remotely? Is there a tool that I should first download? For example: I'm using windowsXP and I want to repair a table in a Linux server.... Is that possible? Thanx |
| | watchinthegame posted the following thread on Mar 14th, 2009 : MYSQL field is Datatype DECIMAL(9,2) When I update the table and set the field to 120.00 it gets populated as 1200.00 What am I doing wrong? Thanks Watchin -------------------------------------------------------------------------------------- It doesn't appear this was every resolved (at least not via … |
| | Dear all, I'm new in php MySQL and I'm wondering on how to maka users add many informations in one table, I'll explain. Now I have a table called users conataining: Username(primary key) - Name - Birthdate - Country and I want the user can add infos in a table … |
| | Hi Experts, I am getting this error message, "Error connecting to mysql" whenever i am running the below scripts: [code=php]<?php $dbhost = 'localhost'; $dbuser = 'root'; $dbpass = 'password'; $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql'); $dbname = 'petstore'; mysql_select_db($dbname); ?>[/code] I've just set-up everything and … |
| | Hi to all keen folks, can you help me to query the first 4 letters and the last 4 letters in one field. example: AAAABBBBCCCCDDDD how to query AAAA and DDDD. thank you. |
| | Hi, I'm creating a basic CMS using PHP and MySQL and i'm struggling to get the checkbox information from my html page across into the database. I want the values to appear as binary 0 or 1 values, any help would be greatly appreciated thanks html document is written as …  |
| | i want source code for chat in php and mysql |
| | Good morning/afternoon/evening! I'm trying to run a MySQL query, but it seems to be ignoring the "ORDER BY" clause, most likely, I'm believing, because I'm using the "IN" keyword in my query (several times, as a matter of fact, along with a "LIKE"). Is there a way I can structure … |
| | hello, i have a mysql database which i use a php script to search and display results with fields make, model, price, year and would like to add extra functionality with presumably javascript to add a drop down form field as when a particular make is selected from the list … |
| | MYSQL field is Datatype DECIMAL(9,2) When I update the table and set the field to 120.00 it gets populated as 1200.00 What am I doing wrong? Thanks Watchin |
| | hey all - I'm more of a self-taught programmer but am going to school for programming as well. I'm quickly finding out that my favorite languages are the ones that school doesn't teach. figures, doesn't it? anyways, I've been playing with php/mysql for around a year now, and have been … |
| | hello guyes ..i dont know what is the problem with this code ..it was working with me before but now it just store nothing ... when i submite the data every thing shows in the database ecept that image nothing shows there ..i attached the code here so every can …  |
| | Hi people, I have run across this website many times, with the first impression that it was a website to ask a guy named 'Dani' questions about code *snicker*. I haven't introduced myself. Maybe I will. But I have a question. In building a program, I'm running mysql code. In … |
| | hello I have an idea of an rack space table which has hostnames and uheight info on it. But as I'm quite new to this mysql programming I actually dont have much of knowledge on this programming. I was thinking the database to be of both single table or multiple … |
The End.