Search Results

Search found 58168 results on 2327 pages for 'mysql real escape string'.

Page 165/2327 | < Previous Page | 161 162 163 164 165 166 167 168 169 170 171 172  | Next Page >

• query mysql table and fetch rows posted in 3 days

  - by Mac Taylor

  Hey guys how can i query my mysql database and fetch rows which are posted in earlier 3 days i know how to fetch todays's rows but not 3 days ago time will save in my table like this : 2010-01-20 19:17:49 and this is what i know : SELECT id FROM pages WHERE date=now() but i need to show posts in 3days and im looking for a simple and straight solution ,because i know how to do so in long php codes

  Read the article

• How to sort MySQL query by two columns

  - by user334269

  The following is my DB data, how can I sorting it by sid and prev_sid with php/mysql!? sid prev_sid type 000 197 app_home 197 198 page_teach 198 218 page_teach 199 211 page_step 211 207 link 218 559 page_step 559 199 page_step Result: sid prev_sid type 000 197 app_home 197 198 page_teach 198 218 page_teach 218 559 page_step 559 199 page_step 199 211 page_step 211 207 link 000 197 198 218 559 199 199 211 207

  Read the article

• Time not entered in mysql ? Java

  - by Nitesh Panchal

  Hello, I have a datetime field in mysql table and i am using JPA for persisting data but only date goes in database. Time always shows 00:00:00. What should i do? I am not doing any manipulation with Date. All i do is to assign new Date() to a variable and store it in database. What am i doing wrong?

  Read the article

• mysql procedure call in codeigniter

  - by ASD

  Any simple example of mysql stored procedure and example to show how to call that procedure from codeigniter php. Any help?

  Read the article

• Getting single value from a single row with Mysql/PHP

  - by Ghostrider

  Often I just need to get a single value from MySQL that I know exists there. I use the following construct: $result = end(mysql_fetch_array(mysql_query('SELECT FOUND_ROWS()', $db))); Is there a proper single function in PHP that would do this?

  Read the article

• Error #1064 in mySQL Query

  - by William

  I get the following error in the query below: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')))' at line 1 Code Snippet: INSERT INTO test_bans( ip, Expiration ) VALUES ( "0.0.0.0", DateAdd( "d", 1, Date( ) ) ) Table creation query CREATE TABLE test_bans ( ID smallint(6) NOT NULL AUTO_INCREMENT, IP text NOT NULL, Expiration DATETIME NOT NULL, PRIMARY KEY (ID) ) TYPE=MyISAM; What am I missing?

  Read the article

• mysql select from one server insert to another mysql server ?

  - by Shvilam

  I wont to do insert to one mysqll server to and get the data or do the select part of the insert into select from anther mysql server not just copy entire tables is this possible in my sql I know that in MS Sql server you can do a linked server thanks

  Read the article

• Sort MySQL result set using comparison between 2 columns of same value type

  - by Kyobul

  Hello, I have a table containing last_updated_1 and last_updated_2 columns, used respectively for text and images update time on a post. I wish I could get a result set of 10 rows based on all time last updated records contained in the 2 columns, ex. row 1 = last_updated_1 record, row 2 = last_updated_2 record, row 3 = last_updated_1 record, etc. How could I compare inside a MySQL query the both columns values, to get unique & mixed result set ? Thank you in advance for your help

  Read the article

• MySQL 5.1 Schema Installer

  - by sergiogx

  I need to make an installer for a MySQL 5.1 Database, but I'm totally a noob when it comes to installers. I've been looking at NSIS and learned a little but I don't really know how to use it to just to execute a script. Anyone out there has experience installing database schemas in multiple computers? thanks

  Read the article

• mySQL convert varchar to date

  - by Jeff V

  I need to convert a varchar value of 1/9/2011 to a date in mySQL and I want only the month and year. So that I can then use the PERIOD_DIFF function (so I would need the above to be converted to 201101). I've tried various ways using the STR_TO_DATE function: SELECT STR_TO_DATE(CYOApp_oilChangedDate, '%m/%Y') FROM CYO_AppInfo But I get weird results... (for example: 2009-01-00) What am I doing incorrectly?

  Read the article

• MySQL, moving first word to last

  - by FEB

  How would I move the first word, if it was the word 'the', to the end of the cell in MySQL? As an example: before: The Good, the Bad and the Ugly after: Good, the Bad and the Ugly, The Thanks

  Read the article

