techker

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?

i like the second one.. so there would be a submit on each tab?but how would the second submit relate to the first submit? so first tab is and insert and second is an update..

Hey guy i was wondering how to make a form with tabs tha correspond to the same. Like lets say tab one description and name... Tab 2 is the image associated to that first tab... How can i make that? its for an auto classifield script.. Cause there is lots of details so i wanted to spread them in tabs..

ok..wow.lol whats the = 3 if i do a settings in the admin panel that he selects what fiscal hear to show? like 2012-2013 then in the search i could but the function? like where date = $fiscal_year..

Hey guys im dealing with a fiscal year issue.. so the script i did is for my body's school..so they have fiscal years..2011-2012 between march and April.. so the databse is set already with a date field. date_field 2012-01-10 15:53:41 is there a way to make it easy and only show fiscal year?cause this year is ok but next year i don't need to show the previous years..