stefands
-
Posts
13 -
Joined
-
Last visited
Never
stefands's Achievements
Newbie (1/5)
0
Reputation
-
[quote]See what I mean? Maybe you meant to sort by region or zip, then by name? [/quote] :-[ :P you are abso right. I need to get away from my pc is what the problem is... I'm very sorry for being a nuisance. Thx for setting me straight!! :-X
-
[tt] camp | region | postal ------------------------------------------------------------------ Camping Athens | Attica | GR-12136 Camping Bacchus | Attica | GR-19550 Camping Delphi | Cent. Greece | GR-33054 Camping Enjoy Lichnos | Epirus | GR-48060 Camping Hellas International | Thessaly | GR-38500 Camping Kalami Beach | Epirus | GR-46100 Camping Kokkino Limanaki | Attica | GR-19009 Camping Sikia | Thessaly | GR-38500 Camping Valtos | Epirus | GR-48060 Chrissa Camping | Cent. Greece | GR-33054 Ionion Beach | West Greece | GR-27050[/tt]
-
Hello all, I've defined an index over 3 columns called "cprgpt" in table "country1". The columns in question being "camp", "region" and "postal". The $wherevar has the dynamic generated WHERE statement. [code]$query = "SELECT * FROM country1 $wherevar ORDER BY camp, region, postal LIMIT $offset, $limit"; [/code] The output of the SELECT statement provides the data looked for, the problem is that it's only sorted by camp, not followed by the region and then by postal codes. What could be the problem here? PS: There is no other index that has "camp" and first key. The primary key index for the table is on another column (campid). I've also read the following info: [url=http://dev.mysql.com/doc/refman/4.1/en/order-by-optimization.html]http://dev.mysql.com/doc/refman/4.1/en/order-by-optimization.html[/url]
-
Loading new file via php as result condition check
stefands replied to stefands's topic in PHP Coding Help
I've read the sticky, other posts concerning this issue, etc. I'm passed the "header already sent" warnings and all that... but the redirect still doesn't work. The php code is above my <html>, checked if the condition statement is true etc? Any advise? [code] $total = 0 if ($total = 0){ header("Location: newsearch.php"); }[/code] -
Loading new file via php as result condition check
stefands replied to stefands's topic in PHP Coding Help
[code]$blah = 1; if ($blah == 1) { // example 1: redirect to new page header('Location: newpage.php'); exit; [/code] The redirect doesn't work. How can I break out of an if/elseif statement and go to an other page? -
Hello, I'd like to open a new php document as the result of a condition check (if/elseif statement). If certain criteria apply during the execution of a search, then a specific file should be loaded. Vars don't need to be passed, no database action needed. I tried an echo of the following code, which obviously didn't work :P ::) (just showing the basic html here!) [code]<HTML> <HEAD> <NOSCRIPT> <META http-equiv="Refresh" content="0; URL=http://www.mysite.com/noresult.php"> </NOSCRIPT> </HEAD> <BODY> </BODY> </HTML>[/code] :-\
-
Is this [code]$sel = new baaSelect();[/code] etc. and [code]$sel2 = new baaSelect();[/code] and so on? Sorry, I'm not into the jargon yet...
-
Thank you so much Barand, that works great! ;D ;D Hmm, I don't want to be pushing my luck here, but can you create 2 series of drop-downs on the same page? I could then use separate submit buttons for each group to define the resulting query... and save me an extra web page.
-
First off: "baaselect" rocks!! ;D One question: How do you create 3 drop-downs from that code? That would really make my day!! ;D ;)
-
This feature interests me. Is it as simple as (?): [code]<a href="javascript:history.back()">back</a>[/code] From what I gather this can cause problems, how is this? Many thx!
-
Wackamoly, you're tha man!!! ;D That works! Thx a lot 8)
-
When I use "print(get_defined_vars());" I get "Array" as result. This is where I use the var: $query = "SELECT * FROM greece WHERE campref='$cmpnr'"; How would I use superglobals here as you say? What's more: when I use the syntax "resultone.php?cmpnr=value" then php should automatically create the variable $cmpnr in "resultone.php" right? I don't get any warnings when using an "echo $cmpnr;" so the variable is created. If php recognises that it must create $cmpnr then why doesn't it add the given value, which in this case is "GR8590"?
-
Hello all, I've searched through the current postings to find a solution for my problem, without result, hence this posting ::) I'm trying to pass a variable from one page to another. My webhosing company is running PHP 5.0.5 and "register_globals" is set to "on" in my php.ini file. This is an example line of code I'm using: <a href=\"resultone.php?cmpnr={$row["campref"]}\"><img src=\"../images/icons/moreinfo.gif\" width=\"62\" height=\"17\" border=\"0\" align=\"middle\"></a> As an example, the link in the browser looks like so: http://www.mywebsite.com/resultone.php?cmpnr=GR8590 So far so good I though... However, when using the link and checking the newly auto-defined variable $cmpnr in 'resultone.php' - it's empty?? I'd really appreciate any advise on this. Thx!