Hi all,
I want a help in the code .. but let me first describe what I do and want I want to do ..
I build a website by PHP and it purpose to find jobseeker and search for job ,,
and I want to search for a available job in a particular location, major and highest qualification..
I do the code for searching and it is work and I display only the important information about the job/ jobseeker ..
for example (search for jobseeker)..
First Name Last name Major qualification Extra info
Ali Rashid Software Engineering Master more
This information will be display when the company search for a jobseeker ..
and when it click on the [more] in the Extra information, it will display more informtion about this boy who is Ali ..
The problem is when I click on more there is no information display for me !!
I don't have any error, but the information doesn't display ...
Can some one help me, please ?
I must to finish this problem before tomorrow >>> now is 9:12 PM
These are my codes
This code is working good, but I put it to make u understand what I want to do __
<?php
$i=0;
include("connect.php");
$sql = "SELECT * FROM student_info WHERE Student_city = '".mysql_real_escape_string($Student_city)."' ";
$result = mysql_query($sql)or die ("could Not execute query $sql");
echo"<p align='center'><font face='Bodoni MT Black' size='5' color='#008000'>Search Result</font></p>";
echo"<BR>";
echo"<BR>";
echo "
<table border=1 width=1000 id= table1>
<tr>
<td width=70 bgcolor=#d0f7bf>
<p align='center'><b><font color=#008000 face='Comic Sans MS' >First Name</font></b></td>
<td width=116 bgcolor=#d0f7bf>
<p align='center'><b><font color=#008000 face='Comic Sans MS' >Major</font></b></td>
<td width=116 bgcolor=#d0f7bf>
<p align='center'><b><font color=#008000 face='Comic Sans MS' >Highest qualification</font></b></td>
<td width=75 bgcolor=#d0f7bf>
<p align='center'><b><font color=#008000 face='Comic Sans MS' >Extra information</font></b></td>
</tr>
</table>
<p align='center'>";
while($row=@mysql_fetch_array($result)) {
$i++;
echo " </p>
<table border=1 width=1000 id= table1>
<tr>
<td width=70 bgcolor=#d0f7bf>
<p align='center'><b><font size=2 color=800000 >".$row["Student_f_name"]."</font></b></td>
<td width=70 bgcolor=#d0f7bf>
<p align='center'><b><font size=2 color=800000 >".$row["Studnet_l_name"]."</font></b></td>
<td width=116 bgcolor=#d0f7bf>
<p align='center'><b><font size=2 color=800000 >".$row["Student_major"]."</font></b></td>
<td width=116 bgcolor=#d0f7bf>
<p align='center'><b><font size=2 color=800000 >".$row["Student_qual"]."</font></b></td>
<td width=75 bgcolor=#d0f7bf>
<p align='center'><b><font size=2 color=800000 ><a href = edit_selected_stud.php?Student_ID =".$row['Student_ID']."> more </a></font></b></td>
</tr>
<table>";
}
echo "<BR>" ;
echo "<BR>" ;
echo "number of result: $i";
echo "<BR>" ;
echo "<a href =search_jobSeeker.htm>OK</a>";
This code which doesn't work :mad:
It can't bring the information from the database ..
<?php
session_start();
$SESSION['user_name']= $user_name;
$SESSION['Pass']= $Pass;
$i=0;
include ("connect.php");
$sql = "SELECT * FROM student_info WHERE Student_ID = '".mysql_real_escape_string($Student_ID)."' ";
$result = mysql_query($sql)or die ("could Not execute query $sql");
$row=@mysql_fetch_array($result);
echo "<a href = http://localhost/job/search_stud_location.php>back</a>";
echo "<table width = 800><tr>
<td width = 1000 align=center><b><font size=4 color=#800000 >This table shows all information about the student $Student_ID </font></b></td><tr><table>";
echo"
<table border=0 width=500 id='table1'>
<tr>
<td width=219>First name</td>
<td>".$row["Student_f_name"]."</td>
</tr>
<tr>
<td width='219'>Last name</td>
<td>".$row["Studnet_l_name"]."</td>
</tr>
<tr>
<td width='219'>Student ID</td>
<td>".$row["Student_ID"]."</td>
</tr>
<tr>
<td width='219'>Age</td>
<td>".$row["Student_age"]."</td>
</tr>
<tr>
<td width='219'>Gender</td>
<td>".$row["Student_gender"]."</td>
</tr>
<tr>
<td width='219'>Status</td>
<td>".$row["Student_status"]."</td>
</tr>
<tr>
<td width='219'>City</td>
<td>".$row["Student_city"]."</td>
</tr>
<tr>
<td width='219'>Phone number</td>
<td>".$row["Studnet_phon"]."</td>
</tr>
<tr>
<td width='219'>Mobile number</td>
<td>".$row["Studnet_mobile"]."</td>
</tr>
<tr>
<td width='219'>Highest qualification</td>
<td>".$row["Student_qual"]."</td>
</tr>
<tr>
<td width='219'>Major</td>
<td>".$row["Student_major"]."</td>
</tr>
</tr>
</table>";
?>
I wait for the helper people __
