[query] Forum Topics

i am trying to get all the result from my databse table but this query is not working. <?php try { $pdo = new PDO('mysql:host=localhost;dbname=articles', 'Avik', ''); } catch (PDOException $e) { $output = 'Unable to connect to the database server.'; echo $output; exit(); } try { $sql = 'SELECT …

Hello Friends, I have a table which says stores 4 values id,publisher name,bookname,time I am firing query like SELECT * from table where time>='sometime' group by `publisher name` order by time DESC What I want is to select results in DESC order of time with unique publisher name. When I …

Hi , I am working on a list : Name Town Street House ID_Number Marco Valletta Triq l-Ajkla 10, Fl 1 53290M Mary Valletta Triq l-Ajkla 10, Fl 1 4748M Victor Valletta Triq l-Ajkla 10, Fl 4 37867M Krystle Valletta Triq l-Ajkla 14, Fl 1 52467M Mariella Valletta Triq l-Ajkla …

Hi! Can anyone know the result of this query: SELECT COALESCE(MAX(ID),0) + 1 FROM Table123

for($i=1; $i<=($jumlah_row_tabel_atas+1); $i++) { $satuan = $_POST['PP_row_'.$i.'_satuan']; $word_2[$i]="SELECT id_unit FROM manage_unit WHERE name_unit = '$satuan'"; $q[$i] = mysql_query($word_2[$i]); $data_X = mysql_fetch_array($q[$i]); $id_unit = $data_X['id_unit']; $harga_1 = $_POST['PP_row_'.$i.'_harga_1']; $harga_2 = $_POST['PP_row_'.$i.'_harga_2']; $harga_3 = $_POST['PP_row_'.$i.'_harga_3']; $id_drug = $_POST['id_drug']; $value = $value_array[$i]; $word="INSERT INTO relation_mu_and_unit (id_drug, id_unit, priority, value, harga1, harga2, harga3, last_edit) …

Hi All, I want to get all the IPs of the A RECORDS for **mail.google.com**. The aim is to deny access to these IPs. I learnt that mail.google.com has several IPs. I did the following steps: 1. whois google.com 2. I got the following as its DOMAIN SERVERS: ns3.google.com ns2.google.com …

I'm working on making a user maintenance system for my class, I have created the add/delete user portion but as for the edit portion I am completely stumped. So far I have created the form but what I want to do is be able to hit find user and then …

Hi Everyone, I am needing some help with a wordpress insert query. I have this update query $qry ="UPDATE `".$wpdb->prefix."comments_real` SET `comment_country` = '$country',`comment_number` = '$phone',`comment_smvcode` = '$ref' WHERE `wp_comments`.`comment_ID` =$comment_id"; how do I change this to insert a new record in a db table called "comments_real" Thanks in advance

what will be result of the following ? "$qry_expirydt="SELECT ('".$stdate."' +INTERVAL ".$day." Month) as expirydt";" especially explain about (+INTERVAL) and (Month) used in the query ???

Dear Sirs, I would like to ask you, if you know any solution, for querying a servers mysql database without phpmyadmin rights, for example, querying it from the website itself with a server side solution. To be a bit more specific, here is what I would like to query on …

i have four tables (1) tbl_module: modNo | modName _ _ _ _ _ _ _ _ 1 | module 1 2 | module 2 (2) tbl_subject subNo | subName | modNo _ _ _ _ _ _ _ _ _ _ _ _ 1 | a1 | 1 2 …

I have an array ($arr) of arrays ($ar) in which I want to describe the columns in a report. The salient elements include the column headings and the MYSQL field to use: Array ( "City", 12, 29,"Y", "City_date", "City_Total" ), Array ( "Atmos", 8, 23, "Y", "Atmos_date", "Atmos_Total" ), etc. …

OKay so this my have been asked before but I have more of a general question than an issue. I don't understand Mysql_num_rows() becuase I don't have any information within my database table so the number or rows should be 0 but what happens is I get an error and …

i have two tables (they are fixed, not going to update any more) in my databae "phoneadd" phone_nos----name(primary id),home,office,college,friend. Examble: john 87954 45698 78965 12365 martin 45698 78962 45789 45789 trull 47896 14587 85632 14563 addresses----name(primary id),address Examble home first street,new town office second street,old town college thrid street,maxi world …

hi there, I have a hidden field in my page which i need to transfer to another page as request query string/paraameter. It works perfectly in IE and in chrome. When i try in Mozilla the value of the req string is always undefined. Can any one help me out. …

select e.employee_id from employees e where (select count(*) from employees f where f.employee_id < e.employee_id) < 5; The above query gives me first five employee id's. I want to know about the output produced by the sub query and explain. Thanks in advance.

Posted earlier in the wrong forum...update here: Hey there...my code below had tradtionally only updated 1 of 4 fields. Now I want to update 2 of 8, but when I enter two variables it crashes. Any help would be appreciated. Code is here if( isset($_POST['Submit']) && $_POST['Submit']=='Submit' ) { foreach($_POST['CFHL_A'] …

I have a very small sqlite3 database with one row consisting of three columns but I can get the page to display the row to save my life. So far all I've been able to get the page to display is the first column of the one row that's in …

while (rs.next()) { System.out.println("Name: "+rs.getString(1)+"\n"); System.out.println("Age: "+rs.getInt(2)+"\n"); System.out.println("Address: "+rs.getString(3)+"\n"); } I just don't understand what is the meaning og getString(1)

I have a page on my website that has three columns of images. I want to use responsive web design to resize it, so that when the screen gets smaller, it becomes two columns, and when it gets even smaller, the design should become 1 column. I want to use …

The below code displays correctly, I need an "IF" statement that prevents displaying rows with 0% in the percent column and I've tried several conditions. None are working. I only want to display rows that has at least 1% in the percent column. Here is the code: $result = mysql_query("SELECT …

Im trying to create a Log in system, Using VB.net 2010, im having a hard time creating a query for the username and password, and also how to make it case sensitive. please help me,...thanks.

Hi, i want to create a query which select three columns from a table on certain condition now i have got certain with three columns and i can bind this data to a datagridview but before this i want to add a column to dgv say col_new and fill its …

Dear All, I have 2 tables one tblAssociate and tblData. The link between them is one to many. My search will be based on date time range where if I find even one data in tblData between the set range then I want to show the tblAssociate data. So I …

Hello, I am doing some search in which my requirment is to search between specific dates. Like user can put start date and then end date. Once submit then it should find result between these two dates. [QUOTE]Select from table where date1>2001-01-05 And date2< 2001-02-05.[/QUOTE] Will this above statement will …

I have a database that contains multiple comments. Each comment has their own ID. I want to select 5 comments from the database, store the last comments ID into a variable and then select 5 more comments at a later time. When I collect 5 more comments at a later …

Hi fellows i want to know how can i update all products once by using sql querry in opencart

I have a mysql query that seperates an array of variables and uses each variables to compare inside the database. The query uses a OR clause and I want to make it so it can also use an AND clause. The trick is I want the left side of the …