yerac8

Good Day all.. I am querying entrants from on table and placing them in another table. When I query the entrants, store them in an array and echo them, I can see that the tables are being accessed and the values are being read. However when i query to put the values into the other, if I put in the entrants with numbers only ( float type or integer type), the following statement works but it doesnt work for the entrants that are of type VARCHAR Here is the statement I use. it works for this $query = mysql_query("INSERT INTO store_data (network_ID, store_num) VALUES ($network_ID, $store_num)"); Doesnt work for this $query = mysql_query("INSERT INTO store_data (network_ID, store_name, store_num, store_type) VALUES ($network_ID, $store_name, $store_num, $store_type)"); $network_ID is an 'int' $store_name is a 'VARCHAR(255) $store_num is an 'int' $store_type is a 'VARCHAR(255) can anybody tell me what wrong?

Thanks for all the replies.. Tried the TRUNCATE TABLE. It worked perfectly!!

Should it be written as $result = mysql_query("TRUNCATE TABLE sales_matrix_new WHERE (row_id =$j_counter AND col_id =$k_counter)"); or just TRUNCATE TABLE sales_matrix_new;

I am writing a php code to perform operations on a database. I want to clear all entries in the table before I start modifying it. The line of code i have to perform that deletion is not workin. Can any body tell me what wrong? $result = mysql_query("DELETE * FROM sales_matrix_new WHERE (row_id =$j_counter AND col_id =$k_counter)");

Goodnight all.. I am a student and I am trying to figure out some php code to produce a jacobian matrix given some information about a power system.. Could any one help... Thanks in advance!