10,940 Topics
 | |
| | 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> … |
The End.