11,093 Topics
 | |
 | Hello Community, I have recently been having a big of a look into connecting to a database using PDO but I'm not too sure what I should stick with, the normal way to connect to a MySql database or should I start using PDO. What would be better to use? … |
| | hi there, looking to get some help. i have created a view which pulls together from different product tables a review date. the thing is that a client could have review dates for the same product and i need it to only display the most recent review date. i tried …  |
 | If I had this: <html> <body> <form action="welcome.php" method="post"> Name: <input type="text" name="name"><br> E-mail: <input type="text" name="email"><br> <input type="submit"> </form> </body> </html> HOW DO I TAKE WHAT SOME TYPE INTO MYSQL. Do I create a table first ect. Examples pleases  |
 | I am using mysql_fetch_assoc to retrieve and display an array; This is what I recieve upon loading the page: *Warning: mysql_fetch_assoc() expects parameter 1 to be resource* I have researched it and do not understand it. **Snippet* while ($row = mysql_fetch_assoc('$result')) { echo $row["emp_name"]; echo $row["emp address"]; } Thank you, … |
| | please help me to display the multiple image from mysql this id my file for uploading multiple image $valid_formats = array("jpg", "jpeg", "png", "gif", "zip", "bmp", "pdf", "doc", "docx"); $max_file_size = 100000*100; //100 kb $path = "uploads/"; // Upload directory $count = 0; extract($_REQUEST); // Loop $_FILES to execute all … |
 | Hallo, I am trying to fix my mysql search query: $data = mysql_query("SELECT * FROM static_content WHERE upper(image) or upper(title) or upper(content) LIKE'%$find%'"); Please help me to fix it. Is it correct? I mean where column image (change to upper case) or column title (change to upper case) or column … |
