[RESOLVED] convert from mysqli to mysql

[reel_biggy_fish]

i have a dropdown menu that displays the options i have in a database. i have this all working in mysqli as i didnt write this part on another website. but i am struggling to convert it back to mysql.

the original code is:

$query = "SELECT gallery_type_id, gallery_type_desc FROM gallery_type ORDER BY gallery_type_id";

/* run the query */
$result = $dbLink->query($query);

/* load the query's results into an array */
$i=1;
while($row=$result->fetch_assoc()){
$galleryTypes[$i] = $row;
$i++;
}  

$num_results = $result->num_rows;


<select name="gallery_type" id="gallery_type">
<option>Please Select an Album
<?php
for($i = 1; $i < $num_results+1; $i++) {
echo "<option value=\"" . $galleryTypes[$i]['gallery_type_id'] . "\">";
echo $galleryTypes[$i]['gallery_type_desc'];
echo "</option>\n";
}
?>

the code i have got so far:

$query1 = "SELECT id, question FROM securtiyq ORDER BY id";

/* run the query */
$result= mysql_query($query1); 
$row = mysql_fetch_array($result);

/* load the query's results into an array */
$i=1;
while ($row = mysql_fetch_assoc($result)) {
$galleryTypes[$i] = $row;
$i++;
}  

$num_results = mysql_num_rows($result);


<select name="gallery_type" id="gallery_type">
<option>Please Select A Security Question
<?php
for($i = 1; $i < $num_results+1; $i++) {
echo "<option value=\"" . $galleryTypes[$i]['id'] . "\">";
echo $galleryTypes[$i]['question'];
echo "</option>\n";
}
?>
</option>
</select>

[reel_biggy_fish]

the only problem is nothing from the database is displayed in the dropdown box. could someone point out where im going wrong

thanks in advance

[dagon]

<?php
$query1 = "SELECT id, question FROM securtiyq ORDER BY id";

/* run the query */
$result = mysql_query($query1);

if(!$result){
	echo "Could not successfully run query ($query1) from DB: ".mysql_error();
	exit();
}

if(mysql_num_rows($result)==0){
	echo "No rows found, nothing to print so am exiting";
	exit();
}

echo '<select name="gallery_type" id="gallery_type"><option>Please Select A Security Question';

while ( $row = mysql_fetch_assoc($result) ){

echo '<option value="'.$row['id'].'">';
echo $row['question'];
echo "</option>\n";
}
echo '</select>';

?>

give that a go

[reel_biggy_fish]

that worked a treat 🙂 thanks so much.

[reel_biggy_fish]

hi quick question, when i write to the database i get it to write the answer and question but the question is the question id how would i write the actually question?

$answer=$_POST['answer'];
$question=$_POST['gallery_type'];

$query=( "INSERT INTO user (uname, pw,email,date_joined,ip,level,isbanned, question, answer) VALUES ('$name',md5('$pw1'),'$email',NOW(),'$ip','$level','no', '$question', '$answer' )");

for example question two is what is your pets name and in the database it writes '2'

[dagon]

you should be using the id, you don't want to duplicate the question text. what you would then do is use a join to the question table when you needed to retrieve the question.

[reel_biggy_fish]

sorry you'v lost me. what would i be doing?

[dagon]

select users.*, securtiyq.question from users
left join securtiyq on users.question=securtiyq.id
WHERE (what ever)

[reel_biggy_fish]

ahh okay thanks for that. i shall look into this with a bit more detail

thanks again for your help