11,093 Topics
 | |
| | Hi, I need help for this problem that i'm trying to solve for a while. How do i submit the value into database and view value ? Here's the code: [CODE] if ($id_pac && $id_rej && $data && $id_kon && $lekarz) { // tworzymy zapytanie $id_mat = (isset($_POST['id_mat'])) ? 1 … |
 | Hi guys, Need help on backing up mySQL database for a specified period of time.  |
| | Okay, I'll admit up front that my request is quite presumptious but I need help. Can anyone here 'give' me the necessary php script to be inserted in my html 'form' that would allow me to accept credit card donations? Additionally, could you also provide me with the mysql database …  |
| | Hi, I'm trying to make a rather simple Visual Basic app with which I can update some tables within my MySQL databases. I've been following [URL="http://www.vbmysql.com/articles/vbnet-mysql-tutorials/the-vbnet-mysql-tutorial-part-3"]this tutorial[/URL] from page 3 on, as the first 2 pages where on how to initialize a local MySQL database. My MySQL database is on … |
| | I have created one php file which open a mysql database in my local system... I want to know that i have created a database in PhpMyAdmin.. What would be the user and password.. And how to run that php file.. Can I run it in a web browser to … |
| | hi guys really i don't know what im doing wrong... i am trying to process multiple radios with mysql. the first step has involved me echoing the results on the process page. each time i select any radio option it simply displays the first row result. this is that i …  |
| | [CODE]<?PHP $results = mysql_query("SELECT * FROM messages, comments WHERE messages.user_on='$user2' AND comments.msg_id_fk = messages.msg_id ORDER BY messages.msg_id, comments.com_id DESC") or die(mysql_error()); ?>[/CODE] |
| | Hello Guys... I'm a novice in both php/mysql. I'm creating an application and have many problems with it.I need help with some of the areas. First my application is a multiple forms based. The first page is that an admin logs into it by authenticating with mysql (This part I've … |
| | Hi, I am beginner in PHP and MYSQL ... Before using mysql i have created database in text files.. Now I have to convert it into the table of mysql database.. The things i want to do is .. first open the specific folder and into that open the sub …  |
| | Hi, I am beginner in PHP and MYSQL ... Before using mysql i have created database in text files.. Now I have to convert it into the table of mysql database.. The things i want to do is .. first open the specific folder and into that open the sub … |
| | I am trying to populate a dropdown list using <select><option> and on the selected option pass the values to another page. I have been trying a lot of things over the las two days and I have finally decided to go to the community for assistance. The data is displayed … |
| | G'day, I've got a small problem. As all who post here usually do. I've got my table [CODE]CREATE TABLE IF NOT EXISTS `attractions` ( `attID` int(11) NOT NULL AUTO_INCREMENT, `attName` varchar(255) NOT NULL, `adultPrice` double NOT NULL, `childPrice` double NOT NULL, `referenceID` int(11) NOT NULL, PRIMARY KEY (`attID`), UNIQUE KEY … |
| | Hello all :) Me and a friend of mine we are working in a project at the moment. We populate our database each one with his own data but now we need to merge our tables. The database has the same name in both machines, and also table name. I … |
| | I am trying to create a set of league table in MySQL and PHP. I can get the tables to show the top and bottom 5 values but the problem is when I have less than ten records in the system. When this occurs the same people can appear in … |
| | Hi all, I am a php rookie. I like to get a PHP function returning an array which gets a string(search query) and db results(an array) as arguments. This array should be sorted in ascending (alphabetical) order with search query positions. I tried of querying the results but i struck …  |
| | Hi, I was wondering if someone could help me, i have nearly complete my site and need some help creating the queries to produce my commission and pipeline. my table structure is: [CODE]CREATE TABLE `pipeline_commission` ( `ProductID` varchar(75) NOT NULL, `Pip_CommID` int(11) NOT NULL auto_increment, `PipComm_UserID` int(11) default NULL, `clients_ClientID` … |
| | Hi, could someone please point me in the right direction for creating an AJAX page that displays "live" data from a mysql database ? I need the page to update its self every time data changes in a mysql table. Thanks, Mark H.  |
| | Hi There, I currently have a PHP/MySQL query script which displays the top 50 MySQL rows in the table, however, it displays the top 50 of all time. I would love a way for it to display the top 50 rows in the last 7 days. The table looks a … |
| | Is there a way to get a distinct value from a table and echo it as a id for a div tag and still have the rest of the values echo too? Say I have a table with these values: category item With 3 categories each having 3 items I'd … |
| | Hi, I am wondering if anyone in this discussion forum uses some sort of web hosting service. Is there one that is free that supports Ajax, PHP, MySQL and ASP.NET? The one I use only supports PHP and MySQL. Anything is appreciated. |
| | [CODE]#---------------------------- # Table structure for litorder #---------------------------- CREATE TABLE `litorder` ( `id` int(10) NOT NULL auto_increment, `name` varchar(50) NOT NULL default '', `address` varchar(50) NOT NULL default '', `xdate` date NOT NULL default '0000-00-00', `ref` varchar(20) NOT NULL default '', `code1` varchar(50) NOT NULL default '', `code2` varchar(50) NOT NULL … |
 | hi friends I am developing a osCommerce website and I am strucking with displaying items. Ok Ill explain what my issue in my site ok I am using a sql query to display all the product in database. ok this is my query [CODE]$products_new_query_raw = "select * from " . … |
| | Hi, Assume, I have a following table whose schema is, create table testing (test1 integer not null, test2 integer not null, test3 integer not null, test4 integer not null); And assume the following details are inserted: insert into testing values (1,1,0,0); insert into testing values (1,1,1,0); insert into testing values …  |
| | Hi, I'm designing a web page that has 6 drop down html form inputs (d, m, y, d, m, y) for pulling records from a mysql database depending on users input of a range of dates. I'm trying to use an Ajax script that will hopefully, on submit of form, … |
| | Hi, can anyone tell me why the below PHP code keeps returning mysql_num_rows(): supplied argument is not a valid MySQL result resource ?? [code=php] $result = mysql_query("SELECT * FROM RewardGenUser WHERE UserID = 123"); $num = mysql_num_rows($result); [/code] |
| | Hello I have another problem. Here is previous thread: [url]http://www.daniweb.com/forums/post1237196.html#post1237196[/url] and my code: [CODE]$tipster = mysql_query("SELECT SUM(Analysis.Profit), Users.id, Users.Country_name, Users.Username, User_status.id_status FROM Users INNER JOIN User_status ON Users.User_status_name=User_status.user_status left outer JOIN Analysis ON Users.Username=Analysis.Tipster WHERE User_status.id_status>=3 GROUP BY Tipster ORDER BY SUM(Analysis.Profit) DESC"); while ($row = mysql_fetch_array($tipster)) { $sel_tipster=$row['Username']; echo … |
| | |
| | Hey guys, need your help here. How best can i Normaliza the sql query below [CODE]#---------------------------- # Table structure for litorder #---------------------------- CREATE TABLE `litorder` ( `id` int(10) NOT NULL auto_increment, `name` varchar(50) NOT NULL default '', `address` varchar(50) NOT NULL default '', `xdate` date NOT NULL default '0000-00-00', `ref` … |
| | my leave table: Field | Type | Null | Key empID int(11) NO EMPDETID int(11) NO Leave_ID int(11) NO LEAVEDATE datetime NO FIRSTHALF tinyint(3) unsigned NO SECONDHALF tinyint(3) unsigned NO REQPENDING tinyint(4) YES APPROVED tinyint(4) YES REJECT tinyint(4) YES my lev_definition table: Field Type Null Key LEVID int(11) NO PRI … |
| | Hi there. Okay heres the scenario. I have 2 tables "Logins" and "User_Details" What I want to do is write a PHP query that whenever a new user is created, that is manually entered into "User_details" table using a form, the next thing that should happen is that it should … |
| | Hi, I have a dropdown box extracted from MySQL database and I have two records for a product as it was produced in different years. i.e. model number 75 repeated, I am trying to extract only one of them in the dropdown box and have used select distinct but it … |
| | How to Rename stored procedures in PL/SQL Is there any query for that? |
| | I need your help!!!. I need to query a table in my database that has record of goods sold. I want the query to detect a particular product and also calculate the quantity sold. The product are 300 now, but it would increase in the future. Below is a sample … |
 | I just wanna ask whats the difference between trim() and mysql_real_escape_string() functions? because i see this code below : [CODE] $username = trim(mysql_prep($_POST['username'])); $password = trim(mysql_prep($_POST['password'])); [/CODE] and myql_prep is a function being made thats contain this : [CODE] function mysql_prep( $value ) { $magic_quotes_active = get_magic_quotes_gpc(); $new_enough_php = function_exists( … |
| | G'day, I've got my SCMA tomorrow morning, and I thought i would post up my notes. These notes are intended as a general tutorial/guide for MySQL. [B]It covers the following topics:[/B] [B]Section 1: Theory, Terminology and Concepts (10%)[/B] [LIST] [*]Client/Server Concepts [/LIST] [B]Section 2: Data Definition using SQL (25%)[/B] [LIST] … |
 | Hi all, I was wondering if any of you have had any experience with Catalyst and Moose. I am starting a project that I think would use both. I plan to use mod_perl or fast_cgi with Catalyst as the framework and Mason as the template language (I have used Mason … |
| | greetings.. i'm newbie on php and mysql.. i need help on how to create search form that return the results related to it? i'm using php mysql.. thus, i need help on how to make each result that'll be as a link to all data in it's row.. thank you! |
| | Hi everyone, I'm trying to write some PHP code to update a user's password. It is not updating and I can't spot what's wrong with my query (I have echo'ed it to the screen). [CODE]$sql="UPDATE $tbl_name set 'password'='$new_password' WHERE 'user'=$user;"; $result=mysql_query($sql);[/CODE] SQL statement [QUOTE]UPDATE user set 'password'='2' WHERE 'user'=test;[/QUOTE] What's … |
| | I have one problem with php and mysql. I have 3 tables (Users, User_status and Analysis) and want to display users and profit in a php table order by profit. So I wrote this code: [CODE]$tipster = mysql_query("SELECT Analysis.Profit, Users.Username, User_status.id FROM Analysis, Users INNER JOIN User.status ON Users.User_status_name=User_status.user_status WHERE … |
| | Hai, I am using MySQL table to store session values. i am getting sid as 'deleted' for some sessions in live server . but i am not able to simulate it in development server . what scenario it will occur. sample data. +---------+-------+-------------+ | sid | value | expire_time | … |
 | Hi I am trying to write a script that puts a Horizontal Line between MySQL query results but doesn't show up after the last row. eg: First Line ---------------- Second Line ---------------- Third Line I'm using PHP, MySQL and JavaScript AJAX. Don't know if that's relevant for this instance or … |
| | G'day, Just a simple question. Does MySQL Support Inheritance? I understand that both Oracle and PostgreSQL support Inheritance, but haven't seen anything in MySQL regarding this. Regards, TC |
| | I am trying to make a function that gets the name of a user from their user id. The function needs to search a database for the matching id. However, when I try the function i get the following error: [B]Warning: mysqli_real_escape_string() expects parameter 1 to be mysqli, null given … |
| | [CODE] $result = mysql_query(" SELECT q.*, IF(v.id,1,0) AS voted FROM quotes AS q LEFT JOIN quotes_votes AS v ON q.id = v.qid AND v.ip =".$ip." AND v.date_submit = '".$today."' "); $i=1; $str=''; $script=''; while($row=mysql_fetch_assoc($result)) { // Looping through all the quotes and generating the list on the right of the … |
| | Sorry I think I posted it on the Wrong Forum, Please Delete this Post... :( [CODE] $result = mysql_query(" SELECT q.*, IF(v.id,1,0) AS voted FROM quotes AS q LEFT JOIN quotes_votes AS v ON q.id = v.qid AND v.ip =".$ip." AND v.date_submit = '".$today."' "); $i=1; $str=''; $script=''; while($row=mysql_fetch_assoc($result)) { … |
| | I need to submit a project in vb & sql I have a project in vb & access which I have to convert to vb & sql secondly I have basic idea of sql data connection. but unfortunately I have done my sql class long back & lost the notes … |
| | I am having issues with the following script. I don't see anything wrong here. Very basic but it is giving me a headache. Any suggestions are welcome. I am running version 5.1.37 and the error is: Error Code : 1064 You have an error in your SQL syntax; check the … |
| | Hi, I don't know if this is the right forum to post this, if not please move it or just delete it. I installed Phpauction via Fantastico after trying several purchased scripts that just wouldn't work. Everything is working fine except the "View Feedback" links which give the following error … |
| | This is my pagination script: [CODE] <?php /*********************************** * PhpMyCoder Paginator * * Created By PhpMyCoder * * 2010 PhpMyCoder * * ------------------------------- * * You may use this code as long * * as this notice stays intact and * * the proper credit is given to * * … |
| | linking database selected through dropdownlist with corresponding database in mysql via php |
The End.