Search found 15 matches

by wHiTeHaT
Sat Oct 14, 2006 10:25 am
Forum: Databases
Topic: INNER JOIN
Replies: 8
Views: 1294

maby this can help someone to help me out , i'm getting a beard at the moment: <?php if (!defined('MODULE_FILE')) { die ("You can't access this file directly..."); } define('INDEX_FILE', true); require_once("mainfile.php"); require_once("source/activecalendar.php"); $mo...
by wHiTeHaT
Sat Oct 14, 2006 12:01 am
Forum: Databases
Topic: INNER JOIN
Replies: 8
Views: 1294

Another attempt: CREATE TABLE `calendar` ( `calendar_id` int(11) NOT NULL default '0', `did` char(250) NOT NULL default '0', `calendar_date` date NOT NULL default '0000-00-00', `calendar_price` decimal(4,2) NOT NULL default '1.00', PRIMARY KEY (`calendar_id`) ) TYPE=MyISAM; CREATE TABLE `items` ( `p...
by wHiTeHaT
Fri Oct 13, 2006 9:47 pm
Forum: Databases
Topic: INNER JOIN
Replies: 8
Views: 1294

Comming back then to this tread again , sorry for the trouble in the other forum :oops: this is my first failed attemp wich failed :roll: : $result = $db->sql_query("SELECT * FROM products_to_calendar LEFT JOIN items AS i ON products_to_calendar.products_id = i.productsmain_id LEFT JOIN calenda...
by wHiTeHaT
Fri Oct 13, 2006 8:22 pm
Forum: PHP - Code
Topic: INNER JOIN 3 tables not know how!
Replies: 1
Views: 316

INNER JOIN 3 tables not know how!

Hello @all i'm having an issue with a db call. The folowing query is the one i use now, however i made a mis-coding couse it shouldnt rely on this call only at the end. This is couse i have to see if there's aditional data required. $result = $db->sql_query("SELECT UNIX_TIMESTAMP(calendar_date)...
by wHiTeHaT
Fri Oct 13, 2006 5:38 pm
Forum: Databases
Topic: INNER JOIN
Replies: 8
Views: 1294

I think i make some mistake on how to make sure i use the correct combination between a product and its attribute. please correct me if i'm wrong. Should i let check first the table products_to_calendar and then inner join table items(what hold the main product) and table calendar(what hold the date...
by wHiTeHaT
Fri Oct 13, 2006 3:30 pm
Forum: Databases
Topic: INNER JOIN
Replies: 8
Views: 1294

pff ok here we go:
by wHiTeHaT
Fri Oct 13, 2006 3:06 pm
Forum: Databases
Topic: INNER JOIN
Replies: 8
Views: 1294

Yes somehow i lost it in the post.


i also seeing i was to quick with asking , withouth making the basic structure first.
i have to excuse for this.
i will come back asp so i can go on to the main question , i think i'm a bit to excited. :oops:
by wHiTeHaT
Fri Oct 13, 2006 2:11 pm
Forum: Databases
Topic: INNER JOIN
Replies: 8
Views: 1294

INNER JOIN

Hello @all I'm working on a kind of shoppingsystem where have 1 main product what can be purchased by selected dates. not a date range but single day's , as i making this step-by-step and my php skils are limited i assume that i frequently will visit this site. I hope whenever see some other posts i...
by wHiTeHaT
Fri Oct 13, 2006 1:17 pm
Forum: PHP - Code
Topic: [SOLVED]Request help with better dbcalltoreduceloading time
Replies: 3
Views: 581

8) i have it $yearID=date("Y"); // current year $monthID=date("n"); // current month $dayID=date("j"); if (isset($_GET['yearID'])) $yearID=$_GET['yearID']; if (isset($_GET['monthID'])) $monthID=$_GET['monthID']; if (isset($_GET['dayID'])) $dayID=$_GET['dayID']; $now = t...
by wHiTeHaT
Fri Oct 13, 2006 1:11 pm
Forum: PHP - Code
Topic: [SOLVED]Request help with better dbcalltoreduceloading time
Replies: 3
Views: 581

lol... Ironic kendall i was just trying again and i think i found the solution... however yours do excact same as my solution. Infact it is couse of 2 scenario. my trick was the folowing: $result = $db->sql_query("SELECT UNIX_TIMESTAMP(calendar_date) AS calendar_date, calendar_id, calendar_pric...
by wHiTeHaT
Fri Oct 13, 2006 6:15 am
Forum: PHP - Code
Topic: [SOLVED]Request help with better dbcalltoreduceloading time
Replies: 3
Views: 581

[SOLVED]Request help with better dbcalltoreduceloading time

feyd | Please use , and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color] Hello @al...
by wHiTeHaT
Fri Oct 06, 2006 11:49 am
Forum: PHP - Code
Topic: Insert selected dates
Replies: 0
Views: 223

Insert selected dates

Hello @all i made a site with a few excisting scripts currently it fungate as a shoppingcart. take a look here: http://www.inteladd.com/modules.php?name=Fly_to_Basket&file=productinfo&Pid=1 As you can see here adding to cart works verry well. However i would like to add also dates to the dat...
by wHiTeHaT
Sat Nov 19, 2005 4:00 am
Forum: Volunteer Work
Topic: Gallery content as presentation on different pc (slideshow)
Replies: 4
Views: 3053

to point is i need a gallery for making adds and every add shows 1 minute long so i get 60 adds in a hour. Now emagine i would use your pc.. and a few other... no keyboard no mouse.. just screen. And there you would automaticly see a "slideshow" (they mostly come with a gallery). Ofcourse ...
by wHiTeHaT
Fri Nov 18, 2005 7:23 am
Forum: Volunteer Work
Topic: Gallery content as presentation on different pc (slideshow)
Replies: 4
Views: 3053

i'm not here to ask if anyone now a script what can do that, couse i know such script doesnt excist. That is why i ask here if anyone could help me build it , and as i sayed , i'm willing to pay for that. As that you want me to let me search google or hotscripts , wouldnt it be gentel if you first w...
by wHiTeHaT
Thu Nov 17, 2005 3:22 pm
Forum: Volunteer Work
Topic: Gallery content as presentation on different pc (slideshow)
Replies: 4
Views: 3053

Gallery content as presentation on different pc (slideshow)

I'm looking for anyone who can build or tweak a gallery for me with some special functions. *What should it do -Create normal album when user is registered each user have an admin pre-setted value for amount of space and image allowed , with on first creation a default value. Also non of the cliënts...