[RESOLVED] search field name in mysql then retreive data from that row

planethax

Ok, well I have found examples of retreiving info from db, one example shows how to get the first row, another shows how to loop to get all info.

What I need to do is search db for a name, then get the data for the row that the name was in.

eg,

in my database named Standings I have
'rank' 'rank_delta' 'driver' 'points' 'behind' 'starts' 'poles' 'wins' 'top5' 'top10' 'dnf' 'winnings' 'in_contention'

I need to search the 'driver' field for "AJ Allmendinger" then get the
Rank Starts Wins Poles Points Top 10's DNF's and put them in a table.

Hope someone can help me with this.

Thanx.

kiwi2

This is not very clear, but if you have got as far as creating a db,then searching it shld not be 2 hard.
$q = mysql_query("SELECT * FROM db WHERE row = '$criteria''");
while($row = mysql_fetch_array($q) )
{
echo "$row[0] ";

echo "$row[1] ";

echo "$row[2] ";

echo "$row[3] ";

echo "$row[4] ";
}
?>
if u use fetch_array u can select rows either by name or array element number!
hope this helps!

planethax

I am newbie and learning,
so am I getting close?

<?php
include_once('db_conn.php');
$criteria = 'AJ Allmendinger'
$query = "SELECT * FROM `nascar_standings` WHERE row = '$criteria'";
$result = mysql_query($query) or die('MySQL Error: '.mysql_error());
echo $result
?>

(this just has blank page 🙁 )

planethax

Am I even close?
Can someone guide me here?

Thank you.

dagon

$result in your example is a resource pointer, you need to use mysql_fetch_array() or one of the others to retrieve the results.

planethax

are you meaning
echo mysql_query

or can you give an example?
Thanx

dagon

there are examples in the manual on the page i provided a link to.

planethax

I am reading that, but a little lost on how to show the result of query

planethax

Ok, I read through that, thought I understood but still get blank page

(trying to figure out out to echo the errors? )

This is what I have

<?php
include_once('db_conn.php');
$criteria = 'AJ Allmendinger';
$query = "SELECT * FROM `nascar_standings` WHERE row = '$criteria'";
$result = mysql_query($query) or die('MySQL Error: '.mysql_error());
while ($row = mysql_fetch_array($result, MYSQL_BOTH))   {
    printf ("rank: %s  starts: %s wins: %s poles: %s points: %s top10: %s dnf: %s", $row[0], $row[6], $row[8], $row[4], $row[7], $row[10], $row[11]);
														}
?>

planethax

I have edited prev code, as I found I had missed a ;

Now I get an error, seems I am not searching correctly?

"MySQL Error: Unknown column 'row' in 'where clause"

I am searching for a driver in row 3 named AJ Allmendinger,
then when AJ Allmendinger is found I need to print the certain fields.

planethax

Aha,
getting closer

$criteria = 'AJ Allmendinger';
$query = "SELECT * FROM `nascar_standings` WHERE driver LIKE '$criteria'";

did the trick, now I need to make it fill my table, I have a slight clue on how to do that and am trying now.

planethax

SWEET!!!!!

I am starting to get it lol,
This does what I want (hopefully no errors? )

include_once('db_conn.php');
$criteria = 'AJ Allmendinger';
$query = "SELECT * FROM `nascar_standings` WHERE driver LIKE '$criteria'";
$result = mysql_query($query) or die('MySQL Error: '.mysql_error());
while ($row = mysql_fetch_array($result, MYSQL_BOTH))   

    {
$d_text .= '<td align="center"><div>'.$row[0].'</div></td>';

$d_text .= '<td align="center"><div>'.$row[6].'</div></td>';

$d_text .= '<td align="center"><div>'.$row[8].'</div></td>';

$d_text .= '<td align="center"><div>'.$row[7].'</div></td>';

$d_text .= '<td align="center"><div>'.$row[4].'</div></td>';

$d_text .= '<td align="center"><div>'.$row[10].'</div></td>';

$d_text .= '<td align="center"><div>'.$row[11].'</div></td>';
	}

$tpl -> AssignArray(array('driver' => $d_text));