7,368 Topics
| |
I am using MYSQL and php version 5.4.16.My table structure is as given below. I want to sort the temp_id cat_id and colors based on the cat_id as given in the second table. The com_id same values should not come at once. My Table is something like this: col1 col2 … | |
Recently I've need to do some table repair and got into my variables and noticed some bizzare numbers. For those of you that know MySQL, these may be familiar to you, so I'll just list the variables and values: max_join_size: 18446744073709551615 max_seeks_for_key: 18446744073709551615 max_write_lock_count: 18446744073709551615 myisam_max_sort_file_size: 9223372036853727232 myisam_mmap_size: 18446744073709551615 The … | |
Im using LOAD DATA INFILE to import a csv file, the files date format is 29/11/2010 and the database format is 2010-11-29, what can i use to format the date inside the query? I've tried str_to_date: `SET date_start = STR_TO_DATE(@from_date,'%Y-%m-%d'),` but that only inserts 0000-00-00 | |
Hey everyone, I'm looking for a free tool to administer MySQL databases. I currently use PHPMyAdmin, which is great, but I'm looking for the same functionality in a desktop software. I've actually found quite a few, but wondered if you any of you could recommend one for me. My only … | |
<?php include 'connectMySql.php'; $emri=$_REQUEST["emri"]; $mbiemri=$_REQUEST["mbiemri"]; $email=$_REQUEST["email"]; $data=$_REQUEST["data"]; $ora=$_REQUEST["ora"]; $nr_persona=$_REQUEST["nr_persona"]; $query="INSERT INTO rezervim(emri,mbiemri,email,data,ora,nr_persona) VALUES(' ".$emri." ',' ".$mbiemri." ',' ".$email." ',' ".$data." ',' ".$ora." ' , '".$nr_persona."')"; mysql_query($query) or die(mysql_error()); mysql_close($conn); ?> | |
i have a problem,i log in even though im not registered in database, please help me urgent!!!!!!!!!!!! | |
Hey I want to make a backup and restore of a MySQL **SERVER** to another machine. Please note the **SERVER** part; I want to backup/restore datebases, tables, procedures, users, configuration, etc....**EVERYTHING** What is the best way to do this? Thank you | |
I have an accommodation reservation system that allows managing agents to list all the properties under their control. There are various 'locations' that have a priority such as:- 'Beach Front' has priority of 1 and 'Off beach' a priority of 2 etc. Setting these are pretty much a straight forward … | |
<?php include 'connectMySql.php'; if(! $conn ) { die('Could not connect: ' . mysql_error()); } $sql = 'SELECT * FROM users '; $result = mysql_query( $sql); if(! $result) { die('Could not get data: ' . mysql_error()); } while($row = mysql_fetch_assoc($result, MYSQL_ASSOC)) { echo "ID : {$row['id']} <br> ". "USERNAME : {$row['username']} … | |
Successfully calculated TotalTime a person has worked and overtime he has done if total working time is greater than 08:00 but if not greater than it puts duration of time person has not worked in Overtime column BUT NOW overtime column should display that time in proper negative format e.g. … | |
I am creating a site and I am trying to put all the posts within a mysql database (phpmyadmin). How do i put articles/posts in the DB? | |
Hi I"m sorry that there is no code, it's just a question in my mind .. How can I sort the request results as rows.In every row 4 results then the next row 4 results and so on.? | |
Hello! I'm needing some help integrating HighCharts into my CodeIgniter application and getting data from my MySQL database! I've followed a YouTube video on actually integrating HighCharts and it was extremely straightforward. However, that method included a hardcoded array and I'm needing to generate an array from data stored in … | |
I'm retriving a youtube link from mysql db with this code <?php //echo $embed; $yt_url=$embed; function get_youtube_id_from_url($url) { if (stristr($url,'youtu.be/')) { preg_match('/(https|http):\/\/(.*?)\/([a-zA-Z0-9_]{11})/i', $url, $final_ID);return $final_ID[3]; } else { preg_match('/(https|http):\/\/(.*?)\/(embed\/|watch\?v=|(.*?)&v=|v\/|e\/|.+\/|watch.*v=|)([a-zA-Z0-9_]{11})/i', $url, $IDD); return $IDD[5]; } } $variable= get_youtube_id_from_url($yt_url); ?> and extracting the id part of the link and placing it in … | |
i am trying to generate pdf file using fpdf selecting data from two different tables i.e. table custreg and table slabpay, but getting MySQL error: "Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\inetpub\vhosts\kisan.net\httpdocs\greengold\exportpdf.php on line 124". Code: $strSQL = "SELECT custreg.mobno1, slabpay.ac_no, slabpay.cust_name, slabpay.install_no, GROUP_CONCAT(`slabpay.install_amt` … | |
HI Hope somebody can help. My query updates a colomn in tab1 from a row in tab2 but only if a colomn in tab1 is equal to that of a row in tab2. tab 1 has 360000 rows tab 2 has 477 rows The update query runs for ages and … | |
i have store an image into my database. but i am unable to display the image what i have done till now is under.... any help will be appreciated. thanks in advance! <? $query="SELECT * from testimonial"; $ret = mysqli_query($mysql,$query); if (isset($ret) && $ret->num_rows>0) { while($row=mysqli_fetch_array($ret)) { $body=$row['body']; $name=$row['name']; $image=$row['img']; … | |
ClassNotFoundException:com.mysql.jdbc.Driver | |
Hi! Anyone can help me about my problem on HOW TO UPDATE TABLE USING THE CONTENTS FROM ANOTHER TABLE? Thank you in advance for those who can help me. Anyway, I'm using VB.Net 2010 I hope you guys can help | |
Hi, I have 5 tables..a.b,c,d,e While doing equi join : 1)a.id=b.id, b.id=c.id, c.id=d.id, d.id=e.id a.id=c.id, a.id=d.id b.id=d.id How internally equi join works.should i need all PK to Join Could you suggest me some tutorial which shows how internally works. | |
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 | |
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, 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 … | |
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. |
The End.