jbwebdesign Posted December 23, 2008 Report Share Posted December 23, 2008 <?php echo $my_rows; ?> Quote Link to comment Share on other sites More sharing options...
monkeysaurus Posted December 23, 2008 Report Share Posted December 23, 2008 What error message are you receiving? Quote Link to comment Share on other sites More sharing options...
jbwebdesign Posted December 24, 2008 Author Report Share Posted December 24, 2008 I never got an error, I just wasn't able to display records from mySQL but I fixed the problem thanx any way Quote Link to comment Share on other sites More sharing options...
administrator Posted December 24, 2008 Report Share Posted December 24, 2008 I never got an error, I just wasn't able to display records from mySQL but I fixed the problem thanx any way What was your solution? .... Good for the forum to have the answer. Thanks, Stefan Quote Link to comment Share on other sites More sharing options...
jbwebdesign Posted December 24, 2008 Author Report Share Posted December 24, 2008 Hey stephan, To answer your question about what I did to fix my problem,......... <?php //=============================================== //CONNECT TO MY DATABASE AND SELECT MY DATABASE $con = mysql_connect('localhost','root',''); $sel = mysql_select_db('calendar'); //=============================================== //DEFINE VARIABLES FOR MYSQL ROWS $id = $_GET['ff_id']; $get_record = $_GET['get_records']; if(isset($get_record)){ echo $my_rows; } //BUILD MY QUERY $Q = "SELECT * FROM ps69_school_registration WHERE ff_id = '$id'"; $res = mysql_query($Q); $my_rows; //NOW I WILL CREATE A LOOP COMMAND while($row = mysql_fetch_array($res,MYSQL_ASSOC)){ $my_rows = $my_rows . ' Student id: ' . $row['ff_id'] . ' Student Name: ' . $row['Student_full_name'] . ' Route Number: ' . $row['Route_number'] . ' Begining Service Date: ' . $row['Begining_service_date'] . ' ' . ' ';} ?> student id: <?php echo $my_rows; ?> Quote Link to comment Share on other sites More sharing options...
jbwebdesign Posted December 24, 2008 Author Report Share Posted December 24, 2008 I added an input name to the submit button, then i added this //DEFINE VARIABLES FOR MYSQL ROWS $id = $_GET['ff_id']; $get_record = $_GET['get_records']; if(isset($get_record)){ echo $my_rows; } Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.