[mysql] Forum Topics

Hi, Assume, I have table which consists of 5 values, say C:/Testing/test1/ C:/Testing/test1/test2/ C:/Testing/1/ C:/Testing/ C:/1/ I want to query the database table to get the values starts from 'C:/Testing/' and '/' as a escape character. ie, I want to get only two things, C:/Testing/test1/ C:/Testing/1/ Both starts with 'C:/Testing/' …

Im trying to retrieve information from a table; I give a date in the form of "yyyy-mm-dd" but in the table date is stored in date/timestamp formate. So while im comparing my inputted date with the table date, no match is found. is there any way to select only the …

I use Visual Basic 8.0 and MySQL 5.0 [COLOR="Green"]Articles are listed in table rental places in table stock if articles not exists in table stock[/COLOR] first check with article are not in listed stock table and wel in listed stock table rental select * from rental,stock where rental.Article<>stock.Article ; This …

Hello Everyone, I am new to PHP and am trying to create a login menu with different user levels. I have used a MYSQL Database and PHP. The database has Username, Password, Role. Role could be an admin, lecturer or student. I need each user to login to their respective …

I use Visual Basic 8.0 and MySQL 5.0 select * from rental,stock where rental.Article=stock.Article ; This gives the following result: stock.article stock.stock rental.article rental.rent 1000 100 1000 15 2000 150 2000 25 Update stock set stock.stock=stock.stock-rental.rent where rental.Article=stock.Article ; This gives the following result: [COLOR="Red"]Unknown column rental.Article lin 'where clause' …

how to do this? like ive seen some HARSH codes with things i dont understand in themm like information.schema and datetime whats the simple way to add a column to a table if it doesnt exist? and what the heck how to not add it if it already exists ? …

I have Visual Basic 8.0 + MySQL 5.0 I have two tables: Table1 ([COLOR="Red"] Rental[/COLOR]) {Article rents may be on different days} Articlelnb Artikelrents Daterent 1000 15 1 nov 2009 5000 12 1 nov 2009 3000 10 1 nov 2009 1000 10 2 nov 2009 5000 5 2 nov 2009 …

Hi I have to build the like of a commercial website for my project and all was going well until I had to try to insert images in a SQL database ; I tried to modify some code that I found online but it is not working. The idea is …

OK! This will probably reveal my IQ , but here goes. I am new to PHP and MySQL--I am learning from a ton of books--and I am struggling with many-to-many relationships. All of the books make a lot of assumptions. I get the concept just not the mechanics. Say I …

i dont understand, because i use mysql num rows and stuff someone on some other webbysite says u have to use lock tables so if someone else changes the table while the script is running then they cant if u lock the tables. but i dont understand anyone know how …

hi.. i'll ask some question regarding my system login part.. This is my databasae connection.. [CODE] <? include("constants.php"); class MySQLDB { var $connection; //The MySQL database connection function MySQLDB(){ /* Make connection to database */ $this->connection = mysql_connect(DB_SERVER, DB_USER, DB_PASS) or die(mysql_error()); mysql_select_db(DB_NAME, $this->connection) or die(mysql_error()); function confirmUserPass($username, $password){ /* …

Hello guys I am a freelance web designer. I work with the following technologies..... PHP, MySQL, ASP, ASP.NET, SQL Server 2000. Doing research in Web Technologies... most of it related to security. Hoping to give and receive knowledge from all of you. Take Care. Regards Praveen Balla

Hi All I'm new to this forum and i would be really greatful if I could get some help! Someone I know has his own tuition school and I must develop a website for him and I dont know lot about anythng to be honest. Not a great programmer or …

