Silly

[LiLaaron]

Hey all

Getting a small problem, that would most prob take seconds to fix, my head has gone blank... :glare:

		elseif ($page == 'eracquet') {
		?>
<table align="center" width="780" border="0" cellpadding="0" cellspacing="0">
	<tr>

	<?php
	include 'template/admin_left.php';
	$racquet = $_POST['racquet'];
		if (isset($racquet)) {
		$rid = $_POST['selracquet'];
		$query = "SELECT * FROM rstring_racquet WHERE index = ".$rid."";
		$result = mysql_query($query);
		$row=mysql_fetch_array($result);
		$id = $row['index'];
		$name = $row['name'];

	?>

	<td valign="top" class="main">
		<img src="template/images/admin.jpg" width="533" height="50">
		<div class="maintext">


		<strong>Edit Racquet</strong>
		<br><br>Change Racquet Type<br>
		<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
		<input type="text" value="<?php echo $name; ?>" name="name" id="name">
		<input type="hidden" name="id" value="<?php echo $id; ?>"><br><br>
		<input name="eracquet_submit" type="submit" value="Save">
		</form>


		</div></td>
</tr>
</table>
		<?

		} else {

	?>

	<td valign="top" class="main">
		<img src="template/images/admin.jpg" width="533" height="50">
		<div class="maintext">


		<strong>Edit Racquet</strong>
		<br><br>Select Racquet Type<br>
		<form method="post" action="admin_page.php?page=eracquet">
		<select name="selracquet">

		<?
		$query = "SELECT * FROM rstring_racquet";
		$result = mysql_query($query);
		while ($r=mysql_fetch_array($result)) {
		$id = $r['index'];
		$name = $r['name'];
		echo '<option value="'.$id.'">'.$name.'</option>';
		}
		?>

		</select>
		<input type="hidden" name="racquet" value="1"><br><br>
		<input name="eracquet_submit" type="submit" value="Edit">
		</form>


		</div></td>
</tr>
</table>
		<?
			}

Getting error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/xpixalc/public_html/rstring/admin_page.php on line 191

This is the line(s):

			$query = "SELECT * FROM rstring_racquet WHERE index = ".$rid."";
			$result = mysql_query($query);
			$row=mysql_fetch_array($result);

Thanks for any help

[richie]

The only thing I see is the double double quote:

        $query = "SELECT * FROM rstring_racquet WHERE index = ".$rid."";
        $result = mysql_query($query);
        $row=mysql_fetch_array($result); 

You probably wanted to do this:

        $query = "SELECT * FROM rstring_racquet WHERE index = '$rid' ";
        $result = mysql_query($query);
        $row=mysql_fetch_array($result);

[cahva]

index is a reserved word so you shouldnt use it and thats why it gives you an error. Better call it id or something else. You can use index if you really, really want by using character round it:
[code=php]
$query = "SELECT * FROM rstring_racquet WHEREindex` = ".$rid;
[/code]
But I suggest that you change the field name.

@
If index is integer, you dont have to use simple quotes.

[richie]

cahva;10894253 wrote:

@
If index is integer, you dont have to use simple quotes.

You're right. But it doesn't hurt either.