Search found 11 matches
- Mon Oct 25, 2004 1:36 pm
- Forum: Databases
- Topic: Is this a URL problem? or a MySQL problem? or browser?
- Replies: 8
- Views: 813
URL variables not working in MySQL query
Thanks for the reply. I'm unable to try this straight away (marking exam papers) so will try your suggestion in two days' time or so, and reply.
- Fri Oct 22, 2004 4:21 am
- Forum: Databases
- Topic: Is this a URL problem? or a MySQL problem? or browser?
- Replies: 8
- Views: 813
URL variables not working in MySQL query
Not able to do the "print" of the $_GET variables right now, but just want to mention the following: I had the same problem in another file which received only one variable from the URL. The actual value of the variable was 131. In the PHP file I did "echo $id" after the $_GET st...
- Fri Oct 22, 2004 2:26 am
- Forum: Databases
- Topic: Is this a URL problem? or a MySQL problem? or browser?
- Replies: 8
- Views: 813
Problem re variables from URL, Mysql query does not work
Oops, that mistake crept in when I changed some variable names for this post, as I did not want to use the originals
So, the URL changes to:
page1.php?shop=abc&sports=123
So, the URL changes to:
page1.php?shop=abc&sports=123
- Thu Oct 21, 2004 3:54 am
- Forum: Databases
- Topic: Is this a URL problem? or a MySQL problem? or browser?
- Replies: 8
- Views: 813
Problems with PHP MySQL queries
<?php $shop = $_GET['shop']; $sports = $_GET['sports']; include("generalfiles/definitions.php"); include("generalfiles/connect2db.php"); $query2 = "SELECT * FROM dbtable WHERE shop = '$shop' AND sports = '$sports'"; $result2 = mysql_query($query2); if (!$result2) { $re...
- Thu Oct 21, 2004 2:55 am
- Forum: Databases
- Topic: Is this a URL problem? or a MySQL problem? or browser?
- Replies: 8
- Views: 813
Is this a URL problem? or a MySQL problem? or browser?
Problem description: User types page1.php?var1=shop&var2=sports This URL sent from my own two computers works fine, MysQL query finds the appropriate record, and next page is displayed correctly. On two computers in another office this works fine, but on three other computers in the same office,...
- Wed Oct 20, 2004 5:56 am
- Forum: PHP - Code
- Topic: Problem retrieving session variables
- Replies: 11
- Views: 426
Problem retrieving session variables
I have discovered that the reason why the session id is not being passed is related to this being a PHP/Flash system. When I use the loadvars.sendandload command in Flash, data is sent back and forth between the Flash movie and PHP, without reloading the HTML file, and the session id is not received...
- Wed Oct 13, 2004 8:28 am
- Forum: PHP - Code
- Topic: Problem retrieving session variables
- Replies: 11
- Views: 426
Problem retrieving session variables
I put in: <?php session_start(); print_r($_SESSION); // without the session_end(), which Dreamweaver/PHP doesn't recognise? When I go to the page before log on, it gives: Array ( [session_id] => ) After logging on it gives: Array ( [session_id] => c35a2559c95ede3bb5255f6f255a4d5f ) i.e. no name, sur...
- Wed Oct 13, 2004 7:38 am
- Forum: PHP - Code
- Topic: Problem retrieving session variables
- Replies: 11
- Views: 426
Problem retrieving session variables
feyd | Help us, help you. Please use and tags where approriate when posting code. Read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/color] Thanks, this is what I get from the print statement: Array ( їsession_id] => c35a2559c95ede3bb525...
- Wed Oct 13, 2004 6:50 am
- Forum: PHP - Code
- Topic: Problem retrieving session variables
- Replies: 11
- Views: 426
Problem retrieving session variables
I've turned on the error reporting and get the following: On the first call to this page (when the user has not logged on), the error message states "undefined index (session_id) on line 11", which makes sense because at that stage the session_id has not been created. After logging on and ...
- Tue Oct 12, 2004 12:22 pm
- Forum: PHP - Code
- Topic: Problem retrieving session variables
- Replies: 11
- Views: 426
- Tue Oct 12, 2004 7:03 am
- Forum: PHP - Code
- Topic: Problem retrieving session variables
- Replies: 11
- Views: 426
Problem retrieving session variables
twigletmac | Help us, help you. Please use and tags where approriate when posting code. Read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url][/color] I have written a complete login system in PHP/MySQL, which works fine on my local webserver. When I test thi...