query result can be 1 at most

[Anon]

I want to execute a query.
But this query can only have 0 or at most 1 result.

How can I do this and how can print the info from the query, say 'Username' of the only 1 result.

Thanks in advance,
Patrick

[Anon]

hi patrick

if you use MySQL Database I can help you

see you later

[Anon]

Yeah, I do use a MySQL database.

[Anon]

if this isn't the code you need, tell me exactly what your application should do

greatings andy

use this code:

<?php

$db = mysql_connect("server","user","password"); 

/
replace the word's server, user and password with your's
*/
mysql_select_db("database",$db);

$qry_shops = "select from table";
/
replace the word's database and table with your's
/
$result = mysql_query($qry_shops,$db);
$num = mysql_numrows($result);
/
this will put out each row of the $result of the qry_shops
*/
for ($i = 0; $i < $num; $i++) {
$row = mysql_fetch_array($result);
echo"$row[field1] $row[field2] $row[field3]<br>";
}

$id = mysql_insert_id($db);

mysql_close($db);

?>

[Anon]

But does this code means that there can be only 1 result? That's the restriction.
The query can have 0 or 1 result. Not more.

Patrick

[Anon]

ok, I understand. There are 2 way:

1st add keyword 'limit 1' to the query-string it look then like this:

qry_shops = "select * from table limit 1";

2nd change for-line to:

for ($i = 0; $i < 1; $i++){

greating andy

[Anon]

What does this line do:

$id = mysql_insert_id($db);

Patrick

[Anon]

Patrick wrote:

What does this line do:

$id = mysql_insert_id($db);

Patrick

this should give the next free id for adding row's to a table and is part of an other project and has no meaning to this one.

is the code that you recived that one where you are looking for?

greatings andy

[Anon]

Yeah! Thanks !

With a few changes it meets my needs!

Patrick