PHP - Query Failed: Incorrect Integer Value: '' For Column 'id' At Row 1

I want to perform a query which returns a subset of the fields in a table.  One particular mySQL field is VARCHAR

I have a query like this:
$query = mysql_query("SELECT * FROM table WHERE code LIKE '3%') ;

It's my understanding this should return all values which begin with "3", but it only returns about a dozen of the values 3, 30-39, 300-399, etc.  (It works with string fields, but this field contains numerals.)

Any help appreciated.

thanks,
Tom

How can I check to see if a query has failed, be it INSERT, UPDATE, DELETE or SELECT?

I want to return one value if the query fails, but a different one if it works.

For example, if I have a query to delete a row, but somehow this query fails because the row doesn't exist, then I want to check that it's failed and then output a result

hi i have the script below which copies data from one table to another but will only insert new data update current data or delete old data from tempproducts to products then it will delete the tempproducts from the db however i keep getting this error:

Warning: mssql_query() [function.mssql-query]: Query failed in E:\UpdateProducts.php on line 33

updateproducts.php
Code: [Select]
<?php
include('../../otherscripts/functions.php');
$log = new Logging(); 

// create DB connection
 $host = "localhost";
 $user = "user";
 $pass = "pass";
 $mydb = "db";

 $db = mssql_connect($host,$user,$pass);
 
//Select Database
 mssql_select_db($mydb);
 

 // delete all old data
    $sql0 = "SELECT * FROM tempproduct";
    $sql1 = "INSERT INTO products SELECT * FROM tempproduct WHERE manf_part_no NOT IN (SELECT manf_part_no FROM products) AND supp_id NOT IN (SELECT supp_id FROM products)";
    $sql2 = "DELETE FROM products WHERE manf_part_no NOT IN (SELECT manf_part_no FROM tempproduct) AND supp_id NOT IN (SELECT supp_id FROM tempproduct)";
    $sql3 = "UPDATE p1 SET p1.avail_qty = t1.avail_qty, p1.cost_price = t1.cost_price, p1.rrp = t1.rrp, p1.date_added = t1.date_added, p1.description = t1.description FROM Products p1 INNER JOIN tempproduct t1 ON (p1.manf_part_no = t1.manf_part_no AND p1.supp_id = t1.supp_id)";
    $sql4 = "TRUNCATE TABLE tempproduct";

//If tempproduct is empty done Execute Commands if it is full then execute commands

$query = mssql_query($sql0) or die($log->lwrite('Failed to select for count from db'));
$rowcount = mssql_num_rows($query);

if($rowcount == 0){
$log->lwrite('Teh tempproduct am emptyish');
}
else{
   mssql_query($sql1) or die($log->lwrite('Failed to insert to db'.$sql1));
   mssql_query($sql2) or die($log->lwrite('Failed to Delete from db'));
   mssql_query($sql3) or die($log->lwrite('Failed to Update db'));
   mssql_query($sql4) or die ($log->lwrite('Failed to TRUNCATE db'));
}
?>

if i run $sql1 command in the sql manager it runs fine and no errors occur?

Hey! I am trying to get a database table of users but am running into the error:

Warning: file_get_contents(http://protege-ontology-editor-knowledge-acquisition-system.136.n4.nabble.com/template/NamlServlet.jtp?macro=user_nodes&amp;user=68583) [function.file-get-contents]: failed to open stream: HTTP request failed! HTTP/1.1 500 in get_user_from_parameter(nabble:utilities.naml:890) - <n.get_user_from_parameter.as_user_page.do/> - public v in C:\xampp\htdocs\website4js\stanford\loadUsernames.php on line 32

I have looked it up and it may be a security thing...The urls I am getting are http://protege-ontology-editor-knowledge-acquisition-system.136.n4.nabble.com/template/NamlServlet.jtp?macro=user_nodes&user=68583 but the error adds an nodes&amp; part that screws it up. Any way around this?

Code: [Select]
<?PHP
$maxPage = 0;
$mainPage = "http://protege-ontology-editor-knowledge-acquisition-system.136.n4.nabble.com/template/NamlServlet.jtp?macro=app_people&node=136";
$mainContent = file_get_contents($mainPage);
$pattern = "/(?<=\"Page )\d\d+/";
preg_match_all($pattern, $mainContent, $pageNumb);

//find the max page
for($i=0;$i<sizeof($pageNumb[0]);$i++) {
if($pageNumb[0][$i] > $maxPage) {
$maxPage = $pageNumb[0][$i];
}
}
//echo('Max page is: '.$maxPage.'\n');

//Get an array of all the pages
$pages = array();
 for($i=1;$i<$maxPage;$i++) {
$pages[$i] = "http://protege-ontology-editor-knowledge-acquisition-system.136.n4.nabble.com/template/NamlServlet.jtp?macro=app_people&node=136&i=".($i*20);
 }
//print_r($userPages);

//Get personal page urls and add to MySQL
mysql_connect("localhost" , "root") or die("Cant connect");
mysql_select_db("protegeusers") or die("Cant find database");
foreach($pages as $url) {
$urlContents = file_get_contents($url);
$pattern = "/http:\/\/protege-ontology-editor-knowledge-acquisition-system\.136\.n4\.nabble\.com\/template\/NamlServlet\.jtp\?macro=.+;user=\d+/";
preg_match_all($pattern, $urlContents, $personalPage);
foreach($personalPage as $user) {
for($i=0; $i<sizeof($user);$i++) {
[color=green]$userContents = file_get_contents($user[$i]);[/color]
$pattern1 = "/user\/SendEmail\.jtp\?type=user.+;user=\d+/";
$pattern2 = "/(?<=\">Send Email to ).+(?=<)/";
preg_match_all($pattern1, $userContents, $userEmail);
preg_match_all($pattern2, $userContents, $username);
[color=green]print_r($username);
print_r($email);[/color]
//$query = "INSERT INTO users (username, userurl) values ('$userName','$userUrl')";
//mysql_query($query);
}
}
}
?>

I am trying to figure how to code around this. I have a DOM scraper function that pulls urls from my database, opens the page, scrapes the data, and then moves onto the next URL to scrape. my issue is that if the page fails to load the script bombs and I have to restart it again. Trying to figure out how if the Code: [Select]
$html->find('div[class="itemHeader address"]') as $div fails to open the page it just skips the DOM inspection.

Here is my error...

Failed to open stream: HTTP Request failed.

Here is where I am at with my script....

Code: [Select]
mysql_select_db("scraped") or die(mysql_error());
$result = mysql_query("SELECT PKEY, URL, HASSCRAPED, SHOULDSCRAPE FROM CRAWLED WHERE SHOULDSCRAPE ='1' AND HASSCRAPED = '0'") or die(mysql_error()); 

while($row = mysql_fetch_array( $result )) {
mysql_query("UPDATE CRAWLED SET CRAWLED.HASSCRAPED =  '1' WHERE CRAWLED.URL = '" . $row['URL'] . "'");
$html = file_get_html($row['URL']);
foreach($html->find('div[class="itemHeader address"]') as $div) {
foreach($div->find('a') as $element){
$CleanData = CleanData($element->innertext);
if (strlen($CleanData[0]) > 5){
    mysql_query("INSERT INTO SCRAPED (ADDR1, CITY, STATE, ZIP, URL, DATE) VALUES ('" . $CleanData[0] . "','" . $CleanData[1] . "','" . $CleanData[2] . "','" . $CleanData[3] . "','". $row['URL'] . "','". date( 'Y-m-d H:i:s ' ) ."')");
        }
}
}

$html->clear();
unset($html);
unset($CleanData);
}

function CleanData($data) {
  $NewData = trim($data);
  $NewData = str_replace("<em>", "", $NewData);
  $AddrCityStateZip = explode("</em>",$NewData);
  $CityStateZip = explode(",",$AddrCityStateZip[1]);
  $StateZip = explode(' ',$CityStateZip[1]);
  $NewDataArray = array ($AddrCityStateZip[0], $CityStateZip[0], $StateZip[1], $StateZip[2]);
  return $NewDataArray;
  unset($NewData);
  unset($AddrCityStateZip);
  unset($CityStateZip);
  unset($StateZip);
}
mysql_close($link);
echo 'Scraping has compleated without error';

I need to write a query that will sum  a column 'serv_cc_total' from the first day of the month to the date the record was saved to the db when the record for that date is viewed.
Any help would be appreciated.

Doug

hello all!

my query, when executed, generates an error i don't understand.    i've seen similar entries, but i couldn't find one that related to this particular problem.  either that, or i'm a retard and didn't see it.  apologies if that's the case.  here's the error:

-->  Database Query Failed: Unknown column 'client_id' in 'where clause'  <--

i triple checked the database table and, YUP, the column is correctly named "client_id" and it is an INT column, so it doesn't need to be encapsulated with single quotes.

here's the code that makes it happen:

<CODE>

        $clientID = $_SESSION['clientID'];
   
   $query = "SELECT * ";
   $query .= "FROM client_data ";
   $query .= "WHERE client_id = {$clientID} ";
   $query .= "LIMIT 1";
   
   $results = mysql_query($query);

</CODE>

what. the. heck. 

thanks in advance gang. 

WR!

Hi Everyone,

I am working on implementing a blog comment system using the query below to display comments. My question is what is the best way to do a row count for the id column with this query or do I need to do a second db query to accomplish this? The purpose of this is to echo out the number of comments for that post, before displaying them.

Any help is appreciated.

Thanks in advance,

kaiman


<?php
// get url variables
$post_id = mysql_real_escape_string($_GET['id']);

include ("../../scripts/includes/nl2p.inc.php");

// connects to server and selects database
include ("../../scripts/includes/dbconnect.inc.php");

// table name
$tbl_name3="blog_comments";

// select info from comments database
$result3 = mysql_query ("SELECT count(*) FROM $table_name3 WHERE id='$post_id' ORDER BY id DESC LIMIT 1") 
or trigger_error("A mysql error has occurred!");
if (mysql_num_rows($result3) > 0 ) {
while($row = mysql_fetch_array($result3)) {
extract($row);

// display number of comments


// display date
$row_date = strtotime($row['date']);
putenv("TZ=America/Denver");
echo "<p class=\post\">On ".date('F, jS, Y', $row_date)." ";

// display commenter name
if($row['url'] == "") { 
echo $row['name']." wrote:</p>\n"; 
} 
     else { 
echo "<a href=\"".$row['url']."\" target=\"_blank\">".$row['name']."</a> wrote:</p>\n"; 
} 

// display content
$comments = $row['comment'];
echo nl2p($comments);
}
}
else {
echo "<p class=\"large_spacer\">No Comments</p>";
}
?>

The Script:

<?php

    include("connect.php");

?>
<?php

    echo "<h1>The Hashtag: </h1>";
    if(isset($_GET['hashtag'])){
        echo $_GET['hashtag'];
    }


    // Select the ID of the given hashtag from the "hashtags" table.
    $tqs = "SELECT `id` FROM `hashtags` WHERE `hashtag` = '" . $_GET['hashtag'] . "'";
    $tqr = mysqli_query($dbc, $tqs) or die(mysqli_error($dbc));
    $row = mysqli_fetch_assoc($tqr);

    // This prints e.g.:
    // 100
    echo "<br/><br/>";
    print_r($row['id']);

    // Select the threads from the "thread" table which contains the hashtag ID number.
    $tqs_two = "SELECT * FROM `thread` WHERE `hashtag_id` IN ('" . $row['id'] . "')";
    $tqr_two = mysqli_query($dbc, $tqs_two) or die(mysqli_error($dbc));
    $row_two = mysqli_fetch_assoc($tqr_two);

    echo "<br/><br/>";
    print_r($row_two);

?>

The script should select the rows by that ID number of the hashtag. It should look in the "hashtag_id" column of the table and see if that ID number can be found there, if it can be found there, then it should select that row.   The ID numbers are inside that "hashtag_id" column separated by commas.   Example:

98, 99, 100

My Question: How to do the SQL query so it selects the rows by the hashtag ID number?
Edited by glassfish, 17 October 2014 - 10:35 AM.

I am trying to create 3 columns of data from a query.  I have used this code before for 2 columns but and now wanting to use for three columns.   There are 5 records from a join query.  The first two columns display the results, 2 results in the left column and 3 results in the center column.  The right column displayw empyt text used in displaying the results, there is no data to populate and it seems to mimic the the number from the center, 3.   Here is the URL to see the problem   http://specialslocat...ignID=1IBu3992p   Here is the Code for the query and the 3 column results.

<?php
$UN_URL = $_GET['un'];
$mS_MGMTcampaignID_URL = $_GET['mS_MGMTcampaignID'];
?>

<table width="944" border="1" align="center" cellpadding="0" cellspacing="0">

<?php 

$result = mysql_query( "SELECT * FROM manager_Specials_company_mgmt MSCM LEFT JOIN b2c_coupons B2CC ON (MSCM.mS_MGMT_id = B2CC.m_primeID )WHERE mS_MGMTcampaignID = '$mS_MGMTcampaignID_URL' ORDER BY mS_MGMT_m_company ASC" );
		$num_results = mysql_num_rows($result);
		$numb_tb_rows= ceil($num_results/3)
?>

<?
if ( $numb_tb_rows > 0 ) {
?>
	<tr >
	      <td colspan="4" valign="top"  class="body_text_10_Center"><strong><?=$mS_campaignName_mS?> is proud to sponsor <?=$num_results?> 
<?		
if ( $num_results == 1 ) {
?>
company:</strong>
<?
} elseif ( $num_results > 1 ) {
?>
companies:</strong>
<?
} 
?>

</td>


	</tr>


	<tr class="body_text_10_Center">

<!-- Column 1 -->
	<td width="320" class="body_text_10_Center" valign="top">


<? // column #1
	if($num_results>=1)
	{
		for($i=0; $i<$numb_tb_rows; $i++)
		{
			$row= mysql_fetch_array($result);
?>



<?php		
		if(!empty ($row["m_logo"])) { 
?>
		<div align="center">
		<img src="http://marketingteammates.com/_ZABP_merchants/_zcnsLogos/gick.php/<?=stripslashes($row["m_logo"])?>?resize(220)" border="0"></a><br />
		</div>
<?php
} else {

}   
?>  
		<h6><?=stripslashes($row["mS_MGMT_m_company"])?></h6>
		<?=stripslashes($row["b2c_m_address1"])?>&nbsp;&nbsp;<?=stripslashes($row["b2c_m_address2"])?><br />
		<?=stripslashes($row["b2c_m_city"])?> <?=stripslashes($row["b2c_m_state"])?>, <?=stripslashes($row["b2c_m_zip"])?><br />
		Phone:&nbsp;<?=stripslashes($row["b2c_m_phone"])?><br />
		Fax:&nbsp;&nbsp;<?=stripslashes($row["b2c_m_fax"])?><br />
		<a href="mailto:<?=stripslashes($row["b2c_email"])?>"><?=stripslashes($row["b2c_email"])?></a><br /><br />
		Hours of Operation:&nbsp;<?=stripslashes($row["m_coupon_title"])?><br />
		<?=stripslashes($row["m_coupon_desc"])?><br /><br />
		<div align="center">
		<img src="../images/print_image.gif" width="29" height="31" /><br /><br />
		<hr width="80%" size="1" />
		</div><br /><br />



<?	// END column #1		
		}
	}
?>		

	</td>
		
		
		


		
<!-- Column 2 -->
		<td width="320" class="body_text_10_Center"  valign="top">
		
		
<? // column #2
	if($num_results>=2)
	{
		for($i=($numb_tb_rows); $i<$num_results; $i++)
		{
			$row= mysql_fetch_array($result);
?>

<?php		
		if(!empty ($row["m_logo"])) { 
?>
		<div align="center">
		<img src="http://marketingteammates.com/_ZABP_merchants/_zcnsLogos/gick.php/<?=stripslashes($row["m_logo"])?>?resize(220)" border="0"></a><br />
		</div>
<?php
} else {

}   
?>  
		<h6><?=stripslashes($row["mS_MGMT_m_company"])?></h6>
		<?=stripslashes($row["b2c_m_address1"])?>&nbsp;&nbsp;<?=stripslashes($row["b2c_m_address2"])?><br />
		<?=stripslashes($row["b2c_m_city"])?> <?=stripslashes($row["b2c_m_state"])?>, <?=stripslashes($row["b2c_m_zip"])?><br />
		Phone:&nbsp;<?=stripslashes($row["b2c_m_phone"])?><br />
		Fax:&nbsp;&nbsp;<?=stripslashes($row["b2c_m_fax"])?><br />
		<a href="mailto:<?=stripslashes($row["b2c_email"])?>"><?=stripslashes($row["b2c_email"])?></a><br /><br />
		Hours of Operation:&nbsp;<?=stripslashes($row["m_coupon_title"])?><br />
		<?=stripslashes($row["m_coupon_desc"])?><br /><br />
		<div align="center">
		<img src="../images/print_image.gif" width="29" height="31" /><br /><br />
		<hr width="80%" size="1" />
		</div><br /><br />	

<?	// END column #2		
		}
	}
?>	
		</td>
		
		
		


<!-- Column 3 -->
		<td width="320" class="body_text_10_Center"  valign="top">
		
		
<? // column #3
	if($num_results>=3)
	{
		for($i=($numb_tb_rows); $i<$num_results; $i++)
		{
			$row= mysql_fetch_array($result);
?>
<?php		
		if(!empty ($row["m_logo"])) { 
?>
		<div align="center">
		<img src="http://marketingteammates.com/_ZABP_merchants/_zcnsLogos/gick.php/<?=stripslashes($row["m_logo"])?>?resize(220)" border="0"></a><br />
		</div>
<?php
} else {

}   
?>  
		<h6><?=stripslashes($row["mS_MGMT_m_company"])?></h6>
		<?=stripslashes($row["b2c_m_address1"])?>&nbsp;&nbsp;<?=stripslashes($row["b2c_m_address2"])?><br />
		<?=stripslashes($row["b2c_m_city"])?> <?=stripslashes($row["b2c_m_state"])?>, <?=stripslashes($row["b2c_m_zip"])?><br />
		Phone:&nbsp;<?=stripslashes($row["b2c_m_phone"])?><br />
		Fax:&nbsp;&nbsp;<?=stripslashes($row["b2c_m_fax"])?><br />
		<a href="mailto:<?=stripslashes($row["b2c_email"])?>"><?=stripslashes($row["b2c_email"])?></a><br /><br />
		Hours of Operation:&nbsp;<?=stripslashes($row["m_coupon_title"])?><br />
		<?=stripslashes($row["m_coupon_desc"])?><br /><br />
		<div align="center">
		<img src="../images/print_image.gif" width="29" height="31" /><br /><br />
		<hr width="80%" size="1" />
		</div><br /><br />

<?	// END column #3		
		}
	}
?>		
		</td>

	</tr>


 <?	
} else {
	echo "";
}
?>



</table>

Thanks for any help in advance. Mike

Hey all, first post to this site. I'm somewhat new to PHP, so bear with me - this might be an easy question, it might not be. Just looking for a little help.

Basically, I have a query which takes commands from a form through AJAX (day, time, time1). The query executes a wildcard on a table named sip_data, searches for linked $id (so if $id=3, for example in multiple tables, it spits out the $name, $zip in a div).

Here's the code:

Code: [Select]
<?php
$dbhost = "localhost";
$dbuser = "";
$dbpass = "";
$dbname = "";

//Connect to MySQL Server
$link = mysql_connect($dbhost, $dbuser, $dbpass);

//Select Database
mysql_select_db($dbname) or die(mysql_error());

// Retrieve data from Query String
$id = $_GET['id'];
$name = $_GET['name'];
$zip = $_GET['zip'];
$server_url = $_GET['server_url'];
$day = $_GET['day'];
$time = $_GET['time'];
$time1 = $_GET['time1'];

// Escape User Input to help prevent SQL Injection
$id = mysql_real_escape_string($id);
$name = mysql_real_escape_string($name);
$zip = mysql_real_escape_string($zip);
$server_url = mysql_real_escape_string($server_url);
$day = mysql_real_escape_string($day);
$time = mysql_real_escape_string($time);
$time1 = mysql_real_escape_string($time1);
//build query

$query = "SELECT * FROM $day,sip_data WHERE $day.id=sip_data.id AND $day$time<=>$day$time1 ORDER BY zip ASC";

//Execute query
$qry_result = mysql_query($query) or die(('No Results'));

//Build Result String
while($row = mysql_fetch_array($qry_result))

{
echo "<table id=query_result align=left>";
echo "<tr>";
    if($zip = $row[zip]); 
echo "<th><b>$row[zip]</b></th>";
echo "</tr>";
echo "<tr>";
echo "<td><a href=$row[server_url] rel=ajaxDiv>$row[name]</a></td>";
echo "</tr>";
echo "</table>";
}
echo $display_string;




?>





Basically, my issue with this is that some of the results within the sip_data DB will have zip codes that repeat. The current code prints out each results with the zip code and name - here's an image of a sample result:



What I would like to do is avoid repeating the zip code and just group the results under each zip code, kinda like this:

55408           55412        55423
---------     ------------    ----------
example      example       example
example                         example
example

Any help would be greatly appreciated. I feel like I'm so close to the answer, but just need a little guidance. Who knows, I might be way off.

Thanks in advance!

To accomplish the layout I was looking for, I used the following code:

for ($i=1; $i<=7; $i++)
   {

//set day of week for display as title of columns
$dow=date("l", strtotime($year.'W'."$weekno"."$i"));

echo "<td class=\"wvcolumn\" valign=\"top\">
<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" align=\"center\" width=\"$daycolumn\">
<tr><th class=\"wvtitle\" valign=\"bottom\" align=\"center\" width=\"$daycolumn\"><a class=\"titledate\" href=\"createticket.php?action=o&month=".date("m", strtotime($year.'W'."$weekno"."$i"))."&date=".date("d", strtotime($year.'W'."$weekno"."$i"))."&year=".date("Y", strtotime($year.'W'."$weekno"."$i"))."\">$dow, ".date("F d", strtotime($year.'W'.$weekno."$i"))."</a>&nbsp;<a onClick=\"window.open('http://www.batchgeo.com')\" title=\"Map $dow's Appointments\" href=\"mapday.php?week=$weekno&year=$year&day=$i\"><img width=\"20\" style=\"border-style: none\" src=\"../images/icon_globe.png\"></a></th></tr>";

if(date("Y-m-d")==date("Y-m-d", strtotime($year.'W'."$weekno"."$i"))) {
$query = "SELECT fieldtickets.ticketnumber, fieldtickets.business, title, apptdatetime, DATE_FORMAT(apptdatetime,'%h:%i %p') AS fapptdatetime, status, billstatus, type, assigntech, clients.business FROM fieldtickets LEFT JOIN clients ON fieldtickets.business = clients.id WHERE status='Open' AND (type = 'Field' OR type = 'Phone') AND apptdatetime BETWEEN '".date("Y-m-d", strtotime($year.'W'."$weekno"."$i"))." 00:00:00' AND '".date("Y-m-d", strtotime($year.'W'."$weekno"."$i"))." 23:59:59' UNION SELECT fieldtickets.ticketnumber, fieldtickets.business, title, apptdatetime, DATE_FORMAT(apptdatetime,'%h:%i %p') AS fapptdatetime, status, billstatus, type, assigntech, clients.business FROM fieldtickets LEFT JOIN clients ON fieldtickets.business = clients.id WHERE status = 'Pending' ORDER BY status ASC, apptdatetime ASC";
} else { $query = "SELECT fieldtickets.ticketnumber, fieldtickets.business, title, apptdatetime, DATE_FORMAT(apptdatetime,'%h:%i %p') AS fapptdatetime, status, billstatus, type, assigntech, clients.business FROM fieldtickets LEFT JOIN clients ON fieldtickets.business = clients.id WHERE status='Open' AND (type = 'Field' OR type = 'Phone') AND apptdatetime BETWEEN '".date("Y-m-d", strtotime($year.'W'.$weekno."$i"))." 00:00:00' AND '".date("Y-m-d", strtotime($year.'W'.$weekno."$i"))." 23:59:59' ORDER BY apptdatetime ASC"; }

$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result)){
//if ticket is open show appt time and business, if ticket pending display DELIVERY and business name
if($row[status]=="Open") { $href="createticket.php?action=e&ticket=".$row[ticketnumber]; $time=$row[fapptdatetime]; $delivery=""; } elseif($row[status]=="Pending") { $href="createticket.php?action=c&ticket=".$row['ticketnumber'].""; $time=""; $delivery="DELIVER"; }
echo "<tr><td valign=\"top\"><a title=\"".$row[ticketnumber]." - ".$row[title]."\" class=\"".$row[status]."\" href=\"$href\"><span>$delivery$time ".substr($row['business'], 0, $displaychars)."</span></a></td></tr>\n"; }

echo "</table>";

}

