techker

thx for the help!il look it up. what should i be looking for?

Hey guys i looking for a tutorial for forms that have drop downs or check boxes that influences other fields.. like if you select yes a box appears with reason why.. if you select no box stays as is... so i guess IF's in a html form..

ok so yes it's more practical to have 1 db for every year but your saying i can get more out of one? i can always use join to get more info..

ya now i have it stored with a fiscal year..me to i was thinking of that..think i will leave as is..so now in my admin he selects the fiscal year and it shows only that.. i was just debating if it would be more safe or practicle to have different databases every year..instead of loading all the same database every year...cause there's like over 1000 students..

ok so a variable would be need..ok i got it thx

so i can export in phpmyadmin the structure then make a script.but it the name of the databse that needs to change every year..

hey guys i have a web app that i did for a school and i ran into a snag... cause every year they have fiscal years and different students... so i was wondering.in the admin i wan't to predetermined the fiscal years.so the year after they click on the fiscal year and it creates a database (expl:2011-2012) with all the tables that i need for the app.. is that possible?

Oh sorry ya i generates it as jason.thx i will look it up.

i got it going with a more simpler code http://api.geoio.com/q.php?key=mykey=geoip&d=json&q=<? echo getenv('REMOTE_ADDR'); ?> but i don't now how to execute that link and show the results on the same page>?

Hey guys i want to do a geobanner that gets the client ip and echo's the location.. i got a API key and and link.. but to echo the perfect ip echo ''; if ( isset($_SERVER["REMOTE_ADDR"]) ) { echo '' . $_SERVER["REMOTE_ADDR"] . ' '; } else if ( isset($_SERVER["HTTP_X_FORWARDED_FOR"]) ) { echo '' . $_SERVER["HTTP_X_FORWARDED_FOR"] . ' '; } else if ( isset($_SERVER["HTTP_CLIENT_IP"]) ) { echo '' . $_SERVER["HTTP_CLIENT_IP"] . ''; and the api link is http://api.geoio.com/q.php?key=MYKEY=json&q=HERE I NEED THE IP could it echo the results of the link instead of clicking the link?

Hey guys i need to make a small app for work.. i have this reference site that has a log in and i would like to make a page that could bypass that log in.but i have no access to that log in page.. that's the tricky part..lol so i tried to view source copy past in to a new document. filled in the field with my user and pass.. and put an auto submit on page load.. so my idea was to target the log in page form submit page(same page self) i was thinking it would detect the same form and load..but it doesn't it stops at the log in page... is this the right way to do it?

still doesnt work..fill the database.. so my goal is to check the rentals done by the loggin in user. so in rentals is have R_ID DVD_ID Employee LP Date then i want to go in the Locations(dvd's) and get the DVD info that he rented.(DVD_ID) L_ID Titre Date Prix Categorie Image Status UPC so basically when he goes to the account page it shows his rented movies..

ok cool thx!

wow fast.. will this formula do what i need?cause now im getting zero output from it..

last thing..now i get Unknown column 'Techker' in 'where clause' i think it's in my were clause?im missing something no? WHERE OUT.DVD_ID = Location.L_ID AND OUT.Employer = $Account";

ahh...lol thx

hey guy i doing a litle script for renting dvd's.. i got the DB OUT for rentals and employee for id of the person renting it.. So on my page account i wan't to list the rented dvd's from the employee need to check the OUT database and the Location database for the movie title and pics.. i got this but i got a syntax error.. $query = "SELECT OUT.Employer,OUT.DVD_ID, Location.L_ID ". "FROM OUT, Location ". "WHERE OUT.DVD_ID = Location.L_ID AND OUT.Employer = $Account"; You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OUT, Location WHERE OUT.DVD_ID = Location.L_ID AND OUT.Employer = techker' at line 1

ok thx i will google the phpmyadmin import csv to see..

i have to make it.. so on the csv: "product_title","short_description","full_description","QTY","Pirce","image.jpg" in phpmyadmin i seen i can import by csv?would it be faster and easier?

So QTY = '".trim(saveToDB($data[3]))."', Prices = '".trim(saveToDB($data[4]))."', Image = '".trim(saveToDB($data[5]))."',

how would i read it from the csv? is it this? short_description = '".trim(saveToDB($data[1]))."', full_description = '".trim(saveToDB($data[2]))."'";

Ya.for the product i got a few filds.but the script has it in 3 diffrent tables..one for name and details .one fo images and the third for priceand qty...

hey guys i have an existing code that inserts from scv to 1 DB. is there a way to add 2 more? cause there is 3 db for the products products(product title-ful and short description) products_images(image file name) products_attribute_values(quantity and price) $csv->file_new_name_body = $filename; $csv->Process(_UPLOAD_DIR_); if (!$csv->processed) { $message .= 'CSV upload error: '.$csv->error; } else { $row = 0; if (($handle = fopen(_UPLOAD_DIR_.$csv->file_dst_name, "r")) !== false) { while (($data = fgetcsv($handle, 1000, ",", '"')) !== false) { $sql = "INSERT INTO ".$TABLES['PRODUCTS']." SET categories_id = ".intval($_REQUEST['categories_id']).", order_id = 0, status = ".intval($_REQUEST['status']).", featured = 0, product_title = '".trim(saveToDB($data[0]))."', short_description = '".trim(saveToDB($data[1]))."', full_description = '".trim(saveToDB($data[2]))."'"; $sql_result = mysql_query($sql, $connection) or die ('Could not execute SQL query:<br />'.$sql.'<br /><strong>'.mysql_error().'</strong>');

ok thx for the help

ok good.would you know of a tutorial for this?just to give me an idea?