SQL Query/echo not working

Posted on 16th Feb 2014 07:03 pm by admin

Hey all,

I'm trying to run (what I thought) was a simple operation and it isn't working. I haven't coded anything in about 2 years, and I'm self taught at that so I know I've got quite a few gaps in my knowledge base.

Here's what is running right now:

Code: <?php

$con = mysql_connect("localhost","adminaccount","adminpassword");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("mornin14_idiot2009", $con);

$id = $_GET['id'];

$query = "SELECT * FROM idiot WHERE index = '15'"; //I want this to say WHERE index = $id, but I'm testing this with just a #
$result = mysql_query($query);

$numrows = mysql_num_rows($result);


for ($x=0; $x<$numrows; $x++){
$result_row = mysql_fetch_row($result);
echo $result_row[0];
echo "<br />";
echo $result_row[1];
echo "<br />";
echo $result_row[3];
echo "<br />";
echo $result_row[5];
echo "<br />";

}


?>


Now it should only be returning one row since I'm checking for a specific index #.

When I just do a basic select * from idiot and omit the where clause, it works fine and dumps the whole table in the for loop. But if I try a specific where, it falls apart. Any help would be greatly appreciated.

Your Answer:

Login to answer

Other forums

HOW to get the bind variables list.
I've the following problem : I've some SQL queries stored in my DB as VARCHAR2 values.
I need t

image upload, resize THEN submit form
Ok so I have a form that requires the user to upload an image, and then do something with that image

 formating when pulling data from a mysql database 
Ok so Im not to sure if this is the right thread to post in but here is my catch 22 issue.

I 
Cache PHP Objects/Classes? 
Does anyone have ideas about caching PHP objects using something like: http://memcached.org/

urldecode question 
How would I format this line of code properly?

<?php echo urldecode($_GET['Title']); ?
Strip Slashes Help 
I've got a script that i've downloaded of the net to edit multiple fields from my sql database, and 
How do I get the row number from from an sql table query 
Hi all

I have a table that I query and it returns a number of rows.
mysql_num_rows($query)
Search with relational database 
Hey,

I have quite a complicated (for me anyway  ) relational database for an apartments syste
if php cookie set, show code... 
Hi all.. I need to figure out this little snippet right quick.. seems like it should be easy enough 
PHP If Else statement for breadcrumb 
Hi

I am trying to use a PHP if else statement to display a breadcrumb link on wordpress