Forum: PHP  May 15th, 2008 |
| Replies: 2 Views: 541 Remove Non Printing Characters From Text
Hi,
I've got a form with a few text fields, and only today I noticed that when i tried copying some text from an email and pasting it into one of the fields, after submitting to the database (and... |
| Forum: MySQL May 7th, 2008 |
| Replies: 10 Views: 854 Re: MySQL Error 1064 when DELETEing
Hi thanks for all the previous help but i've figured it out.
This is the php/sql query i use now:
php:
$sql .= "\nDELETE FROM images WHERE plant_num = ".$_REQUEST['pid']." AND image_id IN... |
| Forum: MySQL May 7th, 2008 |
| Replies: 10 Views: 854 Re: MySQL Error 1064 when DELETEing
nope i get back a result
btw i'm connecting as a user with delete priviliges so it isnt that either
i thought it might be the "\n" in the sql string perhaps but i took it out and still got the... |
| Forum: MySQL May 7th, 2008 |
| Replies: 10 Views: 854 Re: MySQL Error 1064 when DELETEing
well the query i showed you is what prints out.
DELETE FROM images WHERE image_id = 803 AND plant_num = 2277 LIMIT 1;
DELETE FROM images WHERE image_id = 804 AND plant_num = 2277 LIMIT 1;
DELETE... |
| Forum: MySQL May 7th, 2008 |
| Replies: 10 Views: 854 Re: MySQL Error 1064 when DELETEing
thanks, i tried doin that but still get the same basic error.
Query:
DELETE FROM images WHERE image_id = 803 AND plant_num = 2277 LIMIT 1;
DELETE FROM images WHERE image_id = 804 AND plant_num =... |
| Forum: MySQL May 7th, 2008 |
| Replies: 10 Views: 854 MySQL Error 1064 when DELETEing
I'm trying to carry out the following delete statements
DELETE FROM images AS i WHERE i.image_id = 803 AND i.plant_num = 2277 LIMIT 1
DELETE FROM images AS i WHERE i.image_id = 804 AND i.plant_num =... |
| Forum: JavaScript / DHTML / AJAX Dec 5th, 2007 |
| Replies: 4 Views: 808 |
| Forum: JavaScript / DHTML / AJAX Dec 5th, 2007 |
| Replies: 4 Views: 808 |
| Forum: MySQL Nov 14th, 2007 |
| Replies: 1 Views: 582  Re: Query seems to be crashing phpmyadmin/mysql
Ok it looks like i got the crashing problem fixed by reworking my query to:
SELECT
CONCAT_WS(' ',g.genus_name,s.species_name,i.rank,i.infraspecies_name,
conf.auth1,conf.auth2) AS scientific_name,... |
| Forum: MySQL Nov 13th, 2007 |
| Replies: 1 Views: 582  Query seems to be crashing phpmyadmin/mysql
Hi, I have the following query i'm trying to execute:
SELECT CONCAT_WS(' ', g.genus_name, s.species_name, i.rank, i.infraspecies_name, conf.auth1, conf.auth2 ) AS scientific_name,
cn.common_name,... |
| Forum: Database Design Oct 24th, 2007 |
| Replies: 2 Views: 860 Re: Database Design Question
oh sorry well i actually got that sorted out on my own, but i basically wanted to know if i should have stored the names as well as the id's in the same table but i ended up just storing the id's and... |
| Forum: MySQL Oct 11th, 2007 |
| Replies: 5 Views: 1,054 Re: Varchar field as foreign reference
ok i got the data loaded. I was using phpmyadmin's import feature and i was selecting the 'CSV' radio button but i changed it to 'CSV using LOAD DATA' radio button and that worked. I figured... |
| Forum: MySQL Oct 10th, 2007 |
| Replies: 5 Views: 1,054 |
| Forum: MySQL Oct 10th, 2007 |
| Replies: 5 Views: 1,054 Re: Varchar field as foreign reference
hey thanks
i have another quick question tho, in this same table not every entry will have an "infraspecies_id" or "syn_genus_id" (two fields from the table) and i want to set them as NULL in these... |
| Forum: Database Design Oct 9th, 2007 |
| Replies: 2 Views: 860 Database Design Question
I posted a similar question in MySQL section before but i think this one might be more general/easier to understand (hopefully):
I'm doing a database (in MySQL) of different plants which is gonna... |
| Forum: MySQL Oct 8th, 2007 |
| Replies: 5 Views: 1,054 Varchar field as foreign reference
Ok, i have a database where i'm storing information on plants and in one of the tables is a plants table:
here's the first few fields in the table plants:
plant_id, family_id, genus_id, species_id,... |
| Forum: Java Mar 8th, 2005 |
| Replies: 6 Views: 4,633 Re: Using operator[] with an ArrayList
Thanks, i realized i would have to do it this way after a little tinkering. I am coming from C++ so i have to get used to certain things in Java :) ( I miss my operator overloading :cry: ) |
| Forum: Java Mar 3rd, 2005 |
| Replies: 6 Views: 4,633 Using operator[] with an ArrayList
Hi,
I am writing a java application where i am trying to create an arraylist of "Item" objects. An Item has certain methods such as getStartValue(), etc.
What i am trying to do is to access an... |
