[PHP] STRANGE : SELECT OK on Localhost, OK within Dreamweaver, OK on phpmyadmin on site, BUT NOT OK on webpage???????HELP
Following select statement works OK on Localhost, OK within Dreamweaver test, OK on phpmyadmin on site, BUT NOT OK on webpage. It's the IF part where it states if(m.matchtypeid < 3, etc Here on the webpage itself it shows the 'in-/uitschrijven' or 'gesloten' bit on those lines where it shouldn't , and just can't figure out why, they do not show when testing with sqlyog on local pc, within dreamweaver mx test module, withing phpmyadmin on site. STRANGE STRANGE!!! Any brains around who can help me please! Thanks, Martin SELECT distinct m.id, m.naam, left(m.startingtime,5) as starttijd , if(isqualifying,'Ja','') as Q, date_format(playingdate,'%d-%m') as datumpje, mt.naam as soort, if(playingdate < FROM_DAYS( TO_DAYS( NOW( )) + 21), if(m.matchtypeid < 3 , if(playingdate > FROM_DAYS( TO_DAYS( NOW( )) + 9) , 'in-/uitschrijven' , 'Gesloten' ) , '' ) , '' )as inschrijven, if(f.matchid = m.id, 'Startlijst', if(wi.zoekcode='$details[1]','Ingeschreven', date_format(if(playingdate < FROM_DAYS( TO_DAYS( NOW( )) + 9), '', FROM_DAYS( TO_DAYS( playingdate ) -21)),'%d-%m'))) as enu FROM match1 as m left outer join matchtype mt on mt.id = m.matchtypeid left outer join flight f on f.matchid = m.id left outer join wedstrijdinschrijvingen wi on wi.matchid = m.id and wi.zoekcode='$details[1]' WHERE playingdate > ( NOW( )- 3 ) ORDER BY playingdate -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] How to prevent re-entry of data upon page refresh?
Am using dreamweaver and hv an entry form on a page, which works fine, unfortunately upon page refresh the data gets entered another time and another time again on refresh. Any solutions on this? Thanks, Martin -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] relayed mail question
Situation: 1) have a website with www.widexs.nl called www.webwabwob.nl 2) have a domainname with www.bulkregister.com and basicDNS service 3) have configured basicDNSservice of bulkregister to transfer to www.webwabwob.nl Problem: All mail send to specific addressee ( [EMAIL PROTECTED] ) is unable to be received, error message received shown below. Question: Where's the problem, how can I set up my website to receive and accept these emails? Hope there's someone able to help me here, it would be appreciated very much, thanks, Martin quote- The Postfix program <[EMAIL PROTECTED]>: Name service error for MAIL.rtinsmetsers.com: Host not found unquote -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] php conditional formatting question
I know it's possible, but I just can't get it working. In an old file I have a straight php coding doc where it's used and am now trying to mimic the resulting output. I'm trying to get a result from a query in a specific color when it fits the bill ( if ($teamcaptain == $deelnemer) //if yes, we'll make the result green echo ""; etc (SEE BELOW)) when the person ($deelnemer) also fits the $teamcaptain I want this one to be listed in different format, I dont care if it's only color or if it's a css. Hope there's someone able to help me here, thanks, Martin The Netherlands part of php code: do { ?> "; } ?> -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Problem solved
Just in case someone wants to know : I had to uncheck the passing parameters in the go to detailpage parameter box! Martin "Wmb" <[EMAIL PROTECTED]> schreef in bericht [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... | Hope Í'm at the right place to ask this question. | | Am using DMX and encounter following problem: | | Have a connection to a database with plenty of data. | On a page which shows part of these records (10 max) I have a go to detail | page action which works fine when called from the 1st 10 records, but when | called from any other page (not the 1st 10 records any more) it suddenly | sends the following header: | quote-- | http://blabla.com/detailshowpage.php?pageNum_Recordset1=2&totalRows_Recordse | t1=1130&lidnummer=515 | unquote-- | and now the detailshowpage doesn't work correctly, | | while when done from the 1st page with the 1st ten records it only sends: | quote-- | http://blabla.com/detailshowpage.php?lidnummer=515 | unquote-- | | on the page I am using the recordset paging functions, and this is pbly | causing it but just don't know how to solve my little problem here. | | Your help is appreciated, thanks, | Martin | | | -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] go to detail page problem
Hope Í'm at the right place to ask this question. Am using DMX and encounter following problem: Have a connection to a database with plenty of data. On a page which shows part of these records (10 max) I have a go to detail page action which works fine when called from the 1st 10 records, but when called from any other page (not the 1st 10 records any more) it suddenly sends the following header: quote-- http://blabla.com/detailshowpage.php?pageNum_Recordset1=2&totalRows_Recordse t1=1130&lidnummer=515 unquote-- and now the detailshowpage doesn't work correctly, while when done from the 1st page with the 1st ten records it only sends: quote-- http://blabla.com/detailshowpage.php?lidnummer=515 unquote-- on the page I am using the recordset paging functions, and this is pbly causing it but just don't know how to solve my little problem here. Your help is appreciated, thanks, Martin -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Why oh Why????
As a beginner I have been trying and trying, but to no suc6. Hope there's someone here able to help me out: Am trying to get rid of spaces and change all into uppercase in an entered form variable, which I am able to do when trying things out but when running the full php statement it refuses to change and enters the original variable into the database anyway. Haven't got a clue why. Please, what's wrong with the following: if(mysql_result($query, 0, 0) == 0)// && (mysql_result($query2) > 0)#) { $password = md5($_POST['strPassword']); $newstrUserName = $_POST['strUsername']; $newstrUserName = strtoupper(ereg_replace(" ", "", $newstrUserName)); $strQuery = "INSERT INTO users ("; $strQuery .= "`username`, `password`, `level`, `firstname`, `lastname`, `ngfnummer`, `email`) VALUES ("; $strQuery .= "'$newstrUserName', '$password', '1', '{$_POST['strFirstName']}', '{$_POST['strLastName']}', '{$_POST['strNgfnummer']}', '{$_POST['strEmail']}')"; if(mysql_query($strQuery)) etc etc etc original username given f.i. 'joe 8', $newstrUserName makes this 'JOE8', but the above still enters 'joe 8' into database, how come? Thanks, Martin -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Are 2 mysql_query statements psble?
The code below returns : "Parse error: parse error, unexpected T_BOOLEAN_AND ". so must assume it's not possible, but anybody out there who's able to give me a suggestion how to get this going. 2 different tables have to be checked for correct input from form. (Would even want to do a third) Thanks, Martin QUOTE+ if($dbConn) $query = mysql_query("SELECT count(*) FROM users WHERE username = '{$_POST['strUserName']}'"); $query2 = mysql_query("SELECT count(*) FROM lid WHERE Ngfnummer = '{$_POST['strNgfnummer']}'"); if(mysql_result($query, 0, 0) == 0) && (mysql_result($query2, 0, 0) == 0) { UNQUOTE+ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Great solution, but... another question
Like you say it works (with the correction) "." for which my thanks, but: if one my includes is a menu.php where there are links inside, how should these work from rootdirectory and from subdirectories. for rootfilelinks they now just say f.i. index.php, but when called from inside a subdirectories they are supposed to say /index.php. Any solutions for this one?? thanks Martin -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Continued story on : PHP includes without access to the default directory//Tom Rogers//
Hi, original messagethread on dec 6, 2002, but still have following question on same/continued subject by Tom Rogers:(see below) Like you say it works (with the correction) "." for which my thanks, but: if one my includes is a menu.php where there are links inside, how should these work from rootdirectory and from subdirectories. for rootfilelinks they now just say f.i. index.php, but when called from inside a subdirectories they are supposed to say /index.php. Any solutions for this one?? thanks Martin =Original Posting=== Saturday, December 7, 2002, 7:15:38 AM, you wrote: >> ini_set G> ("include_path","/path/to/local/includes:"ini_get("include_path")); >> >> Then no matter what directory you are in you can just include("filename"); >> >> -- >> regards, >> Tom >> G> Thank you. This should work, but I have one question about the format of G> that. this way I can make sure I do things right (getting a parse error G> right now) G> what did you mean by "include_path"? G> /path/to/local/includes is just the path to the default includes folder? G> and is include_path just the path to the includes folder that I use. And G> with this, do I use the URL, or the file path (what I get whenever I get G> errors) G> and thank you again Looks like I forgot a '.' in there :) "/path/to/local/includes:" is the path to your new includes, we do that first so that is the first place it will look . The ':' is used to add in another path which we use ini_get() to retrieve the system wide include file from php.ini. You may drop this and the ':' if you don't need it. so if you are setup like this for example /home/username/public_html/...web directory /home/username/includes/..your include directory the line would be ini_set("include_path","/home/username/includes:".ini_get("include_path")); -- regards, Tom -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php