MYSQL problems

[borrowed]

Hello Im just new to coding into php and im getting this error? i cant seems to see database into my php ? what wrong need help

 

CREATE TABLE IF NOT EXISTS `payment_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idnumber` varchar(30) NOT NULL,
  `date` varchar(30) NOT NULL,
  `amount` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

Here my php code i cant seems to understand what wrong i dont get any error from mysql or from my php  please i dont know what wrong 

 

<label for="filter">Filter</label> <input type="text" name="filter" value="" id="filter" />
								<table cellpadding="1" cellspacing="1" id="resultTable">
									<thead>
										<tr>
											<th  style="border-left: 1px solid #C1DAD7"> Date </th>
											<th>Amount</th>
										</tr>
									</thead>
									<tbody>
								<?php
										include('../connect.php');
									$id=$_SESSION['SESS_MEMBER_ID'];	
										$result = mysql_query("SELECT * FROM student WHERE id='$id'");
										while($row = mysql_fetch_array($result))
											{
												echo '<tr class="record">';
												echo '<td style="border-left: 1px solid #C1DAD7"><div align="left">'.$row['date'].'</div></td>';
												echo '<td><div align="left">'.$row['amount'].'</div></td>';
												echo '</tr>';
											}
										?> 
									</tbody>
								</table>

[Maq]

What error?

[Ch0cu3r]

Question, are you and eyeore part of the same class? They have already posted the same question here.

[ginerjm]

your code is impossible to read.  What did you do?  Did you even look at your post to see it?

[Barand]

Question, are you and eyeore part of the same class? They have already posted the same question here.

 

I think they are part of the same person as Borrowed has just replied to Eyore's post to say it is now fixed

[Ch0cu3r]

I think they are part of the same person as Borrowed has just replied to Eyore's post to say it is now fixed

 

Agreed. Thread locked