11,093 Topics
 | |
| | Hello, My problem stems from reading an image from the local disk and displaying it. There's a middle step of storing it in a database, but I simplified the problem into this test script that replicates the error: The image "http://example.com/test.php" cannot be displayed, because it contains errors. test.php looks … |
| | |
| | inside my database, there is a table name january such as: id | code | 1 | 2 | 3 | 4 2 | 0000 | X | X | O | O when i access the data using PHP and parse it into an array e.g. $array1, It became: … |
| | Hi I have a problem with the mysql query that uses both order by and limit.Following is the sql query i'm using, select * from temp where venue <> '' and cat1 = 'sports' and id < 74528 order by id desc limit 10; in this temp table 'id' is … |
| | I'm hosting on NetworkSolutions (which has PHP 5.2.17) and every time I make a prepared statement it returns the error "Incorrect arguments to mysql_stmt_execute" D: Can you help me spot the error in my code please? D: [code] <?php $mysqli=new mysqli(host, username, password, db); $query="INSERT INTO `Variables` VALUES (?, ?)"; … |
| | hi, i have some variable defined in a php file. for example: DEFINE( '_clientass', 'Cliente' ); so when i do a echo of _clientass they return Cliente now i want call _clientass from a mysql row and return Cliente If i do this: $row['variable'] he return _clientass but i want …  |
| | Ive used date() before but I do not remember how to store it in mysql. VARCHAR, TEXT, TIMESTAMP?  |
| | Hi, I need help with PHP/javascript/mysql I am fairly new to this so excuse me for my bad programming skills. I have PHP page which has to update mysql table and HTML table onclick. It updates HTML table ok but as soon as I refresh page it updates all data …  |
| | hi all, i am using temporary table to store ids,from this i am calculating the records count,it is working fine and i am getting the result.The problem is i am getting warning that temporary table does not exists |
| | Hi Guys, I am having few issues testing a software for which I have to develop a front end GUI. Basically, the previous person failed to document on how to run the system and left all the pleasure for me :D Anyhow, the system basically is a web crawler and … |
 | Hi. I'm not sure if this is possible or not, but I need to be able to SELECT * FROM all the tables in the database. Is this possible? Thanks! |
| | Hi All... I'm wondering if an extra pair of eyes can find a problem with this trigger: [CODE] DELIMITER // CREATE TRIGGER `auto_approval` BEFORE UPDATE ON `my_table` FOR EACH ROW BEGIN SELECT security INTO user_sec FROM users WHERE userid=NEW.userid; IF user_sec >= 10 THEN set NEW.admin = 1; IF NEW.admin … |
| | [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> … |
| | Not sure if I should out this here or in the php forum, I have a question that's probably gonna include both SQL and php... I'd like to add an image field to a table I have but I've never stored images in an SQL database before and I'm not … |
The End.