11,093 Topics
 | |
| | I need to use the mysql query result.following is the mysql query. [CODE] while($row = mysql_fetch_array($result)) { $name=$row['name']; } [/CODE] For example: result of above query is (name1,name2,name3...) The problem is... i need to return that result in the following function.How can i do it? [CODE] function results() { return … |
| | Is this code correct? It is supposed to get input from SMS messaging API and save it to database. Mysql database is created with Table inbox and 2 columns called ID & Msg. I want to know if this code is going to do the job? Else help me in … |
| | Back in February,smantscheff helped me with a problem where I was trying to aggregate data between two queries and after the suggestion of creating two views, everything worked perfectly. However, I failed to look ahead and see a potential future problem! The original thread is [URL="http://www.daniweb.com/web-development/databases/mysql/threads/347065/1473368#post1473368"]http://www.daniweb.com/web-development/databases/mysql/threads/347065/1473368#post1473368[/URL] and quite simply, as … |
 | Hi all. I have a database table containing the details of, lets say, Ninjas. It has a primary key called NinjaID. I have a second table containing a match-up of which Ninjas will be fighting eachother. This table has 4 Columns: 1.) MatchID 2.) BlueCornerNinjaID 3.) RedCornerNinjaID 4.) DateTime What … |
| | Hi to all, first of all thanks to all those who reply... appreciate the input I am using OpenContacts as an address book style program. However it uses a firebird backend db. I have a mySQL webserver and I want to synchronize the two databases by "Replacing All of Local … |
| | Good day, I am climbing a wall trying to figure out why I can not retrieve the results of a mysql query to a php array. My query polls the database and it is retrieved but all the data is encrypted. I need to take the results and put them … |
| | I am having trouble merging two queries. I want to be able to search my recipe inventory by ingredient, but I also want it to tell me how many ingredients I am missing for that certain recipe. I am able to do a search by just ingredient and I am … |
| | im pondering on some functions on MySQL especially on dates and times and i stumbled upon an idea where i can't find a predefined function that gets the next day of a specific day. For example: As of this post, the Date and Time is (GMT +8) : July 4, … |
| | Dear All, I got few tables as below. So then what I do on any time I will calculate the total points collected based on each table via some of this queries like below. What I am using now is the sum function. I am confuse should I like run … |
| | Hello every one whats the difference between mysql_.... and mysqli_.... functions in PHP??? Arent they both for mysql??? |
| | I am attempting to dump a portion of my table after 7 days. This table will hold access logs so will fill up pretty quickly. I'm not too sure if this is entirely possible but this is what I'm trying to use. Any help or a push in the right … |
| | HI friends..I have a tab delimited text file with country, city, Participants field.. Now, when I search for a particular entry for eg. Country England, then I want it to show all the cities associated with it Inot just one). My actual table looks like this. [IMG]http://i56.tinypic.com/2dceg4p.jpg[/IMG] Now, If I … |
| | hi, may i know how can i import my databases from an old version xampp to xampp 1.7.4  |
| | Hi I am trying to build a MySQL database. I have made a table where some fields are VARCHAR and others are INT. All of them are null. One of the columns I made is Vote which is INT(5). Now I am trying to import data from a text file. … |
| | Any could give me a PHP script on how to call or execute mysql stored procedure. Thank you. Roland |
| | Hi, Just started to mess with MySQLi, created a simple login script, Connection to MySQL server establishes correctly, but then displays username is incorrect, because 0 rows were returned. 1) Am I doing it right, is the mysqli layout I'm using correct ? 2) Database structure is uid - username … |
 | So briefly I have a framework class that I'm using that work perfect except with the issue I'm currently having. Problem is this, everything displays on the page as expected [B]until [/B]the form on the page is submitted and the ISSET at the top is true: [CODE=php]if(isset($addAccount)){ $SP = new … |
| | The MYSQL db has a Location field with entries like: CAN CAN ON CAN ON, CAN BC CAN AB, CAN BC NY OH CANFIELD, OH TOLEDO WA, OR, CA Thus the location field can have multiple entries, all separated by a comma, but still held in the single Location field. … |
| | hi guys! i have a problem regarding the queries i coded. my first query is to display the category name, description and maxscore: SELECT c.cat_name, g.maxscore, g.description FROM grp_performance INNER JOIN category c ON g.cat_id = c.cat_id the problem is, i don't know how to delete the row in the … |
| | Hi all, i am working with Uploadify ( a neat little file uploader ) and had a tough time finding an image re-sizer to work with it. I finally found one that works quite well but it encodes the file name using md5 encoding. I am not sure where and … |
 | Here is the image of the table of the Question [url]http://oi55.tinypic.com/2d0gkmh.jpg[/url] Here is the First question(in the image) [url]http://oi52.tinypic.com/2ztix5l.jpg[/url] Above one is question (c) help me to answer that this is the other question(below, as Text) d) Create a database view to display the above output of part (c). help … |
 | This have been a problem to me for long now and I want to settle it once and for all. PHP and MySQL DateTime and date fields have been headache to me. Suppose I have fields ------Name--------------BirthDate--------LastTimeYouAte-- ------VARCHAR(255)------DATE-------------DATETIME-------- Now, When I do insert, How do I format PHP Date and … |
| | i'm not getting any results for the query. I'm sure it has something to do with the apostrophe and back slashes [code] $search = "q test'yes"; $search = mysql_real_escape_string($search); mysql_query("SELECT * FROM block WHERE name LIKE '%$search%' ORDER BY `id` DESC",$this->connect); [/code] When i echo it out i get this … |
| | Hi, i got this error. Please help. Fatal error: Call to undefined function mysqli_list_fields() This is my code, <?php include 'dbFunctions'; $fields = mysqli_list_fields("fyp", "criteria", $link); $columns = mysqli_num_fields($fields); ?> <form method="post" action="doSelectCriteria.php">; <select name = criteria>; <?php for ($i = 0; $i < $columns; $i++) { echo "<option value='".mysqli_field_name($fields, … |
| | hello to *.. I am new in php can you please help me here! cant insert my data into my database. [CODE]<?php error_reporting (E_ALL ^ E_NOTICE); $add = $_POST['add']; //Add button $date = $_POST['date']; $project = $_POST['project']; $task = $_POST['task']; $originated = $_POST['originated']; $incharge = $_POST['incharge']; $deadline = $_POST['deadline']; $status …  |
| | |
| | Good day to *. I having this kind of error when i tried to view all my data in the Database. [CODE]Warning: mysql_query() expects parameter 1 to be string, resource given in C:\wamp\www\pm website\php\bulletin_board\bulletin_board.php on line 51 Error Sir[/CODE] and here's my code. [CODE]<?php $con = mysql_connect("localhost","root",""); if(!$con) { die … |
| | I have tried for hours now trying to figure out how to do this and I'm sure its impossible, I have tried the following queries and still searching for the solution. I need to display the subcategories, subcat_title table row based on the condition the table row cat_id is equal … |
| | Having A Problem in getting results to display correctly I seem to be getting two sets of results displayed for categories "cat_title" when I only need it displayed once. What is the best way around this does anyone know whether I should define using an mysql query or PHP. [CODE] … |
| | What's the notation to add data from a variable to existing data in a field? mysql_query("UPDATE stk SET some_field = '????????????' WHERE id = " . $upc_key . "") or die(mysql_error()); |
 | how do retrieve the last record if its id or other fields are unknown...or simply i need to move the record pointer to the last record in a table...thanx a lot... SELECT * from stud_infos WHERE stud_id = 'HOW DO I DO IT?' |
| | well guys hello i am bit confuse on my way...i up to a project for my university and designing a database system for a school...the problem is i am uploading images and and i set the image type as blob in mysql db but one of friend suggest me that …  |
| | how to populate treeview from multiple columns of sql data table I have attached my sql table here.from that table,i have to populate a treeview of the below form; -outlook ---------overcast -----------------------------yes ---------rainy ----------------wind ----------------------strong ------------------------------no ----------------------weak -------------------------------yes ---------sunny ---------------humidity ------------------------high --------------------------------no -------------------------normal ---------------------------------yes. It is readable like this; if … |
| | I have a script that reads all rows from a database, and prints it out to an html table. The html table has an extra column for "status".In this column there is a form that is supposed to submit the dropdown field to the mysql database. I've got the set … |
| | Hi, I am trying to update data from a column in a database using a php script. But for some reason it doesn't update the database, but i get no error feedback. So first i select a random entry from the database and i add it as a parameter to … |
| | The below line generates this error. Can anyone gives me a solution Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in C:\wamp\www\MySite\php files\approve_page.php on line 25 [CODE] $query = "UPDATE transaction SET approved_status='1' WHERE account_number='$account_number' AND tran_id='$_POST['tran_id']'"; [/CODE] |
| | hello all how to use mysqldump in my project I see an example : MySqlDump my_dump=new MySqlDump(); but it seem need some reference or something,and won't work without it what should I add to make it give no error' thank you denny  |
| | I have a table with entries for different accounts and each account has different products listed in it with a date next to each entry. An example of the structure is below. Account | Product | Holding | Date A1 | Car1 | 2 | 2010-12-31 A1 | Car2 | … |
 | Hello all, I've a seemingly simple question, but it's kind of got me thinkin there might be a "proper" way to accomplish my goal. My goal is a simple MySQL database schema install. In PHPMyAdmin I export a database, any database. I then save the file to the root directory … |
| | Hi everyone, My second time back to Daniweb looking for assistance with PHP. :) Okay, here's my PHP, and I'll explain what it does. [CODE]dbConnect(); if ($userclient == '2438') { dbOpenDatabase($GLOBALS['res_2438_contacts']); } else { dbOpenDatabase($GLOBALS['db_contacts']); } /************************************************ * THE IMPORTANT BITS - CHANGE BELOW * ************************************************/ //Product ID for Safety … |
| | Hi all, [INDENT] i am facing a serious problem working with MySQL and Nhibernate 2.1.2.4.0 named queries. I have written a stored procedure and i am calling it in C# using a flat class to map the database fields. My problem is it seems to work fine with Mysql 5.1 … |
| | CREATE TABLE `employee`(`employee_no` CHAR(4) NOT NULL,`emp_name` TEXT,`employee_sal` INT NOT NULL,primary key (employee_no); << I typed this and it says there is an error (see below).I can't see what is it.000webhost.com Mysql server [CODE]Error SQL query: CREATE TABLE `employee` ( `employee_no` CHAR( 4 ) NOT NULL , `emp_name` TEXT, `employee_sal` INT … |
| | I don't know what's wrong with this code. I think this code should work. I'm about to store number of each query in array [CODE] $antecedent=array(); for($i=0;$i<=$index;$i++){ if(isset($period[$i])|| isset($gpa[$i]) || isset($antecedent[$i])){ echo $period[$i]." "; echo $gpa[$i]."<br/>"; $queryAntecedent=mysql_query("SELECT * FROM mytable WHERE study_period='$period[$i]' AND ipk='$gpa[$i]'") or die (mysql_error()); $antecedent[$i]=mysql_num_rows($queryAntecedent); }//endif }//endfor print_r …  |
| | Of course, Yesterday I ask for help for my google map route creator. And of coure, I made my google maps route creator source. [code] <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Google Maps</title> <script type="text/javascript" src="jquery.js"></script> <script src="http://maps.googleapis.com/maps/api/js?sensor=false"></script> <script type="text/javascript"> … |
| | Hi, i need help , i wanted images to be for instance 4 in row, before it goes on to the next row, and below the images i wanted a title there. This are my work so far, but i just cant get to what I wanted, i've been searching … |
| | hi folks, Here i face problem in my webpage [servlet + mysql] Connection are working fine. But when running time it get download the page instead of display the content in the browser. I try myself so many time, cant sove it.. plz guys help me to overcome this problem. … |
 | So I have a text box in a form. The test box needs to take the value entered and insert it into a column within a row in MySQL. I know it's connecting to the MySQL online, I have a message box telling me so upon a successful connection. I'm … |
| | it doesn't have any error but also i does not update in my database? [CODE]<head> </head> <?php include('connect.php');?> <body> <?php mysql_select_db("dbusers",$connection); $result=mysql_query("UPDATE tblinfo SET idno='$idno', name='$name', address='$address', birthdate='$birthdate', contact='$contact', email='$email' WHERE 'index'='$id'"); $result = mysql_query($update) ?> </body> </html> [/CODE] |
| | [CODE]<script type="text/javascript"> function populateHarga() { var x=document.getElementById("barang").value; document.getElementById("harga").value=x; var y=document.getElementById('barang')[document.getElementById('barang').selectedIndex].innerHTML; document.getElementById('nama_brg').value=y; } function populateTotal() { var y=document.getElementById("jumlah").value; var x=document.getElementById("harga").value; document.getElementById("totalnya").value=x*y; } </script> <body> <p> <?php mysql_connect("localhost","root",""); mysql_select_db("stageco"); ?> <table border="1" cellpadding="0" cellspacing="0"> <?php $nama_b=$_GET['nama_brg']; $harga_b=$_GET['harga']; $jumlah_b=$_GET['jumlah']; $total_b=$_GET['totalnya']; if($nama_b!="") { mysql_query("INSERT INTO temp('t_nama','t_harga','t_jumlah','t_total') VALUES('$nama_b','$harga_b','$jumlah_b','$total_b')"); } $result=mysql_query("SELECT * FROM temp"); $i = … |
| | I'm a bit new to this so excuse my noobness. For the website I'm working on - I'm wondering about whether information like images, uploaded files, date of birth, edited details etc. can all be displayed on the same page (specific to the user who has logged in, not everyone … |
The End.