PHP - This Query Gives No Error And No Result Either

I have this query to show the current class I'm in:
Code: [Select]
$GetTimeTable = "SELECT * FROM timetable WHERE username='$username' AND Subject_date='$today_date'";
Then I have this to display current class:
Code: [Select]
if($TimeNow >= $Start_time && $TimeNow <= $End_time){
echo "Current Class: ";
echo $Subject;}
How would I find next class that day?

Hello, I am new to the board and PHP. I created a simple store locator app with PHP. It pulls the info from a database. I want to  take the website field from the table, once it is returned from the query, and have it print out a a hyperlink.
Please help.

Thanks, I have posted most of the relevant code.


<?php   if (isset ($stores)) {     if (!empty ($stores)) {       
   echo '<p><strong>' . count ($stores) . ' results were found.</strong></p>';     foreach ($stores as $value) {         
   echo '<p><strong>' . $value['name'] . '</strong><br />';       
   echo $value['address'] . '<br />';       
   echo $value['town'] . ', ' . $value['state'] . ' ' . $value['postal'];     
   echo '&nbsp;<a target="_blank" href="http://maps.google.com/maps?q=',
            $value['address'], ' ', $value['town'], ', ', $value['state'], ' ',
            $value['postal'],'">Map this location</a><br />';       
   echo 'Phone: ' . $value['phone'] . '<br />';
   echo 'Website: ' . $value['website'] .  '<br />'; 
   echo 'Email: ' . $value['email'] . '<br />';   
   echo 'Hours: ' . $value['hours'] ;     
   echo '</p>';       }     }
      else {     
   echo '<p><strong>No results found</strong></p>';   }   }   
   ?>
   

Hello!

I am busy developing a script that returns all users that have the cell "Available" set to 1
but I am unsure how to do this, I am familiar with basic SQL and I have made this:

