Search found 95 matches

by vincenzobar
Wed Nov 09, 2005 5:40 pm
Forum: PHP - Code
Topic: delete statement isn't working... why?
Replies: 23
Views: 913

here is all the code on the page. include_once ( 'xmlparser.php' ); include_once ( 'mysql_func.inc.php' ); $data = file_get_contents ( 'rpdf.xml' ); $data = process_xml ( $data ); $hold = array (); $x = 0; foreach ( $data['ROOT'] AS $rn => $rv ) { if ( is_array ( $rv ) ) { foreach ( $rv AS $pn => $p...
by vincenzobar
Wed Nov 09, 2005 5:38 pm
Forum: PHP - Code
Topic: delete statement isn't working... why?
Replies: 23
Views: 913

lol, no kidding!!! i am Looping through a XML page and grabbing data then i use the data in the XML array to check against the database. If the XML Product id matches the database product id then.. move data from BC database to archive then delete it then insert new records from XML sheet. that simp...
by vincenzobar
Wed Nov 09, 2005 5:31 pm
Forum: PHP - Code
Topic: delete statement isn't working... why?
Replies: 23
Views: 913

* causes an error
by vincenzobar
Wed Nov 09, 2005 5:29 pm
Forum: PHP - Code
Topic: delete statement isn't working... why?
Replies: 23
Views: 913

I will try a star * but i want the whole row gone!
by vincenzobar
Wed Nov 09, 2005 5:03 pm
Forum: PHP - Code
Topic: delete statement isn't working... why?
Replies: 23
Views: 913

delete statement isn't working... why?

once again ... $move = array(); $f_move = array(); if(in_array($p_id, $DB_IDList)) { $db_row = mysql_fetch_row($all_rows); array_map('mysql_real_escape_string', $db_row); $move[] = "'', "."'".implode("', '", $db_row)."'"; $f_move[] = "(".implode(', '...
by vincenzobar
Wed Nov 09, 2005 4:35 pm
Forum: PHP - Code
Topic: formatting mysql fetch with "'"
Replies: 10
Views: 572

LOL I feel like a retard... My brain is fried!! I read over array_map and realized that about 2 seconds after i posted that!!! code now looks like $move = array(); $f_move = array(); if(in_array($p_id, $DB_IDList)) { $db_row = mysql_fetch_row($all_rows); $dbf_row = array_map('mysql_real_escape_strin...
by vincenzobar
Wed Nov 09, 2005 4:18 pm
Forum: PHP - Code
Topic: formatting mysql fetch with "'"
Replies: 10
Views: 572

i did this $move = array(); $f_move = array(); if(in_array($p_id, $DB_IDList)) { $db_row = mysql_fetch_row($all_rows); array_map('mysql_real_escape_string', $db_row); $move[] = "'', "."'".implode("', '", $db_row)."'"; $f_move[] = "(".implode(', ', $m...
by vincenzobar
Wed Nov 09, 2005 4:12 pm
Forum: PHP - Code
Topic: formatting mysql fetch with "'"
Replies: 10
Views: 572

where does that go and how would you implode it otherwise??

it needs to look like this

('asd', 'asd'), (...), (...)
by vincenzobar
Wed Nov 09, 2005 3:42 pm
Forum: PHP - Code
Topic: formatting mysql fetch with "'"
Replies: 10
Views: 572

tried that this is the error
mysql_real_escape_string() expects parameter 1 to be string, array given...
everything in there is an array except the last which makes everything \'

there has to be a way around this!!!
by vincenzobar
Wed Nov 09, 2005 2:44 pm
Forum: PHP - Code
Topic: formatting mysql fetch with "'"
Replies: 10
Views: 572

everything but the last call is an array for implode to work and if i attach it to the last call it \ all ' and that won't work!!

Arg it's the last step

scheit!!!!!!!!!!!!!!!!!!!!!!!
by vincenzobar
Wed Nov 09, 2005 1:59 pm
Forum: PHP - Code
Topic: formatting mysql fetch with "'"
Replies: 10
Views: 572

formatting mysql fetch with "'"

now i am running into a problem with 's when i do a fetch_rows and then go to move info to anothe DB it doesn't take the rows that contain words like America's Here is the code $move = array(); $f_move = array(); if(in_array($p_id, $DB_IDList)) { $db_row = mysql_fetch_row($all_rows); $move[] = "...
by vincenzobar
Wed Nov 09, 2005 1:09 pm
Forum: PHP - Code
Topic: What am i missing in this MySQL statement?
Replies: 23
Views: 1262

laughing my ass off!!!!
by vincenzobar
Wed Nov 09, 2005 12:55 pm
Forum: PHP - Code
Topic: What am i missing in this MySQL statement?
Replies: 23
Views: 1262

nevermind dumb mistake!!!

It worked!!! thanks

i forgot i put acolumn call in and once i deleted that it worked great!!!
by vincenzobar
Wed Nov 09, 2005 12:53 pm
Forum: PHP - Code
Topic: What am i missing in this MySQL statement?
Replies: 23
Views: 1262

i did.. $db_row = mysql_fetch_row($all_rows); $move[] = "'', "."'".implode("', '", $db_row)."'"; and i got this 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 'archive_ratep...
by vincenzobar
Wed Nov 09, 2005 12:24 pm
Forum: PHP - Code
Topic: What am i missing in this MySQL statement?
Replies: 23
Views: 1262

how in the hell do i do that!!!! ;)