11,093 Topics
 | |
| | 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 … |
| | Using javascript, a field in an html form is formatted for time. When the user types in 344, the field formats onblur to 3:44. This field is then echoed in PHP an appears properly formatted. However, in the MySQL database it is inserted into, it appears as only "3". Everything … |
| | Lately I have been learning how to use 'sessions' (with some degree of success) for transferring parameters between pages. I have come across a new error report that is so weird that I would not be able to envision how I could do a Google search to find what is … |
 | Hello, I am having trouble with MySQL on a newly installed Fedora 14. I have found that there are several issues with MySQL on Fedora but none of the issues I have found have exactly fit my situation. To start off, when I installed Fedora, I chose the Web Server … |
| | i cant update... is there any error in it... i'm getting an error" you are using a safe updating mode.... please help me.... [CODE] UPDATE $tbl_name SET MUSE_RETRYCOUNT='0', MUSE_ISLOCKED='0' WHERE MUSE_LASTRETRYTIME <=DATE_ADD(SYSDATE(),INTERVAL -6 hour) [/CODE] |
| | i have a problem in query i have attached a sql for query and my searching code is following [code]<div> <form name="frm" action=search.php method=post> <select name="facilities[]" id="facilities[]" style="width: 130px;" multiple="mutiple" size="3"> <option value="17">Conference hall</option> <option value="16">Meeting</option> <option value="14">Danceing</option> <option value="15">Swimming</option> <option value="18">A/c room</option> <option value="19">Dining hall</option> <option value="20">Cooking facility</option> <option …  |
| | Hey guys, I'm getting the above error, could any of you tell me why? Here's the code [CODE]$mysqli=new mysqli("localhost", "***", "***","***") ; if(!$mysqli){ die("Database error"); } function checklogin($username, $password){ global $mysqli; $result = $mysqli->prepare("SELECT * FROM users WHERE username = ?"); $result->bind_param("s", $username); $result->execute(); if($result != false){ $dbArray=$result->fetch_array();[/CODE] |
| | This is not a homework assignment. :) I'm a MySQL newbie and we just bought a product that uses it. The vendor has indicated that what I want is a special request and wants to schedule professional services time (several weeks in the future) to write us a personalized script. … |
| | I'm currently building a website for a small charity and they've asked me if it was possible to make an admin area where they could access some of their work when they're out and about so they don't have to fill in forms twice. I can do this as I … |
| | Hi, I have been trying to execute a query and for some reason it returns 0 when there should be 1 in the result. [CODE] SELECT count(TaskID) AS DueToday FROM tasks WHERE TaskDueDate = CURRENT_DATE AND Completed = 'No'[/CODE] I have tried NOW() and various others reference [url]http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_current-date[/url] however it …  |
| | Hi, I am trying to create a group of html links that are dependant on two arrays. The data of the arrays is populated from a mysql database, here is my code: [code=php] <?php include_once 'title.php'; include_once 'checkuser.php'; if (isset($_GET['view'])) $view = sanitizeString($_GET['view']); else $view = $user; $sql = "SELECT … |
| | hi 2 all m new to mysql and want to make a table in mysql so please help me Table for Name Email Phone number Comment  |
| | hi when i check apache status there is too many line like 198-92 - 0/0/4 . 0.00 78719 0 0.0 0.00 0.00 127.0.0.1 noc1.server.com OPTIONS * HTTP/1.0 i think this is related mysql or not is there anyway to close this pid in 5min or 10min? [CODE]0-112 1881 0/16/24053 _ … |
| | hi, i have just applied a view to my database and when tested works fine if their is a value from the tasks and allrenewals tables of "clientID" or clients_ClientID however i need to be able to view the entries even if the clientid or clients_clientid from the 2 tables … |
| | Hello peeps! I really need a pagination for this code: [CODE]<body> <div class="myFiles-content"> <div id="myFiles-upload"> <table> <tr> <td class="login-form"> <form action="index.php?page=user_upload2" method="post" enctype="multipart/form-data"> <input class="button1" type="file" name="uploaded_file"><br> <input class="button1" type="text" name="description" maxlength="60" value="Description" onClick="this.value='';"> <input class="button1" type="submit" value="Upload"> </form> </td> </tr> </table> </div> </div><br> <table cellpadding="0" cellspacing="0" border="0"> <tr class="myFiles-thtable"> …  |
| | Hey guys, nice to meet you. I have PHP/MySQL driven site. I have finally found an AJAX script to load my data in a div on the same page. It works if i click a static link, but the main purpose i need is to click link with dynamic album … |
| | Hi, I have this question about how to retrieve a column with DateTime from MySQL as String and put the data in a textbox. :| So I've been using something like this... [CODE]Private Function check_ResitDate_ResitNumber() Dim SQLquery As String Dim rrnRD As OdbcDataReader Dim DiTi As DateTime SQLquery = "SELECT … |
| | im new to sql but long story short. just installed mysql server 5.5 and started the configuration and it failed to apply the security settings with error message 2003, cant connect to server on local host. so i cant finnish the installation and canot run mysql.exe. it just beeps at … |
| | Hi There! Our company became a reseller, and we didnt get the product info's in normal way (cd, email, xml, etc). So we have to go to their website and download all of the product infos (name, description, price, pictures) one by one. This could be fun if you have … |
 | Hi all, Im a bit stuck. I think im staring the answer right in the face but cant see it. Im after a query that references 1 table. Its output will be each unique source code along with a total of grouped data from a single column. SOURCECODE Count of … |
| | Hi, I have table structure as follows Table Name- facilities facility_id | hotel_code | facility_name 1 1 Parking 2 1 AC 3 2 Parking 4 3 Parking 5 3 AC 6 4 AC Now i have to find the 'hotel_code' that having 'Parking' and 'AC' both facilities ie 'hotel_code' as … |
| | Hi guys. I have previously been developing a Java application using 2 Windows Vista PCs that both have MySQL as the database. I have always created a user for each PC (specifying their IPs as allowed hosts to connect) on the other and then in the application the code for … |
The End.