- Strength to Increase Rep
- +0
- Strength to Decrease Rep
- -0
- Upvotes Received
- 5
- Posts with Upvotes
- 5
- Upvoting Members
- 5
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
|
Hello This is a simple php login script with sessions. It connects to mySQL for usernames and passwords. I’m using a variation of the code from [url]http://www.phpportalen.net/wiki/index.php?page=Enkel+Inloggning+med+Mysql+och+sessioner+-+Komplett+kod[/url] (index.php is the relevant part) Here is my code (my script is called login.php): [code=php] <?php session_start(); // Always at the top include …
|
|
|
OK gang! I have another stumper! I want to add a variable to an array from within a function and I will not know the variables original name so how can I find this? For instance: [CODE] function AddVariable($vartoadd) { $varlist[] = $vartoadd; } $domain = http://www.dodatingsiteswork.com; AddVariable($domain); [/CODE] Once …
|
|
|
I need a little help architecting a process that is a little beyond my skill set so if I could get a little help in how to approach this, I would appreciate it. Basically: BigBox Corporation has 15,000 employees in multiple countries. They want to build a communications system consisting …
|
|
|
hi, i have two drop down list. First one is populated from database and its working fine. Second one will also be populated from database but as per the value selected from the first drop-down list. [CODE]<head> <script type="text/javascript"> function xyz_list() { // xyz_list is the id of ;;my first … 
|
|
|
Re:
record calls
hi guys, not sure where to start so thought i would see if any you guys have any knowledge on recording calls into a backend website running on php/mysql? site is running a sales order system and working fine however they want to record calls into the database so guess …
|
|
|
[B]guys i am really stuck in this tried couples of ways but didnt get it right please help.My pagiantion is working fine and great untill i specfies WHERE CLAUSE in it.I am trying to have a text field so that if a user enter the interger for class search e.g …
|
|
|
I want to make option to approve users before they can login or to ban them, here is code [CODE]MySQL Syntax (Toggle Plain Text) <HTML><HEAD><TITLE>Fakultet informacionih tehnologija</TITLE> </HEAD> <BODY TEXT="#ffffff" BACKGROUND="fakultet/Assets/bg.jpg" LINK="#FFFF00" VLINK="#CDCD00" BGCOLOR="#000000"> <CENTER><TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0 WIDTH="700"> <CENTER> <FONT SIZE=+4 FACE="arial,helvetica"> Fakultet informacionih tehnologija <HR> </CENTER> <?php session_start(); …
|
|
|
Re:
stuck in query..
hey guys this is the structure of the Db: `Ex_ID` int(11) NOT NULL auto_increment, `N_Etudiant` varchar(25) NOT NULL, `Professeur` varchar(50) NOT NULL, `Foyer` varchar(50) NOT NULL, `Motif` varchar(50) NOT NULL, `Date` date NOT NULL, `Notes` text NOT NULL, `Autre` varchar(150) NOT NULL, so basically N_Etudiant is a student name.. so …
|
|
|
Hey All... This query is waaaay outside my skill set so I can't even fathom how to do this other than the "brut force" method and that's way to slow for my purpose (a mobile app). I have two tables, `Categories` and `Articles`: `Categories` has: `id`, int auto-increment `name` text …
|
|
|
This seems like it should be a simple query but I think I have my eyes in backwards... Give me all the users living in Jefferson, Bingham, Butte, Bonneville and Madison counties in the state of Idaho. [code]SELECT * FROM table WHERE county='Jefferson' OR county='Bingham' OR county='Butte' OR county='Bonneville' OR …
|
|
|
OK, I have a table that has: id (int), name (varchar), parent (int) If parent contains NULL it IS the "parent" otherwise it is the child of a parent So: id=1 name=Meals parent=0 Means the above record is a "parent" (there are 100's of parents). So far, so good? Next …
|
|
|
I have a row of three images that are currently displaying just fine. Now, I want to display two more images right below those three and I want them centered (it would kinda look like an upside down pyramid). No matter what I do, the bottom row stays left aligned. … |
|
Hi All, does anyone know of a PHP FORM GENERATOR, that either exists as a downloadable app or an online generator I use a Mac. I don't want to sign up and pay per form generated, i don't mind paying for the app as long as it works. i just …
|
|
|
Hey All! I'm having trouble getting the nodeValue of a specific set of nodes. The xml looks like this: [ICODE] <root> <SpecialParameter>Some Text</SpecialParameter> <SpecialInfo someNumber="123456789"></SpecialInfo> <book> <title>Rusty Bedsprings</title> <author>I. P. Knightly</title> </book> <book> <title>Rush To The Out House</title> <author>Willie Makeit</title> </book> </root> [/ICODE] What I need to get are the …
|
|
|
Hi, I am having the table of the following details. [B]rollno subject standard[/B] reg01 maths III reg01 physics III reg01 english III This reg01 student has registered this courses. He can make changes this registered courses. How can i find the "updation"(or differences) of my table as the previous using …
|
|
|
Hi All! I'm apparently doing something very wrong here... I can't get my soap client to send the security certificate which a valid .pem file and because of that the subsequent calls are failing. What do I have to do to get the soap client to send the pem file? …
|
|
|
I'm trying to do a little pre-planning here... Let's say I have a user table that has 25 million users spread across all 50 states. Lets also say I have to send an EMERGENCY email to each of these 25 million users... (asteroid hitting planet type of emergency) What would …
|
|
|
I have 2 tables: Users and Log I want to select ALL users from Users who are not in Log having already received a msg_id matching 'x' What I have so far is this: [CODE] SELECT * FROM users AS USR WHERE USR.user_id=2 NOT IN ( SELECT * FROM msg_log …
|
|
|
Hi All... I'm wondering if an extra pair of eyes can find a problem with this trigger: [CODE] DELIMITER // CREATE TRIGGER `auto_approval` BEFORE UPDATE ON `my_table` FOR EACH ROW BEGIN SELECT security INTO user_sec FROM users WHERE userid=NEW.userid; IF user_sec >= 10 THEN set NEW.admin = 1; IF NEW.admin …
|
|
|
OK, I admit I am completely clueless on how to perform this one. In one table I have a list zip codes and the user will select one or more from this list. Once I have those zip codes, I need to perform my query and this is where it …
|
|
|
Situation: I have a form (dont we all! LOL) It's in a table (sigh) The table has 4 rows <tr> and 2 columns Each row has a <fieldset> containing multiple <labels> and various types of input fields (input, selects, radio, check) The CSS formats the labels to appear above the …
|
|
|
[B]Problem:[/B] I have a zip_code/city/state table that has full names and abbreviations for some common things like FT (FORT) and IS (ISLAND). So, I may have a record something like this: zip = '31522' city = '[COLOR="red"]IS [/COLOR]HARBOR POINTE' locationtext = 'Is Harbor Pointe' location = 'US-GA-[COLOR="red"]IS [/COLOR]HARBOR POINTE' and …
|
|
|
Hi All! I have a zip code table that has the zip code, city, state and various other info in each row. The problem is that if I pull up all the cities in a zip code (say 33308) I get the same city spelled twice like this: [CODE]Fort Lauderdale …
|
|
|
I'm not sure where to begin on this... I have a survey engine that supports 7 types of questions and really an unlimited number of entries per question (yes/no being one exception). So, I have 7 tables and each table correspondes to one answer type so I have: response_bool (true/false …
|
|
|
I'm getting constant 404's on my mod-rewrites... this was working and I have no clue where to start looking to debug this so I would appreciate some help... ANY help!!! :) [B]This is the error from the error log:[/B] [Sat Mar 26 17:40:36 2011] [error] [client 89.23.133.199] File does not … |
|
Re:
MyISAM vs InnoDB
When is it appropriate to use InnoDB table types? What about for a forum such as this one with huge post and thread and memberlist tables? I was reading on dev.mysql.com that it is more efficient than MyISAM for large table types? Is this always the case? Would it make …
|
|
|
It's been many, many years since I have written any ASP code and I dont recall this functionality being present in the past BUT: In php we have a serialize() that takes an array of data and creats a single string representation of that data. The single string can then …
|
|
|
This trigger is making me nuts! I've written about a dozen triggers before but nothing where I have ever pulled data from another table. What this is supposed to do is make sure that any inserted rows have a latitude/longitude (lat/lon) value. The users table has the lat/lon and these …
|
|
|
I'm having problems creating the following trigger as I keep getting the syntax error listed below the sql code and well, that error is about as clear as mud! LOL Two things to note: users is a valid table name and it does contain fields called lat & lon (latitude …
|
|
|
Can anyone tell me why this code is not working? It outouts 8 colons, one for each element but no data which means the [$i] is NOT referencing the array element [CODE] $geo_addr = array("number"=>1600, "zip"=>34208, "suffix"=>'', "prefix"=>'', "type"=>'parkway', "street"=>'amphitheatre', "state"=>CA, "city"=>'mountain view'); $count = count($geo_addr); for($i=0; $i<$count; $i++) { …
|