In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] ("Anyangwe, Tanwani") wrote:
> $result = mysql_query("SELECT * FROM motor_vehicle",$db);
> $strSep = ' | ';
> while ($myrow = mysql_fetch_array($result))
> {
> echo $myrow['id'].$strSep;
> }
>
> Gives me the following error:
>
> Warning: Undefined index: id in C:\PHP\Test_Scripts\testdb2.php on line 16
1) It's not considered a good habit to use "select *" in scripts. When you
later modify the table defs, your scripts will be blown. Even if you never
add/drop/change a column, it's still messy since whenever you're working on
the code you have to remember--accurately--all of the columns and exactly
(case_sensitive_ what they are named. Yuck. Much cleaner to include the
column names in your query now. "Select id from motor_vehicle"--then you
know for sure you're working with a column of that name.
2) mysql_fetch_array doesn't fetch NULLs. If the value of column 'id' in a
given row is NULL, then $myrow['id'] will be undefined for that row. See
<http://php.net/manual/en/function.mysql-fetch-array.php>.
--
CC
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]