10,940 Topics
 | |
| | i am building a simple online portal and i have done all the login ,registration pages and all the fields successfully get uploaded in the database but now all i got is a product display page and an shopping cart 1. i want help is how do i pass the … |
 | After updating mysql from 4 to 5, I'm now getting this error: [CODE]Invalid SQL: SELECT HRS.Hrs AS Val, HRS.Job_ID, TS.Staff_ID, Staff.First_name, Staff.Last_name FROM Timesheets AS TS, Timesheet_hrs AS HRS LEFT OUTER JOIN Staff ON (TS.Staff_ID=Staff.ID) WHERE TS.ID=HRS.Timesheet_ID ORDER BY Staff.First_name, Staff.Last_name, HRS.Job_ID DESC: 1054 (Unknown column 'TS.Staff_ID' in 'on clause')[/CODE] … |
| | Have 2 tables - one for new titles and the other for authors. I want to tag the "new titles" table with the "author" value if the author's name appears in list of new titles. As you can see from my code, I don't have a clue what is wrong …  |
| | I've been trying to test out my first website on the following free hosting service for the moment: [url]http://members.000webhost.com/cpanel.php?accountID=6800891&login_hash=xakt1MTI3NQX1Q1z[/url] and it seems that the mysql connection isnt working. I get the following errors... [CODE] Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'Myname'@'10.1.1.34' (using password: YES) in /home/a3793016/public_html/reviews.php on line 35 … |
| | Hi i want to generate barcode for each bill. any one can help me. barcode will be alphanumeric(dynamic). |
| | Hi community, I have a problem with an application which makes use of a mysql database. I have a class which saves the fields of every record on the table. One of the columns is of type Datetime. Sometimes (!) I query this column and get results like with a … |
| | i have been looking everywhere for an answer to this and i still havent found one that works what i want to be able to do is display the details of the user that is logged in but instead it shows the whole database here is my code: [CODE=php]<?php require('authenticate.php'); … |
| | I have around 20 tables in my database. I want to count every row of every table using COUNT and get a total. I have tried doing a separate select statement for each table then using UNION but I cannot find a way to join the results to get just … |
| | Hey there I'd appreciate some help with variables please. I have a search function on a site I'm building and would like to have it so that a user can click on a search result to see more columns from that row on the db, if you see what I … |
 | I have this code for mysql, and in my table i have date entries in my date field from my date table ....i want to make use with between clause ...below is my sql statement..but it displays nothing even there are dates in between... SELECT * FROM date WHERE date … |
 | I have been so stupid to hit go at the bottom after I added a new user, deleting all users including root. I have re-installed xampp twice, tried to change the password via the xampp security, still with no success. xAmpp loads perfect on [url]http://localhost[/url], phpMyAdmin though shows the following … |
| | [ICODE]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 '-userfile WHERE id='642' AND userid='459'' at line 1[/ICODE] This is the code [ICODE] $query = "SELECT * FROM ue-userfile WHERE id='$imageid' AND userid='$userid'"; $result = … |
 | Hi ALL, I am writing a script to retreive entries from a DB. And then I loop through all the entries. Once I am done looping through all the result sets, I have to re-loop over them again. This is done in an infinite loop (Please don't ask why to …  |
| | Hi, I am trying to display images from my db with the following code.. [CODE] <?php include_once("scripts/connect.php"); if ($q == "All Images") { $sql = mysql_query("SELECT * FROM gallery"); $q = "All Images"; } else { $sql = mysql_query("SELECT * FROM gallery WHERE caption LIKE '%$q%'"); } $limit = 7; … |
| | Hello.. Everyone.. I am very new to PHP world.. I have got a lesson to Saving images in folder and paths to database.. I have tried a lot.. I have tried various websites but there has no complete solution! Will you provide me the proper code? |
 | Greetings all. First of all, let me say I am NOT asking for code, just to be pointed in the right direction. I’m a newbie in php and mysql and have been teaching myself what I could learn from online lessons and tutorials (mostly w3school.com). I have found plenty of … |
| | Hi, Actually I don't know if my question belongs in this topic or in the mysql topic. But I'm making a VB.net application with a mysql database and i have to make a trigger but I don't know where I have to use or implement it in my application. I … |
| | Dear All, I have read dateTime field into a string from mysql database and in my java I have another dateTime in string format and in same format as the mysql date time and would like to compare both to see which one is before? |
| | I need the dates in a specific range.And i want to get the result in java manipulating from a MySQL database.Now how can i do so. Suppose there are 3 days 17.08.2011,18.08.2011 and 19.08.2011 .I want the dates in the range 16.08.2011 to 18.08.2011 .So how can i manipulate it … |
| | Hi I create some tables in EasyPhp>>Phpmyadmin>>test(db name)>>((localhost)) and it works correctly with my designed page in dreamweaver but i wanna upload all of tables into the mysql db in cpanel So, the question is How can I move all of the tables with saving details to mysql db in …  |
| | Hi guys, I have a problem on getting the selected radio button and save it in the database. Here is my code: [CODE] <div id="container"> <div id="question1" style="display: inline;"> <p>Question 1</p> <ul> <li><input type="radio" name="q1" value="1" id="ans1" />Answer 1</li> <li><input type="radio" name="q2" value="2" id="ans1"/>Answer 2</li> <li><input type="radio" name="q3" value="3" id="ans1"/>Answer …  |
| | hi, please help in my project in visual studio 2008 and connecting it to mySQL, I'm going to create a simple identification system, can you please help me with the codes? (Form1 - Log-in, Log-out) Here's my project proposal, I need to identify an ID number and a password. Like … |
| | Hi, for some weeks now, i have been trying to develop an [B]attendance system with php and mysql. [/B] I HAVE LOOKED EVERYWHERE!! what i have done is this: user select date (calendar). date is processed in php page. if attendance has not been filled,then new attendance sheet is provided. … |
| | hello, i wrote some commands in notepad and saved it as .sql and i m running these commad at my sql by command- [COLOR="Red"]mysql>source C:\Program Files\MySQL\MySQL Server 5.0\bin\script.sql;[/COLOR] then its run.. but hat to do if i write it without giving whole path. i ren this command-- [COLOR="Red"]mysql> \. filename[/COLOR] … |
| | hi friends, i want to search the data from the mysql database in html form and display that searched data in html form...can u give script for this... |
| | Hello, I have a problem with update in MySql database. In a university system a student apply for what is called a petition then the admin signs it and adds a note. When the admin signs for the first time and enters his note it works. But when the student … |
| | In the below query,the "Account has been successfully approved" message dispayed. But in the database still approved_status remains '0'. [CODE] <?php $connect=mysql_connect('localhost','root',''); mysql_select_db('bank',$connect); if(isset($_POST['account_number'])) $account_number=$_POST['account_number']; else $account_number=''; $query = "UPDATE account_details SET approved_status='1' WHERE account_number='$account_number'"; $result= mysql_query($query) or die(mysql_error()); if ($result) { echo "Account has been successfully approved"; } ?> … |
| | Hi, I am creating a database for a car hiring service and would like to produce reports. I know these are simple to create in MS Access but i dont have the fainest idea if these are at all possible in MySQL. I have created tables and queries to which … |
| | hello there. i was just wondering.is it possible to get the text display of your div and place it in a variable? if so, how should i do it? i've been searching for a solution in this problem but i can't find anything.thanks in advance.  |
| | I am developing a project for a client with a single table in the database for users which includes information about each user, including a field for the userID of a user who referred them. What I need to do is query the "referrer" field of each user record and … |
The End.