PHP Newbie Help

Anon

Here's a script I recently wrote and I'm really new with this stuff so here goes..

If a result set comes back from MySQL empty, it will not default to the "Sorry, no records found" etc... I would like it to default to the Sorry no records if the results are zero.

I have other questions, but that will get me started..🙂 If it finds a valid phone number during it's search it displays the fields properly which is great... my other questions in future will be how to manipulate (if, then statements) the data to be more visitor friendly...

Thanks in advance! 🙂

Paul

Anon

Hi,
Your script will show "Sorry, ..." ONLY when $id is FALSE.

If you want to show "sorry..." when the the result set is empty, you must test the number of rows you SQL return. See

http://www.phpbuilder.com/manual/function.mysql-num-rows.php

This function returns the number of rows of your resultset.

Josemi

van__

<?PHP
$db = mysql_connect("localhost", "turbo");
mysql_select_db("dsl",$db);
// display individual record
if ($id) {
$result = mysql_query("SELECT * FROM onemeg WHERE wtn='$id'",$db);

for ($i=0;$i<@mysql_num_rows($result);$i++) {
$myRow[$i] = @mysql_fetch_array($result, MYSQL_ASSOC);
}

if (is_array($myRow)) {
printf("WTN: %s\n<br>", $myRow[0]["wtn"]); 
printf("Available: %s\n<br>", $myRow[0]["qualified"]); 
printf("Equipment: %s\n<br>", $myRow[0]["equip"]); 
printf("Trouble: %s\n<br>", $myRow[0]["trouble"]); 
printf("Line Sync: %s\n<br>", $myRow[0]["sync"]); 
printf("Line Type: %s\n<br>", $myRow[0]["rb"]); 
} else { echo "Sorry, no records were found!"; }

}
?>