mysql_result equivalent

Donovan · Client Joined: Oct 07, 2003 Posts: 691 Location: Ohio

I have code that I am trying to update and improve.

The original developer used the db/db.php abstraction layers, however the last guy to mess with this code did not. He created another mysql_connect.php and placed them where he needed them which has caused me utter confusion.

The original developer used $db->sql_query($sql) which I am most familar with.

The last guy used stuff like

Code:

$res = @mysql_query($query);

or

Code:

$media = mysql_result($res, 0, "media_dir");

I have been trying to understand what mysql_result($res, 0, "media_dir") would do and what the equivalent would be.

Here is what the last guy did.

Code:

require_once('mysql_connect.php');
//include($somCBT_root_path . 'includes/page_header.'.$phpEx);
$query = "SELECT media_dir FROM course WHERE course_id = " .$cid." LIMIT 1";
$res = @mysql_query($query);
$media = mysql_result($res, 0, "media_dir");
$media = addslashes($media);
//Here, we are joining the quiz, quiz_questions, and questions tables in order to have a single recordset with all of the information that we will need to
//post on the print page. This is required in order to ensure that we are only dealing with a single test for a single course - SMQ
if($lock=='y') {
$query1 = "SELECT * FROM quiz, quiz_questions WHERE quiz.quiz_id=".$qid." AND quiz.course_id=".$cid." AND quiz.quiz_id=quiz_questions.quiz_id AND quiz.course_id=quiz_questions.course_id ORDER BY quiz_questions.ques_order" ;
}else{
$query1 = "SELECT quiz.quiz_name, quiz.year_used, quiz_questions.ques_order, quiz_questions.ques_id, questions.* FROM quiz, quiz_questions, questions WHERE quiz.quiz_id=".$qid." AND quiz.course_id=".$cid." AND quiz.quiz_id=quiz_questions.quiz_id AND quiz_questions.ques_id=questions.question_id ORDER BY quiz_questions.ques_order" ;
}
$result=mysql_query($query1);
//Count the number of records returned from the SQL query, and use this to tell the loop when to stop iterating through the associative array created from the
//database query - SMQ
$num=mysql_num_rows($result);
mysql_close();
//print_r($result);
$med = $root_path.$media;
//}else{
// break();
//}
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<title>Print Test</title>
</head>

<body>
<a href="javascript:history.back();">return</a>
<table width="100%" border="0">

<?php $quizname=mysql_result($result, 0, "quiz_name");?>
<?php $year=mysql_result($result, 0, "year_used");?>
<tr>
<td width="4%">Quiz Name: <?php echo $quizname;?></td>
<td width="50%"><div align="center">Quiz Year: <?php echo $year;?></div></td>
</tr>

<?php $i=0; ?>
<?php while($i < $num) {?>
<?php $imgfl=''; ?>
<?php $dbno=mysql_result($result, $i, "ques_id");?>
<?php $qtitle=mysql_result($result, $i, "ques_name");?>
<?php $qstem=nl2br(mysql_result($result, $i, "stem"))." ";?>
<?php $c1=mysql_result($result, $i, "choice1");?>
<?php $c2=mysql_result($result, $i, "choice2");?>
<?php $c3=mysql_result($result, $i, "choice3");?>
<?php $c4=mysql_result($result, $i, "choice4");?>
<?php $c5=mysql_result($result, $i, "choice5");?>
<?php $imgfl=mysql_result($result, $i, "media_name");?>
<?php $feed=mysql_result($result, $i, "feedback");?>
<?php $opt=mysql_result($result, $i, "points");?>
<?php $type=mysql_result($result, $i, "qtype");?>
<?php $qnum = $i+1; ?>
<?php $opt_arr = explode("#", $opt);?>
<?php $qimage = $med.$imgfl;?>
<tr>
<td colspan="3"><hr /></td>
</tr>
<tr>
<td colspan="3">Question #: <?php echo $qnum;?> </td>
</tr>
<tr>
<td colspan="3">DB Rec.#: <?php echo $dbno;?> </td>
</tr>
<tr>
<td colspan="3">Title: <?php echo $qtitle;?> </td>
</tr>
<tr>
<td colspan="3"> </td>
</tr>
<tr>
<td colspan="3"><?php if($imgfl=='') { echo $qstem; }else{ echo $qstem.' <img src = "'.$qimage.'">'; }?> </td>
</tr>
<tr>
<td colspan="3"> </td>
</tr>
<?php if($type =='1') {?>
<tr>
<td colspan="3">A. <?php echo $c1;?> </td>
</tr>
<tr>
<td colspan="3">B. <?php echo $c2;?> </td>
</tr>
<tr>
<td colspan="3">C. <?php echo $c3;?> </td>
</tr>
<tr>
<td colspan="3">D. <?php echo $c4;?> </td>
</tr>
<tr>
<td colspan="3">E. <?php echo $c5;?> </td>
</tr>
<tr>
<td colspan="3"> </td>
</tr>
<?php for ($j=0; $j < (count($opt_arr)-1); $j++) {?>
<?php if($j==0) {$ans="A";}elseif($j==1) {$ans="B";}elseif($j==2) {$ans="C";}elseif($j==3) {$ans="D";}else{$ans="E";}?>
<?php if($opt_arr[$j] == 1) {?>
<tr>

<td colspan="3">Correct Answer: <?php echo $ans;?></td>
</tr>
<?php } ?>
<?php } ?>
<tr>
<td colspan="3"> </td>
</tr>
<?php } ?>
<tr>
<td colspan="3">Feedback: <?php echo $feed;?></td>
</tr>
<tr>
<td colspan="3"> </td>
</tr>
<?php $i++;?>
<?php } ?>
</table>
</body>

I would like to replace much of this code with some that is easier understood.

This part here looks more like a sql_fetchrow

Code:

<?php $i=0; ?>
<?php while($i < $num) {?>
<?php $imgfl=''; ?>
<?php $dbno=mysql_result($result, $i, "ques_id");?>
<?php $qtitle=mysql_result($result, $i, "ques_name");?>
<?php $qstem=nl2br(mysql_result($result, $i, "stem"))." ";?>
<?php $c1=mysql_result($result, $i, "choice1");?>
<?php $c2=mysql_result($result, $i, "choice2");?>
<?php $c3=mysql_result($result, $i, "choice3");?>
<?php $c4=mysql_result($result, $i, "choice4");?>
<?php $c5=mysql_result($result, $i, "choice5");?>
<?php $imgfl=mysql_result($result, $i, "media_name");?>
<?php $feed=mysql_result($result, $i, "feedback");?>
<?php $opt=mysql_result($result, $i, "points");?>
<?php $type=mysql_result($result, $i, "qtype");?>
<?php $qnum = $i+1; ?>
<?php $opt_arr = explode("#", $opt);?>
<?php $qimage = $med.$imgfl;?>
<tr>

evaders99 · Moderator Joined: Apr 30, 2004 Posts: 2844

mysql_result grabs a specific row and column

Only registered users can see links on this board!
Get registered or login to the forums!

The database abstraction layer provides the following equivalent

Code:

sql_fetchfield($field, $rownum = -1, $query_id = 0)

In pretty much all cases, it is better to grab the entire row using sql_fetch_row and use PHP's array structure to numerate through the fields.