echo "</td></tr>
</table>";

Output is similar to this, and any existing "deliveries" are displayed under the current day.
 _________________________________________________ ______________
|     Monday     |     Tuesday     |    Wednesday    |     Thursday     |       Friday       |
|appointments |appointments |appointments     |appointments   |appointments

This works great, but requires 5 separate queries. My database is very small for now, so its not a big deal, but I know this can be done much more efficiently.

How can I query the whole week and put appointments in their corresponding tables (days)? Thank you for your help!

Ever since I switched over to pagination, the ranks for the sites have been off. I use to have an $i++ increment that kept the ranks, but now with pagination, it just ranks those on the current page. Is there a way to bypass this?

public function grabSites()

{

//amount of sites

$amount = mysql_num_rows(mysql_query("SELECT * FROM sites"));

if($amount > 0)

{

//amount per page

$p_page = 13;

//track page

$start = $_GET['page'];

//max_pages

$max_pages = $amount / $p_page;

//set default

if(!$start) $start = 0;

//new query

$query = mysql_query("SELECT id,title,description,votes,date,outl,site_url FROM sites ORDER BY votes DESC LIMIT $start, $p_page");

while($fetch = mysql_fetch_assoc($query))

{

++$i;

$i = $i + $p_page;

echo "

<div id='post-1' class='post'>

<h2 class='title'><font color='white'>#". $i." ".$fetch['title'] ."</font></h2>

<div class='entry'>

<b>". $fetch['title'] ." currently has ". $fetch['votes'] ." votes. 

<a href='vote.php?id=". $fetch['id'] ."'>Vote now</a>.</b>

<br/><br/>

<p>". nl2br(stripslashes($fetch['description'])) ."</p>

</div>

<p class='meta'><a href='". $fetch['site_url'] ."'>Visit</a></p>

</div>

";

}

//set back and forth variables

$previous = $start - $p_page;

$next = $start + $p_page;

?>

<hr>

<center>

<?php

if(!($start<=0)) echo "<a href='index.php?page=". $previous ."'><<</a>";

$i = 1;

for($x = 0; $x < $amount; $x = $x + $p_page)

{

echo "<a href='index.php?page=". $x ."'> ". $i ." </a>";

$i++;

}

if(!($start>=$amount-$p_page)) echo "<a href='index.php?page=". $next ."'>>></a></center>";

?>

</center>

<?php

}

else

{

echo "

<div id='post-1' class='post'>

<h2 class='title'><a href='#'>Oh NOEZ!</a></h2>

<h3 class='date'>". date("M-d-Y") ."</h3>

<div class='entry'>

<p>There are currently no sites to display!</p>

</div>

<p class='meta'>View</p>

</div>

";

}

}

