11,093 Topics
 | |
| | hi...... i created my login page...everything is working fine. i want to know whether we can get the login date for each users when they login.. and when they login the date shud be posted in the database?? how to implement this... |
| | Hey guys, I'm new to writing SQL and I need a bit of help. What I'm trying to achieve is getting my Java application to successfully send the high score of a specific user to a database. I'm not sure how I would write the SQL code so it will … |
| | I have a table where there is about 1 milliard record. when my website is on high traffic, there is more than 100 requests/second on this table. so request respond time is between 2-4 seconds, which leave a bad impression. is there any suggestion how to minimize the request respond … |
| | please correct the syntax[CODE]$sql = "INSERT INTO products WHERE cat_name = '".$_POST['cat_name']."' (cat_name,pro_name, file_name, manufacturer, manufacturers_code,detail,page_title,page_keywords,page_description,active,featured) VALUES( '" . $_POST['cat_name'] . "','" . $_POST['pro_name'] . "','" . $_POST['file_name'] . "', '" .$_POST['manufacturer'] . "', '" .$_POST['manufacturers_code'] . "', '" .$_POST['detail'] . "','" .$_POST['page_title'] . "','" .$_POST['page_keywords'] . "','" .$_POST['page_description'] . …  |
| | I began to develop a simple coupon site. my db design Contains 4 tables: users deals category city when user purchasers a coupon i connect to getway payment service. in my accont at the getway service i can see all the transaction from my site. does it's meen that i … |
| | I have a php/mysql/html table of results The query is [CODE]$result = mysql_query(' Select var1, sum(var2) round(Avg(var3),0) round(Min(Price),2), round(Max(Price),2), round(Avg(Price),2) as AvgPrice, Country, From table Where country = "Australia" Group By var1 having var3 > 5 Order By var3 DESC') or die("SELECT Error: ".mysql_error()); $num_rows = mysql_num_rows($result); print "<table width=800 … |
| | Hi Guys, Can someone help me. I am using FCK Editor when I add a new news article to my website. When entering each new article, I have included an option where there is a drop-down list to select a particular news category. In the front-end of the website the … |
| | Hello everyone, I have a problem with this code php: [CODE]<?php $sql = mysql_query("select * from news left join categories on news.category_id = categories.id group by category order by categories.id "); while($row=mysql_fetch_array($sql)){ ?>[/CODE] html: [CODE]<div class="title" align="center"> <?=$row['category']?> </div> <div class="headlines"> <span style="float:left;"><?=$row['subject']?></span> <span style="float:right;"> <?=$row['date']?> </span> </div>[/CODE] the problem … |
| | please help me!!! im restarting the mysql server from putty: Empty pid file /var/lib/mysql/mysqld.pid for /usr/sbin/mysqld when i checked mysql status, unused running unused running what's the problem?? im using putty in configuring mysql server thanks in advance.  |
| | hello guys, please give me any idea about solving this problem. I have two tables categories: id .... category .... parent ________________________________ 1 .... general .... 0 2 .... news .... 0 news: id .... headline .... category_id ________________________________ 1 .... headline1 .... 1 2 .... headline2 .... 2 3 … |
| | Hi people, well i am a computer science student and my dissertation title is "An Agent Based Tutoring System" and i am using JADE to do it and MySQL for the database. Can any one help me in doing it?? I want you people propose me some ideas so as … |
| | [CODE]Imports MySql.Data.MySqlClient Imports System.Data.SqlClient Module connection Public conn As MySqlConnection Public Sub xconnect() conn = New MySqlConnection conn.ConnectionString = "Server=localhost;User=root;Database=test;pwd=;" Try [U][B][COLOR="Red"]conn.Open()[/COLOR][/B][/U] MsgBox("Success") conn.Close() Catch ex As MySqlException MsgBox(ex.Message) Finally conn.Dispose() End Try End Sub End Module System.TypeInitializationException was unhandled Message="The type initializer for 'System.Transactions.Diagnostics.DiagnosticTrace' threw an exception." Source="System.Transactions" TypeName="System.Transactions.Diagnostics.DiagnosticTrace" … |
| | i got 3 users to be registered in the registration form through radio button admin,manager and employee... after registration of a admin the other 2 raadio buttons shud only enable in the registration form... admin shud be disable............ how to implement this in php........... |
| | [CODE] $dbhost = 'localhost'; $dbuser = 'root'; $dbpass = 'password1'; $dbname = 'DB01'; $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql for First Database'); mysql_select_db($dbname, $conn) ; [/CODE] This first connection is where the php file is stored. [CODE] $dbhost02 = '192.168.0.16'; $dbuser02 = 'root'; $dbpass02 = …  |
| | |
| | i have mysql xml field like this [CODE]<?xml version="1.0" encoding="UTF-8"?> <record xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.loc.gov/MARC21/slim"> <leader>00764nas </leader> <controlfield tag="221">011258</controlfield> <datafield tag="578" ind1=" " ind2=" "> <subfield code="a">jaun</subfield> </datafield> <datafield tag="356" ind1=" " ind2=" "> <subfield code="a"></subfield> <subfield code="c"></subfield> </datafield> <datafield tag="333" ind1=" " ind2=" "> <subfield code="d">ali</subfield> <subfield code="p">22</subfield> </datafield> <datafield tag="222" … |
| | I have two tables that I'm using in this query. We'll call the first one "userGroups" and the second "links". I've included their structure below. I have one system that is running an older version of MySQL, and I also have a system running a newer version. Older Version: 5.0.91-community-log … |
| | guys, can anyone help me on this problem? i have two tables then what I want is that, when an identical item is found in table2, it will not be displayed. Example: [CODE] Table1 Table2 item1 other1 item2 other2 item3 item2 item4 item3 [/CODE] Condition: if we use this query: …  |
| | I am wanting to set up a home server using an old computer, after doing some costs it would work out considerably cheaper than using a hosting service, and although less reliable I feel it would be some good and valuable experience. I have installed Ubuntu server edition onto my …  |
| | Hello everyone , i just need to insert into my database the state of 4 checkbox , i'm trying now only for two . For this, i have two file formulaire.html and form.php , I've created for each checkbox a column in my database , so , what i want … |
| | |
 | Hi guyz,, I have 2 table like, [B]table1[/B] [B]Name[/B], [B]Number[/B] Gates 123456789 Bill 987456321 John 874123658 Peter 562314752 [B]table2[/B] [B]Number[/B], [B]Message[/B] 123456789 Hai hello 874123658 Gudmorning 123456789 Something Went 123456789 verY Nice morning 562314752 Hai spidy.. My Question is how to select all records from table 2 and also i … |
| | I have a mysql table that has id, name, type, size, content, and link. I have pages download.php and showimage.php. I want the link to affect the image so when the user clicks it sends them their. I only created showimage.php cause I had ran out of options on how … |
| | [ICODE]Hi, am wounding where i can find a script that can do something similar to this [url]www.avis.com[/url] Pls look at the right low side. This is just javascript, want something similar, but using php/mysql.[/ICODE] |
| | i can't install vb.net connector 6.4.4 help |
 | So, I wrote the following program to connect to my local mysql server and create a table in the existing "test" database. The program compiled without any errors, but I got the following run-time error: java.sql.SQLException: Cannot connect to MySQL server on localhost:3306. Is there a MySQL server running on … |
 | I've run into a bit of a problem following a database replace last week. I need an expert in MySQL to help me out as I don't know a thing about the service. If you can help me, I'm able to offer $30 pay. It could be a piece of … |
| | hi... im doing project for a school...and new to php and mysql..just learning.. i have to create one loginpage with 3 different users like corres,principal and the staff in the table field what type i have to give like ENUM or SET.. i want to assign 0 for corr,1 for … |
| | Hi to all I am having this problem can anyone help me to solv this problem pls here is the code. first problem [CODE]Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /hermes/web07/b2501/mydomain.com/htdocs/media.php on line 40[/CODE] media.php code [CODE]<?php $connection = mysql_connect('localhost','test','test'); if (!$connection) { die ('error … |
| | Hi a have 4 tables [ICODE]Table A ID | Data 1 --------------- 1 | A 2 | W [/ICODE] [ICODE]Table B ID | Data 2 ----------------- 1 | B 1 | C 2 | X [/ICODE] [ICODE]Table C ID | Data 3 ---------------- 1 | D 1 | E 1 …  |
| | hi m using php n mysql m trying to merge two tables of same database and then print them but somehow it is not working it gives me the error my code is [CODE]<?php session_start(); print_r($_POST); $con=mysql_connect("localhost","root",""); mysql_select_db("pras2",$con); $date= $_POST['date']; $shift_num=$_POST['num']; $query="SELECT shift_id FROM shift WHERE shift_no='$shift_num' AND date='$date'"; $result=mysql_query($query); … |
| | please help me!!! im restarting the mysql server from putty: Empty pid file /var/lib/mysql/mysqld.pid for /usr/sbin/mysqld when i checked mysql status, unused running unused running what's the problem?? im using putty in configuring mysql server thanks in advance. |
| | Hello Every One ! How to show md5() password from MySql table in PHP, I have saved my user's password as , [CODE]$password = md5($_POST['password']); $save = mysql_query("INSERT into users(password) VALUES ($password)");[/CODE] Its encrypting nice and works fine when user logs in , that's not a problem, my question is … |
| | I'm running the following code in PHP to generate the random list of movies from the database but since value of genere is an array it is just capturing the first value of the array. How can I modify the query so that I can get all the values of … |
| | Hi, I have this program that uses OLEDB connection to open the excel file, and imports it's data. Then I use mysql connection to inserts all this data. Now my question is, is it possible that I can use mysql connection in opening the excel file, or only OLEDB connection … |
| | Hi all........... I shud just how to use ENUM type in mysql..like shud i give any field in form in a website and how to assign a values for eg 0 for admin,1 for manager and 2 for the staff using phpmyadmin?? please help me................. |
| | Hello I'm looking to allow users upload pictures onto my site and have it displayed and linked to their site.. This process is for Ad purposes. Ive looked into php mysql uploading images but ive ran into a lot of threads condemning the practice and suggesting saving the images to … |
 | Hi everyone, I had this problem with phpMyAdmin and successfully fixed it. Then, after some days, I encountered the access problem with the WAMP server. I haven't changed anything yet. Or maybe, I need to set up the environment variables? The message I'm getting is that [QUOTE]Forbidden You don't have … |
| | hi i m writing a program it is workng fine but doesnot update my database it gives me error since there are 4 query how can i know which one is wrong my part of program is: [CODE] $query2="SELECT * FROM rpms WHERE product_name='$raw_material1'"; $result2=mysql_query($query2) or die(mysql_error()); if ($result2) { … |
| | Hi I have one sql query. using this query i can download 10 lakhs of data in csv file for 6 hours. now i want to download 20 lakhs of data for 6 hours or less. please tell me how to increase the performance. SELECT id as imp_addr_id,userEmail, email ,name,mobile_no,gender,city,income,profession,experience,country,pincode,type …  |
| | I want to create a voting system where there is a user and admin pages. so when the user has selected, the user can not choose anymore. To the database system checks whether the user has selected or not. I want to use the session between user and admin. and …  |
| | Hello all, First off, I am not here to debate the merit of storing PDF as a blob in MySQL. I know this is not optimal solution, but this is the requirement that I have to work with. The upload appears to be successful, (Field in the database is filled … |
| | hi all, i have written store procedure which is working fine in MySQL browser the problem i am facing is when i call store procedure through c# usng nhibernate it is throwing exception MySQL.Data.MySqlClient.MySqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is …  |
| | Hi, I'm new in php and face some problem in mysql. I want to check some data if it's remain on database. Example: in my form there are two form field. 1) url 2) name. So i want to check if session user have already this 'url' and 'name' in …  |
| | ( old ) sql = """CREATE TABLE (DATABASE1) ( TEXT_BODY CHAR(20) NOT NULL)""" I would like the above to work like the below. [CODE] sql = """CREATE TABLE ('%s') ( TEXT_BODY CHAR(20) NOT NULL)""" % header [/CODE] ( this produces an error ) Does anyone know how I can make … |
| | hi i am writing a program which take the value from form and then execute a error "failed" each time. which means there is some error in my query but i cant find the problem. here is the code [CODE]<?php session_start(); //print_r($_POST); $name=$_SESSION['SESS_CUSTOMER_ID']; $con=mysql_connect("localhost","root",""); mysql_select_db("pras2"); $product_id=$_POST['P_list']; echo "$product_id"; $quantity=$_POST['quantity']; $query= … |
| | I have this error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near and I don't know how does this happen because whenever I check the SQL that I have made including the inserted … |
| | Hello, I am a student.For the project we have to store first 20 search engine results (URLS and id) in the Mysql database.We referred to the google search API ,it says we will get results in JSOn/ATOM format.But we are not getting exactly how to store those results in JSON … |
| | [CODE] $query = "SELECT item, description, price, imageData, status, username, item_id FROM items"; $result = mysql_query($query) or die(mysql_error()); $z=0; while($row = mysql_fetch_array($result)) { //echo other columns here// echo "<td><div id=status$z></div></td>"; <script type=text/javascript> function updatestatus(itemnum) { var url="updatestatus.php?auc=<?php echo $row['item_id']; ?>"; jQuery('#status' + itemnum).load(url); } setInterval("updatestatus(<? echo $z?>)", 1000); </script> <? … |
| | Hi, I have been searching for a couple of days now for a resolution to this issue, and while I find a few references to it in google, nothing really defines the entire process. I have a MySql table called 'product_distribution' When a customer orders a product, all pertinent information … |
The End.