[RESOLVED] Selecting multiple rows?

Raxz0r

Hey guys, this is my first time doing anything with php or sql from scratch.

I have a database called "drivers" with 3 rows. "id" (auto increment), "plate", and "comment"

I have a search box on my page where I can enter a plate number, and I want it to return all comments for that plate, there is multiple rows with the same "plate" but a different "comment".

At the moment I have managed to produce some code that selects the first comment that it finds.

Now im having trouble selecting more than one comment. Do I need to use a loop of some sort?

This is my current code:

<?
include("config.php");

$search=$_POST['search'];

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$result = mysql_query("select comment FROM drivers WHERE plate = '$search'");
$row = mysql_fetch_assoc($result);
echo $row['comment'];

mysql_close();
?>

Raxz0r

Oops, I cant see where I can edit my original post.

But I meant

"I have a database called "drivers" with 3 columns. "id" (auto increment), "plate", and "comment""

johanafm

Yes, you need just that

while ($row = mysql_fetch_assoc($result))
	echo $row['comment'];

Raxz0r

Oh cool, it was as simple as that. Thanks.

How would I go about formatting it.

Ie.

Comment1

Comment2

Comment3

Etc.

johanafm

Depends on how you run the script.

// In browser, serving XHTML
echo $row['comment'] . "<br/>";	// . is operator for string concatenation. <br/> is XHTML new line element

//In browser, serving HTML
echo $row['comment'] . "<br>";		// <br> is HTML element for newline

// In terminal
echo $row['comment'] . PHP_EOL;	// PHP_EOL is a constant defined as newline character for whatever system you run the script on (\r, \n or \r\n)

Raxz0r

Thanks.