- Joined
- Jun 30, 2008
- Messages
- 1,145 (0.20/day)
- Location
- England
System Name | Wasleys PC |
---|---|
Processor | Intel i5 2400 3.10GHz |
Motherboard | Asus P8z68-V |
Cooling | AC Freezer Pro |
Memory | Kingston 4GB (2x2GB) DDR3 Hyperx Memory |
Video Card(s) | HIS ATi 6850 1GB DDR3 |
Storage | Seagate ST3500320AS 500GB Hard Drive SATA II 7200rpm *32MB Cache* |
Case | Antec 900 with mods |
Audio Device(s) | On Board |
Power Supply | OCZ Stealth Xtream 500W |
Software | Windows 7 |
Hi,
New to phpmyadmin, PHP, MySQL, etc - so please excuse me if the answer to the question is simple.
I've built a database using XAMPP called "evidence db". Within that database, I have a table called "m cases". This table has 11 columns.
I currently have the following code:
Error:
Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\helloworld.php on line 25
Thanks in advanced.
PS - If anyone can recommend PHP/Phpmyadmin tutorials - i'd be interested in reading them.
New to phpmyadmin, PHP, MySQL, etc - so please excuse me if the answer to the question is simple.
I've built a database using XAMPP called "evidence db". Within that database, I have a table called "m cases". This table has 11 columns.
I currently have the following code:
Code:
<html>
<head>
<title>Search data</title>
</head>
<body>
<table>
<tr>
<td align="center">EMPLOYEES DATA</td>
</tr>
<tr>
<td>
<table border="1">
<tr>
<td>Case ID</td>
</tr>
<?
mysql_connect("localhost","root","");//database connection
mysql_select_db("evidence db");
$order = "SELECT * FROM m cases";
$result = mysql_query($order);
while($data = mysql_fetch_row($result)){
$field1= $row["Case ID"];
echo("$field1");
}
?>
</table>
</td>
</tr>
</table>
</body>
</html>
Error:
Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\helloworld.php on line 25
Thanks in advanced.
PS - If anyone can recommend PHP/Phpmyadmin tutorials - i'd be interested in reading them.