Query string not working???

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
cturner
Forum Contributor
Posts: 153
Joined: Sun Jul 16, 2006 3:03 am
Location: My computer

Query string not working???

Post by cturner »

When I test the code that is below, only the date appears in the query string. I know that the month and year are in the database. Can someone please make a suggestion to what could be wrong? Thanks in advance.

Code: Select all

require "config.php";
$id = $_GET['id'];
	  $select = mysql_query("SELECT * FROM newsletters WHERE id = '$id'") or die ("Could not query because: ".mysql_query());
	  while($r = mysql_fetch_array($select)) {
	  	echo '<a href=newsletter.php?date='.$r['date'].'&month='.$r['month'].'&year='.$r['year'].'>'.$r['date'].' '.$r['month'].' '.$r['year'].'</a>';
	}
if (mysql_affected_rows() == 0) {
	print "No newsletters to be displayed.";
}
mysql_close();
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

var_dump($r) help tell you anything?

mysql_affected_rows() is not for selects. I think you want mysql_num_rows().

$id has not been validated or escaped...
User avatar
cturner
Forum Contributor
Posts: 153
Joined: Sun Jul 16, 2006 3:03 am
Location: My computer

Post by cturner »

When I place var_dump($r); into my code it just displays int(1) continuously down the page. That is after I replace mysql_affected_rows() with mysql_num_rows(). I have tried mysql_fetch_assoc() and mysql_fetch_array() but the query string still doesn't display properly. When I try mysql_fetch_assoc() with var_dump($r) it displays:

Code: Select all

array(18) { 
	["id"]=>
	  string(1) "2" 
	["date"]=>
	  string(11) "Monday 25th" 
	["month"]=>
	  string(8) "December" 
	["year"]=>
	  string(4) "2006" 
	["select1"]=>
	  string(16) "The Wool Market-" 
	["txt1"]=>
	  string(17) "show me the money" 
	["select2"]=>
	  string(14) "Sale Position-" 
	["txt2"]=>
	  string(17) "show me the money" 
	["select3"]=>
	  string(12) "Merchandise-" 
	["txt3"]=>
	  string(17) "show me the money" 
	["select4"]=>
	  string(18) "Christmas Trading-" 
	["txt4"]=>
	  string(17) "show me the money" 
	["select5"]=>
	  string(8) "General-" 
	["txt5"]=>
	  string(17) "show me the money" 
	["select6"]=>
	  string(18) "The Cattle Market-" 
	["txt6"]=>
	  string(17) "show me the money" 
	["select7"]=>
	  string(14) "Some to Quote-" 
	["txt7"]=>
	  string(17) "show me the money"
}
When I try mysql_fetch_array() with var_dump($r) it displays:

Code: Select all

array(36) {
	[0]=>
	  string(1) "2" 
	["id"]=>
	  string(1) "2" 
	[1]=>
	  string(11) "Monday 25th" 
	["date"]=>
	  string(11) "Monday 25th" 
	[2]=>
	  string(8) "December" 
	["month"]=>
	  string(8) "December" 
	[3]=>
	  string(4) "2006" 
	["year"]=>
	  string(4) "2006" 
	[4]=>
	  string(16) "The Wool Market-" 
	["select1"]=>
	  string(16) "The Wool Market-" 
	[5]=>
	  string(17) "show me the money" 
	["txt1"]=>
	  string(17) "show me the money" 
	[6]=>
	  string(14) "Sale Position-" 
	["select2"]=>
	  string(14) "Sale Position-" 
	[7]=>
	  string(17) "show me the money" 
	["txt2"]=>
	  string(17) "show me the money" 
	[8]=>
	  string(12) "Merchandise-" 
	["select3"]=>
	  string(12) "Merchandise-" 
	[9]=>
	  string(17) "show me the money" 
	["txt3"]=>
	  string(17) "show me the money" 
	[10]=>
	  string(18) "Christmas Trading-" 
	["select4"]=>
	  string(18) "Christmas Trading-" 
	[11]=>
	  string(17) "show me the money" 
	["txt4"]=>
	  string(17) "show me the money" 
	[12]=>
	  string(8) "General-" 
	["select5"]=>
	  string(8) "General-" 
	[13]=>
	  string(17) "show me the money" 
	["txt5"]=>
	  string(17) "show me the money" 
	[14]=>
	  string(18) "The Cattle Market-" 
	["select6"]=>
	  string(18) "The Cattle Market-" 
	[15]=>
	  string(17) "show me the money" 
	["txt6"]=>
	  string(17) "show me the money" 
	[16]=>
	  string(14) "Some to Quote-" 
	["select7"]=>
	  string(14) "Some to Quote-" 
	[17]=>
	  string(17) "show me the money" 
	["txt7"]=>
	  string(17) "show me the money"
}

feyd | :roll:
Post Reply