[MYSQL] problem with spaces in rows Post: 302397090

Sponsored Content

Top Forums Web Development [MYSQL] problem with spaces in rows Post 302397090 by Neo on Sunday 21st of February 2010 02:56:02 AM

02-21-2010

Administrator

Sorry, I am not fully understanding the problem. Perhaps it is because I am reading this post on my mobile phone.

Are you getting an error message in the log file? If so, please post it? Or are you seeing an HTML formatting issue?

---------- Post updated at 07:56 ---------- Previous update was at 03:07 ----------

OBTW (back on my desktop computer), this statement does not look right, or it is not how I would write it:

PHP Code:


$query = "SELECT venue, SUM(amount) FROM IWD WHERE venue='$sel_venue'";

I would write this:

PHP Code:


$query = "SELECT venue, SUM(amount) FROM IWD WHERE venue=".$sel_venue;

PHP Code:


$query = "SELECT venue, SUM(amount) FROM IWD WHERE venue=$sel_venue";

in PHP, single quotes means "take what is inside literally and do not expand". Double quotes means "expand the variables inside". When you mix single and double quotes (inside each other) you can have huge problems in PHP.

Better for this, and considered the least confusing is:

PHP Code:


$query = 'SELECT venue, SUM(amount) FROM IWD WHERE venue='.$sel_venue;

The reason for this is that 'SELECT venue, SUM(amount) FROM IWD WHERE venue=' does not require any variable expansion inside the single quotes.

Neo

View Public Profile for Neo

Visit Neo's homepage!

Find all posts by Neo

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

MySQL problem >> missing mysql.sock

MySQL on my server is down.... I figured out that the mysqld process isn't running. When I try to run it, it says it can't find mysql.sock Any suggestions? Here's what I can't do: can't be root don't have physical access (do stuff via SSH) reinstall MySQL (need to keep the current MySQL...

2. Solaris

finding & replacing blank rows/spaces in a file

Can anyone help me find and replace blank rows in a file with a numeric value (ie blankrow=someTxtOrNumValue), the file is over 500,000 rows long so it would need to be the quickest way as I'll need to do this for multiple files...I would be greatfull for any suggestions....thanks sample file:...

3. Web Development

Mysql question: Best way to update a column containing 8 million rows

Hi all, I was wondering if anyone knew a good/safe way to update a single column in a table that could contain upto 8 million rows... simple command like: UPDATE set blah=foo where bar=XXX; I will be running this on tables being written to and tables that have already been created. ...

4. Shell Programming and Scripting

convert rows (with spaces) to columns

Hey all, I have a list in the format ; variable length with spaces more variable information some more variable information and I would like to transform that 'column' into rows ; variable length with spaces more variable information some more variable information Any...

5. UNIX and Linux Applications

Online insert MySQL rows by perl-script

Hello, Met a problem when I tried to insert rows to MySQL database from an old book that fits my learning level (MySQL and Perl for the Web, by Paul DuBois, 2001). First, under mysql console I created a database: webdb and the table: todo. Then I draft the perl-cgi script to have online page....

6. Programming

Getting Rows from a MySQL Table with max values?

I feel stupid for asking this because it seems that MYSQL code isn't working the way that I think it should work. Basically I wrote code like this: select * from `Test_DC_Trailer` HAVING max(DR_RefKey); Where the DR_RefKey is a unique numeric field that is auto iterated (like a primary key)...

7. UNIX for Dummies Questions & Answers

[SOLVED] splitting a single column(with spaces) into multiple rows

Hi All, My requisite is to split a single column of phonemes seperated by spaces into multiple rows. my input file is: a dh u th a qn ch A v U r k my o/p should be like: adhu a dh u

8. Shell Programming and Scripting

Retrieve multiple rows from mysql and automatically create a table

Hi, i want to create a table automatically based on another table (sms_key). For example; If user create a new row with sms_keyword field: IRC then a table created automatically (with some field on it, like: name, ph_number, messages). select * from sms_key; +-------------+ |...

9. Shell Programming and Scripting

MySql split rows

Dear community, I have to split string in table and list all values. I'll skip the code and jump directly to mysql query. This is the table: category title ======= ======= 7,3 title 1 1,3 title 2 1,2,3 title 3 Now, what I need is split category into single...

10. UNIX for Dummies Questions & Answers

Mysql: How to update value in 27000 rows?

Hello, some member created 27000 posts in wrong section (lol :D) so i need to edit all his entries to get new section ID. SELECT * FROM `phpbb_topics` WHERE `topic_first_poster_name` LIKE "%ozerway%"; this will select all his topics... the column with forum id is named "forum_id" and...

LEARN ABOUT PHP

main

MAIN(3) 								 1								   MAIN(3)

main - Dummy formain(3)

	There  is  no  function  named	main(3)  except  in  the  PHP  source.	In  PHP  4.3.0,  a  new  type  of error handling in the PHP source
       (php_error_docref) was introduced. One feature is to provide links to a	manual	page  in  PHP  error  messages	when  the  PHP	directives
       html_errors (on by default) and docref_root (on by default until PHP 4.3.2) are set.

	Sometimes  error messages refer to a manual page for the function main(3) which is why this page exists. If you discover such a reference,
       please file a bug report, indicating the PHP function caused the error that linked to main(3) and it will be fixed and properly documented.

       Known errors that point to main(3)

       +----------------+-----------------------------+
       | Function name	|			      |
       |		|			      |
       |		| No longer points here as of |
       |		|			      |
       +----------------+-----------------------------+
       |  include(3)	|			      |
       |		|			      |
       |		|	     5.1.0	      |
       |		|			      |
       |include_once(3) |			      |
       |		|			      |
       |		|	     5.1.0	      |
       |		|			      |
       |  require(3)	|			      |
       |		|			      |
       |		|	     5.1.0	      |
       |		|			      |
       |require_once(3) |			      |
       |		|			      |
       |		|	     5.1.0	      |
       |		|			      |
       +----------------+-----------------------------+
       html_errors, display_errors.

PHP Documentation Group 														   MAIN(3)

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

MySQL problem >> missing mysql.sock

Discussion started by: _hp_

2. Solaris

finding & replacing blank rows/spaces in a file

Discussion started by: Gerry405

3. Web Development

Mysql question: Best way to update a column containing 8 million rows

Discussion started by: muay_tb

4. Shell Programming and Scripting

convert rows (with spaces) to columns

Discussion started by: TAPE

5. UNIX and Linux Applications

Online insert MySQL rows by perl-script

Discussion started by: yifangt

6. Programming

Getting Rows from a MySQL Table with max values?

Discussion started by: Astrocloud

7. UNIX for Dummies Questions & Answers

[SOLVED] splitting a single column(with spaces) into multiple rows

Discussion started by: girlofgenuine

8. Shell Programming and Scripting

Retrieve multiple rows from mysql and automatically create a table

Discussion started by: jazzyzha

9. Shell Programming and Scripting

MySql split rows

Discussion started by: Lord Spectre

10. UNIX for Dummies Questions & Answers

Mysql: How to update value in 27000 rows?

Discussion started by: postcd

LEARN ABOUT PHP

main