Search Results

Search found 14016 results on 561 pages for 'n mysql'.

Page 291/561 | < Previous Page | 287 288 289 290 291 292 293 294 295 296 297 298  | Next Page >

• Selecting financial values from db stored as text

  - by Midhat

  I have some financial values stored as text in a mysql db. the significance of financial is that negative numbers are stored enclosed in paranthesis. is there a way to automatically get the numeric value associated with that text. (like '5' shoudl be retuned as 5 and '(5)' should be returned as -5)

  Read the article

• How can I save content from another website to my database ?

  - by HJ-INCPP

  Hello, I want to upload dynamically content from a soccer live score website to my database. I also want to do this daily, from a single page on that website (the soccer matches for that day). If you can help me only with the connection and retrieval of data from that webpage, I will manage the rest. website: http://soccerstand.com/ language: php/java - mysql Thank you !

  Read the article

• SQL swap field values

  - by Silence

  I have a SQL table (MYSQL 4.0 to be precise) composed of the following : int no (primary) int field1 int field2 I would like to swap the values of field1 with the values of field2 and vice-versa. Ex.: 1;2.5;3.76 becomes 1;3.76;2.5 I need a swapping temporary variable of some sort. But I don't think I can use something like Set @var1 = field1 inside my update statement. And I don't think altering the table to add a temporary column is my best best either.

  Read the article

• HOW TO FIX "The requested URL /phpMyAdmin was not found on this server"

  - by user1392840

  I have install apache,php and mysql on Mac 10.8.1. After this, in my web brower i type this, it give the error message Not Found The requested URL /News-2012-Academy-Awards-53.html was not found on this server. Apache/2.2.22 (Unix) mod_fastcgi/2.4.6 mod_ssl/2.2.22 OpenSSL/0.9.8r DAV/2 PHP/5.3.13 with Suhosin-Patch mod_wsgi/3.3 Python/2.7.2 Server at clontarf.girlsacademy.com.au Port 80" Please help me to solve it.

  Read the article

• how to do multi insert and obtain ids

  - by liysd

  hi, I want to insert some data into a table (id PK autoincrement, val) with use multi insert INSERT INTO tab (val) VALUES (1), (2), (3) Is it possible to obtain a table of last inserted ids? I'm asking becouse I'm not sure if all will in this form: (n, n+1, n+2). I use mysql inodb.

  Read the article

• jQuery Plugin to update live a <li> from PHP

  - by Francesc

  Hi, is there any jQuery plugin to create something like the live feed from the Twitter Main Page , using PHP, which is getting the data from a MySQL database? How has to be the PHP file? Thanks.

  Read the article

• Diffence between "select count(null)" and "select count(1)"

  - by Midhat

  In MySQL Select 1 from mytable and select null from mytable both return the same number of rows. While select count(1) from mytable returns the rowcount and select count(null) from mytable always returns 0. Why?

  Read the article

• Should I sanitize EVERY form variable passed along?

  - by Camran

  I have a form with many fields... The action is set to a php page which queries mysql... Should I sanitize with mysql_real_escape_string every single variable? Or can I ignore sanitizing drop-lists and radios for instance? Also, besides mysql_real_escape_string, what else should I do to prevent attacks? Thanks

  Read the article

• Simple SELECT query problem...

  - by Povylas

  Hi, I have this MySql select query witch seams to have a bug but I am quit "green" so I simple can not see, so maybe you could help? Here is the query: SELECT node_id FROM rate WHERE node_id='".$cat_node_id_string."' LIMIT ".$node_count_star.",".$node_count_end." ORDER BY SUM(amount) GROUP BY node_id Thanks for help in advance...

  Read the article

• What happens if my server loses power and I'm using the MEMORY engine?

  - by Hank

  Does the MEMORY storage engine of MySQL ever write to disk the database contents? Meaning, if I'm using the MEMORY storage engine and my database server loses power - do I lose all of my database content or is it backed up to disk?

  Read the article

• Is it a good idea to Strtolower the username then store it in database?

  - by Axel

  Hi, In a php/mysql application where people can registre, is it a good idea to strtolower the username then store in the database in order to not have problems in the future? because people are using DiFfeReNt cases and i'm afraid that will make conflict in some queries. Thanks

  Read the article

• What is the use of mysql_rollback() function in PHP?

  - by OM The Eternity

  What is the use of mysql_rollback() function in PHP? How is it used? please explain me with some example, PS: Please Do not give me link to the php.net or, mysql site, I dont need AUTHOR language to understand it, I need the Developer way to understand... I hope u understand... Thanks in advance. UPDATE if i have Updated something in a tanle can i Reset the previous value using this function?

  Read the article