this part of php that connected with db [CODE]$q2="select *from emp order by id"; $r2=mysql_query($q2)or dai("query faild:"mysql_error()); while($x=mysql_fetch_array($r2) { if($x["depno"]==10)//[COLOR="Red"]dose it right to use $x=["depno"]like this when i use the query select* from the table??[/COLOR] { echo"<tr><td>$x["emloyeeno"]</td>"; echo"<td>$x["employee name"]</td>"; echo"<tr><td>$x["address"]</td>"; echo"<td>$x["salary"]</td>"; $sum=$sum+$x["salary"]; } }[/CODE]

Hi i just have problem in my software i just want to apply more then one condition in my quary which is joined "and" operator plese helpe me by given an example(coding) it is very urgent

I have Visual Basic 8.0 and Use Mysql 5.0 Database Table Test: Field type ID Integer (PRIMARY KEY) Name Char(10) Adress Char(15) City Char(15) ID Name Adress City 1 Andre Street 1 New York 2 John Street 2 Amsterdam 3. Joyce Street 3 Londen I have create a index on …

I want insert some rows into mysql, each row shold be like this: [code] <input name="code[]" value="{code item dari data mysql}" /> <input name="name[]" value="{nama dari data mysql}" /> <input name="hrg[]" value="{harga dr mysql}" /> <input name="qty[]" value="{qty diinput sendiri}" /> <input name="subt[]" value="{autocalculated saat mengisi qty}" /> [/code] The …

Does anyone has "Leave Application Format" where leave is categorised into SICK & EARN LEAVE, here one needs to enter information into mysql throught PHP and retrive it. I have few queries, how do I take care of following - (1) If any public holidays comes between SL or EL …

Hello, I am using GridViewand bounding values from 2 tables. tbl_login and tbl_register. In tbl_register Table the Field is UserName In tbl_login Table the Field is Active(yes/no field) I used this command to show the fields into the gridview. [CODE] SELECT tbl_createuser.UserName, tbl_createuser.Role, tbl_login.Active FROM (tbl_createuser INNER JOIN tbl_login ON …

HI folks, pardon my ingorance, but is there a possible way to connect to ms sql express directly to the server or you have to copy the .mdf file to your project and then connect to? another question how do you connect to the ms sql express? (I come from …

Hi everyone. So I get the code going now the question is: How to make a menu in Java code? For example: 1.create table 2.insert into table 3.select fro table 4.delete table... Which will you choose: ex.1 and creates table I mean like switch case in C++ [code] import java.sql.*; …

I've got a simple PHP page with a list of events that are taking place at certain times on certain days, and this is my code: [CODE] <? //connect to mysql //change user and password to your mySQL name and password mysql_connect("localhost","root","PASSWORD"); //select which database you want to edit mysql_select_db("events"); …

Hello friends, I have a very minor error, but i am not able to figure out which one is that. I have a simple form page and it goes to the another page and insert the values in database. But the thing is it inserts multiple rows in the database. …

I got my database table named as section_master with attributes id, section, sectiontype. I have 3 radio buttons in sectiontype as office chamber residence I have created a select list for section. When i wish to choose the radio button office. i want to show only those sections in the …

Hello, I am designing School Management System. I dont know how to design database for this. My Application contains 5 parts. Student Teacher Parent Data Entry Admin I need to maintain the following records. And these are not fields and i need all these for the particular page. Register (UserName,Password,SecurityQuestion,SecurityAnswer …

The title is pretty self-explanatory. I'm working on a PHP engine, and I'm trying to implement a SQL query generator. The hardest part of this will be designing the system for using the SELECT command. Are there any practices that I should try to follow when designing this, or any …

for weeks its working fine but this time i dont know what happened after i tried to use hibernate to insert data in my database and decide to delete hibernate and use my old sql query my table model become messy if i insert a 1 row data its fine …

Hello, So lately, I've been coming across this issue of mine and can't seem to find a solid way around this problem. My problem is due to the fact I'm using MYSQL C connector library. And, Attempting to gain all the Row's from my database and store them in a …

Hi, I have a web site. On index.php I have a HTML link to admin/admincp.php By simply adding a htaccess file to the directory 'admin', will the admin directory and it's contents be fully protected? I only want it to be possible for me to access mysite.com/admin/admincp.php, because I am …

The name of this question is jsf_dao_interface Hello and Thank you in advance for any assistance. [B] System info: [/B] netbeans,glassfish,MySQL [B] The Purpose of this post is: [/B] I am trying to learn to use an interface. I was wondering if someone was familiar with using and or had …

i am using the following JQuery function to successfully POST data to the user_submit.php file, its just that the php file is unable to receive the data. [CODE] $(function() { $("#submit_js").click(function() { $.post("user_submit.php", { comment: $("#comment").val() }); }); });[/CODE] upon finishing the Firebug consoloe shows this: [CODE]<html> <body> Your vote …

Hi, If you are a Joomla user and forgot your Administrator password then don’t think of re-installation. There is an easy way to change your Administrator Password. To get your password recovered you will need following things. Access to PhpAdmin If you are Cpanel user you will find the link …

[CODE=php]<strong><p align="center">Air Conditioner Data Update</p></strong><br> <?php $host="localhost"; // Host name $username="root"; // Mysql username $password=""; // Mysql password $db_name="onm"; // Database name $tbl_name="sims_ac"; // Table name // Connect to server and select databse. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); $a=$_REQUEST['a']; //Its getting value from previoes page echo …

please help me with some codes to update about thousand record in the database.i.e. changing all one to two and moving all threes to a different table in the database. 2.Also a code to select all in a listbox

Hey guys I'm having a bit of a problem with a database application i'm trying to design for organizing information from a non profit childrens hockey organization i'm with. Right now my problem is with 3 tables. I've got the application querying a list of games. And now i need …

i have 2 database & need some code to solve this problem. table 1 (food_place) : fp_id | fp_name 1 | McD 2 | Burger King 3 | Pizza Hut -------------------------------------------- table 2 (promo) : p_id | p_name | p_pid 1 | Disc.10% | 1 2 | Free f. fries …

This code is not getting values when I press update. Its showing the values from Db in fields. But at the time of update whrere I SET Values it gets null values. I am using name of input as acmake[] and then using for loop but its not working. [CODE=php]<strong>Update …

I need a code for log-in which will be stored as attendance for students... I am a student and i have tried so many codes but it doesn't work... i am using a mysql server for my database is it ok?

Hello... I'm trying to connect the data that is enter in a textbox to an mysql database table, can someone let me know how to do it in visual web developer 2008, and if is not necessary to write the code, just with some of the options on the toolbox.... …

I made little javascript bbcode editor on my website. How to display that code from mysql? Or how to save in mysql as html that code?

CREATE TABLE message ( id bigint(20) DEFAULT '0' NOT NULL, inReplyToID bigint(20) DEFAULT '0' NOT NULL, createMonth int(11) DEFAULT '0' NOT NULL, createDay int(11) DEFAULT '0' NOT NULL, createYear int(11) DEFAULT '0' NOT NULL, boardID bigint(20) DEFAULT '0' NOT NULL, subject varchar(80) DEFAULT '' NOT NULL, authorEmail varchar(80) DEFAULT '' …

hi 2 all , i have a problem in search according time period, my table name "stats" have field id(int), ip(var char), counter(int),add_date(date time) now i want a search on following ways 1. i want to show sum of counter according weekly >>>means weekly stats of counter 2. i want …

Private Sub Command1_Click() Dim a As New FileSystemObject a.CreateTextFile "D:\Documents and Settings\nithya.s\Desktop\Medius.txt" a.OpenTextFile "D:\Documents and Settings\nithya.s\Desktop\Medius.txt", ForWriting, True Dim b As TextStream Set b = a.OpenTextFile("D:\Documents and Settings\nithya.s\Desktop\Medius.txt", ForWriting, True) b.WriteLine "Nithya,324,Raman,330,Sai,314,Raja,357,Balaji,349,Anand,336,Sasirekha,335,Shivakumar,751,Senthil,733,Sampath,735,Kalyani,395,Ganesh,313,Mahu,304,Thiru,303,Zuhaib,339" b.Close a.OpenTextFile "D:\Documents and Settings\nithya.s\Desktop\Medius.txt" Set b = a.OpenTextFile("D:\Documents and Settings\nithya.s\Desktop\Medius.txt", ForReading, True) Text1.Text = b.ReadLine End Sub …

Hello all, Not sure if this is the proper forum for this but first: I am using Visual Studio 2008 and MySQL Server Version 5.1.42 and Client Version 5.1.11 programming language C# issue: save button from windows form for record editing using databindings and textboxes... is there a way to …

Hello guys. I am looking for a report/statistics generator for mysql. Basically i want a tool that can connect to a sql database and use columns in different tables to generate graphs, charts etc. It would be good if it has support for timestamps. Is there a tool like this …

I have a mysql db with 3 tables (this is supposed to be a db for a dvd rental store) 1) MOVIE PK MovieID Title Type Year Producer 2) CLIENT PK ClientID Name Address City 3) RENT PK RentID Date FK MovieID FK ClientID Cost The exercise told us we …

This is my code: [CODE] <?php //connect to mysql //change user and password to your mySQL name and password mysql_connect("localhost","root","PASSWORDREMOVED"); //select which database you want to edit mysql_select_db("tvguide"); //select the table $result = mysql_query("select * from epair LIMIT 20;"); //grab all the content while($r=mysql_fetch_array($result)) { //the format is $variable = …

i write query like select * from pm_task_user_work LEFT JOIN pm_task_allotment ON pm_task_allotment.task_allotment_id=pm_task_user_work.task_allotment_id where pm_task_user_work.project_id='19' and (Select str_to_date(pm_task_user_work.task_user_work_link_time,'%Y-%m-%d') as MyDate from pm_task_user_work) BETWEEN '2009-12-15' AND '2009-12-15' order by pm_task_user_work.project_module_id,pm_task_user_work.task_user_work_link_follow It gives me Subquery returns more than 1 row ------------ 2> SELECT pm_task_user_work . * , str_to_date( pm_task_user_work.task_user_work_link_time, '%Y-%m-%d' ) AS …

Undefined Variable record: (in a path)/filename.php $sql= "select * from demo table"; $handler=mysql_query($sql); while($data=mysql_fetch_assoc($handler)){ $record[]=$data } <?php for($i=0;$i<count($record);$i++) ?>

Hello, I am trying to compare a MySQL date to a user entered date in Perl. Basically, [code] while ( my @data = $sth->fetchrow_array() ) { print($data->{'day'}); if($data->{'day'} eq $userdate) { $conflict = 1; break; } } [/code] Being Perl code, I wasn't sure if posting in databases was inappropriate. …