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

database design
Hi,

I got a page which allow candidate to type in their previous working experience,
I let

Header redirect
Hello ive got a problem ive got form with its action set to itself.
Code: <form id="f

redirect standard error and assert (how to?)
How do you redirect standard error and assert?

---

(Why? I am creating an web app and

switch form actions? not working
i want on submit to go to different pages according to the CatID

Code: <?php $CatID=$_

! = ''
In the following 'IF' statement if v_ompcat = PU for example then Oracle equates that 'IF' statement

Wierd echo error?
Hi, i got the most wierd php error ever and i don't know why..
Code: echo "<t

Concatenate two strings ???
I have string one $string1 and another $string2.

How to concatenate (add) both of them $str

get url?
how do i get the url of the page i'm currently on, on my website.. i think its get header.. how do i

help with email script...
hey

I need help with my mail script

when the form on http://www.mcgdesignstudio.com/c

Creating a unique 'control panel' for each user
Hi there,

I'm thinking of designing a site that will allow users to sign up and have their ow