PHP - Php If/else Statement To Process Mysql Results?

What's the best way to format results from a MySQL table?  I've found very vague examples of PHP code utilizing html tables.  Below is my current PHP.  Thanks!

<?php
$con = mysql_connect("localhost","xxxxx","xxxxx") or die('Could not connect: ' . mysql_error());
mysql_select_db("addresses", $con);

$result = mysql_query("SELECT * FROM addresses");

while($row = mysql_fetch_array($result))
  {
  echo $row['first_name'] . " " . $row['last_name'] . " " . $row['extra_info'] . " " . $row['address'] . " " . $row['city'] . " " . $row['state'] . " " . $row['zip'];
  echo "<br />";
  }

mysql_close($con);
?>

I'm working on a website that uses a database to display the employees from different states. Below is the code I'm using and everything works great, but I can't figure out why all the results are getting posted twice. I'm trying to isolate just one state so we can have a different contact page for each state. Thanks for any help! Please let me know if you need more information. (I'm attaching a screenshot of what's happening as well.)


Code: [Select]
<?
include "public/public_common.php";
//Open Database Connection
$db = open_db_connection();
$sql = "SELECT DISTINCT state_full = 'california' from users where active = 'Y' and show_on_contactus = 'Y'";
$results = mysql_query($sql, $db);
if(!mysql_num_rows($results) == FALSE)
{
        while($row = mysql_fetch_array($results, MYSQL_BOTH))
        {
           echo "<ul id=\"directors\">\n";
           $state_sql = "SELECT * from users where active = 'Y' and show_on_contactus = 'Y' and state_full = 'california' order by last_name";
   $state_results = mysql_query($state_sql, $db);
           if(!mysql_num_rows($results) == FALSE)
           {
              while($state_row = mysql_fetch_array($state_results, MYSQL_BOTH))
              {
                 echo "<li>\n";
                 echo "   <div class=\"fl dirimg\">\n";
                 if($state_row[photo] == "")
                 {
                    echo "<img border=\"0\" width=\"61\" height=\"85\" src=\"images/exe_placeholder.jpg\" alt=\"$state_row[first_name] $state_row[last_name]\" />\n";
                 }
                 else
                 {
                    echo "<img border=\"0\" width=\"61\" height=\"85\" src=\"n2team/pictures/$state_row[photo]\" alt=\"$state_row[firstname] $state_row[last_name]\" />\n";
                 }
                 echo "   </div>\n";
                 echo "   <span class=\"fr\">$state_row[first_name] $state_row[last_name]<br />\n";
                 echo "       $state_row[title]<br />\n";
                 echo "       $state_row[city], $state_row[state]<br />\n";
                 //echo "       <a href=\"mailto:$state_row[email]\">$state_row[email]</a></span></li>\n";
              }
           }
           echo "</ul>\n";
        }
}
?>

How can I limit the amount of time my while loop to only show the first 4 rows of my SQL table?   I am using this code to loop my whole table:  