The password ARE correct. My code keeps saying that the password is INCORRECT. The password is MD5'ed once a user registers, and when they type in a password at the login (as shown), the password is also MD5'ed.

Why is it that it's output is incorrect password?


<?php
session_start();
include("includes/mysql.php");
include("includes/config.php");

?>


<title><?php echo $title; ?></title>

<?php
if(!$_SESSION['user'])
{

$username = $_POST['username'];
$password = $_POST['password'];

$username = mysql_real_escape_string($username);
$password = mysql_real_escape_string($password);

if(!$password || !$username)
{

echo
'
<h1>Login</h1>

<center><p><form action="login.php" method="POST">
<table border="0">
<tr><th>Username:</th> <td><input type="text" name="username" maxlength="20"><br/></td></tr>
<tr><th>Password:</th> <td><input type="password" name="password" maxlength="30"><br/></td></tr>
<tr><th></th><td><input type="submit" value="Login"></td></tr>
</table></form></p></center>
</div>
';

}
else
{
 $query = mysql_query("SELECT COUNT(username),password,username FROM users WHERE username='$username'");
 $check = mysql_fetch_assoc($query);
 
 $db_username = $check['username'];
 
 $password = md5($password);

 if($check['COUNT(username)'] < 1)
 {
echo
'
 <p>No account exists with this username. Please go back.</p>
';
 }
 elseif($check['password']==$password && $db_username==$username)
 {
echo
'
<h1>Login Successful</h1>

 <p>You have successfully logged in! Return home.</p>

';
$_SESSION['user']=$username;
 }
 else
 {
echo
'
 <p>The password you have enetered in is incorrect. Please go back.</p>

';
 }
}
}
else
{
echo
'
 <p>Your already logged in!</p>
';
}
?>

Hi all

My site is build using php includes. the index.php file contains code like
<?php
if(@$_GET['page'] == "web-design"){
   include("includes/web-design.php");
} else if(@$_GET['page'] == "hosting"){
   include("includes/hosting.php");   
}
 else {
    include("includes/home.php");
 }
?>

I have created a sub domain blog.maplewebdesign.co.uk and a sub dircetory named blog. The link to this part of my site doesn't use includes, I want it to link directly to that sub directories index.php page.
This works fine, but then when I click on a different link anywhere on the site my url is as follows
www.maplewebdesign.co.uk/blog/index.php?page=home

For some reason it is keeping the blog/ in the URL

If you want to see go to
http://www.maplewebdesign.co.uk/blog/
then click on a differnt link and check out the URL

What am I doing wrong?

Thanks
Adi