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