• translate a mysql query into nhibernate

  - by lina

  Good day! Please, can you help me to translate such a mysql query into nhibernate SELECT sales_id, service_id,dayofyear(dt), max(dt) FROM clients.statistics group by sales_id, service_id,dayofyear(dt);

  Read the article

• MySQL Backup Procedure

  - by mouthpiec

  Is there a way to backup an MySQL database so that if something wrong occurs, it will be easy to recreate the tables with the same data?

  Read the article

• Last results submitted in mysql db

  - by Tapha

  How would i get the last 20 results submitted in a mysql db row. I need the 20 most recent user submitted results. Cheers.

  Read the article

• C++ string how to

  - by typoknig

  This is a very simple question and I feel stupid for asking it, but I am pressed for time and I need to figure it out :) I just need to know how to make a string that contains text and other variables. For instance in Java I can just do this: String someString; for(int i = 0; i>10; i++){ someString = ("this text has printed " + i + " times"); //how do I create this line in C++? System.out.println(someString); i++; }

  Read the article

• 6 digit numeric column in MySQL

  - by Vatsala

  Say I want to maintain a 6 digit ID column for a table in my database -is it possible to specify this at the DB level in MySQL?

  Read the article

• how to number the datas from mysql

  - by udaya

  Hi This is a doubt on mysql select query let me axplain my doubt with a simple example consider this is my query SELECT dbCountry from tableCountry tableCountry has fields dbCuntryId dbCountry and dbState I have the result as dbCountry india america england kenya pakisthan I need the result as 1 india 2 america 3 england 4 kenya 5 pakisthan the numbers 12345 must be generated with the increase in data and itis not a autoincrement id How can i get it is it something like loop

  Read the article

• Getting MySQL code from an existing database

  - by nix

  I have a database (mdb file) that I am currently busy with. I would like to know if it is possible to generate MySQL code that would be used to create this database?

  Read the article

• Store html into MYSql database

  - by jouzef19

  hello I'm try to store String (that contain html ) to mysql database by using Longtext data type. but its always says "You have an error in your SQL syntax". (note : i tried to store normal text , and its work)

  Read the article

• is there mysql corelib site for building queries?

  - by mjeason

  Maybe i have the wrong context but... Is there a corelib site for mysql like http://corelib.rubyonrails.org/ for ruby on rails RoR? Would be nice to have 1 stop shop. thx.

  Read the article

• PHP and MySQL - correct way to use mysqli_real_escape_string

  - by TaG

  I was wondering if the code below is the correct way to use mysqli_real_escape_string() when storing users data in a database. Here is the PHP & MySQL code. if (mysqli_num_rows($dbc) == 0) { $mysqli = mysqli_connect("localhost", "root", "", "sitename"); $dbc = mysqli_query($mysqli,"INSERT INTO info (user_id, url) VALUES ('$user_id', 'mysqli_real_escape_string($url)')"); } if ($dbc == TRUE) { $dbc = mysqli_query($mysqli,"UPDATE info SET url = 'mysqli_real_escape_string($url)' WHERE user_id = '$user_id'");

  Read the article

• mysql master/slave failover

  - by myhusky

  Is there any product that make mysql master/slave failover process easier? something that can happen automatically, rather than manually fix it.

  Read the article

• Randomly selecting a limited number of records with two conditions in MySQL

  - by andyashton

  I have a MySQL table with a column called "priority". The column can have two values: high or low. I want to select 8 records from the table at random, but I want 6 of them to be high priority, and 2 of them to be low priority. If possibly, I would like to do it in one SQL statement. Is there any way to do two LIMITS in one query based on this kind of criteria?

  Read the article

• MySQL greatest value in row?

  - by noryb009

  Hi! I'm using MySQL with PHP. This is like my table: (I'm using 3 values, but there are more) id | 1 | 2 | 3 1 | 3 |12 |-29 2 | 5 |8 |8 3 | 99|7 |NULL I need to get the greatest value in a certain row. If should get: (id - output) (1 - 2), (2-2), (3-1). Is there any queries for this? I've been trying, but I can't get it to work right.

  Read the article

• Sorting MySQL table by next due date

  - by Zagga

  Hi folks, I have a MySQL table that stores (amongst other things) a persons date of birth. Is there any way to sort the table so the next due birthday is at the top? I have the date stored in standard yyyy-mm-dd DATE format and seperate year, month and day fields so I can sort it by the first birthday of the year (ORDER BY month, day) but I can't seem to get any further. Any help would be greatly appreciated. Zagga

  Read the article

< Previous Page | 161 162 163 164 165 166 167 168 169 170 171 172  | Next Page >