10,946 Topics
 | |
| | [CODE] <?php include("connect.php"); echo "<h1>Register</h1>"; $submit = $_POST['submit']; $name = strip_tags($_POST['name']); $email = strip_tags($_POST['email']); $password = strip_tags($_POST['password']); $confirmpassword = strip_tags($_POST['confirmpassword']); $level = 0; if ($submit) { $namecheck = mysql_query("SELECT email FROM users WHERE username='$username'"); $count = mysql_num_rows($namecheck); if ($count>0) { die("Email address is already taken!"); } else if ($email&&$password&&confirmpassword) { …  |
| | Nowadays i'm working very hardly on one prohect - mini social network with some advantages: You can generate tree style map ([url]http://goo.gl/ZP5yc[/url]) of all relationships of user. For example B, C, D are friends of A. On profile page of A when you click on "generate" button it shows A …  |
| | hello guys can any one let me known where to find database design template.i am confused in making of my design for the database. Thanks in Adavance  |
 | So I have a table containing various software and a table containing various features. Each software entry need to have a list of features. Here's where it gets tricky: In my application, I need to be able to select a software entry if it has all the features in a … |
| | in visual studio when we make a project in c# with backhand as sql........we can see the sql file and we have to locate it in the corresponding place and specify that location........but in netbeans when we make a project in java and backhand as mysql.....we cannot see where that … |
| | Hey guys, What are your opinions on rating systems in this case? I have users submitting ideas. Now other users can rate an idea UP or DOWN. I want to keep track of what user rates what idea, up or down, and want to be able to display this information …  |
| | Hey, I started learning PHP programming. I wrote this script to update a user's password from the mySQL database, but it's isn't doing so The script is :- [CODE]<?php include("header.html"); include("nav.html"); include("sidebars.html"); ?> <div id="content"> <?php $errors=array(); if(empty($_POST['uname'])) { $errors[]="You forgot to enter your username"; } else { $uname=$_POST['uname']; } … |
| | Hello all, I have searched this forum to find the answer to my question however none of the answers seem relevant so here we go: I am building a member service however when coding the login.php script, I keep coming across this error: [QUOTE]Warning: mysql_num_rows() expects parameter 1 to be … |
| | Hi I am trying to implement a world cup 2010 database, but can't seem to find the best table structure. At the moment I have the following: Team TeadName PK group A with fixtures group B with fixtures group C with fixtures group D with fixtures group E with fixtures … |
| | this query was too hard for me write. so any help is greatly appreciated i have three table , a_device, b_devices and a_app under a_device i have the columns: hostname app_name under b_device i have the columns: hostname cpu_avg mem_avg under c_app i have the columns: app_name department_name I want … |
| | 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 … |
| | 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 … |
| | 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 … |
| | 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 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 … |
| | 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 …  |
| | 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 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 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. |
| | 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 … |
| | 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 … |
| | 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 … |
| | Hey guys.. going crazy over this :'( This is my form [CODE] echo "<form action='addwebsitekeywordsscript.php' method='post'>"; echo "<input type='hidden' value='" . $currentwebsite . "' name='id' /><br />"; echo "<div class='kywrdformcontnr'><div class='kywrdform'>מילת מפתח:</div> <input type='text' name='keyword[]' class='kywrd1' /></div>"; echo "<div class='kywrdformcontnr'><div class='kywrdform'>חיפושים:</div> <input type='text' name='keywordSearch[]' class='kywrdsrc1' /></div>"; echo "<div class='kywrdformcontnr'><div class='kywrdform'>שפה:</div> … |
| | |
| | My code: [CODE] from MySQLdb import * sql_q = '("6 bandicoot crescent doolandella brisbane qld","inala","3","7"),("inala brisbane","forest lake brisbane","3","9")' connection = connect(host = 'localhost', user = 'python', passwd = '******', port = 3306, db = 'logbook') cursor = connection.cursor() cursor.execute('INSERT INTO log VALUES' + sql_q) cursor.commit() [/CODE] I seem to get … |
| | Hello all, I have a database which has 10 tables. Each table has an id, a title and a date. Now i'm having difficulty finding the best way to extract the [B]latest date[/B] from each unique table, while also doing a count(*) attribute to show how many rows I have … |
| | hi everyone i have a problem how to connect sql database with html and must display the columns and rows of the database to html template... |
 | Hello everybody, So this week I am coming up with two questions, they are probably silly questions but I have googled and come up with nothing. [B]1)[/B]Figured out number 1 by myself, accidently had a / where it wasn't supposed to be. [B]2)[/B]This one I have not tried to hard … |
| | Hi, Although I'm not really a novice when talking about web development, I'm not really used to writing MySQL queries that are a bit more advanced than the absolute basic SELECT/INSERT/UPDATE/DELETE queries. Anyway, currently I started working on a project that shows relevant items to the user: A 'you might … |
 | I need a simple solution I have invoice that i want to always diplay 10 rows, but if there is data in mysql it must first put those rows with data in on the invoice then subtract the number of rows and the difference will be the blank rows it … |
| | [B]Hi... I have a table named empl with following fields(eid,ename,esal) I had inserted the following records to empl table 1 Govind Raj 20000 2 GovindRaj 600000 3 Govindraj 10000 4 govindraj 50000 5 Govind.Raj 50000 6 Govind-Raj 20000 7 Govind_raj 2000 8 Govind.raj.3000 9 govind,raj. 4000 10 Govind'raj 6000 11 … |
| | how to connect mysql databse into html and must display the rows and columns of the database to html template  |
| | Hi everyone! I have a problem updating my table named 'friend'. This is where I save my friend requests and updates it when a user accepts the request. My problem is when I accept a request, only one query updates. Separately, they work. But when I try to use the … |
| | I have a html form on another page that is automatically filled from data from the table. I then run the the following script on submit to update the row if any information is changed. Here is the code [CODE] <?php $db=mysql_connect ("connection info") or die ('I cannot connect to … |
 | Hello! I want to create a script which mails emails to subscribers. I'm almost done, but I'd like it to say "Sent to # people". I've tried using: [CODE]<?php $dbc = mysqli_connect('localhost', 'username', 'password', 'database') or die('Error: Could not connect to database'); $query = mysql_query("SELECT * FROM table"); $number = … |
 | Hey Guys, I have an "events" table in my DB and a "default_events" table also. Every day I display one event. I check to see if any rows in the "events" table match todays date and then display that event, if no events match by date, I check the "default_events" … |
The End.