10,940 Topics
 | |
 | Hi, So basically I have a php file that fetches database records and displays it. Now i would like to add the ability to edit each record using lightbox. here is the main file [CODE=PHP] <?php $username="root"; $password=""; $database="lhs_anniversary_banquet"; mysql_connect("localhost",$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $query="SELECT * FROM … |
| | hi all im looking to use a select mysql query - but im trying to query the database against a users logged in sessions. I have the sessions working correctly but I am unsure how to included the session data in my sql select query. here is my users session …  |
| | I am getting the following error Fatal error: Call to undefined function mysql_connect() in C:\Inetpub\wwwroot\valid.php on line 4 Using php and my sql on localhost |
| | hello. is there a way which i am able to cast/ convert my substrings into integer? This is what i have been trying to do, apparently, it does not work. SELECT campaignmonth CAST(campaignmonth, substring(campaignmonth,1,1)as Jan) FROM campaign a; thanks |
| | Hi, Ive been at this all weekend and can't figure it out.... I need to take it name and 3 results via a form and store this in a mysql database - done. Then I need to print on screen via php who got the highest score. The highest score … |
| | I've got my pagination script working, but now I need help trying to get it to extract data from 2 different sources. The episode data is stored in table episodes, whilst the main table (where the info on airdates for episodes is stored in epdata2). This is my code: [CODE] …  |
| | Hi all ! I 'm a newbie in SQL and has just install the Oracle 10g Express Edition. When using its SQL Command in the Web-interface, I took an error with the GROUP BY, as follow : First, I create a table DEPARTMENT, here 's the code : [CODE] CREATE … |
 | Hi all, I have been running errors too much that I realized that I have learned 'bad' behaviour in writting PHP query. So I decided to change. Please tell me what is good behaviour of writting queries that involve PHP variables as well as functions like one below. [CODE=php]$query = … |
| | Hi, i'm not really sure how to explain this. I have a table with a lot of places sorted by date, all connected to a MySQL database. I'd like the table to update automatically everyday and remove the top ones where the date has passed so that the table only … |
| | Doing a system in drupal using php and mysql. Want to integrate a function for reporting - that is print out watever search result in the search page which displays in tabular form. please help. i have only heard of jasper reports. is there something simpler? if so wat n … |
| | Doing a System in Drupal - coding with php and mysql - want to know how i can integrate jasper reports to it so i can generate reports at the click of a button.. does anyone know? please help.. |
| | Hi folks, [COLOR="Green"] I have a MySql table...which has 4 columns say sid pid tid data 1 abc 2 def 3 ghi 4 jkl - - 10 xyz 1 dfsf 2 sdfs [/COLOR] I want to convert column name 'data' into multiple rows i.e. 1 2 3 4 5 --- … |
| | I have a table and I want to start the select with the 20th row. How do I do this? Does conditionals work on "limit" |
| | I'm doing my assignment, and I can't figure out how do it. For instance, I have to decrease the prices in a "movie" column by 3%...how do you update the table like that? So, would you say: UPDATE table_name SET PRICE = (PRICE * 0.97); ? |
| | Hey I am trying to run this in php: [code]// Retrieve data from table where row that match this passkey $sql1="SELECT * FROM $tbl_name1 WHERE confirm_code ='$passkey'"; $result1=mysql_query($sql1) or die(mysql_error())[/code] and I get this error: [code]You have an error in your SQL syntax; check the manual that corresponds to your … |
| | Please see this: [CODE]WARNING [1024] Error while executing query: select event_type, EventId, VenueId, Price, Schedule, ev.startDate, ev.endDate, events.name eventname, movies.name moviename from `eventvenue` ev, `events` left join (movies) on (movies.ID = ev.EventId) where events.ID = ev.EventId and VenueId = '493' and ((ev.startDate >= '2010-04-25' or ev.endDate >= '2010-04-25') or event_type … |
| | Anyone, please help me here. I created a view in mysql but when I use it in my code in php, an error appears that the view doesn't exist. What can I do? Here is my code. [CODE] $count = mysql_query("SELECT COUNT(*) FROM ViewName where ftTimeIn != '' AND ftTimeOut … |
| | Hi Everyone, I have a page that displays information from a mysql database. The information is taken from the members table where the id is in the url e.g. [url]http://www.clancorner.net/tounament.php?go=MW2&[/url][B]id=2[/B]. And that works perfectly, pulls ou all the information i asked for. Unfortunatley i now need to just echo "Invalid … |
 | Hello, I'm trying to pull data from multiple tables in a single mysql_query and I'm having trouble displaying the data that's pulled. Here's what I've got so far.. the highlighted code is the part that doesn't work. (sorry in advanced for the sloppy code.. i've been copying/pasting stuff all over … |
 | |
| | hello, I need to have in ONE request clients who just like apple AND banana : clients id name relations_like id id_client id_like like_fruits id title a same client can have a few differents like_fruits if I made a classic SELECT FROM relations_like WHERE id_like IN (idapple, idbanana) I will … |
| | hi, I need php mysql image upload and resizer. The image uploaded through a uploading page should be resized and should kept in mysql server. and we need to retrieve it to another page. help me. thanks, |
| | Hi, I`ve started doing PHP and MYSQL for a few months now and I am working on a project for a friend. Basically I had the code written down in mysql format and decided to change my code too mysqli. Everything was working fine except for one function. I keep … |
| | Hi, I have written the following code to download a file from a MySql database using a Servlet.The problem i have is that i havnt done it right. Can someone please point me in the right direction. Any help will be greatly appreciated. Thank you for your help. [code=java] import … |
| | Hi all. I've been having this problem and I was hoping someone could catch something I didn't. So here it goes: I have developed a registration system using PHP and mySQL, with usernames and passwords being encrypted by salt and md5 (and display names getting no encryption) on PHP's end … |
| | I'm coding a simple forum, for a user system that I'm making. By simple I mean very simple - viewing categories, threads, and topics, as well as posting, editing, and reporting to a moderator. Moderators can also delete, sticky, or lock threads, or delete posts. Now, I'm doing quite well … |
| | Hello all. Am new to the forums and this is my first post and I am in need of a little help. I am in the planning stages of building a pretty involved web application. This question needs some background info first. This is for a direct mail company (a …  |
| | i would really like to automate something like ... login to mysql cmd followed by creating a database following by creating tables... with one bat script here is my try: [code] mysql -u root password password; [/code] however it returned me this: [code] C:\Documents and Settings\lih>mysql -u root password root … |
| | Hi, I want to create some kind of AJAX script or call that continuously will check a MySQL database if any new messages has arrived. When there is a new message in the database, the AJAX script should invoke a kind of alert box or message box. I’m not quite …  |
| | I'm trying to build a room booking web application with php+mysql. I'm close, but something keeps going wrong. The way it works is this: 1. User logs in 2. User redirects to "booking" page, where they can choose from 1 of 2 rooms to book 3. there are drop downs … |
The End.