i'm just going through the review.cgi source right now and noticed that i rarely used dbsql.pm for my queries.. i am not used to it yet and would like to know if i can do the following..
1. SELECT COUNT(Review) FROM Reviews WHERE LinkID = $id
2. SELECT * FROM Reviews WHERE LinkID = $id AND Review REGEXP ".+" ORDER BY ID Desc LIMIT $OUT{start}, $reviews_per_page
also.. the status of review.cgi..
i haven't worked on it much.. to be honest.. i started again today and made it build html pages instead of making it load from .cgi all the time.. it was an easy change. however.. i am making instructions to do 4 different types of displays.. .cgi, own html page, on detailed page, and have newest X on the detailed with a link to either .cgi or html to view all..
i'm deciding right now whether to release now or after i finish some other things that i wanted to do.. the instructions will take me awhile though.. i always take forever doing instructions..
i'll put a demo up asap.. right now i'm just combining as much as i can to make it work with dbsql.pm.. i originally made it for another sql program with plain sql queries and a bunch of numerous lines of code that can be turned into single line commands with dbsql.pm
anyways.. before i release.. i have to figure out a problem.. i don't want to be bombarded with email about help or anything cause i get enough already and i still have to do my homework you know!? ..
jerry
1. SELECT COUNT(Review) FROM Reviews WHERE LinkID = $id
2. SELECT * FROM Reviews WHERE LinkID = $id AND Review REGEXP ".+" ORDER BY ID Desc LIMIT $OUT{start}, $reviews_per_page
also.. the status of review.cgi..
i haven't worked on it much.. to be honest.. i started again today and made it build html pages instead of making it load from .cgi all the time.. it was an easy change. however.. i am making instructions to do 4 different types of displays.. .cgi, own html page, on detailed page, and have newest X on the detailed with a link to either .cgi or html to view all..
i'm deciding right now whether to release now or after i finish some other things that i wanted to do.. the instructions will take me awhile though.. i always take forever doing instructions..
i'll put a demo up asap.. right now i'm just combining as much as i can to make it work with dbsql.pm.. i originally made it for another sql program with plain sql queries and a bunch of numerous lines of code that can be turned into single line commands with dbsql.pm
anyways.. before i release.. i have to figure out a problem.. i don't want to be bombarded with email about help or anything cause i get enough already and i still have to do my homework you know!? ..
jerry