DaniWeb Forum Index > Web Development > PHP

Grab a row

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Dec 2007

Posts: 54

Reputation: rouse is an unknown quantity at this point

Solved Threads: 1

rouse

Offline

Junior Poster in Training

Grab a row

Dec 3rd, 2008

I am trying to get a row from a table based on the record number, a unique ID in a table which is passed from another form. The record number seems to be passed correctly and is received on the forwarding page. The query in the PHP page does not bring up values in the receiving page although the query works when tried from an external application. Below is a listing of the PHP code. Could some one point out what I am doing incorrectly. Thanks!

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
<?php
include("connect.php");
$id = $_GET['id'];
 
$qProfile = "SELECT * FROM signers WHERE recordNum='$id'  ";
$rsProfile = mysql_query($qProfile);
$row = mysql_fetch_array($rsProfile);
extract($row);
$recordnum = stripslashes($recordnum);
$firstmiddlename = stripslashes($firstmiddlename);
$lastname = stripslashes($lastname);
…
…
mysql_close();?>
<?php
include("connect.php");
$id = $_GET['id'];

$qProfile = "SELECT * FROM signers WHERE recordNum='$id'  ";
$rsProfile = mysql_query($qProfile);
$row = mysql_fetch_array($rsProfile);
extract($row);
$recordnum = stripslashes($recordnum);
$firstmiddlename = stripslashes($firstmiddlename);
$lastname = stripslashes($lastname);
…
…
mysql_close();?>

•

Join Date: Jun 2008

Posts: 62

Reputation: PomonaGrange is an unknown quantity at this point

Solved Threads: 3

PomonaGrange PomonaGrange is offline

Offline

Junior Poster in Training

Re: Grab a row

Dec 3rd, 2008

•

$qProfile = "SELECT * FROM signers WHERE recordNum='$id' ";

I think it would work to use something like this...

$qProfile = "SELECT * FROM signers WHERE recordNum='".$id."' ";
Hope This Helps.

There are alot of people smarter than me, BUT at least I try to be of some help. Of coarse I'm not perfect, I need help too.

•

Join Date: Nov 2008

Posts: 24

Reputation: xarz is an unknown quantity at this point

Solved Threads: 1

xarz

Offline

Newbie Poster

Re: Grab a row

Dec 3rd, 2008

i don't know if this will really work or not but instead of having

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
extract($row);
$recordnum = stripslashes($recordnum);
$firstmiddlename = stripslashes($firstmiddlename);
$lastname = stripslashes($lastname);
extract($row);
$recordnum = stripslashes($recordnum);
$firstmiddlename = stripslashes($firstmiddlename);
$lastname = stripslashes($lastname);

you can try

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$recordnum = stripslashes($row['recordnum']);
$firstmiddlename = stripslashes($row['firstmiddlename']);
$lastname = stripslashes($row['lastname']);
$recordnum = stripslashes($row['recordnum']);
$firstmiddlename = stripslashes($row['firstmiddlename']);
$lastname = stripslashes($row['lastname']);

Last edited by xarz; Dec 3rd, 2008 at 8:42 pm. Reason: wrong closing tag for code

:: xarz ::

•

Join Date: Jun 2008

Posts: 62

Reputation: PomonaGrange is an unknown quantity at this point

Solved Threads: 3

PomonaGrange PomonaGrange is offline

Offline

Junior Poster in Training

Re: Grab a row

Dec 3rd, 2008

