Search found 11 matches

by mlkarie
Mon Oct 25, 2004 1:36 pm
Forum: Databases
Topic: Is this a URL problem? or a MySQL problem? or browser?
Replies: 8
Views: 812

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.
by mlkarie
Fri Oct 22, 2004 4:21 am
Forum: Databases
Topic: Is this a URL problem? or a MySQL problem? or browser?
Replies: 8
Views: 812

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...
by mlkarie
Fri Oct 22, 2004 2:26 am
Forum: Databases
Topic: Is this a URL problem? or a MySQL problem? or browser?
Replies: 8
Views: 812

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
by mlkarie
Thu Oct 21, 2004 3:54 am
Forum: Databases
Topic: Is this a URL problem? or a MySQL problem? or browser?
Replies: 8
Views: 812

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...
by mlkarie
Thu Oct 21, 2004 2:55 am
Forum: Databases
Topic: Is this a URL problem? or a MySQL problem? or browser?
Replies: 8
Views: 812

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,...
by mlkarie
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...
by mlkarie
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...
by mlkarie
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 ( &#1111;session_id] =&gt; c35a2559c95ede3bb525...
by mlkarie
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 ...
by mlkarie
Tue Oct 12, 2004 12:22 pm
Forum: PHP - Code
Topic: Problem retrieving session variables
Replies: 11
Views: 426

The values of session.use_cookies and session.use_trans_sid are ON for both local values and master values

To Twigletmac:

Apologies for not posting the code properly. I'm new to this forum, will check out the guidelines and do it properly next time.
by mlkarie
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...