| | Hi, below queries gives two rows like category_name high_value_complaints category_name high_value_duplicate_complaints I am trying to merge both queries category_name high_value_complaints high_value_duplicate_complaints I tried to join both tables but its giving category_name high_value_complaints category_name high_value_duplicate_complaints Need suggestions select category_name, count(distinct complaint3.id ) as high_value_complaints from complaint_category,assignment3,user3,complaint3_details, complaint3,complaint_tag ct where complaint3.complaint_category_id=complaint_category.id and … |
| | Hi All, I'm battling to get this query to work. I have a select form that allows user to select dates. When he submits it it needs to remove weekends from the request. $DateStart='2013-09-01'; $DateStart='2013-09-05'; $DateSTR=strtotime($DateStart); $DateSTO=strtotime($DateStop); for($i=$DateSTR; $i<=$DateSTO; $i++){ $NewDate=strtotime($i); $DateCalc=date('D', $NewDate); $TotalCount++; if($DateCalc == 'Sat' || $DateCalc == … |
| | Hi, I have mysql database dump xxx.sql How can i convert xxx.sql to xxx.csv? Thanks  |
| | I am using MYSQL MYISAM and php version 5.4.16,MYISAM and am doing a fulltext search based on the (product_name) column and i want to randomize the result but the problem is rand()not giving the random values. I tried something like this: SELECT `product_name`,`main_cat_id`,`sub_cat_id`,`prod_cat_id`,`prod_short_desc`,`com_id`,`product_id`,`product_ratings`, `min_order_quantity`, `fob`,`country_id`,`company_name`,`attributes`,`attr_values`,`verify`,`image`,`product_additionals` , MATCH (`product_name`)AGAINST ('"girls top"'IN …  |
| | Hi. I have a mysql field with a record like: [2,5,11]. I have a query like: $query = $this->select() ->from($this->_name) ->where('id = ?', $id); This query work if record is of integer type: 5. Is it possible to create a query to find 5 in the array? Please advise. Thanks. |
| | hi..please help.. i have 2 tables tblStudents and tblGrades. in tblStudents, all details of students and in tblGrades, grades of the students. column "StudId" is their only common column.. in tblStudents: StudId LastName FirstName in tblGrades: columns are: StudId SubjectCode Grade what i want to achieve is to query on … |
| | I am converting a PHP application from MySQL to PostgresSQL. The MySQL works flawlessly. The database for this application is a one to many relationship. I have a while loop nested inside another while loop <?php while ($movie_row = pg_fetch_array($movie, PGSQL_ASSOC)) { ?> [html code to echo various elements of …  |
| | Hi Can I use the ajax to update a form feild by get a value of another feild on the same page(without submiting the page). This process involves the mysql as well.  |
| | Hi I'm creating a website that uses a count query, to see how many things in the database match a variable. Table eg: Whats Liked User Liked By potatoes djiajgi computer djiajgi ......... Now, I'm trying to see people who like the same thing as you do, and am ordering …  |
| | I got a product table like this id | name | category 1 | name1 | 2,1,5,8,9 2 | name2 | 2,1 3 | name3 | 5,8 And I got a category table like this id | catname 1 | cat_name1 2 | cat_name2 5 | cat_name3 8 | cat_name3 … |
| | how to disply mysql table data on same form and also edit update and delete these data on that form in wordpress |
| | hi.please help me with mysql query. i have a table tblGrades with fields ID, Subject, Remarks. how can i create a stored procedure that will display the students that have subjects(user input) and Remarks='Passed'? the Subjects will depend on the user, therefore it may be one or two or three … |
| | Hi, I'm creating a website where users can liket things and by liking things you'll see people who have liked the same thing on your home page. Now, currently my code shows people who like ONE same thing as you, but how would I make it so that if anyone … |
| | Ok,I havent a clue how to do this. I have a mysql table for products, each has id as the primary key. I have an admin page where I upload products to this table or delet/hide them too. But I want a way where when I'm uploading the products to … |
| | I would love to know whether this code is the correct manner to send mysql data to a remote database. $host = 'www.domain.tld'; $user = 'remote_user'; $pass = 'remote_password'; $time_end = microtime(true); //grant per;misions to connect to remote host if (!function_exists("ssh2_connect")) die("function ssh2_connect doesn't exist"); // log in at server1.example.com … |
 | How to count data from field name .Fields("findings") and txtcount.text will hold the answer...Please help..I almost forgot to count data from database..Haha |
| | HEY THERE! COULD ANYONE HELP ME WITH THIS? THIS CODE DOESN'T HAVE AN ERROR BUT MY PROBLEM IS NOTHING DISPLAYS ON MY TEXTBOX. I WANT TO GET THE VALUE FROM MY MYSQL DATABASE TO TEXTBOX. Is there another way to do? dbcon = getconnect() dbcon.Open() cmd = New MySqlCommand("select * …  |
| | how do i stop user inserting duplicate records INSERT INTO person_tbl(person_name,person_status,creation_time,modified_time) VALUES ('$person',$status,$ctime,$mtime) WHERE person_name NOT IN(SELECT person_name FROM person_tbl WHERE city_name='$person'); |
 | Hi, I have here a code for saving a pdf file to mysql database as blob. may problem is how can i retrieve pdf blob in php. thank you. <?php if(isset($_POST['add']) && $_FILES['filename']['size'] > 0) { $fileName = $_FILES['filename']['name']; $tmpName = $_FILES['filename']['tmp_name']; $fileSize=$_FILES['filename']['size']; $fileType = $_FILES['filename']['type']; $fileType=(get_magic_quotes_gpc()==0 ? mysql_real_escape_string( $_FILES['filename']['type']) … |
| | |
| | Hi all, I am not sure if I am in the right place. But I don't know where to start. I had a web page that was working properly, almost at the end of a year of work (housweb.com). Last week, I tried to work in a different site, diferent …  |
| | Hi, I stored hindi data in my my sql table through Php form. While fetching,it is not coming in hindi but some unusual symbols like गिरधर गोपाल रायतानॠis coming. using below code also [CODE]mysql_query('SET character_set_results=utf8'); mysql_query('SET names=utf8'); mysql_query('SET character_set_client=utf8'); mysql_query('SET character_set_connection=utf8'); mysql_query('SET character_set_results=utf8'); mysql_query('SET collation_connection=utf8_general_ci'); [/CODE] Need help.. |
 | THIS IS A NO GUI TEST. GUI COMES AFTER THIS IS DONE. " i hope to learn from this so i can use it on the gui " :D i have my database : friends , table : info , values : (name ) : dragon , (address) : china …  |
| | Hi, I have a table: user uid status 1 1 2 1 3 1 4 2 5 2 6 1 7 2 8 1 9 3 10 2 I am trying to fetch data for below logic: 1) fetch top 6 rows having status=1 2) if status=1 has less then … |
 | I'm trying to create a dropdown list in a HTML form populated by results for a mysql query. However it is not loading and i am just given a white screen. $query = mysql_query("SELECT eventName from sgt")or die(mysql_error()); while($row = mysql_fetch_array($query)) { echo "<option value=\"$row['eventName']\">" $row['eventName']"</option>"; } Any help would … |
| | <table width="200" border="1" class="form_table"> <tr> <td>Driver:</td> <td><select name="driver" class="driver" id="form_name" > <?php do { ?> <option value="<?php echo $row_Driver['id_driver']?>"><?php echo $row_Driver['driver_fullname']?></option> <?php } while ($row_Driver = mysql_fetch_assoc($Driver)); $rows = mysql_num_rows($Driver); if($rows > 0) { mysql_data_seek($Driver, 0); $row_Driver = mysql_fetch_assoc($Driver); } ?> </select></td> </tr> <tr> <td>Waybill:</td> <td><select name="select" class="waybill" id="form_name" ></select></td> … |
| | I have been researching this as I am getting the distinct feeling I will have to transition my code to this soon, eventually. From your experience, can someone provide a brief overview of the benefits of MySQLi and why I should transition. Is it even necessary? I'm not sure. Any … |
| | I have database with Name, email, joindate and my Query is $name=$_POST['txtname']; $email=$_POST['txtemail']; $date = date("Y/m/d"); INSERT INTO member (name,email,joindate) VALUES ('$name', '$email', '$date') What should be the output query to get all data by month? |
| | Hi, I have around 4 lakhs email id data(In CSV). I want to change status of above emailids. Could i run a simple update query or do something more. Need Suggestions |
| | i need to create a search button for my vb 6.0 to mysql database search that when data is entered in textbox1 (user id), then textbox2 (fname) and textbox3 (lname) feactes data |
| | Hi I wrote this code and I hope that you can tell me what is wrong with it .! $sql = "INSERT INTO offers (title,description,location,type,status,img,real,username) VALUES('".$title."','".$description."','".$location."','".$type."','".$status."','".$img."','".$real."','".$username."')"; $query = mysql_query($sql) or die(mysql_error()); The error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL … |
| | Below tables :I am trying to calculate **openLeadsCount** having status 1 I tried but getting wrong results SELECT COUNT(lead.id) FROM lead JOIN lead_status ls WHERE ls.lead_id=lead.id AND ls.id=(SELECT MAX(id) FROM lead_status lst WHERE lst.status=1 ) Lead table: id created_on 1 2014-1-13 2 2014-1-18 lead_status table id lead_id created_on lead_status 1 …  |
| | Wordpress - I want to use a title condition for displaying info on a page, from a MySQL table "country". The condition must compare the title with the names in the column "name" and when it match a value than display on the page the text from column "description" from …  |
| | Dear, I make a php page to upload the images, pdf, swf etc etc for specific orginisation entered in same form. In the form i made the input type files to upload a maximum of three files but i know how to upload one of them only. here i upload … |
| | Hi, I am using timestamp datatype for storing date..and value of column is like 2013-12-31 T 23:59:59.000Z For query SELECT * FROM a WHERE created_on BETWEEN '20131201' AND '20131231' SELECT * FROM a WHERE created_on >= '20131201' AND created_on <= '20131231' Which will give right result?? |
 | Hello. I am having a hard time in figuring out how to view the pdf file after uploading it in your system. My plan is retrieved PDF files that is stored in mysql database and display them in the browser when the user click the view button. please help me. … |
| | I am having a problem on notifying the user when he/she submit a empty form. When I submit an empty form, the system doesn't notify or alert the user that the form is empty. And when I put a title and I leave the content textbox empty its still add … |
 | Ok, so I'm working on a web-project, I connected a custom hanlder to the root Logger in `contextInitialized()` of a ServletContextListener: @Override public void contextInitialized(ServletContextEvent sce) { Logger def = Logger.getLogger(""); Handler hand = new DatabaseLoggingHandler(); hand.setLevel(Level.WARNING); def.addHandler(hand); } which looks like: import java.io.PrintWriter; import java.io.StringWriter; import java.util.logging.LogRecord; import java.util.logging.Logger; … |
| | Hi, I am trying to merge below two queries in a single query such that company_id,company_name,noOfOpenTickets,noOf PendingTickets Need suggestions?? No Of open Tickets: select c.company_id, (select company_name from company where id=company_id) as companyName,count(s.complaint_id) as noOfOpenTickets from complaint3 c ,complaint3_status s where s.id =(select max(d.id) from complaint3_status d where d.complaint_id =c.id … |
| | Hello Everyone, I have to create a temporary table for basket. I have to include certain fields from different table. Now I know the code to create a temporary table "CREATE TEMPORARY TABLE", is that right? But I dont know how to choose different fields from different table. Let me … |
| | Read first row from csv file and create table automatically according to it(csv file fields) in mysql. Looking for PHP script? I have tried this. <?php $arr = array(array(),array()); $num = 0; $row = 0; $handle = fopen("./contacts.csv", "r"); while($data = fgetcsv($handle,1000,",")){ $num = count($data); for ($c=0; $c < $num; …  |
| | Hi, I want to do like: 1> [COLOR="Red"]browse file and upload .xls file only[/COLOR] (Not csv or other format) 2> save into mysql database. Any sample demo example?? Or link please? |
| | Hello guys, i have been working on a new script that will import data from a TXT file to mysql. Using this code works ok: $sql = 'LOAD DATA LOCAL INFILE 'logons-16-12-2013.txt' INTO TABLE pcvsuser COLUMNS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\\r\\n''; But if i … |
| | Hi I'm working on a function and it was working good until I had an error that tells me I should swich from mysql to mysqli so I did swich but I'm having a lot of errors ! (the function is working fine but I have a lot of errors!). … |
The End.