18,960 Topics
OK, I admit I am completely clueless on how to perform this one. In one table I have a list zip codes and the user will select one or more from this list. Once I have those zip codes, I need to perform my query and this is where it …
I am in desperate need of some guidance here. Any suggestions or ideas would be very much appreciated! Is it possible to have a relationship based on two columns? For example: The table "Parents" has columns: ParentID (PK) The table "Children" has columns: ChildID (PK) ParentID The table "Addresses" has …
Hello. I have a simply php script for my school project that checks books back into a library database. What I was trying to accomplish was when you checked in the book for it to check and see if the book has been requested and notify the librarian that there …
Hey guys, As you can see below I am trying to add row of data to a table called tblOut. When i execute the code, it works without a single error message but the problem is I dont see any new record when i preview my table data. Can anyone …
I am trying to upload few texts and the image using the code But its showing error have a look at the two codes... [CODE]<body> <center> <h2>Add News</h2> <form name="news_registration" action="addnews_process.php" method="post" enctype="multipart/form-data"> <table width="600" border="0" align="center"> <tr> <td width="49%" align="left">News Type</td> <td width="3%"> </td> <td width="48%" align="right"><select name="category" id="category"> <?php …
Hi all. I am new user here and I found a lot of usefull info in this board. What I am curious to learn is how can I update a record in MySQL and in the same time to Insert a new record in another table. For example, I have …
So I need to make a table where all the records in my ACCESS database will reflect. The table should be editable. the table should have the basic functionalities such as ADD, EDIT and DELETE. I also need to make a search where a user can type what he/she wants …
i got this error to on my database "Host 'localhost' is not allowed to connect to this MySQL server" and when i tried to use mysql workbench i got this "cannot connect to the database server" what is wrong with my database, its the second time happen to me. yesterday …
i want to update my sql field but i can't.if any one write this part for me i will be thankful. in this parrt i recieve the id of user and if it br in the sql i recieve the inforetion and update his/her information in the sql. my sqlconnection …
I am having an issue creating a stored procedure but I keep getting an error "Error Code : 1064 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 'CREATE PROCEDURE sp_Insert_Address ( in p_UserID …
i m using gettext() method in getting text from the form and pass it to the sql query to record in the mysql database. when i don't enter any string for textfield (for eg: phone no.) , i get sql exception error.. here is my sql query in the code.. …
Hi, I have some difficulty with my 'select' In my select/menu, I display all the options come from a table (table_db_email) in my database In this table ([B]tb_code_prmtn11_email[/B]) I have two field : [B]fld_email_id fld_name_email[/B] It works here is a code [CODE]<select name="email_adress_menu" id="email_adress_menu" class="valid" onchange="submit()"> <?php echo "<option selected=\"selected\" …
Hi all! I'm a new to PHP and I embarked on a making a small store. One part of this involves making a form to add new products, and tables for categories. But I am getting this error: Parse error: syntax error, unexpected T_VARIABLE, expecting ',' or ';' on line …
Hi friends am trying to develop a software that can store biometric input like a finger print to my Sql server using c# how can i do this. thank you in advance
Hello all, I've been trying to get metasploit working on my mac for a couple of days and I just keep getting this error:"Error while running command db_connect: Failed to connect to the database: Unknown MySQL server host '0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.1' (1)" and then is says "call stack" and gives me a …
hi my friends. i have a problem with my VB 2010 ultimate. when i was create my project i cant to create it. i start to confuse. why i cant to create project from my vb. after that problem i unninstall vb 2010 ultimate. after i unninstal. i want to …
Hello everybody, So this might seem like a really simple thing to some of you more advanced people but it has me extremely stumped, currently I am trying to create a menu. What I have is a mySQL database with a row called page_name I have written the following code: …
Hi, I have a table with 2 date fields startdate and enddate. A program have a start date and an end date like this 01/01/2011-25/03/2011 . Now I want to test any date and get the program it belongs to. Say for the above, 12/01/2011 would return the above program. …
Order Confirmation Thank you for your order! 84,46,62,84 Your Credit Card informations: Credit Card type: 0 Credit Card number: 2147483647 Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\wamp\www\baby\checkout.php on line 16 Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:\wamp\www\baby\checkout.php …
Hey all, I'm looking for a way to insert values from one table from another in a pretty straightforward way, I just can't get the syntax... If table 1 has fields A,B, and C, and table 2 has 20 fields... I want to insert into: A a value that I …
[CODE]-- phpMyAdmin SQL Dump -- version 3.2.4 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jun 22, 2011 at 08:44 AM -- Server version: 5.1.41 -- PHP Version: 5.3.1 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- …
HI , i have a little problemn. I have to tables codMP and Content.Display like this. codMP name In 1 x ? - 20 - here i want to sum the column from the second table where codMP = with what is in the column codMP. The same for the …
hey guys, first time on this forum so sorry if i make mistakes .. My problem is .. I have done a final year project for a local pizza shop. It has some basic functions such as customer registration, shopping catalogue and ordering online. The website is linked to a …
Hi, I jaust want to convert the example in the link below, for filtering and paging with gridview, in order to use in my page. The example uses SQL with noorthwind database. I think Visual Studio does not suppport mySql fuly, I already download MYSQL driver do I also need …
hi,i need to developed a database for criminals and i have all the basics of developing a database but my problem is that i dont know how to build relational databases. i will be glad if someone helps me with relational database notes (prefarabliy free online links notes). kindly help.
I made two scripts register.php and register1.php, the register.php takes the values and register1.php process them and stores them into a mysql database. after i fill in the form and press submit, I get an error. I am using mySQL 5.5.8 Register.php [CODE]<?php include("header.html"); include("nav.html"); include("sidebars.html"); ?> <html> <form action="register1.php" …
hi all..i am new to this sql thing..i am tryin to install it on win xp .but after i enter current and new password and then press execute button , the installer stops responding before starting the service .the two operation 1.)prepare configuration and 2.)write configuration file are done..after that …
Hi there, I am starting the final year of my BSc Honurs Computing degree in September and I am currently on my work placement doing programming. The company I work for holds many events and always require websites for these events so.. Talking to my Lecturers I had suggested to …
Hi guys! please tell me - where is error here - [ICODE]select `OWNER.OWNER_ID`, `Previous_owner.GDATE` from `Previous_owner` left join `OWNER` on `Previous_owner.OWNER_ID`=`OWNER.OWNER_ID` left join `AVTO` on `Previous_owner.OWNER_ID`=`AVTO.OWNER_ID` where `AVTO.AVTO_ID` = 3[/ICODE] phpmyadmin shows error - [QUOTE]#1054 - Unknown column 'OWNER.OWNER_ID' in 'field list' [/QUOTE] the db structire is = [CODE]create table …
SQL is my "weak" part, however I can handle it. I was wondering if there are alternative ways of writing my queries below. Any alternative is welcome, it's a way to learn more. I have the expected/correct results on all of them. **Shows which shops have the product code 1234 …
hi every one my problem is is to convert id column values as comma separated ex: id 1 2 3 4 5 6 i want result set as string "1,2,3,4,5,6,7....."
[ICODE] mysqldump -u root -p pass**** coke_pos > testbc.sql [/ICODE] i tried this command to generate back-up of my database but i got an error about, eroor in my syntax i have mysql 5.5.11 community server and i am using mysql workbench 5.2, i am using windows 7 please help …
Hi, I'm new here, seems like a nice forum so I'm gonna start. I need to make table which gets info from mysql sortable. Now, I have idea to make it with switch and case's but thing that gives me problem is two $_GET's in address. What I mean is …
Hi, i'm having the following problem. i have a list of products and each product has different items attached to them for example(it's all about wines) [CODE]id prodid text bedrag 35 1 1 fles kist Prosecco Tallero 14,95 36 1 2 fles kist Prosecco Tallero 26,95 1 10 1x Fles …
Hi Friends I Want Exact Connection String For MySQL With ASP .NET. I have Facing This Error : No Such Host Name if Known. Thanks.
Hello all, Think I am going mad I want to do a simple update and get a parse order at line 1. 1: UPDATE ir312 // the table name 2: SET 3: R3_21 = $tot // R3_21 is the field name, $ tot is an amount 4: WHERE irdnumber=$irdnumber The …
Hi All, As the title says. Have been looking for solution these past 2 days, Salary Record are pulled from database (MySql) in to PHP table (do/while loop). - Name , Salary , OvertimePay , Subtotal , MedicalDeduct , UnionFeeDeduct , Tax , Grand Total - Peter , 1300 , …
Dear All, I have run this query SELECT (3958*3.1415926*SQRT((2.20569-3.13900)*(2.20569-3.13900)+COS(2.20569/57.29578)*COS(3.13900/57.29578)*(102.25616-101.68686)*(102.25616-101.68686))/180); and it gives a value of 75.49810.... The problem is that the first city (2.20569,102.25616) and second city (3.13900,101.68686) is hundred plus kilometers far apart. Can any one verify what is wrong here?
Hey guys.. i have been having trouble with this script: [CODE] $con = mysql_connect("localhost","XXXXXXXXX","XXXXXXXX"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("XXXXXXX", $con); echo "<table class='viewuserprofiles'>"; echo "<tr>"; echo "<td>שם האתר</td><td>סוג</td><td>קישור</td><td>משתמש</td><td>סיסמה</td><td>תיאור</td>"; $query = "SELECT * FROM ProfilesWebsites, ProfilesAccounts ". "FROM ProfilesWebsites LEFT JOIN ProfilesAccounts ". "ON ProfilesWebsites.ProfileWebsiteName …
I dont know why this code will not show any data from the mysql......................... [CODE]$query = "SELECT * FROM g_attack WHERE winner ='$username' ORDER BY created ASC LIMIT 10"; $row = mysql_query($query) or die("Could not connect to db"); while ( $result = mysql_fetch_assoc($row)) { $created = $row['created']; $looser = $row['looser']; …
Hello, this error has been torturing me for an hour... [I]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 ''lock'='0' where pmID='206'' at line 1[/I] This is the code: [CODE] else { print "Žinutė …
Here's my code and I am getting an error undefined variable, this code submits the information submitted by the user to a mysql database. [CODE]<?php include("header.html"); include("nav.html"); include("sidebars.html"); ?> <?php $errors=array(); if(isset($_POST['submitted'])){ if(empty($_POST['fname'])){ $errors[]="You forgot to enter first name"; } else{ $fn=$_POST['fname']; } if(empty($_POST['lname'])){ $errors[]="You forgot to enter last name"; …
Hello community, can anyone provide me the answers please? I am not a MySQL guy, i know that this is not an excuse, but this is how it is. Thanks in advance. [CODE]Employee (**Employee ID**, Employee Name, Employee Last Name) Director (**Employee Code**) Cashier (**Employee Code**) Customer (**Code Card**, Customer …
Where can I get a free mysql thesaurus database? I would literally like to download a .sql file, and just upload it straight to my mysql host. I would just want in the thesaurus... Word Synonym #1 It would be great if it also had... Part of Speech Synonym #2 …
hi im working with two form the first form is to insert cheek box into db so the first code i write like this : [CODE]mysql_select_db("project", $con); if(count($orders)>0) { foreach($orders as $key=>$order) { $query="INSERT INTO orders (ORDER_DESC) VALUES ('".$order."' )"; mysql_query($query) or die ('Error Updating the Database' . mysql_errno()); } …
I have tried a lot for JDBC using mysql but none of them work.... Can anyone help me how to get this work.... [CODE] import java.sql.Connection; import java.sql.DriverManager; public class Main { public static void main(String[] argv) throws Exception { String driver = "com.mysql.jdbc.Driver"; String connection = "jdbc:mysql://localhost:3306/abc"; String user …
hello i am developing my uni project organiztion management system for hr organization hirarchy -organization1 can have its [CODE]--org1suborg1 --org1suborg2 ---org1suborg2suborg1[/CODE] -organization1 can have [CODE]-suborg1 department1 department1 department2 -employee in organization departments[/CODE] here is database so far [CODE] organaization (orgid,orgname,parentorgid) department (departid,orgid,departname,parentdepartid) employee (orgid,departid,employeeid,employeename) [/CODE] i want some one to …
hello guys i am working on DATABASE and teacher me to make header and sub header tables in it...i am not getting it that wot are header and sub headers
<?php // Inialize session session_start(); include('config.inc'); // Check, if username session is NOT set then this page will jump to login page if (!isset($_SESSION['username'])) { header('Location: index.php'); } ?> <html> <head> <title>Secured Page</title> </head> <body> <?php $result = mysql_query("SELECT user.password, data1.dob FROM user INNER JOIN data1 ON user.username = data1.username …
[B]Problem:[/B] I have a zip_code/city/state table that has full names and abbreviations for some common things like FT (FORT) and IS (ISLAND). So, I may have a record something like this: zip = '31522' city = '[COLOR="red"]IS [/COLOR]HARBOR POINTE' locationtext = 'Is Harbor Pointe' location = 'US-GA-[COLOR="red"]IS [/COLOR]HARBOR POINTE' and …
The End.