• NHibernate Mapping in Asp.Net

  - by Siva

  Hi guys, I'm new to NHibernate. I'm trying to save the information in MySql Database. Here I got the error in class file. That is "Missing partial modifier on declaration of type 'WebApplication1.Personal.Personal_info'; another partial declaration of this type exists". Help me to fix it

  Read the article

• SQL query to remove text within parentheses?

  - by Josh Fraser

  What is the best SQL query to remove any text within parenthesis in a mySQL database? I'd like something that works regardless of the position of the parenthesis in the text (beginning, middle, end, whatever). I don't care about keeping the text inside the parenthesis, just removing it. Thanks!

  Read the article

• Is it possible to capture data from a WHERE clause?

  - by Kristopher Ives

  I have a scenario where I'm calculating something in the WHERE clause of my SQL, but I also want to get that calculation - since it's expensive. Is it possible to get the results of something done in the WHERE clause, like this: SELECT `foo` FROM `table` WHERE (foo = LongCalculation()) Wishful thinking, or possible with MySQL?

  Read the article

• morethan one between clause

  - by tismon

  hi how can i use more than one 'between' clause in mysql query ? like if i want to select students having height between 20 and 25 and weight between 50 and 70.. thanks in advance tismon

  Read the article

• DB.Null equivalent in JDBC

  - by Fakrudeen

  Is there an equivalent of (ADO.NET) DB.Null in JDBC? Or do I simply pass null in the parameter? Particularly in the context of Mysql?

  Read the article

• what does "out of range" mean?

  - by user329820

  Hi I have checked these statements with mysql and no error will happen and also the out put will be 0 rows BUT my friend checked it and he found an error for SELECT becaouse it is out of range !! IS he correct? thanks CREATE TABLE T1(A INTEGER NULL); SELECT * FROM T1;

  Read the article

• Regular Expression to parse SQL Structure

  - by user351429

  I am trying to parse the MySQL data types returned by "DESCRIBE [TABLE]". It returns strings like: int(11) float varchar(200) int(11) unsigned float(6,2) I've tried to do the job using regular expressions but it's not working. PHP CODE: $string = "int(11) numeric"; $regex = '/(\w+)\s*(\w+)/'; var_dump( preg_split($regex, $string) );

  Read the article

• differences between socket and port in database context

  - by Yang

  hi guys, when i am using 'localhost' as the host for mysql database, sequel pro alert me that i will be using socket, if i am using '127.0.0.1', i am actually using the ip address and port 3306 to locate the server. is there any difference?

  Read the article

• alternative to sql server 2005

  - by csetzkorn

  Hi, I got used to the xml support and recursive common table expressions of sql server 2005. I am just wondering whether any free dbs like mysql support these requirements nowadays? Thanks. Christian

  Read the article

• Ajax: Partial refresh of a parent page (update a div) from "lightbox" window

  - by superUntitled

  Is there a way to update information in a div of a parent page from a pop-up/"lightbox" window. I would like to create a pop up window that contains a form that updates a database (currently i am using php/mysql with prototype). In other words... I would like a user to be able to use a form in a popup window to update the database, and the changes that are made to be shown on the parent page without that parent page being refreshed. Thanks.

  Read the article

• jQuery + ajax livesearch

  - by andrei

  I am doing a mysql database search and retrieving some results via ajax livesearch using the example on w3schools and i want to manipulate those results (drag and drop them) but im having a problem because the script loads before you enter the search and get the results so it does absolutely nothing no the search results. Any thoughts on this matter ?

  Read the article

• Fetch Products Grouped By Total Sales ?

  - by David

  Hi, I have the following MySQL tables: TABLE: Products ---------------------- id | productname 1030 | xBox 360 1031 | PlayStation 3 1032 | iPod Touche TABLE: Sales ---------------------- productid | saledate 1031 | 2010-06-14 06:30:12 1031 | 2010-06-14 08:54:38 1030 | 2010-06-14 08:58:10 1032 | 2010-06-14 10:12:47 I want to fetch using php the products i sold today and groupe them by sales number and order by sale date (if possible) , example of Output: Today's statistics: -Playstation 3 (2 sales) -Xbox 360 (1 sale) -iPod Touche (1 sale) Thanks

  Read the article

• WHERE condition accross multiple rows

  - by Chris G

  I have this table... -------------------------------------- | user_id | status | status_date | -------------------------------------- | 1 | Current | 2012-08-01 | | 1 | Referral | 2012-03-14 | | 2 | Referral | 2012-04-23 | | | | | -------------------------------------- How would I query to find a distinct user_id who has a referral date before 2012-06-30 AND either a current date of after 2012-06-30 or no current status record at all? Database is MySQL.

  Read the article

< Previous Page | 287 288 289 290 291 292 293 294 295 296 297 298  | Next Page >