pagegen

Hi mate, sorry didnt mean it that way, your idea is great and I will go with it, just wanted to share what I had in mind to see what you thought Thank you

I was thinking one table named 'members' which stores fields like username, password, name and a 2nd table which extends members and has all the fields I need like age, etc which will not be needed in members then I can do an INNER JOIN so somet like this members: id | name | username | password | user_type_id members_customers: member_id | age | sex | address what do you guys think

Hi guys I am making a mysql (most uptodate version), php (v5) web application I am making a system which allows multiple user types to login so we will have admin, user, affliates, and customers I can create a table called members and enter all the records in there and have a field which determins what the user type is. The issue is some members i.e customers will have other fields like age, date of birth etc so they will be extra fields for admin, users and affliates can someone please advice me on how they would do this

Hi Guys, We are working on a PHP page which loops through several records of the database. Current code using php5, MYSQL db <?php $rs_members = mysql_query("SELECT * FROM members"); while($row_members = mysql_fetch_assoc($rs_members)){ ?> <table> <tr><td><?php echo $row_member['fname']; ?></td></tr> </table <?php } ?> One of the guys suggested passing the data to client side (am guessing to javascript) and then write to the screen to speed things up. Can someone please comment, or suggest the best way to deal with this

Hi guys, I just want to know if any one has worked with streamline payment gateway before, we are building a cart for a customer, a in house built sulition, and just wanted some help / advice on how to process payments. The customer has picked streamline as their merchant Thank you

Hi guys I need help writing a php script I have a table 'categories' with fields 'id' 'cat_name' 'parent_id' the 'parent_id' is just an the id field.. I want to create a way to have unlimited sub categories so I can have categorie -> sub-categories categories -> sub-categories -> sub-categories categories -> products

Ah nice one, Thank you guys

Hi guys I hate a table which stores results for everydays page impressions example: table_result (id, campaign_id, clicks, date) How can i create a sql report which returns weekly SUM(clicks)

any one?

bump

Hi mate, we will need data to be entered everyday from start of campaign to end, and if there is missing data, just flag the issue, thank you

bump any advice guys

Hi mate Yes all dates are stored as "date" in the database

Hi guys, I am trying to create a program which manages campaigns. each campaign has a start date and and end date. a user has to enter data releated to the campaign everyday example start date: 10-1-2011 end date: 17-1-2011 now all this information is stored in 2 tables 1st table is "campaigns" this stores the campaign name, start date and end date and 2nd table is "campaign_data" this table stored the data for each campaign and also date of when that data was entered my question is, if the user did not enter data on 11-1-2011 how will I know this, keeping in mind the month diffrence which can accur if the length of the campign was 2 month long? table: campaigns fields: id | campaign_name | start_date | end_date table: campaign_data fields: id | campaign_id | date | page Thank you

Hi guys am using PHP + mysql. I am looking to delete all rows that are 10 mins old using SQL, I have a field "time_created" which is a current time stamp field (time of when the row was created) any suggestions Thanks guys