Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /home

You have an error in your query. It isn't returning a valid resource. Print out $query, execute it in phpmyadmin/mysql. Then you ll know what's the error. You can also give die(mysql_error());
ie., $result=mysql_query($query,$conn) or die(mysql_error());

Web Development mysql php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: How do you only display 8 rows per page? PHP/MYSQL

Print out the query and test it in phpmyadmin/mysql. Check if the query returns any value.

Web Development mysql php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: How do you only display 8 rows per page? PHP/MYSQL

Search for pagination. You can make use of 'limit' to display only 8 records at a time.

Web Development mysql php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Pagination error..

no. The WHERE clause.

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: G'Day

:P sure!

Say Hello!
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Pagination error..

there is no where condition for limit. select * from table where limit 0,5 Wrong. select * from table limit 0,5 Right.

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: hey there!!!

She never brings the ball back when you throw it, and when she gets tired of the game she buries the ball.

LOL.. Welcome to Daniweb otakh! :)

Say Hello!
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: G'Day

uhm! I have already seen you in php forum! But, welcome (?) to Daniweb :P

Say Hello!
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Greetings

Welcome Shaninc :)

Say Hello!
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Hi everybody

Welcome to Daniweb Esperentiste!

Say Hello!
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Gilsygirl (Newbie)

:) Welcome to Daniweb!

Say Hello!
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: greetings to all my future mentors and advisers!

:) Welcome wannabeIT !

Say Hello!
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: display the data into listbox

You are getting the listbox and the values but you can see it, because you don't have the value between <option></option>.
Ie.,

echo '<option value='.$myrow['$industrytype'].'>'.$myrow['$industrytype'].'</option>';
Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: hide textarea

Right ! :)

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: hide textarea

Using css.. :) You can post this question in css to get better replies..

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Email in php 
if ($_POST['jobtype'] == $value_of_option_in_the_database) { 
$selected = "selected"; 
} else {
$selected = "";
}
?>
<select name='jobtype' style='width: 350px'>
<option value='$line[4]' <?php echo $selected; ?>>$line[4]</option>
<option value='Employee' <?php echo $selected; ?>>Employee</option>
........
Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Email in php

When the user submits, get the listbox value. Check if it matches with the value in the database and make it selected.

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: session log out problem

Warning: session_destroy() [function.session-destroy]: Trying to destroy uninitialized session in C:\xampp\htdocs\cycle\logout.php on line 34

That means you are trying to destroy a session that doesn't exist.

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Count Down Game

-713

Geeks' Lounge posting-games
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Time To Wake everyone up - Words Within Words

date
late
acclerate


Framework

Geeks' Lounge posting-games
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: This or that?

Walk.


desktop or laptop ?

Geeks' Lounge posting-games
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Greetings

Welcome to Daniweb Chris :)

Say Hello!
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Hi All :)

Hi ! :) Welcome to Daniweb Nepenthe8!

Say Hello!
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: session log out problem

Maybe this isn't working. Print some statements inside this loop and execute this script (without logging in). if (!isset($_SESSION['agent']) OR ($_SESSION['agent'] != md5($_SERVER['HTTP_USER_AGENT'])) ) {

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Hidden variable in php

I would suggest you to go through the tutorials first. Then understand the example I gave you.

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: session log out problem

I'm using Mozilla Firefox. After I logged it, I checked the cookies, there will only 'YourVisitID' under localhost. Then when I press log out button, It will redirect me back to the i.dex.php. Then I tried to copy & paste the direct link to the admin's page., it still works.

Can you post your script of admin's page ? When you run the logout script, sessions should get destroyed. Check if there are still values in the session variable :S

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: session log out problem

Are you validating existence of session in admin's page ? Try ths simple example.

<?php //page1.php
session_start();
$_SESSION['name']="test";
echo "<a href='page2.php'>Click here</a>";
?>

This is page2.php

<?php
session_start();
if(!empty($_SESSION['name'])){
 echo $_SESSION['name'];
} else {
 echo "Invalid session";
}
?>

Well, if you try to access page2.php directly, you will get Invalid session. Are you doing a check like this one in admin's page ?

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: session log out problem

huh! How do you know it creates another session ?

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Checkbox Arrays ARGH!!

:) Yep. Please post your code. If anyone come across the same problem, this thread might be useful.

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: PHP tags into HTML tags

