10,940 Topics
 | |
 | Hi, i need some help, since mysql benchmark don't work well on select i need help with a query what will be the fastest way? to use this query: [code]select * from news n, users u where n.users_id = u.users_id and u.users_id = '1' limit 0, 20[/code] using like this … |
| | How do I format the links from a mysql query to show [U]click here[/U] on my webpage. $row['reviewlink'] (eg of reviewlink = [url]http://www.abc.com[/url]) I want this result to show in the html source code: <a href="http://www.abc.com" >click here</a> So the page shows [U]click here[/U] and links to [url]http://www.abc.com[/url] I want … |
| | I've been trying for a few hours now, and to be honest I'm getting fed up of it not updating the table!!!:icon_sad: [CODE]$sql="UPDATE list SET title='$_POST[title]', console='$_POST[console]', system='$_POST[system]', tv='$_POST[tv]', sram='$_POST[sram]', chips='$_POST[chips]', size='$_POST[size]', md5='$_POST[md5]', sha1='$_POST[sha1]', work='$_POST[work]', error='$_POST[error]', retrode='$_POST[retrode]', comments='$_POST[comments]' WHERE ID='$_POST[id]'"; if (!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); } echo "1 … |
| | This is the part which searches and add the result to the 'pass' variable. At one stage I was getting a resource id number and found to get around that, but when I do this I get nothing on the pass variable [code] $result = mysql_query("SELECT `Pass` FROM `wiki` WHERE … |
| | Hi all, I hope you are well. I have a very quick question for you please. I have a table with x rows and y columns. I need to select the top 100 rows ordered by col2 for eg. Further, I need to select only one row for a particular … |
| | Ok back again. lol I just purchased a new hosting provider and was trying to transfer my database over to my new site. I exported the tables using Navicat and "tab" as the delimiter. I have three tables and they all saved as text files and look fine when I … |
| | Hi, Please let me know whats wrong with syntax of the following query, its written in MS Access format: Select count(*) from [Demographics/Job Data Table] D1 WHERE EXISTS (Select (*) from [Demographics/Job Data Table] D2 where [D2].[Supervisor ID] = [D1].[Employee #] and [D2].[Termination]=Yes) I am getting a syntax error message … |
| | how to insert and retrieve a 20mb pdf file from mysql database? |
 | Hi all I have a table that has a datetime column. What I'm trying to do is select the time only like one does when selecting only the day or month from a date column (eg SELECT day(date)) Can anyone tell me how to get this right. Using the following …  |
 | HI All, my requirement is as below: lets product name is "aaa bbb ccc". Now in search coding i have use LIKE statement. [CODE]"... where product_name LIKE '%".$keyword."%'"[/CODE] Now when user insert 'aaa' or 'bbb' or 'ccc' or 'aaa bbb' or 'bbb ccc' search works. But if user insert 'aaa … |
| | Hi everybody, I wanna make a simple leads form in php, this form has three fields. the first field is "code", the second one is Name and third is e-mail. the issue is that i have two tables in my database and i want in one hand store all this … |
| | Hi, Im having a problem with this image uploading thing..:( I was able to upload the image to a folder in the server,but the problem is I dont know how to set the path in the database.Every time after uploading I set the path manually.And I could be able to … |
| | Dear all, I have some table on my database. i had input them via JSP and i view them on JSP too. i use simple MySql queri in it to view the values of the Table. But when i use another query like : [CODE] SELECT tabel_jawab.nis, CASE WHEN (tabel_jawab.jwb1=tabel_kunci.Kjwb1) …  |
| | I use a couple of functions to which I have to pass the name of the mysqli connection in order to fetch some data. Is it safe to use a global variable for the mysqli connection to skip passing the connection name to the functions?  |
 | I want to upload and store images in MySQL database, but have no idea. Please help me out? Thank you |
| | I have my website up and runnng succesfully with around 5000 member - [url removed] Now I want to start a Social Networking option for members using a CMS - like Wordpree-WU, Drupal, Joomla, SE ... How can I use my current users databese to these CMS database? Please help … |
| | hello all i'm using cUrl and mysql in PHP but new to c++ for connecting to remote mysql database and run query what i need? should i install mysql connector? where are mysql libraries? may i download a large file for example 400 mb in c++ using cUrl ? i … |
| | i want to use federated tables in my db and not sure how to set them up in phpmyadmin...? does anyone have a solution for me...? |
| | How exactly do I transfer data from my local server to my remote server. I had been using Navicat, but want to do it using myPhpAdmin, if possible. Thanks for any help in advance. |
| | Hey guys, I'm a total newbie with this PHP stuff but i'm stuck with my page that allows people to sign up to my mailing list. Every time you press the "Submit Query" button on the form it brings up the option to download the php file. Have been working … |
| | I have a table with 3 columns, a record_num, a date field, and a description. In the date field there can be some rows that have a distinct date and others that have the same date. I wanted to take a look at all the rows that have dates that … |
| | Hello guys, I am having a weird problem. I cant understand and i have spent almost 2 hours in finding the problem. Well,Actually I have a table of id,date,comment. id and date are composite primary key. so id always starts with 1 everyday. now i want to find the max … |
| | Hi I m using xampp latest version. I have a table created by phpmyadmin. Now I want to delete all data form the table, But dont want to drop the table. Problem is that... When I click oncheck_all it select all checkbox. but some row r yello background. When I … |
| | Hi, I need to print all the orders with the month in the Monthly Order Report.How should I do it.Can someone tel me how to do it... This is my query.Order date should equal to the relavent month... [code] $this->result = mysql_query("SELECT * FROM tbl_order,tbl_order_items WHERE tbl_order.order_id=tbl_order_items.order_id AND tbl_order.order_status='accepted' AND … |
| | Hi frnds, I need display mysql field as check box value. <?php mysql_connect("localhost","root",""); mysql_select_db("postal") or die(mysql_error()); $query = mysql_query("SELECT name FROM register"); while ($row = mysql_fetch_assoc($query)) { $tag = $row['name']; echo "<input type='checkbox' name='register[]' [U]value='$tag'[/U] />\n"; } ?> here i paste my code here. it displayed only checkboxes. not value.any … |
| | Greetings, I installed MySQL 5.1.48-2 on Fedora 13 64bit. Whenever I tried to connect using the terminal by typing : [B][user@work ~]$ mysql[/B] I get the following error: [B]ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)[/B] I also installed MySQL on Red Hat Enterprise 5 … |
| | Hi, I'm an experienced developer but not done much in c++ and wanted to get some basic database operations in my program, open, store, retrieve etc. Does anyone have any good links that could get me started? Thanks Baden  |
 | I just got postgresql & pgAdmin III up and running. I'M trying to start the book "Simply SQL" so how do I go about getting to .sql files for the book into pgAdmin? Thanks for any and all replies. |
| | how do i run a query for a variable with multiple values? i've been told a loop is not the right way to do it, which is the way i've been doing it and it has worked. I assumed putting it in a foreach loop would accomplish looping the query … |
| | hi all, i have a little issue with SUM query from this table UNIQUEID Date Production engine1 01/12/1999 1440 engine1 01/01/2000 6061 engine1 01/02/2000 5152 engine1 01/03/2000 5347 engine1 01/04/2000 4642 engine1 01/05/2000 5264 engine1 01/06/2000 5247 engine2 01/07/1995 561 engine2 01/08/1995 3066 engine2 01/09/1995 2133 engine2 01/10/1995 2282 engine2 … |
The End.