10,940 Topics
 | |
| | I experiencing problem in executing query on between date command. I got wrong result. [CODE]SELECT approval_date FROM itemdetail WHERE approval_date BETWEEN '01/01/2011' AND '15/01/2011'[/CODE] My Record in Mysql Database: |Approval Date| 05/01/2011 10/12/2010 12/12/2010 15/12/2010 10/01/2011 |Result| Like above Need result |Approval Date| 05/01/2011 10/10/2011 Anyone could help me. how … |
| | I want that mysql data will be in one row but it doesn't, in my case data echoes in a right down side :( [URL="http://lashatt.comoj.com/php+mysql.php"]http://lashatt.comoj.com/php+mysql.php[/URL] [IMG]http://lashatt.comoj.com/mysqlproblem.JPG[/IMG] [CODE=php]<?php $user="a7247794_a724779"; $password=""; $database="a7247794_testdb"; mysql_connect("mysql5.000webhost.com",$user,$password); @mysql_select_db($database) or die( "Unable to select database"); if (isset($_POST['saxeli'])) echo "saxeli {$_POST['saxeli']}"; $a = $_POST['saxeli']; $query = "INSERT INTO … |
| | First of all i'd like to say hello to everybody. I've been working upon a script and i seem to be facing a problem with a mysql_query. Here it goes: I have 2 tables on my data base and there are some html forms through which tha data is entered …  |
| | i am writing a program and i need to increment a table row. How would i increment a table row on the click of a button? |
| | First of all i'd like to say hello to everybody. I've been working upon a script and i seem to be facing a problem with a mysql_query. Here it goes: I have 2 tables on my data base and there are some html forms through which tha data is entered … |
| | Hi All, I have made a dynamic form details content table where the data is storing by comma separated values.All the form fields are stored as dynamic in the table. Fields : [CODE]n1_First_name,n2_bank_aaccount,piriod_to,n5_comments_by,n6_like,n7_comments[/CODE] Data: [CODE]nil@nil.com,test1,4-May-2010,test2,no,abc nil@nil.com,test1,4-June-2010,test2,no,abc[/CODE] Now as you see this field "piriod_to" refers to 4-May-2010 and 4-June-2010.....till now its … |
| | I am new to this so please excuse any errors but does anyone know why... I have a function which is called and 3 arguments passed [CODE] identifychannel(centre_code, company_class, stock_type) [/CODE] the function tests centre_code to return channel and where appropriate 'else' tests another argument. problem is this... If I … |
| | Hi, I have tried to Google this but cant find anything. I want to use a select AS statement to select multiple columns. i.e. [CODE]Select unitno country price AS propertyref[/CODE] is this possible using multiple columns AS one reference? many thanks |
| | I am creating a website that is going to allow customer's to view photography on the site and purchase it when selected for download. I have created all the php and mysql to be able to display the data correctly. But... to display the search results or recordset, how do … |
| | i have a register and a log in page and it will not work. Here is the script for the register:[CODE]$myusername=$_POST['user']; $mypassword=$_POST['pass']; $cleanpwd=md5('$mypassword'); $myusername = stripslashes($myusername); $cleanpwd = stripslashes($cleanpwd); $myusername = mysql_real_escape_string($myusername); $cleanpwd = mysql_real_escape_string($cleanpwd); $sql="SELECT * FROM $tbl_name WHERE email='$myusername' and password='$cleanpwd'"; $result=mysql_query($sql); $count=mysql_num_rows($result); if($count==1){ setcookie('username', '$myusername'); setcookie('password', '$cleanpwd'); …  |
| | Hi, I have a successfully working system at the moment where a user can choose a file and upload it to my MYSQL database as a BLOB, but before the image gets saved as a BLOB I want to resize it. I have been giving this a try by using … |
 | Im new at PHP but learning fast, I need help on getting the mysql result into the $imagedir value [CODE]//Select Query for images from db $query="SELECT id, fld_imagename FROM tbl_banner"; $result = mysql_query($query) or die(mysql_error()); //Loop to get path from query while($row = mysql_fetch_array( $result )) { $mydir = "imge_uploads/".$row['fld_imagename']. … |
| | i have two tables like this i want retrive cname from person where cid duplicated at per_db and did at per_db=$value i want sql statment return "wael" from person person cname | cid ----------- gamal | 1 wael | 2 samy | 3 ------------- per_db cid | did ---------- 1 … |
| | Hi there, I have two tables. The first one holds information about cities: Locations: [code] locID | locationID | locationName | countryCode | 1 | 2922239 | Berlin | de | 2 | 291074 | Paris | fr | 3 | 295522 | Orlando | us | 3 | 292345 … |
| | Hi Guys, I have a predicament here which I think is really easy if you get it right. I just cant wrap my brain around it for the moment (probably been staring at the screen too long) I have two table (financial data) Table 1 looks as follows id account … |
| | Hi Guys, I am building a social networking site that is dedicated to nightclubs and night events. Among other tables, I have a users table, events table and establishments table. I am really intrigued with how Facebook in particular is able to query and return matches of not just users … |
| | I have created a register page which send the data of user from that page to my query processing page. [b]Problem is some of my database table field takes integer value but through post i get only string values i try to change them through type cast but not good … |
| | Hi Guys I have been all over the web searching for an answer. Hope someone can help me. I have a script with the following: $total_crt //total available credits (taken from mysql database using php) $credit // Display an ad credit. (also stored in mysql database using php) select dropdown … |
| | Hi everyone! I recently created a MySQL table that has three columns: (1) integer ID (2) integer num1 (3) integer num2 Now, I have a C program that waits for the user to input an integer ID and when there is an input, the corresponding num1 and num2 in the … |
| | Hi Guys, Back again. I'm having an issue with my java with mysql. I have the following query generated through my java, which reads in about 3k records from an excel file and churns out an sql query for me. For the purpose of this forum, ill show the first … |
| | I have this email newsletter field that works. I just dont want the person to be directed away from the page they are on when they submit the form. Is there a way to process the form then have a window pop-up saying: Thank you for submitting $email! My HTML … |
| | I have a small problem with a code snippet for a random display of images on a page... first off I have a table that has 10 records, only 3 of them have pictures, I need the pictured records to display randomly... I can get a random display of ALL … |
| | I have ordered yahoo news rss, I use simplepie to separate the news items like title, content, url, date... and then insert them into database. I catch the source every 2 hours with cron. How to judge RSS source, if there has new then UPDATE into database? I mean if … |
| | How to save ITEMS on listbox to MySQL Database in vb.net.... plz reply... |
| | I want to select some rows from my database SELECT * FROM searches WHERE campaign_id = 49 Then insert all that data (except the autoincrementing id column) back into the database, changing "49" to "50" is that possible? |
| | Ok, i have a couple of questions. I am learning php and i built a log in and a register page. When u register it auto-increments the id row and the user name goes to row "user" in a mySQL database. now how would i make it so it says … |
| | i have table users in my database))the host of my website is in US and i am currently leaving in Russia. so when i display date/time in web page it shows time as if i am in US also my clients in different countries they are experiencing the same problem.\ … |
| | Hey guys, I'm a newbie to mysql and wanted to know how can I connect 2 tables together with a many-to-many relationship. This is what I have. [CODE] create table pharmacy ( pharmacy_id int not null primary key auto_increment, businessName varchar(25) not null, location varchar(25) not null ); [/CODE] [CODE] … |
| | i am using these codes to generate linear graph from mysql... <?php ini_set('display_errors', 1); error_reporting(E_ALL); session_start(); //if(isset($_SESSION['user'])) { //function generateGraph(){ include('connectsml.php'); //include('jpgraph/src/jpgraph.php'); //include('jpgraph/src/jpgraph_bar.php'); include ('jpgraph/src/jpgraph_line.php'); include ('jpgraph/src/jpgraph_log.php'); //dapatkan nama ladang; $ldgcode=$_POST['ldgcode']; $year=$_POST['year']; $sqllsblock="select * from ladang where ldgcode='$ldgcode' order by block"; $reslsblock=mysql_query($sqllsblock); if ($rowlsblock=mysql_fetch_array($reslsblock)){ do{ $data[] = $result['yield']; $y2data[] = … |
| | Hi all I'm writing a wpf app that requires a user to log in. I thought this would be a pretty easy thing but it's hurting me. I can't find any error, I'm hoping someone can point out the silly mistake I made or the obscure gotcha I wasn't aware … |
The End.