Command and Conquer: Renegade Official Forums: Other

Home » Technical Support » Other » PHP issue

Show: Today's Messages :: Polls :: Message Navigator

Re: PHP issue [message #439799 is a reply to message #438943]

Sat, 20 November 2010 13:51

cnc95fan
Messages: 1261
Registered: July 2007

Karma:

General (1 Star)

I have yet another really weird issue, I've tried rewriting this thing about 4 times.
Basically, inside a DB there is for arguments sake, 3 tables.
The first table is an index, which contains 2 columns, id (as in some id in the URL) and a name.
The page is supposed to select from the index where $_GET['id'] is equal to id in the index, then look up the name in the same row. After getting the name it is then supposed to add on a postfix (such as x or y, so where the name would be renegade, the variable I assigned to the next task would be renegadex).

$pid = $_GET['id'];
$index = mysql_query("SELECT * FROM index where id = '".$pid."'") or die(mysql_error());
$row = mysql_fetch_array($index);
$thisvar = $row['name'];
$x = "x";
$query = mysql_query("SELECT * FROM ".$thisvar . $x." where uid = '".$_SESSION['id']."'") or die(mysql_error());
$row1 = mysql_fetch_array($query); 
$uid = $row1['id'];
echo $uid;

The echo returns nothing so I'm assuming that one of the mysql_querys is failing somewhere...

Report message to a moderator

[Message index]

		PHP issue By: cnc95fan on Fri, 05 November 2010 16:24
		Re: PHP issue By: Omar007 on Fri, 05 November 2010 16:46
		Re: PHP issue By: cnc95fan on Fri, 05 November 2010 16:51
		Re: PHP issue By: Omar007 on Fri, 05 November 2010 16:55
		Re: PHP issue By: Crimson on Fri, 05 November 2010 17:18
		Re: PHP issue By: danpaul88 on Sat, 06 November 2010 03:03
		Re: PHP issue By: cnc95fan on Mon, 08 November 2010 15:35
		Re: PHP issue By: danpaul88 on Mon, 08 November 2010 16:07
		Re: PHP issue By: cnc95fan on Thu, 11 November 2010 12:15
		Re: PHP issue By: danpaul88 on Thu, 11 November 2010 12:37
		Re: PHP issue By: cnc95fan on Thu, 11 November 2010 12:43
		Re: PHP issue By: danpaul88 on Thu, 11 November 2010 12:48
		Re: PHP issue By: cnc95fan on Fri, 12 November 2010 16:06
		Re: PHP issue By: danpaul88 on Sat, 13 November 2010 02:02
		Re: PHP issue By: cnc95fan on Sun, 14 November 2010 12:40
		Re: PHP issue By: danpaul88 on Mon, 15 November 2010 06:28
		Re: PHP issue By: cnc95fan on Tue, 16 November 2010 15:09
		Re: PHP issue By: danpaul88 on Tue, 16 November 2010 15:42
		Re: PHP issue By: Zion on Tue, 16 November 2010 16:40
		Re: PHP issue By: Ethenal on Tue, 16 November 2010 22:44
		Re: PHP issue By: cnc95fan on Sat, 20 November 2010 13:51
		Re: PHP issue By: Omar007 on Sat, 20 November 2010 16:04
		Re: PHP issue By: cnc95fan on Sat, 20 November 2010 16:07
		Re: PHP issue By: danpaul88 on Sun, 21 November 2010 15:25
		Re: PHP issue By: cnc95fan on Sun, 21 November 2010 16:14
		Re: PHP issue By: danpaul88 on Mon, 22 November 2010 09:56
		Re: PHP issue By: cnc95fan on Mon, 06 December 2010 09:13
		Re: PHP issue By: danpaul88 on Mon, 06 December 2010 10:00
		Re: PHP issue By: cnc95fan on Mon, 06 December 2010 11:30
		Re: PHP issue By: danpaul88 on Mon, 06 December 2010 15:45
		Re: PHP issue By: cnc95fan on Mon, 06 December 2010 15:56
		Re: PHP issue By: danpaul88 on Tue, 07 December 2010 05:33
		Re: PHP issue By: cnc95fan on Tue, 07 December 2010 06:09
		Re: PHP issue By: danpaul88 on Tue, 07 December 2010 11:26
		Re: PHP issue By: cnc95fan on Tue, 07 December 2010 11:52
		Re: PHP issue By: danpaul88 on Tue, 07 December 2010 11:56
		Re: PHP issue By: cnc95fan on Tue, 07 December 2010 11:58
		Re: PHP issue By: cnc95fan on Sun, 06 February 2011 10:14

Previous Topic:	GameSpy
Next Topic:	Generals... AGAIN

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Nov 26 16:11:46 MST 2024

Total time taken to generate the page: 0.01251 seconds