10,946 Topics
 | |
| | Hey, I'm having a problem executing the following code: [CODE] <?php session_start(); require('connect.php'); if($_POST['username'])){ $name=$_POST['username']; $checkUsername = mysql_query("select * from users where UserName='$name'"); if(mysql_num_rows($checkUsername){ echo 'Logged in successfully!'; $_SESSION['username'] = $name; } else{ echo 'The username or password you've entered is not valid!'; } } ?> [/CODE] |
| | how to create binary tree method in mysql  |
 | Hi All, I am new to the site, and also to PHP and MySQL, so please go easy on me for asking what may be an obvious question for many. I am wanting to store the data from a sign-up form in a MySQL DB, but I cannot get my …  |
| | Please can someone tell me what are things that I should add to my database, do I add my website pages to my database too ?,please I am sorry for this question I don’t know anything.  |
 | Hi All experts, I am facing problem with mysql view. I have migrated my database from oracle to mysql qith views, View on Mysql is created , but when i try to execute query it takes a long timw , some times it time qout server connection, Any body help … |
| | Hello , I would like to enquire if how could I put MYSQL Row to a TextBox ? Here is my code [CODE]Private Sub Form1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load MySqlConnection = New MySqlConnection MySqlConnection.ConnectionString = "server=localhost;Port=3306; user id =root; password=****; database=visualbasic" MySqlConnection.Open() Dim Myadapter As … |
| | i have this code to create a contact directory and my instructor wants me to create a function for database connect to minimize the coding and if an instance to change the server it is easy to change. <?php if(isset ($_POST ["add"])){ $name = $_POST['name']; $address = $_POST['address']; $email = …  |
| | i am building a simple online portal and i have done all the login ,registration pages and all the fields successfully get uploaded in the database but now all i got is a product display page and an shopping cart 1. i want help is how do i pass the … |
 | After updating mysql from 4 to 5, I'm now getting this error: [CODE]Invalid SQL: SELECT HRS.Hrs AS Val, HRS.Job_ID, TS.Staff_ID, Staff.First_name, Staff.Last_name FROM Timesheets AS TS, Timesheet_hrs AS HRS LEFT OUTER JOIN Staff ON (TS.Staff_ID=Staff.ID) WHERE TS.ID=HRS.Timesheet_ID ORDER BY Staff.First_name, Staff.Last_name, HRS.Job_ID DESC: 1054 (Unknown column 'TS.Staff_ID' in 'on clause')[/CODE] … |
| | Have 2 tables - one for new titles and the other for authors. I want to tag the "new titles" table with the "author" value if the author's name appears in list of new titles. As you can see from my code, I don't have a clue what is wrong …  |
| | I've been trying to test out my first website on the following free hosting service for the moment: [url]http://members.000webhost.com/cpanel.php?accountID=6800891&login_hash=xakt1MTI3NQX1Q1z[/url] and it seems that the mysql connection isnt working. I get the following errors... [CODE] Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'Myname'@'10.1.1.34' (using password: YES) in /home/a3793016/public_html/reviews.php on line 35 … |
| | Hi i want to generate barcode for each bill. any one can help me. barcode will be alphanumeric(dynamic). |
| | Hi community, I have a problem with an application which makes use of a mysql database. I have a class which saves the fields of every record on the table. One of the columns is of type Datetime. Sometimes (!) I query this column and get results like with a … |
| | i have been looking everywhere for an answer to this and i still havent found one that works what i want to be able to do is display the details of the user that is logged in but instead it shows the whole database here is my code: [CODE=php]<?php require('authenticate.php'); … |
| | I have around 20 tables in my database. I want to count every row of every table using COUNT and get a total. I have tried doing a separate select statement for each table then using UNION but I cannot find a way to join the results to get just … |
| | Hey there I'd appreciate some help with variables please. I have a search function on a site I'm building and would like to have it so that a user can click on a search result to see more columns from that row on the db, if you see what I … |
 | I have this code for mysql, and in my table i have date entries in my date field from my date table ....i want to make use with between clause ...below is my sql statement..but it displays nothing even there are dates in between... SELECT * FROM date WHERE date … |
 | I have been so stupid to hit go at the bottom after I added a new user, deleting all users including root. I have re-installed xampp twice, tried to change the password via the xampp security, still with no success. xAmpp loads perfect on [url]http://localhost[/url], phpMyAdmin though shows the following … |
| | [ICODE]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 '-userfile WHERE id='642' AND userid='459'' at line 1[/ICODE] This is the code [ICODE] $query = "SELECT * FROM ue-userfile WHERE id='$imageid' AND userid='$userid'"; $result = … |
 | Hi ALL, I am writing a script to retreive entries from a DB. And then I loop through all the entries. Once I am done looping through all the result sets, I have to re-loop over them again. This is done in an infinite loop (Please don't ask why to …  |
| | Hi, I am trying to display images from my db with the following code.. [CODE] <?php include_once("scripts/connect.php"); if ($q == "All Images") { $sql = mysql_query("SELECT * FROM gallery"); $q = "All Images"; } else { $sql = mysql_query("SELECT * FROM gallery WHERE caption LIKE '%$q%'"); } $limit = 7; … |
| | Hello.. Everyone.. I am very new to PHP world.. I have got a lesson to Saving images in folder and paths to database.. I have tried a lot.. I have tried various websites but there has no complete solution! Will you provide me the proper code? |
 | Greetings all. First of all, let me say I am NOT asking for code, just to be pointed in the right direction. I’m a newbie in php and mysql and have been teaching myself what I could learn from online lessons and tutorials (mostly w3school.com). I have found plenty of … |
| | Hi, Actually I don't know if my question belongs in this topic or in the mysql topic. But I'm making a VB.net application with a mysql database and i have to make a trigger but I don't know where I have to use or implement it in my application. I … |
| | Dear All, I have read dateTime field into a string from mysql database and in my java I have another dateTime in string format and in same format as the mysql date time and would like to compare both to see which one is before? |
| | I need the dates in a specific range.And i want to get the result in java manipulating from a MySQL database.Now how can i do so. Suppose there are 3 days 17.08.2011,18.08.2011 and 19.08.2011 .I want the dates in the range 16.08.2011 to 18.08.2011 .So how can i manipulate it … |
| | Hi I create some tables in EasyPhp>>Phpmyadmin>>test(db name)>>((localhost)) and it works correctly with my designed page in dreamweaver but i wanna upload all of tables into the mysql db in cpanel So, the question is How can I move all of the tables with saving details to mysql db in …  |
| | Hi guys, I have a problem on getting the selected radio button and save it in the database. Here is my code: [CODE] <div id="container"> <div id="question1" style="display: inline;"> <p>Question 1</p> <ul> <li><input type="radio" name="q1" value="1" id="ans1" />Answer 1</li> <li><input type="radio" name="q2" value="2" id="ans1"/>Answer 2</li> <li><input type="radio" name="q3" value="3" id="ans1"/>Answer …  |
| | hi, please help in my project in visual studio 2008 and connecting it to mySQL, I'm going to create a simple identification system, can you please help me with the codes? (Form1 - Log-in, Log-out) Here's my project proposal, I need to identify an ID number and a password. Like … |
| | Hi, for some weeks now, i have been trying to develop an [B]attendance system with php and mysql. [/B] I HAVE LOOKED EVERYWHERE!! what i have done is this: user select date (calendar). date is processed in php page. if attendance has not been filled,then new attendance sheet is provided. … |
| | hello, i wrote some commands in notepad and saved it as .sql and i m running these commad at my sql by command- [COLOR="Red"]mysql>source C:\Program Files\MySQL\MySQL Server 5.0\bin\script.sql;[/COLOR] then its run.. but hat to do if i write it without giving whole path. i ren this command-- [COLOR="Red"]mysql> \. filename[/COLOR] … |
| | hi friends, i want to search the data from the mysql database in html form and display that searched data in html form...can u give script for this... |
| | Hello, I have a problem with update in MySql database. In a university system a student apply for what is called a petition then the admin signs it and adds a note. When the admin signs for the first time and enters his note it works. But when the student … |
| | In the below query,the "Account has been successfully approved" message dispayed. But in the database still approved_status remains '0'. [CODE] <?php $connect=mysql_connect('localhost','root',''); mysql_select_db('bank',$connect); if(isset($_POST['account_number'])) $account_number=$_POST['account_number']; else $account_number=''; $query = "UPDATE account_details SET approved_status='1' WHERE account_number='$account_number'"; $result= mysql_query($query) or die(mysql_error()); if ($result) { echo "Account has been successfully approved"; } ?> … |
| | Hi, I am creating a database for a car hiring service and would like to produce reports. I know these are simple to create in MS Access but i dont have the fainest idea if these are at all possible in MySQL. I have created tables and queries to which … |
| | hello there. i was just wondering.is it possible to get the text display of your div and place it in a variable? if so, how should i do it? i've been searching for a solution in this problem but i can't find anything.thanks in advance.  |
| | I am developing a project for a client with a single table in the database for users which includes information about each user, including a field for the userID of a user who referred them. What I need to do is query the "referrer" field of each user record and … |
| | I created a Javascript application that collects user data to calculate a moving quote. ([url]http://economymoving.net/get_an_online_moving_quote.php[/url]) When submitted, it inserts a new record into the database then it displays a personalized moving quote on a new page. The application also collects personal info (name, phone number, email, address, etc.) How can … |
| | hello guys...i have a class table in which there are two fields [B]class_id[/B] and [B]class_name[/B] and a student form in which there is a text field in which user will mention the student class and then hit add.this will retrieve class_id from class table instead of class name into student … |
| | I want to have a setup where users from hundreds of sites hosted elsewhere will all be pulling information from my one master database that I host. I don't want to allow them to make any changes to the databases, just pull information from it to display on their site. … |
| | hello friend...want to ask something after completing my [B]student form[/B] now i am up to [B]classes table[/B] so i make a table in DB which consist of two fields [B]'class_id'[/B] and [B]'class_name'[/B].[B]class_id [/B]is auto_incre.so i thought to add a field in the same [B]student form [/B]in which the user will … |
| | I have written a mysql database using PHP which uses a multi-field form to collect descriptive information about archaeological finds/features etc. Some of the fields are text or medium text in length. It is common when describing things to include references, which frequently now take the form of a url. … |
| | hello... i need help from you all.. i am still new in php.. i hope you all can help me.. i am desperate. i can't delete delete data(delete multiple row from mysql using check box). this is my coding.. the cooperation is greatly appreciated. i have 2 file this is … |
| | Hi every one, I have a problem in inserting database entry, suppose I have two paragraph entered in one richtextbox what I want is that When I hit save, every paragraph will be save as one database entry therefore my database will have two records.. This uses VB.net 2010. Please … |
| | Do anyone see what im doing wrong with the update query? i get this mysql_error message; 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 '-xxx WHERE id = '616' AND userid = '15'' … |
| | good morning. i am new still new in php. I need help from you all. why i cannot delete multiple rows from mysql with checkbox in my database... this is my coding.. <?php $host="localhost"; // Host name $username="root"; // Mysql username $password=""; // Mysql password $db_name="cek"; // Database name $tbl_name="del"; … |
| | hi,im using registration form for registering users to the new account.i have 2 tables in one database.database name is test and table name is student and member.in student table which contain the register no of student which is already stored in the database.in member table,it has 4 fields which is … |
| | This is my 2 tables. [B]account_details[/B] (account_number, nic, full_name, phone_number, address, gender, date_of_birth,__) [B]account[/B] (account_number, name_with_initials,account_type, fd_period,__) I want to select records in both the tables. This is my SQL line. [CODE] $query ="SELECT account_details. nic,full_name,phone_number,address,gender,date_of_birth,account.name_with_initials,account_type,fd_period". "FROM account_details,account". "WHERE account_details.account_number=account.account_number"; [/CODE] The following error occurs. You have an error in … |
| | Hi I get my data posted from another form.html page i receive it just fine and decode the json just fine, and the validation works just fine, the only problem is the part where i have to insert the values into the database.. any suggestions.. [CODE] <!DOCTYPE html> <html> <head> … |
| | hello..., [CODE]SELECT DISTINCT store_type FROM stores s1 WHERE NOT EXISTS ( SELECT * FROM cities WHERE NOT EXISTS ( SELECT * FROM cities_stores WHERE cities_stores.city = cities.city AND cities_stores.store_type = stores.store_type));[/CODE] please any one help me to understand this query... and what would be the output of this. and please …  |
The End.