select statment incrementing records

malbert77

I am having a strange problem with my select statement. It is return this:
ResultID #2
Basically I have figured out that it is finding the first record but only return values if there is a second record with the same id. I am not sure why it is doing this. Me and all my tech friends are completely stumped on this one. Can someone please help me out.
Here is a copy of the section of code. Tnx.

#!/usr/local/bin/php
<?php
session_start();
session_register("id");
$id=$HTTP_GET_VARS["ids"];
echo $id;
?>

    <head>
            <meta http-equiv="content-type" content="text/html;charset=iso-8859-1">
            <title>HipHopG - Card Pickup</title>

<?php
$db = mysql_connect("unixsql4.interland.net", "HipHopG", "Maclure71132");
mysql_select_db("hiphopgcom", $db);
//---> bad code:>
$result = mysql_query("SELECT * FROM send WHERE ids = $id");
echo $result;

Anon

If id is a text field, you have to enclose it between single quotes. Like in

SELECT * FROM send WHERE ids = '$id'

and also, make sure that the field name is ids.

fLIPIS

Anon

The value returned from mysql_query is just a handle. To get the actual result you to call Mysql_fetch_array or something with that handle.

$result = mysql_query("SELECT * FROM send WHERE ids = $id");
while($row = mysql_fetch_array($result)) {
echo $row["column1"];
echo $row["column2"];
}

http://www.php.net/manual/en/function.mysql-fetch-array.php

malbert77

Thank you Lars and Flipis...both of you suggestions have helpped me resolve all of the db problems I was having. Thank you so much.

Late