- 论坛徽章:
- 0
|
5可用积分
select.php
-------------------PHP部分---------------------
<?
$db=mysql_connect("127.0.0.1","root","1234567");
mysql_select_db("playlist",$db);
$select="select * from list091808";
$select="select * from list091808";
// $rr=mysql_query( $select );
$rr=mysql_num_rows;
if ( $rr )
{
echo "STEP1 DONE";
}
$p=$mysql_result($rr,0,"name");
if ( $p )
{
echo "STEP2 DONE";
}
echo $p;
?>
----------------MySQL部分-------------------------
mysql> use playlist;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
+--------------------+
| Tables_in_playlist |
+--------------------+
| list091808 |
| tsl |
+--------------------+
2 rows in set (0.00 sec)
mysql> describe list091808;
+-------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+-------+
| inode | varchar(20) | NO | PRI | NULL | |
| path | varchar(50) | YES | | NULL | |
| name | varchar(256) | YES | | NULL | |
+-------+--------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
mysql> select * from list091808;
+---------+------------+------------------------------------------+
| inode | path | name |
+---------+------------+------------------------------------------+
| 1135527 | /home/test | 20087362981593.wma |
| 1135724 | /home/test | 410762994.wma |
| 1134643 | /home/test | pub1171190001976.mp3 |
| 1134829 | /home/test | pwqq.mp3 |
| 1135529 | /home/test | tg.mp3 |
| 1135725 | /home/test | thatday.mp3 |
| 1135723 | /home/test | 春天花会开.mp3 |
................
--------------------出错部分------------------------------
#elinks http://127.0.0.1/select.php
STEP1 DONE
诚心请教各位,为什么会出现空值?应该怎样解决?
谢谢。 |
|