11,093 Topics
 | |
| | I need to restrict access to other table id's by making a check against an (id) of a table named users and then check that the (user_id) of another table is the same i.e table1 id username password table2 id somedata user_id if table1 id is the same as table2 … |
| | I have been searching for ways to do this but I was not able to find any. What I want to do is this: movie_genre (Table) movidId movieTitle movieGenre (Varchar) 1 Copying Beethoven (2006) Biography 2 Copying Beethoven (2006) Drama 3 Copying Beethoven (2006) Music movie_plot (Table) movieId movieTitle moviePlot … |
| | Hi there, Noob here sry. Mysql DB 1. How can i insert an H1 tag <h1>Listings</h1> to a table structure as field ? A functional H1 tag. 2. How can i insert or import a nationalities csv file to a table ? Thx a lot and happy new year!! |
| | I'm trying to run a date range query which works, but I also need to get data outside of the date range inside of the same query which I get to work. The issue I'm having is when the start date is in say 2011 and the end date is … |
| | I am a programmer and i use 64-bit windows 7 as my OS and i need a free localhost server i can work on my PHP and perl on. I also need it to have MySQL PHPmyAdmin. If anyone has any ideas, please let me know. Thanks :D  |
| | hi guys, thanks for viewing my thread. i have a program in java application and i want to connect to mysql database because i need to use database for a few parameter.the result will b showed in web-page using php. my question is how can i connect my program to … |
| | I am displaying data from an sql database in a textarea which will be altered by the user then re-submitted to the database. The problem is displaying a line break. I get <br /> displayed in the textarea rather than the newline. Can anyone help? |
| | Hi!, I have a contacts table in MySQL and I want output in a select menu. Problem is, some rows dont have any record in it, and it is displayed in very odd way as it outputs blank fields and some data in between. My overall code is: [CODE]<?PHP $query=mysql_query("SELECT …  |
| | Can anyone tell me if I am going in the wright direction with this, or if there is a better way, I am trying to create a session check so that if logged in clients change the url id number example.com?id=192 it won't show other clients contents. Its the first … |
| | I am getting this error, and dont know what I should do to fix this. Column 'uptime' in order clause is ambiguous uptime = date uploaded set to NOW My Query: $select = ("SELECT * FROM photo_album, video ORDER BY uptime DESC LIMIT 10"); Maybe I cannot call a query … |
| | I'm building a local database with VS.Net, using C#. I have constructed the database and filled it with data. I've already been through the process of connecting to the \bin copy of the Db and setting the file to "Do Not Copy". Now, I want to design Views in the … |
| | Hi, can anyone help with formatting a date range query in MySQL? It's just a form to enter two dates, and a second page to run the query and show the output. The form looks like so: [CODE]<form id="getdate" action="tracking_result.php" method="post"> <table> <tr> <td> <input type="radio" value="single" checked="checked" name="type"/> </td> … |
| | Hi folks. I'm currently looking at developing a client app in Python. I have a server app developed in C++ that captures wifi data and then my app connects to the server and grabs the data relating to the wifi access points and then inserts this into a MySQL DB. … |
| | I have a page that displays all movie of various cat. and i designed it to help people in my community click any old movie want to watch and it will send it through a URL parameter to the view video page. So any movie clicked is filtered on the … |
| | Hi everyone! Is there a way to set a MySQL server to not automatically start execution until prompted by the user? I recently installed a MySQL server on Windows and I'm having a little bit of problem at start up. Everytime I go to the command prompt to type the … |
| | [B]The Idea[/B] The idea is that my PHP page will execute specific SQL statements on a database depending on which form elements are filled in. Instead of having to write continuously lengthy IF statements to determine which statement to use, I would like to have the necessary statement "looked up". … |
| | Hello all, I am new to MYSQL programming, although i have been working with MSSQL for a while now. I am using delphi on a project and the query below does not return any results, just cant find what is wrong with it Select Airwaybill, SDate, BLAccount, RCountry, PackageCodeDesc, TotalWeight, … |
| | [CODE]<?php $host="xxxxx.xxxxxx.com"; // Host name $username="xxxxxx"; // Mysql username $password="xxxxx"; // Mysql password $db_name="xxxxxxxx"; // Database name $tbl_name="xxxxxx"; // Table name // Connect to server and select database. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); // get value of id that sent from address bar $id=$_GET['id']; // Retrieve … |
| | A. Write a java program to do the following 1. Read text files from Directory 2. Use the xml tags on the text files to i. determine field names ii. extract actual value 3.write details of i and ii above into a database (eg. mysql) table. B. i. Read the … |
| | How to retrieve a image stored in mysql using jsp.  |
| | I am having the hardest time trying to figure out what I am doing wrong with this section of code. Basically, I am using the GET method to pull a variable from the URL which I then want to search the database for. This "ticket" is unique and I only … |
| | Hello, I'm trying to skip a line every 'x' queries that gets displayed. I can get the records to show but I can not skip a line every 'x' query shown. I've tried using javascript and php but can not get it to work. Can someone plz help or give … |
| | when i put this in phpmyadmin i get errors... can anyone look over it and find a mistake.. [code]CREATE TABLE Student { SID int NOT NULL default, SNAME varchar(200) NOT NULL default, ADDRESS text NOT NULL default, POST_CODE varchar(10) NOT NULL default, PHOTO mediumblob NOT NULL default, Primary Key (SID) … |
| | Hi, I have three tables as below. tbl1 [CODE]eid qnt pb 12 3 1 13 1 1 23 3 1[/CODE] tbl2 [CODE]tid eid fx so 1 12 0 1 2 13 0 1 3 23 1 1 4 23 0 1[/CODE] tbl3 [CODE]tlid tid eid fx 1 1 12 0 … |
| | I have been trying to download the community server edition of MySQL for 2 days with no success. I was able to download the installer and found the ZIP archive (both downloaded and mirrored properly) which I was also able to download but I cannot for some reason open the … |
| | Hi Guys, I really don't not know where I'm going wrong with this. I am learning PHP. I have been able to input a user birthday on registration on my website using a list menu such as is on facebook. I however just cant be able to extract the date, … |
 | Hello I am trying to develop a group site where a user can signup and create group and other user can signup and join the groups created by other users, each user will have a wall where the posts from the groups they joined will appear, I need help in … |
| | Hi everyone, I am new to PHP and need help in making my script be able upload multiple images simultaneously. I need a large image and a thumb for each. I got this script from the web and made a few changes. I would really appreciate any help. The forms … |
| | Hi... I have this Web program running on UBUNTU... and I'm not familiar with Linux Systems... Heres the problem... I need to access the MySQL database on UBUNTU to create a report using VB.Net on WINDOWS... I downloaded an ODBC driver(MySQL ODBC 5.1 Driver) for MySQL then I tried to … |
| | [b]How to speed up the Group By Clause for a large 3GB database.[/b] I am using Group by clause for a large database having 148 columns and 5 million rows with approx 3GB of size. We need to apply the Group by clause on approx 1,00,000 rows at a time … |
| | |
| | Hi Guys, I am having trouble with my links, i am currently trying to use my $_SESSION['SESS_MEMBER_ID']; to automatically link it directly to the specific user page. However I always have this error: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\ThesisDB\DisplayThisUser.php on line 21 [CODE] … |
| | Hey Guys! :) Sorry to bother you all I can't seem to get my code to work and I would be much obliged if you could help me out. So what I was trying to do was get a column from a table of my database and show only the … |
| | I have one table that I need to pull data from to display. there are two fields that a user's id can be attached to. Field1 and Field2, but they are always either or. In addition, I have a couple of extra where clauses in my query. My experience in … |
| | Hi, I am working on web application in java. I need to copy table from local database to web table database. So please help me solve this query. Thanks in advance. |
| | Hello, I have table with test results. Every user have 3 records in the table RESULTS Table RESULTS contains fields USERID (int), TEST_POINTS (int), TEST_TIME (int); I need query to sort up results, but only the best result per user. Best result for user is one with MAX points for … |
| | [CODE]<?php ob_start("ob_gzhandler"); include("../config/dbconfig.php");//connect db $result = mysql_query('select * from salesreport'); $count = mysql_num_fields($result); for ($i = 0; $i < $count; $i++){ $header .= mysql_field_name($result, $i)."\t"; } while($row = mysql_fetch_row($result)){ $line = ''; foreach($row as $value){ if(!isset($value) || $value == ""){ $value = "\t"; }else{ $value = str_replace('', '', $value); $value …  |
 | I have a database, test.db, with a table called Events. I tried this: [code] <?php try { // open the database $database = new PDO('sqlite:test.db'); $result = $db->query('SELECT * FROM Events'); foreach($result as $row) { // both of these lines produce a blank page //echo $row['EventName'] . ' | ' … |
| | Hello, I am facing something strange. I will discuss it by very clear and simple example below. 1)I have function called Test() in [B]page1.php[/B] (gives correct output) as follows: function Test(){ $sql = "SELECT * FROM accounts WHERE account_id = 4"; $rs = mysql_query($sql); while ($row = mysql_fetch_array($rs)) $mobile_number = … |
| | Is it possible to copy a mysql database to an excel worksheet writting PHP code.. please help with code. |
 | I am new to SQL .. [code]SELECT status FROM statuses ORDER BY date;[/code] I know this will order by date but i want to alter the table and rearrange them by datestamp.. Is it possible to alter like that ? |
| | Hi!This is my 1st thread. I wanted to ask that I have a common table for clients.If client is given quotation, hes status is 1, if given invoice, hes status is 2 and so on. If i want to display only the clients who have received the invoice, I fire … |
| | I git this warning>> [CODE]Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Program Files (x86)\EasyPHP 2.0b1\www\HotelCalifornia\sites\reserve_room.php on line 85 Unknown column '' in 'where clause[/CODE] This is my code>> [CODE] <?php $user=$_GET['username']; $Custno=$_GET['Custno']; $RoomNo=$_GET['RoomNo']; $username="jasmine"; $password="price"; $db=mysql_connect("localhost" , $username, $password); mysql_select_db("hotel_cali", $db); $sql="SELECT Email FROM customer … |
| | hello guys.. I am new to php. May I ask if it is possible to store a mysql result into a single cookie..(the mysql result has multiple rows..).if it is possible, how to do it.. thanks in advance |
| | 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 'reasons = '', birthplace = '' dob_month = 'January', dob_day = '' at line 8 Hello aLL I am developing an online registration form that … |
| | I have table names 'payroll' with following data month , pay January , 1200 March , 1500 December , 2000 I want the following result Janury , 1200 February , 00 March , 1500 April , 00 May , 00 June , 00 July , 00 August , 00 September … |
| | Hi all, I am transitioning a bunch of data from html (yuck!) to some sort of separated schema. I was going to use xml: [code] <events> <event> <title> <date> <speaker> <description> </event> </events> [/code] but now I am wondering if I should use a real database instead. Can anyone comment …  |
| | hello people . i am writing a login system for administers , so i made the login page with this code : [CODE] <?php ##################################################### # created by : Awah Mohammed # # date : 23/12/2010 at 23:15 pm # # haha , i like writing such stuff in my … |
| | Hi, I am having an issue saving images to a MYSQL database as a BLOB, I have been for a few days now, I have used several different tutorials and even though the code works with no errors returned, nothing actually get put in my database. Here is my form … |
| | Hi I am pretty new to all this so bear with me. I have created some forms on dreamweaver which I want to populate mysql database when completed. I have created a table using phpmyAdmin through godaddy. I have created a record set which links to each form field. I … |
The End.