11,093 Topics
 | |
| | I'm having trouble displaying results when i connect to 2 databases. My connection script seems to be working fine and returns no errors; [CODE]$connect1 = mysql_connect("localhost","user","pass", true); $connect2 = mysql_connect("localhost","user","pass", true); $db_selected = mysql_select_db("database1", $connect1); $db_selected = mysql_select_db("database2", $connect2);[/CODE] When i run the queries, however, I'm only managing to get … |
| | I have dtpker1 and dtpker2 to choose from the date and I want to display in Listview. the problem with this code is that it cannot display dates from the listview. Please help me with the right syntax plzzzzzzzz.........:) Thank you so much!![code]Option Explicit Dim rs As New Recordset Dim …  |
| | Hello Everyone, I hava design just a register page and a login page ,a user can register then login..during registration i used the password() for password field insert value to database. During login I used as password('_POST[pass]') and comparing with the inserted value but its not working .... I just … |
 | Thanks for taking the time to read this. Let me start by saying I'm a php newb so be gentle! I have a form that is used to insert data into my database to display info and images in a portfolio section on my site. In the form, the input … |
| | Hi, I need some guidence or some tutorials which will teach me how to do , i am not sure is this the correct forum i am in. i need a way to upload any kind of file from the fileUpload control to MySQL server how can i do this, … |
| | Hi, I am a PHP developer I never learned much JS but there is no way to accomplish this function using only PHP without a refresh. I am trying to adapt a script that did the basics. [CODE] <script language="JavaScript"> function som() { var First, Last, Full; First = document.Credit.First.value; …  |
| | [code=sql]DELIMITER $$ DROP PROCEDURE IF EXISTS `hrprocess_temp`.`sp_alltabinsert1` $$ CREATE DEFINER=`invensis`@`%` PROCEDURE `sp_alltabinsert1`(empid varchar(10),fname varchar(45),lname varchar(45), fathername varchar(30),dob varchar(20),gender varchar(6),maritalstatus varchar(9),spousename varchar(15),children varchar(8), commadd varchar(250),permadd varchar(250),mobileno varchar(15),landlineno varchar(15),email varchar(40), languages varchar(25),nationality varchar(25),bloodgroup varchar(5),drivingno varchar(20),panno varchar(15), passportno varchar(15),imagepath varchar(100),resumepath varchar(1000),skill varchar(250),deptname varchar(30), Course varchar(20),Specialize varchar(35),institute varchar(25),PassYear varchar(10), Organization varchar(25),Designation varchar(25),FromDt varchar(15),ToDt varchar(15),ReasonsChange …  |
| | please help me it usually gives me error ( it says cant enter the values ) [CODE] <?php $host = "localhost"; $con = mysql_connect("localhost","awah","password") or die ("error to connect to the server"); // contact the table and enter the form mysql_select_db("kigalifinders_clanteam_admin", $con); $query = mysql_query("INSERT INTO contacts(from, subject, message) value('$_POST[email]','$_POST[subject]','$_POST[messgae]')"); … |
| | I'm trying to write some php that will allow a user to edit an order they previously placed. But in the same way they made the order if that makes sense. So this is my jQuery code to send values to a php page: [CODE]$('#submit').live('click',function(){ var postData = {}; postData['data[order_id]'] …  |
| | I'm trying to teach myself a bit more php/mysql so that I can implement better usability on my osCommerce site. I've set up a bit of space on the web server and the db server so that I can play about with stuff and I'm close to doing what I … |
| | hay gays i want to retrieve xml data from three table stored in mysql. i used the below code it works fine but first it retrieve one record from first table than iterate to second table and print the whole table and then iterate to third table and print the …  |
| | Hi i'm new to php and i'm developing one admin tool which involves a form. The form involves more database interaction. My main interest with this form is to upload images to database with file system which i'm able to do. My form consists of fields like..... "Photo Taken by","Number … |
| | Hey guys, In my DB, i've got appointments set, and i need to select all appointments which are an hour or less away. For example i want to do something to the following (Dont worry, i know this wont work as is) [CODE]SELECT * FROM timetable WHERE time has one … |
| | hi all, i am trying to create a room booking system in php. now i want to check if a period exists within a given month. i ask the user for the month and how many days they want to come, now i want to look in mysql (where i … |
| | Hello! I've made a site called 'About us' on norwegian it means 'omoss' in my code;) But when i am displaying my code the hole page is white! I can't find the error. Can someone pleas help me? [CODE]<?php include('connect.php'); ?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> …  |
| | PHPMYSQL - How do you perform a double SELECT query or check against multiple fields? Does anyone know how this can be achieved? What i want is from a search page that has multiple search areas such as name / description / functions and be able to type multiple search … |
| | Hi, I am trying to get a live search facility working but my code is not working, I was wondering if someone could help me out and see if there are any mistakes or things I can change: Index.php [CODE] <form id="jobSearch" method="get" action=""> <input type="text" id="searchJobs" class="JobSearchBox" name="z" onkeyup="showResult(this.value)" … |
| | I'm looking to re-order a table while keeping the table's id column constant. ie, Links has entries in no particular order, whereas LinksPopular is a duplicated table but I want it ordered by category X, while leaving the id category unchanged. That way the first most popular is at id … |
| | I have a query which generates an xml file from data collected. There are 2 columns in the data (reason, TotTime) but they are joined together into one column using the concat command. Currently the results are ordered by reason, but I want to limit my results to only the … |
 | So let me start by saying I am new to PHP so any extra advice is helpful, working on a large scale personal project hoping to get better with PHP because of it. Now I have a script that displays my database just as I like, and next to each … |
| | I am having huge trouble with this Mysql_real_escape_string to prevent SQL Injection. I have tried everywhere possible to input it in my code. My code looks a lot different than most peoples. I mean my login/registration system works PERFECT.. besides that it's not protected from SQL Injection yet which is … |
| | how is MYSQL works and i want to know how set up database table with MYSQL |
| | |
| | Hi All, I need to use the results of this query as an array to exclude files from a tree. The file and folder names that I enter into $exclude work fine but I can not seem to add the results from the query to the array. Below is the … |
| | Hey everyone.. I am relatively new to PHP and JS and I need help. I need to populate a dropdown list from a db(mysql). I can do it just with PHP. The problem arises when I add another of the same dropdown to my form using javascript. I need the … |
| | hey everyone i need your help i want to create a mailling list in php and mysal but i dont know how to do it , so please if you know how to do it please tell me or if you know where i can get it also tell me … |
 | Hi, I am developing a program which requires access to my websites' MySQL. I keep getting errors trying to connect to it. My firewall is allowing the connection but MySQL won't accept it. How can I solve this problem? Thanks in advanced Kieran :) |
| | Hi * I have spent the last 18 hrs or so trying to get the wright sql code or think of an alternative but I just can't get my head around it. If any one can help me it would be awsome. What I am trying to acheive is getting … |
| | Hey everybody, I'm new to PHP, and am having a seemingly simple problem, (Probably a stupid error on my part, atleast I really hope so) I hope you can help me deal with this, and to say thanks for any efforts, I will build 1,000's of backlinks for you, for …  |
| | Hi all, I want to ask how i insert the selected data (Institution Name) and the input text data (School name) into MYSQL?? Thanks~ my database as below: [CODE=SQL]-- -- Database: `inno_education` -- -- -------------------------------------------------------- -- -- Table structure for table `institution` -- CREATE TABLE IF NOT EXISTS `institution` ( … |
| | oh hey guys, i got this little issue where i can read from the database. but i cannot write to it.. here be my full code. live site at [url]http://downloadavirus.net[/url] [CODE]<?php $params = $_SERVER['QUERY_STRING']; $url = $_POST["url"]; $username = "--------"; $password = "--------"; $database = "--------"; mysql_connect(localhost, $username, $password); @mysql_select_db($database) … |
| | Im Writing a c# Code that Takes an Excel Sheet ,creates the Corresponding SQl table and Dumps the data in a new table in SQL. Now My problem is: In the " create table" command , i have to specify the DATATYPE for the column !i.e. CREATE TABLE "table_name" ("column … |
| | Hi, My sql database contains a video table which has a video 'adddate' field. I need to change the code [COLOR="Red"].$video['adddate'].[/COLOR] from the following format: 2010-11-02 to 11-2010 I've changed it in .tpl files doing the following: {assign var='vidMthYr' value=$videos[i].adddate} {$vidMthYr|date_format:"%m-%Y"} However that does not work in my .php code … |
| | Hi guys, I'm trying to create the simplest of databases. The database needs all the standard tasks, such as: add record, delete record, show all records. I need this accessible on the internet, so anyone can check it out. I will probably put it in a password protected directory, unless … |
| | Hi, This code is from an older thread. I'm want to use the code, but I'm having some difficulty with the MySQL table creation. Here's the code: [CODE]<? session_start(); require("connection.php"); if(isset($_POST['submit_btn_name']) && $_POST['submit_btn_name']!='') { $title = mysql_real_escape_string($_POST['title']); $date = mysql_real_escape_string($_POST['date']); $author = mysql_real_escape_string($_POST['author']); $type = mysql_real_escape_string($_POST['type']); $description = mysql_real_escape_string($_POST['description']); $vidName … |
| | Hi, I have a table `Categories` with fields (category_id, category, parent_category_id) I want to write in a single query to replace the parent_category_id with the corresponding category_name. [CODE] // OBJECTIVE: To return all category names and parent category names // if category is root (no parent), parent category name is … |
| | Would someone please try & modify this query in a way that it shows the count for how many users have registered for the current day ? So like right now it should display a count of 2 and then come midnight it would show 0 and then incrementally go … |
| | First off, system specs : MAC OSX, PHP 5 and MySQL 5.1.51 Trying something very simple and for the life of me it just won't work... HTML Form Code: Filename : AG_test_DB.html [CODE] <html> <head> <meta content="text/html; charset=ISO-8859-1" http-equiv="content-type"> <title>AG test</title> </head> <body> <form method="post" action="add.php"> <input name="fname" type="text"> <input … |
| | Hi! I've downloaded the MySQL Server 5.1 and developed a small database using the MySQL Command Line Client. However, now I must update a structure of some tables, include some foreign keys, etc. In my opinion, it is not very comfortable to use the MySQL Command Line Client and the … |
| | Hi guys, me again. Having an issue with a multiple select form object that is generated through PHP and retrieves and displays MYSQL values. it displays and retrieves correctly and PHP produces is correctly, however, the form submission to post the values to MYSQL do not, instead it posts the … |
 | Hi ,all i have two field one is checkin date and other is checkout date . i have table structure as i attached jpg file here. when user enter dates i have to show his season on the basis of hotel id? note:user can enter any date checkin date and … |
| | i am trying to connect a form to mysql database by using php code,but once a click submit button to submit the form this is the error am getting. Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the … |
| | Dear Friends, I want to know that how can we compare two hebrew string in MySQL database? I tried and search a lot on net but still could not found the answer. My website is dealing with Hebrew(main) and English as well. So please let me know How can I … |
| | Dear Friends, I want help to generate [url]www.bestuff.com[/url] like paging in my application because my client want same thing and in today's era this thing is found everywhere. I searched a lot but still could not found help. Here I am providing link to that paging so that you can … |
 | Hey guys, i have looked all over the web on how to upload a file to MySQL database and retrieve using coldfusion. I know i can do it in PHP, but im not using that anymore. Is there a script or some place that someone can point me so i … |
| | I need to do project about online banking. so i was told i need to learn php n mysql. I dont have access to any tutor coz its a distance program course. I know php.net website. and mysql.com. I am assuming i just need these two sites and a book … |
| | Could anyone help and advise me on how to create a new sql database and then connect it to my html webpage. I would like to have a search window on my webpage with text search by Languages, Country or Services so as when a customer enters for example "french" … |
| | I have created a very basic database in 'MySQL Workbench' just as a test.. This is the SQL it produced - [CODE]CREATE TABLE IF NOT EXISTS `CustomerOrder` ( `OrderID` INT NOT NULL AUTO_INCREMENT , `OrderDate` VARCHAR(45) NOT NULL , `ProductName` VARCHAR(70) NOT NULL , `ProductCost` VARCHAR(45) NOT NULL , PRIMARY … |
| | i found the way to store wave file in mysql database as blob format. But how to retrieve the wave file from the database and store it as audio Stream in c#? |
| | If I put this line [ICODE]$friends = $connection->get('followers/ids', array('screen_name' => '2020volt'));[/ICODE] Twitter api returns something like this : [CODE]Array ( [0] => 173605790 [1] => 187372244 [2] => 17535566 [3] => 190756198 [4] => 184577861 [5] => 119247538 [6] => 183813521 [7] => 18013082 [8] => 149601084 [9] => 186491393 … |
The End.