10,938 Topics
 | |
| | Hi all, I just learn PHP couple days ago, due to some 'trouble' in the company and my boss asking me to create an employee database Help on PHP MYSQL Forms Input With some help of dreamweaver, i finally manage to create a form for employee database but..... Sadly....some of … |
| | hi, I am having a problem doing a select in MySQL among multiple tables. I have two tables that are virtually the same except that one table is for January and one is for February. I have two columns in each of the tables i want to match on: Account, …  |
| | Hi, I'm new in using MySQL database and have problem with character encoding. Database was created by this query: [code=sql]CREATE DATABASE 'dbname' CHARACTER SET utf8 COLLATE utf8_general_ci;[/code] Then I've create table using this query: [code=sql]CREATE TABLE IF NOT EXISTS 'tblname' ( ... ) CHARACTER SET utf8 COLLATE utf8_general_ci;[/code] AFTER query: … |
| | Hi there, I am new to Php and MySql. However, i have been learning for some time now. I get the above error and my line 77 has the following statement: $result=mysql_query($query,$conn); Any ideas? If you need more of the code please let me know. Thanks a lot, Sofia  |
 | Hi The user clicks on a buttons to delete all posts in a thread (this also deletes the parent post). The code is bellow. This however isnt working, its deleting all the parent posts, even those that dont correspond to the topic clicked on. Any ideas [CODE] if (isset ($_GET['delete']) …  |
| | I am getting an "Connection must be valid and open" error. After some research I have found two possible reasons for this: malformed sql or bad connection string. Since the error is being thrown on a second .executescalar statement I will assume the connection string is working. I have two … |
| | hi..I'm just a newbie programmer who needs some help. I'm trying to enter a date and save it in a mysql database. however the format in mysql is yyyy-mm-dd and the format in vb.net is mm-dd-yyyy. how can i format the date in vb in order to successfully enter it … |
| | Good day.! Thank you for all of you in this forum in helping me in all my post. I just got one last problem with my project.!Please help me on how to back up and restore my mysql database that when i click backup my mysql database named (onlineenrolement) will … |
| | My system is a stand alone system, I want to connect to MYSQL using PHP, I am giving hostname as localhost, and the needed username and passoword. In the browser i am getting Internal server error 500. Any sort of help much appreciated, Thank you |
 | hi all, Donn't know much php........... i want that when user register,his registration date store in db.i want to use server date not his system date in db. thankx in adva... |
| | Hi i had a database table which stores images in columns. ie [ICODE]idno + image name + name 1 | lal.jpg | raj 2 | lal2.jpg | raj2 3 | lal3.jpg | raj3 .....[/ICODE] Now I need to show this images and these names in a page as 3 columns.... … |
| | I have these two tables.. [B]Product[/B] ============================= ID Title Description ============================= 1 My first product First description 2 My second product Second description … … … …. …. …. [B]META[/B] ============================= ID PRODID KEY VALUE ============================= 1 1 StartDate 22-MAR-2009 2 1 EndDate 23-MAR-2009 3 2 StartDate 28-MAR-2009 4 2 … |
| | Hi, I want to use a php form textfield to change a value in my databas. Statement i want to send the databas: UPDATE people SET name='VALUE FROM TEXTFILED' WHERE id=1 How do i integrate this statement into a php form textfield? |
| | Hello guys, quick question for ya... Here is the code i am looking at [CODE]<?php $conn=mysql_connect("internal-db.s*****.gridserver.com","db*****","*******") or die(mysql_error()); mysql_select_db("db*****_gradsurvey") or die(mysql_error()); function generatePassword ($length = 5) { // start with a blank password $password = ""; // define possible characters $possible = "0123456789"; // set up a counter $i = … |
| | Hello everyone, I need help. I have two table name: Table 1: resortid resortlocation Table 2 resortid resortname Now I want to get the maximum of resortlocation then getting the name of that specific resort also. I am having a hard time. Can someone please help me? Thanks. |
| | Hi everyone :) I'm completely new here. Let me introduce myself - My name's Dave and I'm a student studying Multimedia applications development at the Waterford Institute of Technology in Waterford, Ireland. [B]I'm currently involved in a college project where I have a JSP web application connecting to a MySQL … |
| | Hello, Im new to that kind of code so forgive me. I have 3 diferent tables players: id_player name_player players_details: id_player position age players_eval: id_player value wage You can see that the ‘id_player’ is in all tables. Now, what i want to do is export on csv and if the … |
 | Accorting to MySql manual and web site I modified the environment variable for installing JConnector for mysql as follows : CLASSPATH C:\Program Files\Java\mysql-connector-java-5.0.7\mysql-connector-java-5.0.7-bin.jar where my MySql connector Folder is placed on Java folder in program files (I put there willingly) But actually when I want to do any testing program …  |
| | hi i want to merge two rows in a table. but a little confused.. Please help!:confused: the example is as shown below Record #1: [B]Nikhil [/B]Bhat [B]1Jan2009 [/B][B]Married [/B]ABC Record #1: Nikhil [B]Ong [/B]1Feb2009 Single [B]DEF[/B] Meged Record : Nikhil Ong 1Jan2009 Married DEF There is a primary key 'ID' … |
| | Hi, How do i order results for most relevant one? [code]Select id, title from data where (titleLIKE '%PHP developer%')[/code] id title ---- ------------------------------- 1 ASP developer 2 WEB developer 3 PHP 4 PHP developer In this case, it should be displayed in this other 4, 3, 2, 1 OR 4, … |
| | Hi I am writing a search script that you will type in a search term and then the system will go off and search 2-3 tables at once and bring back the search results. Now the proble that i have is that i am unsure how to go about sorting … |
| | Hi I seem to be getting this error on the reply section of my forum. I've never had this problem before and have tried google but found nothing. So, now i turn to daniweb, surly someone must be able to help me here. [B]This is the error:[/B] [CODE]Warning: Wrong parameter … |
| | i have a code like this [CODE]select * from tableX group by fieldA order by fieldB[/CODE] this code sort according to fieldA. but i need to sort according to fieldB. please help me ?? |
| | |
| | Thanks for your help in the past, and this forum is great. I have a question about dates, and in searching, there are huge amounts of results, but very hard to narrow it down to exactly what I'm asking. In using PHP, I have some variables pulled from mysql databases … |
| | i am trying to get this code to work but there is something wrong with the array (not to good at these). the main part of the code works it is sending out the email but only ever to one registered user. here is the code i have so far. … |
| | Hi, I have a distributed DB , comprising of 800 db servers (huge data for a social networking company). the records are sorted in db based on user_account _id, and the table also has user's credit card number , now - given a credit card number I need to find … |
| | I'm not very good at MySQL stuff, so I need a little help with a problem I'm having. I'm trying to make a script that will open up a text file and print the contents of the list onto the screen. Additionally I wanted the contents of the file (a.k.a. … |
| | I have three tables: posts, topics, and forums. Each row in post table has a topic id and a author name. Each row in topics has an id that corresponds with the topic_id in posts, and then it has an id for the forum that it (the topic, containing the … |
| | We have integrated Paypal with our application and everything is working perfectly. But after the transaction is completed and successful we need that it should redirect to our application again. But its not happening. We have turned on the auto return option in the paypal too but its still not …  |
The End.