helllp

[williambro]

hello im trying to output a navigation w/ my array and use jQuery & CSS to style it... im not sur how we do that but i try something sketchyy i can output a simple navigation but cant style it someone help.

THX
btw sorry for my english. 😉

1.php

<?php
//MYSQL connect...
$sql = ("SELECT id , name , mark FROM phone");
$result = mysql_query($sql);

echo "<div id='sbi_container' class='sbi_container'>";
while($row = mysql_fetch_array($result)){
$id = $row['id'];
$name = $row['name'];
$mark = $row['mark'];
echo "<div class='sbi_panel' data-bg='image/{$name}.jpg'/>";
echo "<a href='./index.php?id={$id}' class='sbi_label'/>$mark $name</a></li></div>";
echo "</div>";
}
echo "<div>";



?>

2.php
//MYSQL connect..,

<?php $sql = ("SELECT * FROM phone where id LIKE '%$_GET[id]%' ");
$bla = $_GET['id'];
$result = mysql_query($sql);

while ($row = mysql_fetch_assoc($result)) {
    echo $row["id"],"<br/>";
    echo $row["mark"];
    echo $row["name"],"<br/>";
}


?>

[Derokorian]

If you first one you would have invalide HTML output when executing the given code.

First you are using a closing li tag with no opener to match, and also no parent ul or ol element.
You are then closing the div TWICE in the loop but only opening ONE previously.

Unless I'm misunderstanding your problem I think its just a need to fix the html you have within your echo's

Try the following:

<?php 
//MYSQL connect... 
$sql = ("SELECT id , name , mark FROM phone"); 
$result = mysql_query($sql); 

echo "<div id='sbi_container' class='sbi_container'>"; 
while($row = mysql_fetch_array($result)){ 
   $id = $row['id']; 
   $name = $row['name']; 
   $mark = $row['mark']; 
   echo "<div class='sbi_panel' data-bg='image/{$name}.jpg'/>"; 
   echo "<a href='./index.php?id={$id}' class='sbi_label'/>$mark $name</a>"; // Removed </li></div> in an attempt to fix invalid HTML
   echo "</div>"; 
} 
echo "<div>"; 

[Bonesnap]

I would be very weary about self-closing tags such as:

echo "<div class='sbi_panel' data-bg='image/{$name}.jpg'/>"; 

Most tags cannot be self-closed unless you use a certain doctypes/MIME-types. For best practice, I would certainly close all <div> tags like so: <div></div>, even if they're empty.