I need someone to help me write this up in a php based sql statement.
i already have connection to the database and can output crap but not what i need.
there are 2 tables
pts_ultd
scrape_data
here's what i need.
select all from pts_ultd and scrape_data where pts_ultd field P_B is equal to scrape_data.S_R
BUT.....
OMIT any records where pts_ultd.P_R has "4" saved within the field as data...
--- from that point, i can display the output as i need....
"4" means that the item is no longer available, so i don't need it to display..
i need ALL of the info from scrape_data to be available, but i only need 2 fields from pts_ultd. P_B to match up with the other one, and P_D
--
ultimately, i am trying to write this crap to a CSV.
i basically just need to get info from both tables, where the two things match, then omit the "4" ones. hopefully that makes sense, and hopefully someone answers this soon. it's 4:51pm on sunday. sooner the better lol
i already have connection to the database and can output crap but not what i need.
there are 2 tables
pts_ultd
scrape_data
here's what i need.
select all from pts_ultd and scrape_data where pts_ultd field P_B is equal to scrape_data.S_R
BUT.....
OMIT any records where pts_ultd.P_R has "4" saved within the field as data...
--- from that point, i can display the output as i need....
"4" means that the item is no longer available, so i don't need it to display..
i need ALL of the info from scrape_data to be available, but i only need 2 fields from pts_ultd. P_B to match up with the other one, and P_D
--
ultimately, i am trying to write this crap to a CSV.
i basically just need to get info from both tables, where the two things match, then omit the "4" ones. hopefully that makes sense, and hopefully someone answers this soon. it's 4:51pm on sunday. sooner the better lol