Ad:

PHP Discussion Thread
Unsolved
Views: 770

Dec 3rd, 2008

Grab a row

Expand Post »

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!

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();?>

Similar Threads

Apache in Linux Servers and Apache
WebCrawler / Bot needed in Configuring Readymade Scripts
WizardSteps-> SQL Insert -> Grab ID field in ASP.NET
reading from custom input file?! in C#
paging & _POST variables in PHP

rouse

Reputation Points: 10

Solved Threads: 1

Junior Poster

Offline

111 posts
since Dec 2007

Permalink

Dec 3rd, 2008

Re: Grab a row

Quote ...

$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.

PomonaGrange

Reputation Points: 10

Solved Threads: 3

Junior Poster in Training

Offline

67 posts
since Jun 2008

Permalink

Dec 3rd, 2008

Re: Grab a row

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

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

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

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

24 posts
since Nov 2008

Permalink

Dec 3rd, 2008

Re: Grab a row

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

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...

PomonaGrange

Reputation Points: 10

Solved Threads: 3

Junior Poster in Training

Offline

67 posts
since Jun 2008

Permalink

Dec 4th, 2008

Re: Grab a row

Hi try this,

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 Butchi

Reputation Points: 10

Solved Threads: 4

Junior Poster in Training

Offline

69 posts
since May 2008

Permalink

Dec 4th, 2008

Re: Grab a row

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

rouse

Reputation Points: 10

Solved Threads: 1

Junior Poster

Offline

111 posts
since Dec 2007

Permalink

Dec 4th, 2008

Re: Grab a row

Try This...

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!?!?!?

PomonaGrange

Reputation Points: 10

Solved Threads: 3

Junior Poster in Training

Offline

67 posts
since Jun 2008

Permalink

Dec 5th, 2008

Re: Grab a row

Hey,

Just remove the blank spaces from your query string..

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:

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

sikka_varun

Reputation Points: 11

Solved Threads: 12

Junior Poster in Training

Offline

94 posts
since Dec 2008

Permalink

Dec 5th, 2008

Re: Grab a row

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

Aamit

Reputation Points: 3

Solved Threads: 15

Posting Whiz

Offline

341 posts
since Apr 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: new files created under apache ownership!! Need Help

Next Thread in PHP Forum Timeline: code will not subtract negative number in mysql field? :( pls help!

DaniWeb Message

Cancel Changes