11,093 Topics
 | |
 | Currently I'm working on a microblog just to get familiar with PHP MySQL. I have a pretty big problem though. Here's the php code: [code] function get_all_users(){ $query = "SELECT * FROM ".$this->prefix."users"; if ($stmt = $this->prepare($query)){ $stmt->execute(); … |
| | Pretty new at php and working on my class project. I get this error code on my action page for my log in page plus, it does not redirect when the result is wrong. I still get into the members' area. Code below. Thanks "mysql_num_rows(): supplied argument is not a … |
| | I tried lot of way to pass the checkbox values from page 1 to page 2. But I only get successes on fruit id, how can pass the fruit charges. [CODE] // how can I pass room charges"$result[room_charges]" to page 2 // page 1 $sql=mysql_query("select * from fruit"); while ($result … |
| | Hello. I am making a register/login function, and i want the user to be able to upload files to his account, and can later view these files. I wonder how i can make the upload script insert data in a mysql table only for the current user uploading, i dont … |
 | im currently running on windows 7 and i cant seem to find some suitable installation of mysql for python 3.1.2.. any help on this?my professor havent gave me any links on where to download it, anyone would mind helping me on this? or as i tried import mysqldb and i …  |
| | Hello Everyone, I have triple drop down menu. I want to display the contents of the table based on the third menu selection. The code is in the link [url]http://php.pastebin.com/hgazULxi[/url] I know I need to include a onchange function to <select name="genus"> but as you can see I have a …  |
| | I couldn't register php session from mysql query. Can you tell me what is the correct method to register php session in mysql field. I tried many ways. Still no solution. [CODE] $sql=("SELECT email FROM people"); $result=mysql_query($sql); $email = mysql_fetch_array($result); echo $email['email']; //could not register this way session_register("$email"); [/CODE] |
| | I'm new to mysql and was wondering if someone could help me Im using the following code on search engine on my site I have to table blog and news when i change blog to news and post to article the error disappears but when i change it back i … |
| | create table book(bookid int ,title varchar(50),author varchar(50),book longblob); insert into book values(1,'c#','arun','c:/c#.pdf'); BUT this code is not working properly |
| | how come my real escape strings are getting entered into my table as blank entries - if i don't escape them, they enter just fine.... Any ideas? [CODE] <?php session_id($_POST['current_email']); session_start(); if (!empty($_FILES)) { $con = mysql_connect("xxx", "xxx", "xxx") or die("cannot connect"); mysql_select_db("xxx", $con) or die("cannot select DB"); $tempFile = … |
| | Hi, I have this connction string: [CODE]Private conexion As New OdbcConnection("DRIVER={MySQL ODBC 5.1.50 Driver}; SERVER=localhost; DATABASE=netstore; UID=root; PASSWORD=123456; OPTION=3")[/CODE] I use: Visual Studio 2010 MySQL 5.1.50 When I try to open the connection, this error appears: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver … |
| | I have this simple script: [PHP]<?php // MySQL Connection mysql_connect($sql['host'],$sql['user'],$sql['pass']) or die("Unable to connect to SQL server"); mysql_select_db($sql['data']) or die("Unable to find DB"); // Getting rows $select = "SELECT * FROM table WHERE uid = '". $_POST['uid'] ."'"; $data = mysql_db_query($sql['data'], $select) or die("Select Failed!"); // Query results $row = … |
| | hi, i am struggling and it will prob be a simple answer but cannot figure it out at all today. checked online but no use. my to create my view i need to compare a column to a yes or no. at the moment i have tried this but no … |
| | Hi, anyone can help me on how to connect PHPMyAdmin with java?  |
| | Hello I want a query to get my result I have two tables: 1) articles 2) comments 1) This is my articles table: [code] -------------------------------------- id | article_title | article_body | -------------------------------------- 1 | dummy article | some body | 2 | article2 | body2 | 3 | article3 | …  |
| | Hello, Can somebody help me to make a logon script? I want to make this script like that I add useres manually, in the database. And when people are going to the admin content it will show up: Pleas Login! Username: Password: Forgotten your password? click her! (And when the … |
| | Iam working on a database and would like to write code to asign lecturers time ,and days of lecture automatically.I so far have this select stattement that matches the lecturers and their speciality. (select Courseunits.courseunitcode,lect_skill.courseunitcode where Courseunits.courseunitcode =lect_skill.courseunitcode;) now my problem is :how can I assign them to various days … |
| | I have created a Java program which scans a given folder and creates a .txt with a list of names of all the files in that folder. I want to create a table on MYSQL server on a website and fill it with the names of the files given in … |
| | Good day: I'm creating a form to write SEO into my php page head and have run into a block on the mysql_query() UPDATE function. I just cannot seem to get it to write multiple fields in a row. What I've done so far is as follows: [CODE] <? if … |
| | hello everyone, i think this a rather complex question but i'll have a go. i have this output from mysql printed on a php page: user1 ------------------- week | hours worked | hours had to work | missing hours 32 | 30 | 32 | 2 user2 ------------------- week | … |
| | Hello everyone, I'm working on a project where I wish to find out who the instructor for a particular course is. The user is has to input the course name and course id for that course id then the script will search for the instructor. If the value returned is … |
| | Hi I have created a simple search form to search a movies database on my page using jsp and mysql, how can I make a download link after results have been extracted in a result page. Thanks for your nice reply. |
| | hello,im new to hibernate and not so familiar to its query language yet. can anyone please help me to translate this mysql query to its hql counterpart. select TRANSACTION_RECORD.BOOK_TYPE,TRANSACTION_RECORD.ID, TRANSACTION_RECORD.RECORD_DATE, TRANSACTION_ACCOUNTS.ACCOUNT_NAME, TRANSACTION_ACCOUNTS.DEBIT_AMOUNT, TRANSACTION_ACCOUNTS.CREDIT_AMOUNT, TRANSACTION_ACCOUNTS.ACCOUNT_TYPE from TRANSACTION_ACCOUNTS inner join (TRANSACTION_RECORD inner join TRANSACTION_ENTRIES on TRANSACTION_RECORD.ID = TRANSACTION_ENTRIES.TRANS_ID) on TRANSACTION_ACCOUNTS.ID = TRANSACTION_ENTRIES.TRANSACOUNT_ID; … |
| | Hi, I am looking to create a Jobs Board Database which will work with PHP 5 and PayPal, but I am having trouble figuring out the relationships: I know I might have a table for Company details and another one for Job Details but what do I do with regard … |
 | Hi all, the following script will not increment (2nd level), but updates fine at level 1 (COMPLETED POSITIVE). can anybody see why? regards [code] if ($_REQUEST['16emp'] == 'Yes'){ $flag = $_REQUEST['flag']; $flag2 = 'COMPLETED POSITIVE'; mysql_query("UPDATE accounts SET `flag` = '$flag2' WHERE `client_id`='$clientid'") or die(mysql_error()); } else if ($_REQUEST['16emp'] == …  |
| | hello guys.. Can someone give me a code on storing path image and retrieve path into image using mysql database and vb.net/vs 2008. I only know how to make a browse button and get the image into hard disk and display it in picturebox. I'm done with the the problem … |
| | Hello How to place a MYSQL database in my ASP.NET site? In what format I produces the file for my APP_DATA database folder to place it. How to build CONNECTION STRING to database located in APP_DATA I created a site communicates with a LOCALHOST database Now I want to import … |
| | Hi! I need help with cobining two queries into one, if possible. The queries looks like this: [CODE]SELECT route, SUM(volume) AS rested_volume FROM buff WHERE route = 019 AND date = '2010-10-10';[/CODE] and... [CODE]SELECT id.RouteNo, SUM(id.PickVol) AS total_volume FROM imported_data id WHERE id.id_date = '2010-10-10' AND id.LoggCode = 40 AND … |
| | I am running a form that pulls data from multiple mysql tables. However whenever the php/mysql code is in the html form tags it will not read the php/mysql nor will it read any php for exampl echo "here";. I have done this several times before so I imagine it … |
| | Hi I have a dynamic page that doesnt validate because I have special characters such as "&" in the data. I was wondering if I should do a find and replace of all those ampersand signs and replace them with the safe "&" code. Thanks for any help or suggestions … |
| | [code] <?php include("conn.php"); include("session.php"); ?> <html> <head> <title></title> </head> <body> <form action="user.php" method="post"> <table border="0" align="center" width="100%"> <tr> <td align="center"><a href="editevent.php">Edit Event</a></td> <td align="center"><a href="addevent.php">Add Event</a></td> <td align="right"><a href="logout.php">Logout</a></td> </tr> <tr> <td colspan="3"><b>List of events</b></td></tr> <?php $str="SELECT * FROM eventdesc "; $res=mysql_query($str); if(mysql_num_rows($res)!=0) { while($data=mysql_fetch_array($res,MYSQL_ASSOC)) { echo '<tr> <td>'. $data['eventdesc'].'</td> … |
| | If I run my php file manually I am getting the output as follows: [{"org_id":"39575","orgname":"ARTHRITIS FOUNDATION - VIRGINIA CHAPTER","orgcity":"RICHMOND","orgstate":"VA"}] The php code is as folows: [code=php] <html> <body style="background-color:#33990f"> <?php // connect include require ("connect.php"); $query = "SELECT * FROM orgs WHERE org_id = 39575"; $result = mysql_query($query)or die(mysql_error()); if … |
| | hey i despritly need some help getting this phpmyAdmin up and running again. i'm using wamp with mysql but can't get into my PhpmyAdmin for some reason. i've uninstalled it and re-installed it. the extension mysql.dll is there in the php.ini file uncommented the php extension for mysql is checked … |
| | I have created a login system based in PHP and MySQL, where upon registration, users enter the information required in the form. However, there is another page where they can review their information once they have logged in. I am new to PHP but I would like to know the … |
| | Hello, I am starting to freak out with my php codes because it is just a mess and i get an error when i close my php tag. This php file is going to upload an image and set a name,description, and signature from the player, but i get this … |
| | Hello all - I'm having some trouble UPDATING my mysql using php. I'm working on a event planning system; the user can click on the company to see a small report that has some areas which must be editable (payment status, etc.). I get these values into a form to … |
| | hi, i have a view in the database which queries about 6 tables to produce the results and works great. however i need to create a view based on the info from this view along with data from another table. when creating the view that queries the view and table … |
| | Hello, I am looking for some fullscript/CMS ready-made which would help me to see how to articulate and merge ruby/html/MySql. I allready worked on these different languages but have difficulties into merging all of them togheter to create a website. I thank you in advance, Damiano from Nicaragua! :) |
 | I use mysqldump.exe (Size 2.281 Kb, date 22-2-2010, time 18:06) I use MySQL Workbench 5.2 OSS Revision 6091 I have database [COLOR="Red"]TEST [/COLOR]with table [COLOR="red"]NAW[/COLOR] I use the i use the following statement to export table [COLOR="red"]NAW[/COLOR] [CODE] C:\mysqldump.exe --user=XXX --password=XXX --host=localhost test naw > c:\MybackupNAW.SQL [/CODE] This export file … |
| | What driver do you need to connect vb.net to MySQL? How do I create a Data source to MySQL? ...am only getting the options for SQL and MS-database! Please help... am designing a reg system for a college! Thanx :-) |
| | |
| | Hi All, Im getting and error from the following mysql statement when running it in the browser. Any help would be appreciated. "you have an error in your sql syntax near -nextq accounts" on line 1" this is the code [code] <?php $result = mysql_query("SELECT DISTINCT(source) FROM accounts WHERE source …  |
| | Hello everyone, I have a little bit problem here.I have installed PHP version 4.4.1 and it's working well. I want to connect PHP with MySQl . I have also installed MySQL and it installed successfully. Inorder to configure PHP to work with Mysql, I did the following changes in the … |
| | I have tried and tried and looked and looked, but I still can'y get this to work.... I am trying to (a)check form data on-the-fly, (b)once all required data is entered, then CLEAN the data and insert into MySQL database, and ONLY IF (a) and (b) have completed, then (c)send … |
| | I was trying to backup a database with the name test. I got the error as below: ERROR 1064 (42000): You have an error in your SQL syntax; check...... This error occurred when I am executing (command line) mysql> mysqldump -u root -p password test > test.sql; How could this … |
| | Hi I m using xampp server in my localhost. I m having problem. When I change value by phpmyadmin of any table. query does not give proper result. For example In contact table I have change user id number from 3 to 10 by phpmydmin. When I query by user … |
| | I have a screwed install of MySql Server on my Machine its a 10.04 64-bit Ubuntu. I can neither Remove it or Install a new one. [CODE]I tried apt-get remove [/CODE]and [CODE]dpkg --purge mysql-server-5.1[/CODE] They both reach [CODE]dpkg --purge mysql-server-5.1[/CODE] and stay stuck there. Can anyone please help me completely … |
| | I'm alowing a user to save their "configuration" from a form to the database> I also want the user to be able to load that configuration back onto the form from the database. Now tbh I've got no idea how to do it. I'd like this to be done without … |
| | I need an Event Registration Script that allows for payment with Paypal & saves form details and Paypal transaction ID to my MySQL DB After the payment has been finalized. I want to have ppl be able to register for camp, and with that choose if they want to preorder … |
| | I have a mysql table full of pictures(their path) that are owned by many different users. I need to run the following query and return the results into a 5 column table. The number of rows will be however many it takes to display all the pictures. My query is …  |
The End.