$sql = "SELECT * FROM `clans` WHERE `available` =1 LIMIT 0 , 30";
if ($result = mysql_query($sql)) {
if (mysql_num_rows($result)) { 
$row = mysql_fetch_assoc($result);
echo ($row['name']);

but it only displays information from the first row found, and I want it to display all the rows found, how can I do this?
Thanks

- GreenFanta

Hi all,

Just a pretty basic question that I can't find the asnwer to:

I have a MySQL query of the following form:
Code: [Select]
$result = mysql_query (" SELECT $cols FROM tablename   WHERE.......");
Where $cols is as follows:
Code: [Select]
$cols = firstname, lastname, $price1, $price2, etc.
($price1 and $price2 are variable column names that contains prices)

How do I find the lowest value for $price1 and/or $price2 out of the results set of this query?

Thanks!

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=306966.0

Hello.  This one is driving me up the wall.  It used to work,

I have a sports league database (MsSql) and one of the tables contains team Captain's first name, last name, etc..  To create a unique but simple login, the query searches for the captain's first initial of their first name + lastname + league.  However since there is the remote possibility of two similar usernames (i.e. David Smith) if the last name is found, the query adds an integer to the end of the last name.

So the result would look like this:  DSmithM4A

At the moment, my database is completely blank.  However what is happening when I run the query below is I get: DSmith1M4A

Can someone figure out why this code is not working correctly?  If there is not more than one "Smith" no integer is supposed to be returned.  There is something in the "Captain Count" that I think is not working correctly.

Code: [Select]
    /*
     * Gather captian information
     */
    $strCaptainFirstInitial = substr($arrPost['cpt_first'],0,1);
    $strCaptainLastName = preg_replace("/[^a-zA-Z]/","",$arrPost['cpt_last']);
    $strCaptainName = strtolower($strCaptainFirstInitial.$strCaptainLastName);
    $sqlCaptainSearch = sprintf
    (
        $strCaptainSearch,
        $strCaptainName
    );
    $resCaptainSearch = mssql_query($sqlCaptainSearch,$conDB);
 
    /*
     * Create unique captain login and Password
     */
    $strCaptainCount = (mssql_num_rows($resCaptainSearch) > 0)
        ? mssql_num_rows($resCaptainSearch)
        : "" ;
    $strLeagueTypeInitial = substr($arrLeagueSearch['type'],0,1);
    $strCaptainLogin =
        $strCaptainName .
        $strCaptainCount .
        $strLeagueTypeInitial .
        $arrLeagueSearch['size'] .
        $arrLeagueSearch['division'];

Hi,

I have attached sql script for table structure and sample data.

When I run following sql query ,I get result set.

Code: [Select]
select * from tablename order by col10 desc
I want to create array using result set.

Following is the require structure of array.

Code: [Select]
<?php

$resultSet[]=array
    (
        ('0') =>array (
              ('col10value1') => array
                    (
                        ('0') => array
                            (
                                ('col1') => 'col1',
                                ('col2') => 'col2',
                                ('col3') => 'col3',
                                ('col4') => 'col4',
                                ('col5') => 'col5',
                                ('col6') => 'col6',
                                ('col7') => 'col7',
                                ('col8') => 'col8',
                            ),
                        ('1') => array
                            (
                                ('col1') => 'col1',
                                ('col2') => 'col2',
                                ('col3') => 'col3',
                                ('col4') => 'col4',
                                ('col5') => 'col5',
                                ('col6') => 'col6',
                                ('col7') => 'col7',
                                ('col8') => 'col8',
                            ),
                    ),
            ),
 

        ('1') => array (
          ('col10value2') => array
                (
                    ('0') => array
                        (
                            ('col1') => 'col1',
                            ('col2') => 'col2',
                            ('col3') => 'col3',
                            ('col4') => 'col4',
                            ('col5') => 'col5',
                            ('col6') => 'col6',
                            ('col7') => 'col7',
                            ('col8') => 'col8',
                        ),
                ),
        ),
    );   
?>

Hi
sorry for my bad English
I have this queries but when I using num_queries show over 40 for this code!!
how can I optimize it for best performance


category table is : ".$prefix."_modules_categories
item table is : ".$prefix."_modules


  $display = $openclose;
    if ($display == 0) {
    $show = "none";
    $catimg = "<img src=\"$closedimg\" align=\"absmiddle\" border=\"0\">";
    } else {
    $show = "show";
    $catimg = "<img src=\"$openimg\" align=\"absmiddle\" border=\"0\">";
      }

    //Categories
    $result = $db->sql_query("select mcid, mcname FROM ".$prefix."_modules_categories WHERE visible='1' ORDER BY mcposition");
  //$coin=0;
      global $multilingual, $currentlang;
      while ($row = $db->sql_fetchrow($result)) {
        $mcid =      $row['mcid'];
        $mcname   =   $row['mcname'];
    //$coin++;
      $mcname1 = $mcname;
    if(strlen($mcname1) == 0){
      if ($multilingual == 1) {
        include("modules/languages/lang-".$currentlang.".php");
        $mcname = "$mcnamed[$mcid]";
      } else {
        include("modules/languages/lang-english.php");
        $mcname = "$mcnamed[$mcid]";
      }
    }else{
      $mcname = "$mcname1";
    }




               $content  .= "</div><table border=0 cellpadding='1' cellspacing=1><tr><td width='16'><a id=\"x".$mcname."\" href=\"javascript:Toggle('".$mcname."','$align');\">$catimg</a></td><td><b>".$mcname."</b></table>\n";
               $content  .= "<div id=\"".$mcname."\" style=\"display: $show; margin-left: 1em;\">\n";
        $result2 = $db->sql_query("SELECT title, custom_title, view, url FROM " . $prefix . "_modules WHERE active='1' AND inmenu='1' AND title!='$def_module' AND mcid='$mcid' ORDER BY custom_title ASC");


 while ($row = $db->sql_fetchrow($result2)) {
  $title =  $row['title'];
   $custom_title  =   $row['custom_title'];
   $view =  $row['view'];
   $url =   $row['url'];
   $arraymodules[] = "$title:$custom_title:$view:$url";
  $m_title = $title;
  $m_title2 = ereg_replace("_", " ", $m_title);
  include("modules/".$title."/language/lang-".$currentlang.".php");
      if ($custom_title != ""){$m_title2 = $custom_title;}else{
      if(strlen($mudulename) != 0){
      $custom_title = "$mudulename";
      }
      $m_title2 = $custom_title;

    }
          if ($m_title != $main_module) {
          $showit = 0;
          switch($view){
            case 0: // All users case
                $showit = 10;
            break;

            case 1: // Registered user access
                if (is_user($user) || is_admin($admin)) $showit = 1;
            break;

            case 2: // Admin only access
                if (is_admin($admin)) $showit = 2;
            break;

            default: // Subscriber only access
                if (is_user($user) || paid()) $showit = 3;
            break;

        }
        global $db , $prefix;
        $rowz = $db->sql_fetchrow($db->sql_query("SELECT gtset FROM ".$prefix."_config"));
        $gtset = intval($rowz['gtset']);
        if ($showit != 0) {
        $adds =  $_SERVER['SERVER_NAME'];
          if ($url != "" AND $gtset != 0) {
               $content .= "<table border=0 cellpadding='1' cellspacing=1><tr><td width='16'><img src=\"$arrowimg\" align=\"absmiddle\" border=\"0\"></td><td><a href=\"$url\" title=\"$m_title2\" onMouseOver=\"self.status=' $m_title2 ';return true\" onmouseout=\"self.status='';return true\">$m_title2</a></td></tr></table>\n";
           } else {
       $content .= "<table border=0 cellpadding='1' cellspacing=1><tr><td width='16'><img src=\"$arrowimg\" align=\"absmiddle\" border=\"0\"></td><td><a href=\"modules.php?name=$m_title\" title=\"$m_title2\" onMouseOver=\"self.status=' $m_title2 ';return true\" onmouseout=\"self.status='';return true\">$m_title2</a></td></tr></table>\n";
          }
        }
      }
    $mudulename = "";
    }
  }
$content .= "</div>";

$db->sql_freeresult($result);
$db->sql_freeresult($result1);

Hello -

Suppose I had a MySQL result set that was something like this:
ITEM: COLOR: ball red ball blue book red book green book black
If I were to use the code:
Code: [Select]
do {
   echo $row_myQuery['item'] . " - " . echo $row_myQuery['color'] . "<br />";
} while ($row_myQuery= mysql_fetch_assoc($myQuery));

Then I end up with this:

Code: [Select]
ball - red
ball - blue
book - red
book - green
book - black
MY QUESTION:

What I'd like to know is, how could I re-write that php code so that I could get an output like this?:

Code: [Select]
ball - red, blue
book - red, green, black
Thanks!

I´ve reached to

    <?php require_once('Connections/conexxion.php'); ?>
    <?php
    mysql_select_db($database_conexxion, $conexxion);
    $query_consulta = "SELECT venta,compra,taller,regula_mas,regula_menos,movimiento.id_item,sum(compra+regula_mas-venta-taller-regula_menos)  as stock, cilindro, esfera FROM movimiento  join item on item.id_item=movimiento.id_item join rx on rx.id_rx=item.id_rx join cilindro  on cilindro.id_cil=rx.id_cil  join esfera  on esfera.id_esf=rx.id_esf GROUP BY movimiento.id_item ORDER BY esfera desc, cilindro desc";
    $consulta = mysql_query($query_consulta, $conexxion) or die(mysql_error());
    $row_consulta = mysql_fetch_assoc($consulta);
    $totalRows_consulta = mysql_num_rows($consulta);
    ?>
    <!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=utf-8" />
    <title>test</title>
    </head>
     
    <body>
     
       <?php
    echo "<table align=center>";
     
    $columnes = 10; # Número de columnas (variable)
     
    if (($rows=mysql_num_rows($consulta))==0) {
      echo "<tr><td colspan=$columnes>No hay resultados en la BD.</td></tr> ";
    } else {
      echo "<tr><td colspan=$columnes>$rows Resultados </td></tr>";
    }
     
    for ($i=1; $row = mysql_fetch_row ($consulta); $i++) {
    $resto = ($i % $columnes); # Número de celda del <tr> en que nos encontramos
    if ($resto == 1) {echo "<tr>";} # Si es la primera celda, abrimos <tr>
       echo "<td>$row[1]</td>";
    if ($resto == 0) {echo "</tr>";} # Si es la última celda, cerramos </tr>
    }
    if ($resto <> 0) { # Si el resultado no es múltiple de $columnes acabamos de rellenar los huecos
    $ajust = $columnes - $resto; # Número de huecos necesarios
    for ($j = 0; $j < $ajust; $j++) {echo "<td>&nbsp;</td>";}
    echo "</tr>"; # Cerramos la última línea </tr>
    }
    mysql_close($connexion);
    echo "</table>";
    ?>
     
     
     
    </body>
    </html>
    <?php
    mysql_free_result($consulta);
    ?>

it "works", but results doesn´t start at number 1 but number 2   anyways, The intent of this table is to show the stock of a product, a lens, that has a range of Rx, we use to see this range this way, and show the stock this way would be very productive, but I can´t figure out how to achive it, any sugestion??  
Edited by gralfitox, 16 December 2014 - 06:45 AM.

This topic has been moved to CSS Help.

http://www.phpfreaks.com/forums/index.php?topic=353608.0

Hi Everyone.

I get the following data from a result from database search

<?php echo $rsjobs['CompanyURL'];?>  It prints out the url but when I try to turn it into a clickable link it does not work

Here is the coding I have so far.


<a href="<?php echo $rsjobs['CompanyURL'];?>"><?php echo $rsjobs['CompanyURL'];?></a>


 What am I doing wrong ? please help.

Hi,

i have a database with multiple records. One of those values is an image. When i query the database and i want only the images as a result it gives the result in a field. It then fills up the field horizontal and when there is no more field left it starts a new row. That is what i want.

But now i want some extra info next to the picture so i put that in a table with two colums like this:

echo '<table border="1" width="400"><td><a href="'.$row['website'].'"> <img src="'.$row['prod_img'].'">
               '.$row['prod_name'].' <a href="'.$row['website'].'">'.$row['website'].'</td></table>
            ';}}

But i still want the result to fill up the field and when the field is full i want the next results on a row below this....

Anyone?

soo i get info from a form and i want to search for it in my db .. if i find user_name AND user_password the $result returns true .. otherwise false ..

<?php require_once("../includes/connection.php"); ?>
<?php
$user_name=$_POST["user_name"];
$user_password=$_POST["user_password"];
?>
<?php
$query = "SELECT *
          FROM users
          WHERE  '{$user_name}' = user_name
          AND '{$user_password}'= user_password
          ";
$result = mysql_query($query,$connection);
if($result==false){ 
redirect("../index.php");}
elseif($result==true){
redirect("../welcome.php");
}
?>
<?php //close connection!
mysql_close($connection);
?>


but the problem is that it always returns TRUE !!!!
whats the problem here exactly ???