10,940 Topics
 | |
| | 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 … |
The End.