kevgais

Hi Guys, I have a web app that feed into a MYSQL db perfectly. I want some low skilled user to start accessing the data easily so have decided to connect the MySQL db to an MS access db. I've successfully done this using an ODBC connection but this requires the ODBC to be setup on on every potential user (which is not really possible) Is there anyway (in code) I can connect the 2 databases? Cheers Kev

great thanks. what is semantic code?

Hi guys, I have to do presentation on the critique of 2 sites for a job interview next week. What sort of things should I be reviewing? design, usability I suppose anything else? cheers kev

Hi Guys, I'm about to send out a 100 invites to my website application via email and letter, in the letter I will give the domain url (www.sitename.com) I need away to track which of the invites have looked at the site. My idea is to issue a unique 5 digit number in each letter. The idea is that when the site is loaded some sort of popup login screen will appear (similar to http://www.maxkiesler.com/images/site_images/phatfusion-lightbox.png) the user will then have to enter their code to gain entry to the site. I need then to record this user in a table so I can report on it later. I have some experience with php and html but am looking for some advice on the best way to achive this? many thanks Kevin

interesting thoughts guys thanks

Hi guys, I'm coming to the end of my website development. My site is more of an application in that users arrive at it from a main site (my application is a booking engine for restaurants). The whole process involves many different screens, SMS messaging, Automated emails & pdf on the fly generation. I no need to start selling this product now and as such need to figure out the best way to do a snappy presentation show casing it to it's full. I'm thinking of some sort of flash movie (but how do i include the sms & emails etc. Anyone have any ideas on the best approach for this? cheers

hi, I'm am after a script that connects to an online address book (gmail/yahoo/AIM/lycos) then users select the required email address and import them into my web application. anything out there?

Hi Guys, Anyone know what I have to do to make my URL's not needing the .html at the end? I've read that's something to do with .htaccess but as a complete newbie I need some more help thanks Kev

thanks, basically on my form I have a hidden input box that upon loading has a random id entered into it. now, on the same form I have 10 username & email textboxes for users to enter their information in, next to each row (username box & email box) i have hidden input boxes that I want to copy the random id into. this way when I send the the data to the mysql database I have the key identifyer. any thoughts? cheers

Hi guys, I have form that contains several input boxes. I set the value of the 1st input box like: <input type='text' name='email1[]'value="enter guest email here" /> but how can I set the values of other input boxes bases on the 1st input box? something like: <input type='text' name='email2[]'value=email1 /> cheers

hi, I have this sql statement on form.php, thanks to this forum. I want to amend it but am having trouble understanding it. The form prior to this creates 2 empty textboxes on the fly. I need to insert the same random number into the 'id' field next to every record inserted in the below statement. Any ideas? Code: $sql.="INSERT INTO guests (guest_name, guest_email, event_id) VALUES"; for($i=0;$i<sizeof($_POST['username']);$i++){ $sql.="('".mysql_real_escape_string($_POST['username'][$i])."','".mysql_real_escape_string($_POST['email'][$i])."','".mysql_real_escape_string($_POST['id'][$i)."')"; if(!$i==sizeof($_POST['username'])){ $sql.=","; } }

hi, I have this sql statement on form.php, thanks to this forum. I want to amend it but am having trouble understanding it. The form prior to this creates 2 empty textboxes on the fly. I need to insert the same random number into the 'id' field next to every record inserted in the below statement. Any ideas? $sql.="INSERT INTO guests (guest_name, guest_email, event_id) VALUES"; for($i=0;$i<sizeof($_POST['username']);$i++){ $sql.="('".mysql_real_escape_string($_POST['username'][$i])."','".mysql_real_escape_string($_POST['email'][$i])."','".mysql_real_escape_string($_POST['id'][$i)."')"; if(!$i==sizeof($_POST['username'])){ $sql.=","; } }

apologies. it prints "INSERT INTO guests (guest_name, guest_email) VALUES"

hi again, I've worked out that this script work when using only 2 rows of fields, if I add anymore it fails. So I'm assuming that it's somthing to do with the loop, which, I think, is this line for($i=0;$i<sizeof($_POST['username']);$i++){ does this line look correct?

cheers works perfectly. still having problems with this sql statement $sql.="INSERT INTO guests (guest_name, guest_email) VALUES"; for($i=0;$i<sizeof($_POST['username']);$i++){ $sql.="('".mysql_real_escape_string($_POST['username'][$i])."','".mysql_real_escape_string($_POST['email'][$i])."')"; if(!$i==sizeof($_POST['username'])){ $sql.=","; } } // if (!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); } echo "record added"; ?>