10,940 Topics
 | |
| | 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 … |
| | Hi, I am showing my output using this. It shows all the records on web page where month is July(07) But I want it show all the records like: there are 29 records found, I also need 3 records per page, How I will do paging for these. please guide … |
| | Hi friends I am new to mysql . After Installing mysql-standard-4.1.22-unknown-linux-gnu-x86_64-icc-glibc23 in linux i am getting the error ./mysql_install_db ./mysql_install_db: line 85: my_print_defaults: command not found Could not find help file 'fill_help_tables.sql' in ./support-files or inside .. pl help me how to overcome it Thanks in advance |
 | I have MySQL running such that I can open a client command line and log on and make databases, tables, etc. I wanted to do some AJAX. Doing AJAX with ASP, SQL Server, etc is not advisable since both places where I am hosting my websites do not use the … |
| | Hi all, I am writing a program which needs to connect to a mysql server I have set up. I use the proxy server at school to access internet. I found that my program cannot connect to the database. So how do I connect to mysql through the proxy server? …  |
 | read: \"you fail at life =]\" yuh is being put into the database from a form submit obviously i dont want the backslashes. how do i get the backslashes rom being inserted into the mysql db table? my code is `$code = mysql+real_escape_string($_POST[code]);` then insert it with mysql query. how … |
| | Hi, I'm running a Vbulletin install on a CentOS server. MySQL is ver 4.1.22. Every few days, seemingly at random I have a Db that will reach it's connection limit of 150. The rest of the time connections stay below 30. Then all at once queries build up, and we … |
The End.