I don't know why I didn't catch that. I usually use something similar to the following.

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$qProfile = "SELECT * FROM signers WHERE recordNum='".$id."' ";
$rsProfile = mysql_query($qProfile);
while ($row = mysql_fetch_assoc($rsProfile)){
 
$recordnum = stripslashes($row['recordnum']);
$firstmiddlename = stripslashes($row['firstmiddlename']);
$lastname = stripslashes($row['lastname']);
…
…
mysql_close();?>
$qProfile = "SELECT * FROM signers WHERE recordNum='".$id."' ";
$rsProfile = mysql_query($qProfile);
while ($row = mysql_fetch_assoc($rsProfile)){

$recordnum = stripslashes($row['recordnum']);
$firstmiddlename = stripslashes($row['firstmiddlename']);
$lastname = stripslashes($row['lastname']);
…
…
mysql_close();?>

Hope some of this helps...

There are alot of people smarter than me, BUT at least I try to be of some help. Of coarse I'm not perfect, I need help too.

•

Join Date: May 2008

Posts: 67

Reputation: Kavitha Butchi is an unknown quantity at this point

Solved Threads: 3

Kavitha Butchi Kavitha Butchi is offline

Offline

Junior Poster in Training

Re: Grab a row

Dec 4th, 2008

Hi try this,

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
 
 
<?php
include("connect.php");
$id = $_GET['id'];
 
$qProfile = "SELECT * FROM signers WHERE recordNum='$id'  ";
$rsProfile = mysql_query($qProfile);
$row = mysql_fetch_array($rsProfile);
$recordnum = stripslashes($row['recordnum']);
$firstmiddlename = stripslashes($row['firstmiddlename']);
$lastname = stripslashes($row['lastname']);
…
…
mysql_close();?>

<?php
include("connect.php");
$id = $_GET['id'];

$qProfile = "SELECT * FROM signers WHERE recordNum='$id'  ";
$rsProfile = mysql_query($qProfile);
$row = mysql_fetch_array($rsProfile);
$recordnum = stripslashes($row['recordnum']);
$firstmiddlename = stripslashes($row['firstmiddlename']);
$lastname = stripslashes($row['lastname']);
…
…
mysql_close();?>

Last edited by Kavitha Butchi; Dec 4th, 2008 at 9:16 am.

Kavitha
I Love My Indonesia.

•

Join Date: Dec 2007

Posts: 54

Reputation: rouse is an unknown quantity at this point

Solved Threads: 1

rouse

Offline

Junior Poster in Training

Re: Grab a row

Dec 4th, 2008

None of these suggestions worked. I am surprised this task is so tricky.

•

Join Date: Jun 2008

Posts: 62

Reputation: PomonaGrange is an unknown quantity at this point

Solved Threads: 3

PomonaGrange PomonaGrange is offline

Offline

Junior Poster in Training

Re: Grab a row

Dec 4th, 2008

Try This...

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<?
$server = ""; // Your MySQL Host - might be local host
$dbusername = ""; // Your Database User Name
$dbpassword = ""; // Your Database PassWord
$db_name = ""; // Your Database Name
 
$connection = @mysql_connect($server,$dbusername,$dbpassword) or die(mysql_error());
 
$db = @mysql_select_db($db_name,$connection) or die(mysql_error());
 
//build and issue query
 
$qProfile = "SELECT * FROM signers WHERE recordNum='".$id."' ";	
 
$rsProfile = @mysql_query($qProfile,$connection) or die(mysql_error());
 
while ($row = mysql_fetch_assoc($rsProfile)){
 
$recordnum = stripslashes($row['recordnum']);
$firstmiddlename = stripslashes($row['firstmiddlename']);
$lastname = stripslashes($row['lastname']);
 
mysql_close();?>
<?
$server = ""; // Your MySQL Host - might be local host
$dbusername = ""; // Your Database User Name
$dbpassword = ""; // Your Database PassWord
$db_name = ""; // Your Database Name

$connection = @mysql_connect($server,$dbusername,$dbpassword) or die(mysql_error());

$db = @mysql_select_db($db_name,$connection) or die(mysql_error());

//build and issue query

$qProfile = "SELECT * FROM signers WHERE recordNum='".$id."' ";	

$rsProfile = @mysql_query($qProfile,$connection) or die(mysql_error());

while ($row = mysql_fetch_assoc($rsProfile)){

$recordnum = stripslashes($row['recordnum']);
$firstmiddlename = stripslashes($row['firstmiddlename']);
$lastname = stripslashes($row['lastname']);

mysql_close();?>

You can enter your db info into this script or change references to whatever you want...
Maybe I got everything this time. One thing I like to do is include the
or die(mysql_error()) on MySQL commands. This may tell you what the problem might be.

Again. Hope This Helps!?!?!?

There are alot of people smarter than me, BUT at least I try to be of some help. Of coarse I'm not perfect, I need help too.

•

Join Date: Dec 2008

Posts: 94

Reputation: sikka_varun is an unknown quantity at this point

Solved Threads: 11

sikka_varun sikka_varun is offline

Offline

Junior Poster in Training

Re: Grab a row

Dec 5th, 2008

Hey,

Just remove the blank spaces from your query string..

Help with Code Tags

php Syntax (Toggle Plain Text)

$qProfile = "SELECT * FROM signers WHERE recordNum='$id'  ";

There are some white spaces at the end of this string..
Remove the white space at the end..

Change it to:

Help with Code Tags

php Syntax (Toggle Plain Text)

$qProfile = "SELECT * FROM signers WHERE recordNum='$id'";

This was the problem with your query.... thats why it is not running

VâRûN
---Happy to Help---
sikka_varun@yahoo.com

•

Join Date: Apr 2008

Posts: 296

Reputation: Aamit has a little shameless behaviour in the past

Solved Threads: 11

Aamit

Offline

Posting Whiz in Training

Re: Grab a row

Dec 5th, 2008

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$con = mysql_connect("localhost","root","");
	if (!$con)
	  {
	  die('Could not connect: ' . mysql_error());
	  }
	  else
	  {
	 // echo('Connected with Mysql');
	  }
	  @mysql_select_db("db_name", $con);
	  $sql=mysql_query("SELECT * FROM signers WHERE recordNum='$id'");
	  $row = mysql_fetch_array($sql);
 
	  $recordNum=$row['recordNum'];
	  $user_lname=$row['user_lname'];
	  $user_add=$row['user_add'];
	  $user_id=$row['user_id'];
$con = mysql_connect("localhost","root","");
	if (!$con)
	  {
	  die('Could not connect: ' . mysql_error());
	  }
	  else
	  {
	 // echo('Connected with Mysql');
	  }
	  @mysql_select_db("db_name", $con);
	  $sql=mysql_query("SELECT * FROM signers WHERE recordNum='$id'");
	  $row = mysql_fetch_array($sql);
	  
	  $recordNum=$row['recordNum'];
	  $user_lname=$row['user_lname'];
	  $user_add=$row['user_add'];
	  $user_id=$row['user_id'];

check your database column name.....correctly..
whether recordNum or recordnum...or id...

you are got the 'id'...and check with recordNum...

so problem with your sql query not with fetching data in row