:) You are welcome!

Web Development html-css php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: nukewarm

:) Welcome!

Say Hello!
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: hi alll

:) Welcome to Daniweb amala009 !

Say Hello!
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: PHP tags into HTML tags

just echo it. die is an alias of exit and once exit/die is encountered, the execution of the script stops there itself. You can print the error in this fashion !

<?php
if(isset($_POST['submit'])){
  if(empty($_POST['name'])){
    $error="Name field is empty !";
  } else {
  //process the information 
 }
}
?>
<html>
<body>
<form method="post" action="test.php">
<input type="text" name="name"><?php echo $error; ?><br />
<input type="submit" name="submit" value="submit">
</form>
</body>
</html>

So, If the textbox is empty, then $error will have the value, Name field is empty.. If it isn't empty, $error will be null. If its empty, the script wont do anything but show the error message next to the textbox.

Web Development html-css php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Hidden variable in php

Why do you need a switch when you know $_POST can only have 2 values. Either 1 or 2. You can make use of a simple if condition.

$action = $_POST['action'];
if($action == 1 ) {
 // show the textboxes and update 
}
if($action == 2 ){
 // delete the record
}
Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Hidden variable in php

Umm..What exactly are you trying to do ?

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Hidden variable in php

Check this out. http://in2.php.net/switch

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Hidden variable in php 
<?php //this script is hidden.php
$action=$_POST['action'];
echo $action; //use $action in your switch case
?>
<html>
<body>
<form method="post" name="hidden" action="hidden.php">
<input type="hidden" name="action">
<input type="button" name="button" value="Update" onclick="javascript: document.hidden.action.value='1';document.hidden.submit();">
<input type="button" name="button" value="Delete" onclick="javascript: document.hidden.action.value='2';document.hidden.submit();">
</form>
</body>
</html>
Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Hidden variable in php

Yeah. This is just a simple example how you can assign a value to a field.

<html>
<body>
<form method="post" name="hidden" action="hidden.php">
<input type="text" name="action">
<input type="button" name="button" value="Update" onclick="javascript: document.hidden.action.value='1';">
<input type="button" name="button" value="Delete" onclick="javascript: document.hidden.action.value='2';">
</form>
</body>
</html>
Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Email in php

Check example 4 here. http://us.php.net/function.mail . And, $body1 can have the variable values within double quotes. $body1 = "your resume $restitle was posted on $date";

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: PHP - sending data via hyperlink

You are welcome :)

Web Development perl php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: adjusting the width of the page

Say if the output is of 2 pages. Then how can you output everything in 1 page ? You can specify the width and height of the page, but if the output is more, I dont think you can avoid scroll.

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: PHP - sending data via hyperlink

You need to put <a href tag inside php echo statement. OR, use this.

<a href="Details.php?firstname=<?php echo $first; ?>&lastname=<?php echo $last; ?>"><?php echo "$first" . " " . "$last<br>";?></a>
Web Development perl php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: create a mysqldatabase inside another database

Huh! database inside another database ? Not possible AFAIK.

Web Development mysql php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Hey from Ravenscroft

Welcome to Daniweb! :)

Say Hello!
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Count Down Game

-710

Geeks' Lounge posting-games
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Time To Wake everyone up - Words Within Words

Cure
City
tire

Truncate

Geeks' Lounge posting-games
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Zend?

Yep.. eclipse with php plugins is good too, but not as good as zend(obviously!). Its a decent IDE with features like code blocks, matching braces, php syntax help, etc. and moreover, its FREE ! :)

Community Center
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Checkbox Arrays ARGH!!

if the user changes any values in the checkbox array, I need the db updated with all changes.

You mean, from checked to unchecked and vice versa ? As ShawnCplus has already mentioned, only those checkboxes which are 'set' will be passed on to the next page. Well, if you want to delete certain value when an checkbox is unchecked, then (what I do is), delete all the checkboxes for that particular user, then insert only checked checkboxes. So, it will indirectly delete the unselected checkboxes.

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: Array values for validation

lil complicated script, this one ! :P

Web Development php
Member Avatar for nav33n
nav33n 472 Purple hazed!
Re: OPTION problem

I actually wasn't even aware PHP could use that format for while loops

Yeah.. I wasn't aware too.. :)

Web Development php