This is more mySQL, but I am using it with my php-based game and I am wondering how I can select multiple rows from a table but only if they have the same variable number. I know I could just do something like (WHERE showid = 2) but I want to run this in a cron and have it just run for every single show without me having to plot in a number. I am confused so I am probably confusing others but please, if you have any hints for me I’d be extremely grateful. I am a beginner too so sorry if my code is atrocious LOL.
I want to select all the ones with showid 2 without having to write the number 2, then select all the ones for #5 and so on.
my code: http://pastebin.com/y23p0dEm