BrianM
-
Posts
217 -
Joined
-
Last visited
Never
BrianM's Achievements
Regular Member (3/5)
0
Reputation
-
I think it's JavaScript that uses this on web pages. Does anyone know how this is done? If so, could you please provide an example? I can provide a more descriptive question if needed.
-
Ah, thank you very much!
-
How do I create a search using PHP/MYSQL
BrianM replied to lost in translation's topic in PHP Coding Help
Have you tried Google for any examples? That's typically the first thing I always do in a case like this. -
I've searched Google for subjects as "How to add php session id in url" and such, but hadn't had any luck with finding the answer I'm looking for. Could anyone please help by maybe showing an example of creating a session and adding the session id inside the url bar? Please and thank you!
-
Does anyone know of a tutorial showing how this is done, or does anyone mind explaining?
-
thorpe, thanks very much. You are right. It now works.
-
Here is my code: <?php $result = mysql_query("SELECT Date FROM $table id=$id") or die(mysql_error()); ?> And here is the error I'm receiving: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '08-1111-E id=1' at line 1 Can anyone tell me what is wrong? Thanks
-
Ah, thank you again for your help! Learn something new everyday.
-
Unknown column '1' in 'where clause' - that's the error I get. That doesn't make since, I have an 'id' column. Here is what my table looks like at the moment to give you a visual. id date report 1 07-04-08 test report.
-
Okay, a little problem ... can't figure this one out. Here is my code: <!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=iso-8859-1" /> <title>MPS Project Tracking - by Brian Medley</title> </head> <?php mysql_connect('localhost', 'brian', 'some_pass') or die(mysql_error()); mysql_select_db('reports') or die(mysql_error()); $table = $_GET['table']; $id = $_GET['id']; $sql = mysql_query("SELECT * FROM `$table` WHERE id=`$id`"); while($row = mysql_fetch_array($sql)) { echo $row['date'] . " " . $row['report']; } ?> <body> </body> </html> And I get this error when I display the page: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\new_mps\report\edit_report.php on line 16
-
Yeah, I was going to say, while waiting I Googled this little example from w3schools.com SELECT * FROM person WHERE FirstName='Peter' Alright, well hopefully all will go well from here. Thank you very much for your help and the quick reply!
-
Would somebody please show me an example of a database connection to MySQL via PHP selecting and displaying one row from a table and not every row in it? I'm wanting to select only one row from a table, selected by it's "id" and display only that one row. And the id will be pulled from a query string using $_GET['id'] and storing that as a variable at the top of the script; ie. "../index.php?table=some_table&id=1" - $id = $_GET['id'];
-
something like <?php if ($GLOBALS['text_dir'] === 'rtl') { echo '*,'; } echo $GLOBALS['cfg']['NaviWidth']; if ($GLOBALS['text_dir'] === 'ltr') { echo ',*'; } ?>
-
= == and === What is the difference between the single, double and triple equal signs, and is there anything higher than 3 used at once?
-
How would I set the size of this text box using CSS? <td id="header_report">report</td> <style type="text/css"> #header_report { size: 100; } </style> That doesn't work...