ppetree

Can all users logged in to session1 also log in to session2 and can all users logged in to session2 also log in to session1? My thinking is that instead of seperate logins, you can have security levels. That failing, you can rename your session variables to SESS1_xxx and SESS2_xxx …

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 …

Hmm... I hesitate to jump in here as my suggestion will only complicate things (since you're new to both languages). The way you need to do this is via ajax calls to xyz.php and have it return json strings. Also if you're new to javascript, you'll wanna use jquery or …

By recording calls do you mean telephone calls? I did something similar a long, long time ago and its UGLY! Depending on the laws in the state/country where the phone order is being taken, it may not be legal to record the call without the customers permission so that requires …

First thing that jumped out at me was that $pages_query had no mysql_query() but you were doing $pages = ceil(mysql_result($pages_query, 0)/$per_page); Other than that, I think your whole $pages_query is unnecessary. I think you can use LIMIT in your second query and it will skip the first n results.

[CODE] if ( $obj = @mysql_fetch_object($r) ) { if($obj->approved == 1 && !$obj->banned) { // Login good, CREATE session variables $_SESSION["valid_id"] = $obj->id; $_SESSION["valid_user"] = $_POST["username"]; $_SESSION["valid_time"] = TIME(); // Redirect to member page Header("Location: index.php"); } else echo "user not approved or has been banned!"; } [/CODE]

Off the top of my head I would start with this... SELECT `Foyer`, SUM(IF(`Professeur` = "mrpopins", 1,0)) AS `count` FROM student_table WHERE `N_Etudiant` = 'Mike' GROUP BY `N_Etudiant` ORDER BY count DESC

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. …

Try the one I wrote... [URL="http://www.philpetree.com/ajaxforms/"]http://www.philpetree.com/ajaxforms/[/URL]

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 …

wouldn't you put a timestamp in the table and set its ON_UPDATE status so that anytime the row is modified the timestamp gets set to the current time? then you could check that timestamp against the timestamps in the master. but the bigger question is why are you having to …

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 …

[QUOTE=cscgal;196924]Here is some information about this: [url="http://dev.mysql.com/doc/refman/5.0/en/table-locking.html"]http://dev.mysql.com/doc/refman/5.0/en/table-locking.html[/url][/QUOTE] I had really only ever seen the MyISAM engine in use but when I installed MySQL Workbench it defaults to the innodb engine and that led me to do the same research you did and I concluded exactly what you did: MyISAM is …

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++) { …

Often times I see a SOAP document (blog or example) that references the WSDL from the client side as: [url]http://yourUserid:yourPassword@example.com/foobar.wsdl[/url] as in this example:[code] $client = new SoapClient("https://yourLogin:yourPassword@foo.com/bar.wsdl", array( "login" => "yourLogin", "password" => "yourPassword", "trace" => 1, "exceptions" => 0));[/code] How are they processing the userid/password and managing the …

I'm sure these are easy for someone but I am having problems with them. [b]Background Image Placement[/b] On this first problem, I have an image of some 36 point quote marks and I need to have next to the text. As my css manages this, it only happens when the …

Sorry for the duplicate post... I just posted an AJAX forms generator that will read a MYSQL table, allow you to define how the fields are treated and then generate the necessary HTML, Javascript and PHP files to implement the form. You end up with a complete and working form …

I just posted an AJAX forms generator that will read a MYSQL table, allow you to define how the fields are treated and then generate the necessary HTML, Javascript and PHP files to implement the form. You end up with a complete and working form backed by code thats very …

OK, putting together a simple table based on the output from a sql query. mysql_num_fields() returns 9 so I know I'm getting ONE row back. mysql_field_name($result, $i) returns the column name. When I try to output the table row(s), I get nothing... nada... zip... I must be missing something! (tired …

I think you're missing a field in your tables. I think after ID you need CUSTOMER_NUMBER and CUSTOMER_NUMBER should be the same for each account and should be the ID from the customer record.

I have created an array as: [CODE] //$field = "email"; //$value = "text"; $structure[$field] = $value; [/CODE] $structure gets passed to a function that uses a for() loop to work through a process and in this process I need to extract the key/value pair [CODE] for($i=0; $i<$cntFields; $i++) { $a …

I've started with the samples included with prototype.js which has the following code in the fillin example (a portion of which I want to isolate into its own function). The original code looks like this ([COLOR="red"]red[/COLOR] is what I want to isolate):[CODE] function dofill( ) { new Ajax.Updater( 'result', 'getdata.php', …

I have a block of code from a prototype.js (ajax code) sample and I want to modify it in order to isolate a piece of the code to make it more maintainable: The original code looks like this ([COLOR="red"]red[/COLOR] is what I want to move):[CODE] function dofill( ) { new …

What effects? I suspect you really just want to build backlinks to your site... just my hunch!

If you go to my site (link below) and click on the consulting tab you'll see where the .css is NOT working! If you scroll down to the bottom right corner of that page and click on the [URL="http://www.philpetree.com/consulting/strategy.html"]Strategy[/URL] you'll see that it works on THAT page. However it doesn't …

check out the contents of the $_GET or $_POST variables.

OK, I'm completely stumped by this one!!! Here's the code, it's included in the <head> tag as it should be... the files exist, the site works just fine. [CODE] <link rel="stylesheet" type="text/css" href="rateasite.css" /> <link rel="stylesheet" type="text/css" href="star-rating.css" title="Do dating sites work?" /> [/CODE] If I add a title="" to …

hmm... if I understand you, you have a text box that a user will enter data into and when they click a link (<a href='blah.php'>) you want the contents of that text field passed as a parameter to the file on the link (blah.php). Is that right? I think you …

This idea came from my days as a C programmer back eons ago. I created a function called OutputDebugString() that takes a string as an argument and writes that string to a mysql table you create in your database (.sql code included). From there, a seperate module, called from a …

I believe you only get a value back if the checkbox is checked. Download the debug script I posted and you can inspect the $_POST variables and see if checkbox is indeed there or not. [URL="http://www.daniweb.com/forums/thread291659.html"]Debug Code[/URL]

Create a php file that contains all your language strings. Name it something like language_xxx.php where language is the 3 char country code. Then you identify what country you need as output (user preference, location of users ip address etc.) and then read in that language file and anywhere you …

[code]<input type="text" name="pick2field" id="pick2field" size="30" value="<?php echo $apath ?>"/>[/code] Where is $apath defined? I see it used in an onclick() but thats a javascript function executed on the client side and you're using $apath on the server side. I'm just sayin...

sounds like your hostname is not being resolved through the DNS. Have you tried using an IP address to see if thats the problem? If you can't connect using an ip address then something (firewall?) is blocking the connection. If you're on windows machines you can edit hour hosts file …

Much easier to just change the select statement in working code (i.e. rajarajan's): [code] $query = "SELECT DISTINCT name FROM persons"; // execute query $result = mysql_query($query) or die ("Error in query: $query. ".mysql_error()); //Return number of rows based on your query and the table. echo mysql_num_rows($result); [/code]