10,940 Topics
 | |
| | 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 …  |
The End.