php query help
2 posts
Page 1 of 1
Hello,
I use this code to display all my records in my database
Thanks
Mark
I use this code to display all my records in my database
Code: Select all
this is how i display the username in of who is creating the new order.$result = mysql_query("SELECT * FROM customers WHERE late = 'N' ", $sql);
Code: Select all
I was wondering if you can show me how to display the records that i only put in to the database not the records from other users.<input type="hidden" name="OrderBy" value=" <?php echo $username; ?>" disabled />
Thanks
Mark
You could alter your query..example:
Or use an IF maybe

Code: Select all
That would get all results just for that user.$result = mysql_query("SELECT * FROM customers WHERE late = 'N' AND username = yourusername", $sql);
Or use an IF maybe
Code: Select all
That is if I understand your needs correctly lol if($username == "mark")
{
display your output here
}

Welcome to CodenStuff.com Learn Code, Love Code. Thank you for being a member of the community.
2 posts
Page 1 of 1
Copyright Information
Copyright © Codenstuff.com 2020 - 2023