- Upvotes Received
- 3
- Posts with Upvotes
- 3
- Upvoting Members
- 2
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
19 Posted Topics
I forgot the way to write a query where you can psuedo name a table, for instance I have a table named user but I have to access it twice in one query and I want the results to be different. something like select user(a).f_name, user(a).l_name, user(b).f_name, user(b).l_name from user(a), … | |
Here is my issue, I am really perplexed when it comes to string parsing and manipulation in php. I am writing a database driven inventory using mysql and php. One of the issues is that there are multiple people who are able (by company rule) to add to this database. … | |
Re: I am not sure what the community feels about this, but usually when there is something that needs to be validated before submitting to the form processorI find that using javascript reg exp code to work the best. Because this validates the form fields before it is even sent to … | |
Re: I agree with Ardav, PHP (server side scripting) will usually load and complete before an image could be seen on a page. js on the other hand is on the front side, and can start loading at the body tag as the page is loading. [code] <body onload="displayLoading()"> [/code] It … ![]() | |
Re: SELECT name.task_id, name.member_id FROM name, subname WHERE name.member_id != subname.member_id This will get you 3 21 1 4 23 1 5 24 1 I am not sure of what your other condition means. could you clarify your second condition more? | |
Re: To add a link or a path to the unique car you would also need to add another column for storing a path in the car table. If I were you I would make an auto increment id tag as well so you could make the your PK. Looks like … | |
Re: This might be an odd question, but did you switch your database login credentials to your new site (instead of using the old ones from the test site) | |
Re: Nothing is added because to create a row in a database your query needs to be an insert statement for instance in your case: [code] $insertQuery = "INSERT INTO members (`column_names_here`,`seperated_by_commas`) VALUES ('$firstColumnValue','$secondColumnValue')"; $result = mysql_query($insertQuery) or die('Invalid query: ' . mysql_error()); [/code] | |
I have been having some issues with a date compare I have been getting a date from a database in YYYY-MM-DD format, and trying to compare todays date to that date to see if it has expired, then also a 30 day from the YYYY-MM-DD to check if it is … | |
Re: hmmm I though I spotted you issue, but those sessions are odd, not sure what is going on with $imagelocation. | |
Re: What you need is a linking table, because of the situation, a student can take many courses, and each course can have many students. (roll of student is played by the person who is not the teacher) Do yourself a favor, Draw it out. I think if I gave you … | |
I know that in a dev cycle the warnings are there to help you figure out what is wrong with your code, What I am wondering is what types of warnings should you just disregard? Are there any? are there warnings that are caused due to degradation of a command … | |
Re: wp does store that in the database, its in the _options table option id # 45 & 46 It wouldn't take much to get that info from the database using php. | |
Re: The only other thing that you could do possibly to make it warn the user that the account is coming near due is to create a cron job that runs a check once a day, if the account is coming near due (like maybe 10 days) it will shoot an … | |
Re: Approx line 10 instead of a comma between the two email addresses have you tried a semi colon? | |
Re: I agree with pritaeas, from the code it looks like you are not using the $_GET[] correctly,as well as the comma problem in line 62. You typically use get when you are passing the variable in the url ie (.../myphpscript.php?id=11243) the $_GET['id'] will be 11243. The &_POST[] is used for … | |
Re: I had a similar problem so what I did was link php with Javascript. On the form submit button: [code]<input id="Cart66CheckoutButton" class="Cart66ButtonPrimary Cart66CompleteOrderButton" type="submit" onclick="submitTwice(this.form);" value="Complete Order" name="Complete Order"/> [/code] you will notice the on click event. then above the form in javascript I have : [code]<script type="text/javascript"> function submitTwice(f){ … | |
Re: If you post your existing code I will show you how to fix this. Basically you will have a set of if statements to check if the value is negative or over 2359, if so then it figures how much over the amount it would be and subtracts or adds … |
The End.