while($row = $results->fetch(PDO::FETCH_ASSOC))
                        {
                        echo '
                        <li>Mileage: '.number_format($row["Mileage"]).'</li>
                        <li>Engine size: '.$row["EngineSize"].'cc</li>
                        ';} ?>

I only want to loop through the first 4 rows of my SQL table, I then want to duplicate the same code but start at the 5th row until the 8th row of the table, how can I do this?   Thanks, Nick

I have a problem displaying the results of a table,

It shows them in one long list and I'd like them to show as 2 or 3.

I had a look around and the most favoured way to this I found was to split the results either by odd/even or using percentages but Im having trouble implementing it into my script.

How would I go about adding the odd/even way to this:

<?php
$query = mysql_query('SELECT * FROM users ORDER BY Username');
while ($row = mysql_fetch_array($query)) {
if ($row['UserID']) 
       ?>
<b>Username:</b> <span class=class1><a href="aeditprofile.php?username=<? echo $row['Username'] ?>"><? echo $row['Username'] ?></a></span><br>
<b>Group:</b> <? echo $row['Level'] ?></color><br /><hr>
<?php
}
?>


Essentially I'm after getting something like this:

Name                           Name                          Name
Group                          Group                         Group

and so on down the page....

this is my code but i want to have a pice so if their is no results the it will put in a message like "No Results"
but i cant figger it out


<?php
$host="localhost";
$username="xxxxx";
$password="xxxxxx";
$db_name="xxxxxxx";
$tbl_name="Shows";

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name WHERE Month='April'and Year='2011' order by Day asc ";
$result=mysql_query($sql);

?>
<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td>
<table width="400" border="1" cellspacing="0" cellpadding="3">

<?php
while($rows=mysql_fetch_array($result)){
?>

<span class="elevenbold"><? echo $rows['Day']; ?> <? echo $rows['Month']; ?> <br><strong class="elevenboldblue"><? echo $rows['Song']; ?></strong><br><? echo $rows['Data']; ?></span><br><br>


<?php
}
?>
</table>
</td>
</tr>
</table>
<?php
mysql_close();
?>

Hey everyone.

So I am coding a badge system for my website usersystem. I am trying to think how I'll handle issues before actually starting to code it and one issue I just can't seem to figure out how to handle..

How would I limit the amount of MySQL results to show per line.
Eg. A user has 6 badges but I'd only like to show 2 per line. So in total it'd show 3 lines with 2 badges per line. If that makes any sense?

Is there any way possible to actually do this?

Hi everyone,

I am currently making a page for a friend to upload a bunch of photos at a time.

I was quite pleased that after a bit of googling and trial and error, I figured out how to do this so that multiple records could be added to my table with one submit button.

However, my form has 10 browse iconcs. A few tests have revealed that my problem is that if only one picture is uploaded, I still get 9 entries in my database, which I don't want.

My question is how can I alter the code so that a row is only populated in the database if an image is uploaded.

I guess something that sort of says :

   if($imgx!="")   
{
populate that row in the table
}

else

{
don't
}


...and the same for $imgx002 through to $imgx010


The current query is below. Any pointers are much appreciated.

Code: [Select]


$query = "INSERT INTO photo_uploads (date, photo_name)" . "VALUES (NOW(), '$imgx'), (NOW(), '$imgx002'), (NOW(), '$imgx003'), (NOW(), '$imgx004'), (NOW(), '$imgx005'), (NOW(), '$imgx006'), (NOW(), '$imgx007'), (NOW(), '$imgx008'), (NOW(), '$imgx009'), (NOW(), '$imgx010')";

This isn't the entire code just enough to see what I'm trying to do.

Everything was working until I added the mysql update query in the if statement. Is this possible or am I doing something wrong?

When I run the script it just echos "No results found" twice as $num_results = 2. 

Code: [Select]
<?php

include("../includes/connect.php");

$query = "SELECT ........ ";
$result = $db->query($query);

$num_results = $result->num_rows;

if ($num_results == 0) {

exit;

} else {

$i=0;
while ($i < $num_results) {
$row = $result->fetch_assoc();

$id = $row['id'];

if ($expiration_date > $today) {

### EMAIL CODE HERE ###

$update = "UPDATE model SET reminder_sent = '1' WHERE id = '$id' ";
$result_2 = $db->query($update);
 
$i++;

} else {

echo "No results found.";

$i++;

}
}
}

?>

I've decided to move over to using Prepared statements for security purposes, however I'm having problems with the following code.

Any help or suggestions would be appreciated

Output:

Code: [Select]

You are Logged In

Fatal error: Call to a member function bindParam() on a non-object in [b]xxxxxxx[/b]/login.php on line 34


Code:
Code: [Select]
<?php
include "functions.php";
$db_connection = db_connect();
$db_connection2 = db_connect();

$login_statement =  $db_connection->prepare("SELECT COUNT(*) AS accounts FROM `accounts` WHERE `email` = ? AND `password` = ?");
$test_stmt =   $db_connection2->prepare("INSERT INTO `test` (`test`) VALUES (:tst)");



login($_POST[email],$_POST[password],$login_statement);
log_login($test_stmt);

function login($email,$password,$login_statement){

$login_statement->bind_param("ss", $email, $password);
$login_statement->bind_result($accounts);
$login_statement->execute() or die ("Could not execute statement");

while ($login_statement->fetch()) { 

if ($accounts==1){
echo "<br/> You are Logged In <br/>";
}

else{
echo "<br/>Credentials Invalid<br/>";
     } 
}
}

function log_login($test_stmt){

$test_stmt->bindParam(':tst', $tst);  //< ********LINE 34*******
$tst="blah";
$test_stmt->execute()  or die ("Could not execute statement");
}
?>

Hello everyone! I'm new here on phpfreaks - Here's my problem. I get "1 <br/> 2" echoed, but not the query results. the connect() function connects and selects a table in a mysql database.

Here's the code:
Code: [Select]
<?php
connect();

$query = "SELECT `title`, `body`, `date` FROM `tutorials` ORDER BY `date` DESC" or die ("Query Error");

$counter = 0;

if ($query_run = mysql_query($query)) {

while ($query_row = mysql_fetch_assoc($query_run)) && ($counter <= 2) {
$title = $query_row['title'];
$body = $query_row['body'];
$date = $query_row['date'];
$counter ++;
echo $counter;
echo "<br/>";
echo $title;
echo $body;
echo $date;
}
}
?>
If anyone has any idea, please help! - I'm been battling this for a few hours now

Hi, I'm having a slight issue with some coding (see below). It worked a few minutes ago before I add "Packages" & "Safety & Technology" titles to the MySQL database.

Hopefully the attached image has worked, but if it hasn't go to www.bikescarsandvans.co.uk/test.php and select the first Audi A3 additional extras drop down menu and you'll see whats going wrong.

Code: [Select]
$query_title = "SELECT * FROM extras JOIN car_to_extra ON (car_to_extra.extras_id = extras.id) WHERE car_to_extra.car_id = '{$car_row['id']}' ORDER BY extras.price ASC";
$title_results = mysql_query($query_title) or die ("Error in query: $query_title. ".mysql_error());
$current_heading = '';
print "<div class='addtional_extras'>";// ADDED TO TRY TO SORT OUT POSITIONING ISSUE
while ($title_row = @ mysql_fetch_array($title_results ))
{
if ($current_heading != $title_row["title"])
{
    // The heading has changed from before, so print the new heading here.
    $current_heading = $title_row["title"];
    print "



<div class='title_tab2'>" . $title_row["title"] . "</div>
  ";
  }

  ?>
                                           
                                            <a class='data' href='#' onmouseout='hideTooltip()' onmouseover='showTooltip(event,"<?php print "" . $title_row["info"] . "<br/>(&pound;" . $title_row["price"] . ")"; ?>");return false'>
                                      <?php
print "
<img class='extra_img' src=\"". $title_row["img"] ."\" alt='" . $title_row["img_alt"] . "' /></a>


";

}// CLOSES WHILE LOOP ($title_row = @ mysql_fetch_array($title_results )) 
print "</div>";// CLOSES DIV IMAGE55

Hi Guys

I don't know if this is possible but can someone point me in the right direction. I have a php function which takes two inputs and returns an output. for simplicity's sake let's say it's an addition function. What I want to do is use a mysql select statement to show all the rows from a database where field1 and field2 equal '3'. Here's the sort of thing I mean.

function addNumbers($one,$two) {
return $one + $two;
}

mysql_query("SELECT * FROM table WHERE 'addNumbers(field1,field2)' = '3'");

What I actually want to do is a lot more complex than this but I am trying to understand how to make the syntax work in simple terms first.

Can anybody help?

Many Thanks
Dan

ive tried to write the $sql in so many ways and this looks the best and its still not working
and ive checked the correct syntax but still.

this is how i wrote:
$sql2 = "UPDATE `tvchaty`.`episodes` SET `showid` = ".($showid).", `epname` = ".($epname).", `season` = ".($season).", `episode` = ".($episode).", `info` = ".($info).", `airdate` = ".($airdate).", `directwatch` = ".($directwatch)." WHERE `episodes`.`id` = ".($id)." LIMIT 1;";   


this is the error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Prideses, `season` = 6, `episode` = 11, `info` = , `airdate` = 2010-11-01, `dire' at line 1

what could be the problem?

tnx....

What im trying to do is make a mysql result appear on my screen like this

result 1     result 2     result 3
result 4     result 5     result 6
result 7     result 8     result 9

i will be using the query like
mysql_query("SELECT * FROM `cars` ORDER BY `id`");

so how will i get it to display like that
thanks

Hi guys,  Having problems sorting mysql results. I can easily order/sort table columns but would like to order the results by a variable.(Distance in Miles).
Havent much experience in PHP and really struggling with this. Basically a query echoing out car make and models and how far they are located from a postcode. Can get it to work no porblem, but not to order/sort by least distance.

Heres what i'm working with:
Code: [Select]
$res=mysql_query("SELECT * FROM cars");
while ($row = mysql_fetch_assoc($res)){

echo $row['Make'];
echo $row['Model'];

//variable will be determimed by user input form
$postcode="W12 3SR";

$start=$postcode;
$ends = array();

//finds value from database field
{
$ends[]=$row['Location'];
}

// Postcode entered by user via input form
$result=mysql_query("SELECT * FROM postcodes WHERE Pcode='$start'");
while($row=mysql_fetch_array($result)){
$gridn[0]=$row['Grid_N'];
$gride[0]=$row['Grid_E'];
}

foreach($ends as $fin){
// Postcodes within mysql table
$result=mysql_query("SELECT * FROM postcodes WHERE Pcode='$fin'");
while($row=mysql_fetch_array($result)){
$gridn[1]=$row['Grid_N'];
$gride[1]=$row['Grid_E'];
}

// TAKE GRID REFS FROM EACH OTHER TO WORK OUT DISTANCE.
$distance_n=$gridn[0]-$gridn[1];
$distance_e=$gride[0]-$gride[1];

// CALCULATE THE DISTANCE BETWEEN THE TWO POSTCODES AND DIVIDE BY 1.6 TO CONVERT KM TO MILES
$hypot=sqrt(($distance_n*$distance_n)+($distance_e*$distance_e))/1.609;

//VARIABLE FOR DISTANCE AND ROUNDED OF TO NEAREST WHOLE NUMBER.
$distance=''.round($hypot/1000,0).'';


  echo " $distance miles";
  echo "<br>";
}
}
?>
I wish i could just do something like this but isnt possible, is it ?
Code: [Select]
"Select * FROM cars ORDER BY $distance";
Thanks!