No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
|
Suppose this is a Table Create Table Person( PersonID varchar(8), PersonLN varchar(16), PersonFN varchar(16), PersonADD varchar(64), PersonPH varchar(16)); so there are many enrty in that table.. So how to select the lastest row entry from that table? what will be the Mysql statement? take PersonID as a Primary key..........
|
|
Hey everyone, I'm using php to delete a row from a table in a database in mysql, but it's not working. I'm not even trying to do anything fancy, just delete one row. Here's the code: [PHP]<? include 'config.php'; $recordid = $_POST['recordid']; echo $recordid; mysql_query("DELETE FROM employees WHERE recordid='$recordid'") or … 
|
|
|
i don't see anything wrong with it... what's the deal? this is the results page that displays the results of a search query. [b]Parse error: parse error in ../../../../merchandise/testreg/results.php on line 21[/b] [code=php] @ $db = mysql_connect("localhost", "apache", "R3GP@SS!"); if(!$db) { echo "Error: Could not connect to the database. Please … 
|
|
|
I fond some tutorial that can search one field of the table in a database,. But I would like to search the whole table.. In my table I have people's name by first name, last name, phone number etc... how can I display the whole thing as a result? For …
|
|
|
for some reason or another, my AUTO_INCREMENT command won't work in my sql table for the column named 'ID'. i have no idea why. it SHOULD work, but it doesn't. anyway, that's not really much of an issue. however, i have decided to take this opportunity to learn something new …
|